Skip site navigation (1) Skip section navigation (2)

Re: schema level variables and deferrable unique constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paramveer(dot)Singh(at)trilogy(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: schema level variables and deferrable unique constraints
Date: 2004-09-20 14:34:33
Message-ID: 11284.1095690873@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Paramveer(dot)Singh(at)trilogy(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-09-20 14:36:34
Subject: Re: No parameters support in "create user"?
Previous:From: Abhijit Menon-SenDate: 2004-09-20 14:30:00
Subject: Re: libpq and prepared statements progress for 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group