On Tue, 24 Apr 2001, Jason Davis wrote:
> >Currently, you can:
> >
> > * add columns
> > * add or drop a default value for a column
> > * rename a column
> > * rename a table
> > * add a constraint / referential integrity
> > * assign the table to a new owner
> >
> >Some features are not yet implemented:
> >
> > * dropping a column
> > * changing a column from NULL to NOT NULL or vice versa
> > * adding a primary key
> > * changing a column type
>
> Is it possible to remove a referential integrity trigger without dropping
> tables? I tried to DROP TRIGGER using the name of the trigger created from
> the foreign key clause when the table was created, without success (no such
> trigger name).
>
> Unfortunately dropping and recreating tables is not an option as it is a
> production system. Therefore I don't want to get too reckless destroying
> things in case I trash the entire database.
Yep, check pg_trigger, where you can disable it.
There's a tutorial about hacking around the system catalogs for
ref integrity:
http://www.postgresql.org/mhonarc/pgsql-docs/archive/pgsql-docs.200012
HTH,
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington