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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Fri, 08 Jun 2007 09:56:42 -0400
  • Message-id: <22692.1181311002@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group