Skip to content

Commit 1b42ad7

Browse files
peterepetere
committed
Initial version of the SQL information schema
1 parent 2d8d666 commit 1b42ad7

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)