Ashok Agrawal wrote: > 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?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 & functions in the PRODUCTION on the fly. > >>>> > >>>>2. During application support, need to write script which > >>>> uses procedural language (IF ELSE, AND , OR, Cursor, Loop etc) > >>>> to produce results or identify/fix issues. Number of this kind of > >>>> Requests goes in hundreds during Quarter end. > >>>> > >>>>Currently on Oracle as long as you have sqlplus read only access, > >>>>you can write PL/SQL block and get the work done. > >>>> > >>>>Since postgres doesn't support procedural language except in > >>>>stored objects like procedure/functions, how do I achieve in > >>>>postgres without using stored objects. If this is not possible, > >>>>then does it make sense to add this requirement into TO-DO list. > >>> > >>>So you want to write procedural code on the client. > >> > >>I guess he rather wants to have dont-save-but-execute-immediately > >>pl/pgsql code. > >> > >>could this perhaps be solved by having temporary functions, similar to > >>postgresql's temporary tables ? > > > > > > I am thinking they want the ability to sit at a prompt and type stuff. > > > ~
[ application/x-soffice is not supported, skipping... ]
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings