Re: disable constraints

rute solipa wrote:
> i whant avoid to dropping constraint, i whant to disable the constraints, 
> because i need to insert a large amont of data.
> is there a way?
> 
> best regards,
> rute
> 
> 

There is no "oficial" way to do that, as far as I know...
You can disable *triggers* on a table (which will disable all the FK constraints, but not things like 'not nul' or
'unique'),by doing:
 

update pg_class set reltriggers=0 where relname = 'YOUR_TABLE_NAME';

to enable them after you are done, do

update pg_class set reltriggers = count(*) from pg_trigger where pg_class.oid=tgrelid and relname='YOUR_TABLE_NAME';

I hope, it helps...

Dima


> 
> At 03:47 PM 2/26/2003 +0100, you wrote:
> 
>>Hi!
>>
>>use "alter table ??? drop constraint ???"
>>
>>example:
>>
>>create table asdf (userid text, foreign key (userid) references 
>>person(userid) on delete cascade);
>>
>>\d asdf
>>    Table "public.asdf"
>> Column | Type | Modifiers
>>--------+------+-----------
>> userid | text |
>>Foreign Key constraints: $1 FOREIGN KEY (userid) REFERENCES person(userid) 
>>ON UPDATE NO ACTION ON DELETE CASCADE
>>
>>alter table asdf drop constraint "$1";
>>
>>Regards,
>>Patrik Kudo
>>
>>rute solipa wrote:
>>
>>>hello,
>>>does anyone nows how can i disable/enable table or column constraints?
>>>in oracle it's possible to disable constraints like this:
>>>alter table tb_1
>>>disable primary key;
>>>best regards,
>>>rute
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>subscribe-nomail command to majordomo@postgresql.org so that your
>>>message can get through to the mailing list cleanly
>>
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org