pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDisabling constraint check
3+ messages / 3 participants
[nested] [flat]
* Disabling constraint check
@ 2012-09-17 18:58 Salomao Domingos <salomaodomingos@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Salomao Domingos @ 2012-09-17 18:58 UTC (permalink / raw)
To: pgsql-sql
Hi,
I'm need to import data to PostgreSQL via csv file. The database in
question is very problematic and I have that import those data without
checking it. How can I to do that? I know that I can to disable FKs
through "ALTER TABLE table_name DISABLE TRIGGERS ALL", however how can
I disabling CHECK CONSTRAINT too?
--
* Salomão Domingos
* * Analista de Suporte
* * * Linux Professional Institute Certificate 2 - LPIC2
* * * * e-mail comercial: salomaodomingos@f13.com.br
* * * * * MSN : salomaodomingos@hotmail.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Disabling constraint check
@ 2012-09-17 19:33 Oliveiros d'Azevedo Cristina <oliveiros.cristina@asperger-talents.com>
parent: Salomao Domingos <salomaodomingos@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Oliveiros d'Azevedo Cristina @ 2012-09-17 19:33 UTC (permalink / raw)
To: Salomao Domingos <salomaodomingos@gmail.com>; pgsql-sql
Have you tried this
ALTER TABLE table_name DROP CONSTRAINT constraint_name;
Best,
Oliveiros
----- Original Message -----
From: "Salomao Domingos" <salomaodomingos@gmail.com>
To: <pgsql-sql@postgresql.org>
Sent: Monday, September 17, 2012 7:58 PM
Subject: [SQL] Disabling constraint check
Hi,
I'm need to import data to PostgreSQL via csv file. The database in
question is very problematic and I have that import those data without
checking it. How can I to do that? I know that I can to disable FKs
through "ALTER TABLE table_name DISABLE TRIGGERS ALL", however how can
I disabling CHECK CONSTRAINT too?
--
* Salomão Domingos
* * Analista de Suporte
* * * Linux Professional Institute Certificate 2 - LPIC2
* * * * e-mail comercial: salomaodomingos@f13.com.br
* * * * * MSN : salomaodomingos@hotmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Disabling constraint check
@ 2012-09-17 20:42 Richard Broersma <richard.broersma@gmail.com>
parent: Salomao Domingos <salomaodomingos@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Broersma @ 2012-09-17 20:42 UTC (permalink / raw)
To: Salomao Domingos <salomaodomingos@gmail.com>; +Cc: pgsql-sql
On Mon, Sep 17, 2012 at 11:58 AM, Salomao Domingos <
salomaodomingos@gmail.com> wrote:
> ... however how can I disabling CHECK CONSTRAINT too?
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-09-17 20:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-17 18:58 Disabling constraint check Salomao Domingos <salomaodomingos@gmail.com>
2012-09-17 19:33 ` Oliveiros d'Azevedo Cristina <oliveiros.cristina@asperger-talents.com>
2012-09-17 20:42 ` Richard Broersma <richard.broersma@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox