diff options
Diffstat (limited to 'src/test/regress/expected/alter_table.out')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 904ad9b840..31278f89f0 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -24,8 +24,8 @@ ALTER TABLE tmp ADD COLUMN r lseg; ALTER TABLE tmp ADD COLUMN s path; ALTER TABLE tmp ADD COLUMN t box; ALTER TABLE tmp ADD COLUMN u tinterval; -ALTER TABLE tmp ADD COLUMN v datetime; -ALTER TABLE tmp ADD COLUMN w timespan; +ALTER TABLE tmp ADD COLUMN v timestamp; +ALTER TABLE tmp ADD COLUMN w interval; ALTER TABLE tmp ADD COLUMN x float8[]; ALTER TABLE tmp ADD COLUMN y float4[]; ALTER TABLE tmp ADD COLUMN z int2[]; @@ -69,8 +69,8 @@ ALTER TABLE tmp ADD COLUMN r lseg; ALTER TABLE tmp ADD COLUMN s path; ALTER TABLE tmp ADD COLUMN t box; ALTER TABLE tmp ADD COLUMN u tinterval; -ALTER TABLE tmp ADD COLUMN v datetime; -ALTER TABLE tmp ADD COLUMN w timespan; +ALTER TABLE tmp ADD COLUMN v timestamp; +ALTER TABLE tmp ADD COLUMN w interval; ALTER TABLE tmp ADD COLUMN x float8[]; ALTER TABLE tmp ADD COLUMN y float4[]; ALTER TABLE tmp ADD COLUMN z int2[]; @@ -377,14 +377,14 @@ CREATE TEMP TABLE PKTABLE (ptest1 int, ptest2 inet, PRIMARY KEY(ptest1, ptest2)); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable' -- This should fail, because we just chose really odd types -CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 datetime); +CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 timestamp); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable; NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ERROR: Unable to identify an operator '=' for types 'cidr' and 'integer' You will have to retype this query using an explicit cast -- Again, so should this... DROP TABLE FKTABLE; -CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 datetime); +CREATE TEMP TABLE FKTABLE (ftest1 cidr, ftest2 timestamp); ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable(ptest1, ptest2); NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s) |
