Re: case sensitivity in PQExecPrepared - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: case sensitivity in PQExecPrepared
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB34101AEE5@Herge.rcsinc.local
Whole thread Raw
In response to case sensitivity in PQExecPrepared  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: case sensitivity in PQExecPrepared
List pgsql-hackers
Peter Eisentraut wrote:
> Merlin Moncure wrote:
> > While using the PQExecPrepared interface, the statement name passed
> > to the function (as a const char*) has to be in lower case to get it
> > to work.  I kind of understand why this is, but it is kind of weird
> > that passing the exact same statement name to PQExecPrepared and
> > PREPARE does not work if it contains any upper case characters.
>
> PQExecPrepared is used in C programs, PREPARE is used in SQL programs.
> I think it's fairly obvious that those use different syntax rules.

Well, yes :)  Just to be absolutely clear what I mean, the following
will fail (pseudocode, but you get the idea):

char stmt[] = "prepare X as select 0()";
PQexec(c, "execute X"); <-- works
PQexecPrepared(c, "X" [...]); <-- fails

You are saying this is the correct and expected behavior?

Merlin



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: case sensitivity in PQExecPrepared
Next
From: Peter Eisentraut
Date:
Subject: Re: case sensitivity in PQExecPrepared