Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1b42ad7

Browse files
committed
Initial version of the SQL information schema
1 parent2d8d666 commit1b42ad7

File tree

12 files changed

+616
-92
lines changed

12 files changed

+616
-92
lines changed

‎doc/src/sgml/features.sgml

Lines changed: 73 additions & 73 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.12 2002/12/14 00:24:23 petere Exp $
33
-->
44

55
<appendix id="features">
@@ -655,6 +655,48 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
655655
<entry>SQL comments using leading double minus</entry>
656656
<entry></entry>
657657
</row>
658+
<row>
659+
<entry>F021</entry>
660+
<entry>Core</entry>
661+
<entry>Basic information schema</entry>
662+
<entry></entry>
663+
</row>
664+
<row>
665+
<entry>F021-01</entry>
666+
<entry>Core</entry>
667+
<entry>COLUMNS view</entry>
668+
<entry></entry>
669+
</row>
670+
<row>
671+
<entry>F021-02</entry>
672+
<entry>Core</entry>
673+
<entry>TABLES view</entry>
674+
<entry></entry>
675+
</row>
676+
<row>
677+
<entry>F021-03</entry>
678+
<entry>Core</entry>
679+
<entry>VIEWS view</entry>
680+
<entry></entry>
681+
</row>
682+
<row>
683+
<entry>F021-04</entry>
684+
<entry>Core</entry>
685+
<entry>TABLE_CONSTRAINTS view</entry>
686+
<entry></entry>
687+
</row>
688+
<row>
689+
<entry>F021-05</entry>
690+
<entry>Core</entry>
691+
<entry>REFERENTIAL_CONSTRAINTS view</entry>
692+
<entry></entry>
693+
</row>
694+
<row>
695+
<entry>F021-06</entry>
696+
<entry>Core</entry>
697+
<entry>CHECK_CONSTRAINTS view</entry>
698+
<entry></entry>
699+
</row>
658700
<row>
659701
<entry>F031</entry>
660702
<entry>Core</entry>
@@ -905,6 +947,30 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
905947
<entry>INSERT statement: DEFAULT VALUES clause</entry>
906948
<entry></entry>
907949
</row>
950+
<row>
951+
<entry>F231</entry>
952+
<entry></entry>
953+
<entry>Privilege Tables</entry>
954+
<entry></entry>
955+
</row>
956+
<row>
957+
<entry>F231-01</entry>
958+
<entry></entry>
959+
<entry>TABLE_PRIVILEGES view</entry>
960+
<entry></entry>
961+
</row>
962+
<row>
963+
<entry>F231-02</entry>
964+
<entry></entry>
965+
<entry>COLUMN_PRIVILEGES view</entry>
966+
<entry></entry>
967+
</row>
968+
<row>
969+
<entry>F231-03</entry>
970+
<entry></entry>
971+
<entry>USAGE_PRIVILEGES view</entry>
972+
<entry></entry>
973+
</row>
908974
<row>
909975
<entry>F251</entry>
910976
<entry></entry>
@@ -1133,6 +1199,12 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
11331199
<entry>Constraint management</entry>
11341200
<entry></entry>
11351201
</row>
1202+
<row>
1203+
<entry>F501-03</entry>
1204+
<entry>Core</entry>
1205+
<entry>SQL_LANGUAGES view</entry>
1206+
<entry></entry>
1207+
</row>
11361208
<row>
11371209
<entry>F511</entry>
11381210
<entry></entry>
@@ -1557,48 +1629,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
15571629
<entry>Module language</entry>
15581630
<entry></entry>
15591631
</row>
1560-
<row>
1561-
<entry>F021</entry>
1562-
<entry>Core</entry>
1563-
<entry>Basic information schema</entry>
1564-
<entry></entry>
1565-
</row>
1566-
<row>
1567-
<entry>F021-01</entry>
1568-
<entry>Core</entry>
1569-
<entry>COLUMNS view</entry>
1570-
<entry></entry>
1571-
</row>
1572-
<row>
1573-
<entry>F021-02</entry>
1574-
<entry>Core</entry>
1575-
<entry>TABLES view</entry>
1576-
<entry></entry>
1577-
</row>
1578-
<row>
1579-
<entry>F021-03</entry>
1580-
<entry>Core</entry>
1581-
<entry>VIEWS view</entry>
1582-
<entry></entry>
1583-
</row>
1584-
<row>
1585-
<entry>F021-04</entry>
1586-
<entry>Core</entry>
1587-
<entry>TABLE_CONSTRAINTS view</entry>
1588-
<entry></entry>
1589-
</row>
1590-
<row>
1591-
<entry>F021-05</entry>
1592-
<entry>Core</entry>
1593-
<entry>REFERENTIAL_CONSTRAINTS view</entry>
1594-
<entry></entry>
1595-
</row>
1596-
<row>
1597-
<entry>F021-06</entry>
1598-
<entry>Core</entry>
1599-
<entry>CHECK_CONSTRAINTS view</entry>
1600-
<entry></entry>
1601-
</row>
16021632
<row>
16031633
<entry>F031-19</entry>
16041634
<entry>Core</entry>
@@ -1667,30 +1697,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
16671697
<entry>SET TRANSACTION statement: DIAGNOSTICS SIZE clause</entry>
16681698
<entry></entry>
16691699
</row>
1670-
<row>
1671-
<entry>F231</entry>
1672-
<entry></entry>
1673-
<entry>Privilege Tables</entry>
1674-
<entry></entry>
1675-
</row>
1676-
<row>
1677-
<entry>F231-01</entry>
1678-
<entry></entry>
1679-
<entry>TABLE_PRIVILEGES view</entry>
1680-
<entry></entry>
1681-
</row>
1682-
<row>
1683-
<entry>F231-02</entry>
1684-
<entry></entry>
1685-
<entry>COLUMN_PRIVILEGES view</entry>
1686-
<entry></entry>
1687-
</row>
1688-
<row>
1689-
<entry>F231-03</entry>
1690-
<entry></entry>
1691-
<entry>USAGE_PRIVILEGES view</entry>
1692-
<entry></entry>
1693-
</row>
16941700
<row>
16951701
<entry>F291</entry>
16961702
<entry></entry>
@@ -1769,12 +1775,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.11 2002/12/06 05:07:12 mo
17691775
<entry>SQL_SIZING view</entry>
17701776
<entry></entry>
17711777
</row>
1772-
<row>
1773-
<entry>F501-03</entry>
1774-
<entry>Core</entry>
1775-
<entry>SQL_LANGUAGES view</entry>
1776-
<entry></entry>
1777-
</row>
17781778
<row>
17791779
<entry>F502</entry>
17801780
<entry></entry>

‎doc/src/sgml/release.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.169 2002/12/12 20:35:07 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.170 2002/12/14 00:24:23 petere Exp $
33
-->
44

55
<appendix id="release">
@@ -24,6 +24,7 @@ CDATA means the content is "SGML-free", so you can write without
2424
worries about funny characters.
2525
-->
2626
<literallayout><![CDATA[
27+
Information schema
2728
Domains now support CHECK constraints
2829
]]></literallayout>
2930

‎src/backend/Makefile

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
#
55
# Copyright (c) 1994, Regents of the University of California
66
#
7-
# $Header: /cvsroot/pgsql/src/backend/Makefile,v 1.88 2002/10/09 16:21:54 momjian Exp $
7+
# $Header: /cvsroot/pgsql/src/backend/Makefile,v 1.89 2002/12/14 00:24:23 petere Exp $
88
#
99
#-------------------------------------------------------------------------
1010

@@ -131,7 +131,7 @@ ifeq ($(MAKE_DLL), true)
131131
$(INSTALL_DATA) libpostgres.a $(DESTDIR)$(libdir)/libpostgres.a
132132
endif
133133
endif
134-
$(MAKE) -C catalog install-bki
134+
$(MAKE) -C catalog install-data
135135
$(INSTALL_DATA) $(srcdir)/libpq/pg_hba.conf.sample $(DESTDIR)$(datadir)/pg_hba.conf.sample
136136
$(INSTALL_DATA) $(srcdir)/libpq/pg_ident.conf.sample $(DESTDIR)$(datadir)/pg_ident.conf.sample
137137
$(INSTALL_DATA) $(srcdir)/utils/misc/postgresql.conf.sample $(DESTDIR)$(datadir)/postgresql.conf.sample
@@ -170,7 +170,7 @@ ifeq ($(MAKE_DLL), true)
170170
rm -f $(DESTDIR)$(libdir)/libpostgres.a
171171
endif
172172
endif
173-
$(MAKE) -C catalog uninstall-bki
173+
$(MAKE) -C catalog uninstall-data
174174
rm -f $(DESTDIR)$(datadir)/pg_hba.conf.sample \
175175
$(DESTDIR)$(datadir)/pg_ident.conf.sample \
176176
$(DESTDIR)$(datadir)/postgresql.conf.sample

‎src/backend/catalog/Makefile

Lines changed: 7 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
#
33
# Makefile for backend/catalog
44
#
5-
# $Header: /cvsroot/pgsql/src/backend/catalog/Makefile,v 1.42 2002/07/18 23:11:27 petere Exp $
5+
# $Header: /cvsroot/pgsql/src/backend/catalog/Makefile,v 1.43 2002/12/14 00:24:24 petere Exp $
66
#
77
#-------------------------------------------------------------------------
88

@@ -41,17 +41,18 @@ postgres.bki postgres.description: genbki.sh $(POSTGRES_BKI_SRCS) \
4141
$(top_srcdir)/src/include/postgres_ext.h $(top_builddir)/src/include/pg_config.h
4242
CPP='$(CPP)' AWK='$(AWK)' $(SHELL) $< $(BKIOPTS) -o postgres $(pg_includes) $(POSTGRES_BKI_SRCS) --set-version=$(VERSION)
4343

44-
.PHONY: install-bki
45-
install-bki:$(BKIFILES) installdirs
44+
.PHONY: install-data
45+
install-data:$(BKIFILES) installdirs
4646
$(INSTALL_DATA) postgres.bki$(DESTDIR)$(datadir)/postgres.bki
4747
$(INSTALL_DATA) postgres.description$(DESTDIR)$(datadir)/postgres.description
48+
$(INSTALL_DATA) information_schema.sql$(DESTDIR)$(datadir)/information_schema.sql
4849

4950
installdirs:
5051
$(mkinstalldirs)$(DESTDIR)$(datadir)
5152

52-
.PHONY: uninstall-bki
53-
uninstall-bki:
54-
rm -f$(addprefix$(DESTDIR)$(datadir)/,$(BKIFILES))
53+
.PHONY: uninstall-data
54+
uninstall-data:
55+
rm -f$(addprefix$(DESTDIR)$(datadir)/,$(BKIFILES) information_schema.sql)
5556

5657

5758
clean:

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp