From: | John Morton <jwm(at)plain(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unimpletmented features |
Date: | 2000-08-16 06:44:27 |
Message-ID: | 200008160644.SAA03870@vesta.plain.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From the ALTER TABLE documentation on postgresql.org
Synopsis
ALTER TABLE [ ONLY ]table [ * ]
ADD [ COLUMN ] column type
ALTER TABLE [ ONLY ]table [ * ]
ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
ALTER TABLE table [ * ]
RENAME [ COLUMN ] column TO newcolumn
ALTER TABLE table
RENAME TO newtable
ALTER TABLE table
ADD table constraint definition
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
What happened when I tryed it:
DBD::Pg::db do failed: ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented
If I find another unimplemented 'feature' of postgresql 7.0.2 documented
in the manual I swear to god I'm going to go postal.
How about a 'not yet implemented in 7.0' line in the documentation for
this stuff?
John.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Hernandez | 2000-08-16 06:57:54 | variables in SQL?? |
Previous Message | Choosna Makarasara | 2000-08-16 05:52:05 | index with user-defined function |