Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Of course having the ability to execute arbitrary plpgsql in .sql scripts would be handy in some cases as well, though as others pointed out there are alternatives. I don't know if it's possible. PL/pgSQL parser live in different context than SQL parser and PostgreSQL supports more languages th

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

On Thu, Dec 22, 2005 at 06:35:24PM -0500, Bruce Momjian wrote: > Hannu Krosing wrote: > > ?hel kenal p?eval, N, 2005-12-22 kell 18:19, kirjutas Bruce Momjian: > > I guess he rather wants to have dont-save-but-execute-immediately > > pl/pgsql code. > > > > could this perhaps be solved by having tem

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

It's implemented in the server with extensions for psql to support it.On 12/23/05, Bruce Momjian wrote:Jonah H. Harris wrote:> I know this is a tech forum and as such, I don't generally plug products too > much.  However, EnterpriseDB has anonymous PL/SQL if you need it.In

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Jonah H. Harris wrote: > I know this is a tech forum and as such, I don't generally plug products too > much. However, EnterpriseDB has anonymous PL/SQL if you need it. Interesting. The posting is certainly appropriate. I know Command Prompt and GreenPlum have been using this "loophole". :-)

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

I know this is a tech forum and as such, I don't generally plug products too much.  However, EnterpriseDB has anonymous PL/SQL if you need it. On 12/22/05, Bruce Momjian wrote: Wow, that is large.  I think PL/pgSQL is your best approach.  Irecommend you create a schema that

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Wow, that is large. I think PL/pgSQL is your best approach. I recommend you create a schema that users can write into. --- Ashok Agrawal wrote: > I don't need ability to sit at a prompt and type stuff. > > To be more clea

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

I don't need ability to sit at a prompt and type stuff. To be more clear, I am attaching one sample code. I would like to migrate this code using postgres without converting into procedure or function. Thanks Ashok Bruce Momjian wrote On 12/22/05 15:35,: > Hannu Krosing wrote: > >>?hel kenal p?

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Hannu Krosing wrote: > ?hel kenal p?eval, N, 2005-12-22 kell 18:19, kirjutas Bruce Momjian: > > Ashok Agrawal wrote: > > > Hi , > > > > > > Here is the requirements : > > > > > > 1. Development & Support team can ONLY have READ Only ACCESS > > >to PRODUCTION Database. They will NOT have acces

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Ühel kenal päeval, N, 2005-12-22 kell 18:19, kirjutas Bruce Momjian: > Ashok Agrawal wrote: > > Hi , > > > > Here is the requirements : > > > > 1. Development & Support team can ONLY have READ Only ACCESS > >to PRODUCTION Database. They will NOT have access to create > >stored procedure &

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

Ashok Agrawal wrote: > Hi , > > Here is the requirements : > > 1. Development & Support team can ONLY have READ Only ACCESS >to PRODUCTION Database. They will NOT have access to create >stored procedure & functions in the PRODUCTION on the fly. > > 2. During application support, need to