If you read the entire man page, it should say further
down that it only works for FOREIGN KEY constraints (and
gives info on what to do for other constraints).
"In the current implementation, only FOREIGN KEY
constraints can be added to a table."
Stephan Szabo
sszabo@bigpanda.com
On Wed, 16 Aug 2000, John Morton wrote:
> >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.
>