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:
see trigger and estatus

select tgname,tgenabled from pg_catalog.pg_trigger

--- On Mon, 6/30/08, kartik <kartik@v2technocrats.com> wrote:
From: kartik <kartik@v2technocrats.com>
Subject: [GENERAL] Query
To: pgsql-general@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