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

Re: Re: CAST doesn't work

From: Jason Davis <jdavis(at)tassie(dot)net(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: CAST doesn't work
Date: 2001-04-23 23:30:45
Message-ID: 200104232324.JAA06237@zeus.tassie.net.au (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
>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.

regards
Jason Davis


In response to

Responses

pgsql-novice by date

Next:From: Joel BurtonDate: 2001-04-24 00:03:10
Subject: Re: Re: CAST doesn't work
Previous:From: Ian Lance TaylorDate: 2001-04-23 20:25:13
Subject: Re: Using cursors inside PL/pgSQL function

pgsql-general by date

Next:From: Michelle MurrainDate: 2001-04-23 23:31:11
Subject: Re: installing DBD::Pg without installing postgres
Previous:From: Tom LaneDate: 2001-04-23 23:22:41
Subject: Re: pg_dump failure: "handler procedure for language plpgsql not foun d"

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