Re: schema level variables and deferrable unique constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: schema level variables and deferrable unique constraints
Date
Msg-id 11284.1095690873@sss.pgh.pa.us
Whole thread Raw
In response to schema level variables and deferrable unique constraints  (Paramveer.Singh@trilogy.com)
Responses Re: schema level variables and deferrable unique constraints  (Andre <andre@abs.ee>)
List pgsql-hackers
Paramveer.Singh@trilogy.com writes:
> 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 implementing this?

It seems more appropriate to me to store your values in a table
(variable name and value).  I don't see any strong need for a
system-level facility for this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: Re: libpq and prepared statements progress for 8.0
Next
From: Tom Lane
Date:
Subject: Re: No parameters support in "create user"?