aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2003-06-25 03:02:37 +0000
committerBruce Momjian <bruce@momjian.us>2003-06-25 03:02:37 +0000
commitdbca370278fd702efb504d57d2f89619f3be7091 (patch)
treeca578f9b87a0ec7089e6e062aab5781e4fc51bc5
parentad41cd6c4a24494ac335b440be3082993123e90b (diff)
downloadpostgresql-dbca370278fd702efb504d57d2f89619f3be7091.tar.gz
postgresql-dbca370278fd702efb504d57d2f89619f3be7091.zip
Back out commit.
-rw-r--r--src/test/regress/expected/inherit.out43
1 files changed, 0 insertions, 43 deletions
diff --git a/src/test/regress/expected/inherit.out b/src/test/regress/expected/inherit.out
index aa2d03d165a..e6fc8bcb575 100644
--- a/src/test/regress/expected/inherit.out
+++ b/src/test/regress/expected/inherit.out
@@ -570,46 +570,3 @@ SELECT relname, bar.* FROM bar, pg_class where bar.tableoid = pg_class.oid;
bar2 | 3 | 103
(8 rows)
-/* Test inheritance of structure (LIKE) */
-CREATE TABLE inhx (xx text DEFAULT 'text');
-/*
- * Test double inheritance
- *
- * Ensure that defaults are NOT included unless
- * INCLUDING DEFAULTS is specified
- */
-CREATE TABLE inhe (ee text, LIKE inhx) inherits (b);
-INSERT INTO inhe VALUES ('ee-col1', 'ee-col2', DEFAULT, 'ee-col4');
-SELECT * FROM inhe; /* Columns aa, bb, xx value NULL, ee */
- aa | bb | ee | xx
----------+---------+----+---------
- ee-col1 | ee-col2 | | ee-col4
-(1 row)
-
-SELECT * FROM inhx; /* Empty set since LIKE inherits structure only */
- xx
-----
-(0 rows)
-
-SELECT * FROM b; /* Has ee entry */
- aa | bb
----------+---------
- ee-col1 | ee-col2
-(1 row)
-
-SELECT * FROM a; /* Has ee entry */
- aa
----------
- ee-col1
-(1 row)
-
-CREATE TABLE inhf (LIKE inhx, LIKE inhx); /* Throw error */
-ERROR: CREATE TABLE: attribute "xx" duplicated
-CREATE TABLE inhf (LIKE inhx INCLUDING DEFAULTS);
-INSERT INTO inhf DEFAULT VALUES;
-SELECT * FROM inhf; /* Single entry with value 'text' */
- xx
-------
- text
-(1 row)
-