Barry Lind <barry(at)xythos(dot)com> writes:
> files31=# alter table XYF_FILES DROP CONSTRAINT XYF_FILES_PK;
> ERROR: parser: parse error at or near ";"
You forgot the RESTRICT/CASCADE option.
> I am assuming that this syntax should work because it is documented in
> the 7.2 docs.
If it's documented without the option then the docs are in error;
where are you looking?
regards, tom lane