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

Re: disable constraints

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: rute solipa <rutes(at)eselx(dot)ipl(dot)pt>
Subject: Re: disable constraints
Date: 2003-02-28 22:42:00
Message-ID: 3E5FE5B8.6080405@openratings.com (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)postgresql(dot)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


In response to

pgsql-sql by date

Next:From: Dmitry TkachDate: 2003-02-28 22:47:04
Subject: Re: DELETE FROM t WHERE EXISTS
Previous:From: Dan LangilleDate: 2003-02-28 22:01:11
Subject: Re: DELETE FROM t WHERE EXISTS

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