Re: [GENERAL] passing text value with single quote to stored procedure

2013-07-13 Thread Alban Hertroys
On Jul 13, 2013, at 24:05, Prabhjot Sheena wrote: > when this value is passed to the function > > select load_stage_start_v1('QA_SUMMER'2013_(EU/US)'); > > This gives an error. Is there a way to fix this issue. Your issue has nothing to do with stored procedures. You need to escape the stri

Re: [GENERAL] [HACKERS] Frontend/backend protocol improvements proposal (request).

2013-07-13 Thread Dmitriy Igrishin
2013/6/28 Albe Laurenz > Dmitriy Igrishin wrote: > >> Since there can be only one unnamed prepared statement per > >> session, there should be only one such object per connection. > >> It should not get deallocated; maybe it could be private to the > >> connection, which only offers a "parseUnnam

Re: [GENERAL] Build RPM from Postgres Source

2013-07-13 Thread James B. Byrne
> Date: Fri, 12 Jul 2013 14:37:19 -0700 (PDT) > From: ktewari1 > To: pgsql-general@postgresql.org > Subject: Build RPM from Postgres Source > Message-ID: <1373665039319-5763633.p...@n5.nabble.com> > > Hi, > I need to have some different settings(like NAMEDATALEN etc.) > and that's why I'm tr

Re: [GENERAL] Re: pg_upgrade could not create catalog dump while upgrading from 9.0 to 9.2

2013-07-13 Thread Adrian Klaver
On 07/12/2013 11:25 PM, shankar.kotamar...@gmail.com wrote: Thanks Adrian for your reply. You were right i am using Enterprise DB version for 9.2 and community version for 9.0. I am including the screenshot From what I can tell the community version of 9.2 does not have the same fields as you

Re: [GENERAL] Re: pg_upgrade could not create catalog dump while upgrading from 9.0 to 9.2

2013-07-13 Thread Adrian Klaver
On 07/12/2013 11:25 PM, shankar.kotamar...@gmail.com wrote: Thanks Adrian for your reply. You were right i am using Enterprise DB version for 9.2 and community version for 9.0. I am including the screenshot To follow up on my previous post, I do not use Enterprise DB, but a little digging lead

Re: [GENERAL] initdb of pg 9.0.13 fails on pg_authid

2013-07-13 Thread snark
Sorry, gcc-4.7 and "make clean" solved the problem. -- View this message in context: http://postgresql.1045698.n5.nabble.com/initdb-of-pg-9-0-13-fails-on-pg-authid-tp5750773p5763679.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing