Skip site navigation (1) Skip section navigation (2)

Re: Re: CAST doesn't work

From: Joel Burton <jburton(at)scw(dot)org>
To: Jason Davis <jdavis(at)tassie(dot)net(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: CAST doesn't work
Date: 2001-04-24 00:03:10
Message-ID: Pine.LNX.4.21.0104232002280.32219-100000@olympus.scw.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2001-04-24 00:16:02
Subject: Re: Re: CAST doesn't work
Previous:From: Jason DavisDate: 2001-04-23 23:30:45
Subject: Re: Re: CAST doesn't work

pgsql-general by date

Next:From: Thomas LockhartDate: 2001-04-24 00:05:17
Subject: Re: Hardcopy docs available
Previous:From: Peter PilslDate: 2001-04-23 23:52:10
Subject: find position of an special entry in a select-result

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group