schema level variables and deferrable unique constraints

From: Paramveer(dot)Singh(at)trilogy(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: schema level variables and deferrable unique constraints
Date: 2004-09-20 11:26:24
Message-ID: OFF95F1DDF.C01F9A96-ONE5256F15.0035D768@trilogy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi!
I apologize for mailing on the hackers list but I posted on the general
list and did not get a good answer.
I have two independent issues, but am addressing them together.

1.
Oracle has package level variables which are not mappable to any postgres
equivalent.
could we have something like schema scope variables which could be
directly referred from let's say plpgsql functions?
Can someone give me some pointers on how to go about imlpementing this?

.
Postgres does not support deferrable unique constraints.
we would however like to support this especially as some updates give
non-standard behavior because of this.
for details please refer to

Browse pgsql-hackers by date

  From Date Subject
Next Message Paramveer.Singh 2004-09-20 11:29:32 schema level variables and deferrable unique constraints
Previous Message Andrew Dunstan 2004-09-20 08:42:29 Re: execve() vs system() for chrooted filesystems in dbcommands.c