Postgres Pro
Downloads
Home   >   mailing lists

Thread: Query

Query

From
"kartik"
Date:

Hello ,

I am a beginner for  postgresql. I want to activate a constraint for some time and after that I want to deactivate it.

 

Or

 

I want to know whether a particular constraint exists and whether its activated or not.

 

Waiting for yr reply

 

Re: Query

From
Lennin Caro
Date:


--- On Mon, 6/30/08, kartik <kartik@v2technocrats.com> wrote:

> From: kartik <kartik@v2technocrats.com>
> Subject: [ADMIN] Query
> To: pgsql-admin@postgresql.org
> Date: Monday, June 30, 2008, 9:55 AM
> Hello ,
>
> I am a beginner for  postgresql. I want to activate a
> constraint for some
> time and after that I want to deactivate it.
>
>
>
> Or
>
>
>
> I want to know whether a particular constraint exists and
> whether its
> activated or not.
>
>
>
> Waiting for yr reply

triggers and status

select tgname,tgenabled from pg_trigger