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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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