From: Bruce Momjian <pgman@candle.pha.pa.us>
To: dave.bath@unix.net
Cc: pgsql-sql@postgresql.org
Subject: Re: ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements?
Date: Tue, 25 Oct 2005 21:38:15 -0400 (EDT)
Message-ID: <200510260138.j9Q1cFL17707@candle.pha.pa.us> (raw)
In-Reply-To: <200510261113.43685.dave.bath@unix.net>
Please see the 8.1 beta release notes for new capabilities in that
release.
---------------------------------------------------------------------------
Bath, David wrote:
> Folks,
>
> Summary:
> Does postgresql have equivalents to the following Oracle statements?
> DISABLE CONSTRAINT ...
> ENABLE CONSTRAINT ...
> DISABLE TRIGGER ...
> ENABLE TRIGGER ...
>
> Background:
> One of the advantages of Oracle over some competitors such as MS-SQL
> and Sybase is the ability to toggle a constraint or trigger on and
> off, without blatting it, and without the hassle of finding any
> code and any accessory information (like comments, permissions...).
>
> BTW, I personally put C-style comments at the front of the clause so
> I can get the why's/how's into the syscatalogs - but I wear jackboots
> where documentation is concerned :-) and get at these for autodoccing
> and/or generation of meaningful messages to users when raising
> exception messages from the server.
>
> This capability is especially useful when there is some disgusting
> data-munging by a DBA, not just for import/export.
>
> I've tried grovelling through the sql from a pg_dump invoked with
> --disable-triggers, but it has no enable/disable triggers or
> constraints, merely creating primary/foreign constraints AFTER
> issuing the COPY.
>
> Yep, I'd expect this ONLY to work when issued by someone with DBA
> privs (and maybe the target object owner, although I imagine reasons
> that /might/ be a bad idea for paranoid info management governance).
>
> Thanks in advance
> --
> David T. Bath
> dave.bath@unix.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, dave.bath@unix.net
Subject: Re: ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements?
In-Reply-To: <200510260138.j9Q1cFL17707@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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