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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2001-04-24 00:05:17 | Re: Hardcopy docs available |
Previous Message | Peter Pilsl | 2001-04-23 23:52:10 | find position of an special entry in a select-result |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-24 00:16:02 | Re: Re: CAST doesn't work |
Previous Message | Jason Davis | 2001-04-23 23:30:45 | Re: Re: CAST doesn't work |