diff options
author | Bruce Momjian <bruce@momjian.us> | 2003-06-25 03:02:37 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2003-06-25 03:02:37 +0000 |
commit | dbca370278fd702efb504d57d2f89619f3be7091 (patch) | |
tree | ca578f9b87a0ec7089e6e062aab5781e4fc51bc5 /src | |
parent | ad41cd6c4a24494ac335b440be3082993123e90b (diff) | |
download | postgresql-dbca370278fd702efb504d57d2f89619f3be7091.tar.gz postgresql-dbca370278fd702efb504d57d2f89619f3be7091.zip |
Back out commit.
Diffstat (limited to 'src')
-rw-r--r-- | src/test/regress/expected/inherit.out | 43 |
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) - |