| 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: | Whole Thread | Raw Message | 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 |