>Did you also change the variable definition to long long?
Yes
Michael Meskes
10/04/2011 05:15 AM
To
Jim Gray
cc
pgsql-bugs@postgresql.org
Subject
Re: [BUGS] BUG #6238: ECPG converts "long long" to long on Windows
Hi Jim,
> Postgres 9.1.1 installed on a Windows
the disk; the
postgres process was idle.
I also noticed this icacls.exe issue being discussed in the bug mailing
list after I had already submitted my bug report.
>Is your PC on a domain?
No.
Craig Ringer
10/03/2011 04:56 PM
To
Jim Gray , PostgreSQL bugs ,
Dave Page
cc
Subject
Re: [BUGS]
The following bug has been logged online:
Bug reference: 6238
Logged by: Jim Gray
Email address: jim.g...@bull.com
PostgreSQL version: 9.1.1
Operating system: Windows XP
Description:ECPG converts "long long" to long on Windows
Details:
Postgres 9.1.1 inst
The following bug has been logged online:
Bug reference: 6237
Logged by: Jim Gray
Email address: jim.g...@bull.com
PostgreSQL version: 9.1.1
Operating system: Windows Vista
Description:Hang during install database initialization
Details:
The only PostgreSQL release
>If Oracle strips trailing spaces on the client
side, is that a
>configurable option? How would you insert significant trailing
>spaces into a VARCHAR column if the client library strips them?
The Oracle precompiler (PROC) has an
option: CHAR_MAP=CHARZ
that allows retaining cobol's trailing
bl
>Does Oracle really munge data on the client side?
Or does it, like
>PostgreSQL, pass the host variable's value as-is to the server, and
>the server considers trailing spaces significant or not depending
>on the context?
The Oracle C preprocessor/client
library has an option to strip trailing bl
We are working in a rather complex environment,
where COBOL/SQL on a legacy
mainframe has its SQL portions sent
via a high speed link to a Unix box.
The SQL is translated to a C/SQL environment
in the process and the Postgres
ECPG preprocessor is used on the Unix
side for interfacing with Postg
What do you think of an Postgres option
that would enable stripping of trailing blanks
from connect host variables when turned
ON?
This would allow current behavior to
be supported by ECPG and the Postgres server,
but allow applications that need the
behavior (like a Cobol/SQL preprocessor for P
>Identifiers are NAME types, not CHAR types
>From the URL reference that you gave:
UPDATE MY_TABLE SET A = 5;
The tokens MY_TABLE and A are examples of identifiers.
But I don't think it is legal SQL to state this as:
UPDATE :V1 SET :V2 = 5;
In other words, host variables are never
