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

Re: PQprepare case sensitive?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: PQprepare case sensitive?
Date: 2007-06-08 13:56:42
Message-ID: 22692.1181311002@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Michael Meskes <meskes(at)postgresql(dot)org> writes:
> I haven't looked into the sources yet, but PQprepare's behaviour in my
> new ecpglib code suggests that the statement name is case sensitive. Is
> this by design?

Yes, it's assumed that any quoting/dequoting has already happened by the
time the name gets into the protocol message.

> I wonder because a statement like this cannot be
> deallocated afterwards since the parser is case insensitive with regard
> to statement names.

Sure it can --- use quotes.

			regards, tom lane

In response to

Responses

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2007-06-08 14:58:30
Subject: Re: PQprepare case sensitive?
Previous:From: Michael MeskesDate: 2007-06-08 12:33:51
Subject: PQprepare case sensitive?

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