Re: Re: CAST doesn't work

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   
Director of Information Systems, Support Center of Washington