pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedbug report
3+ messages / 3 participants
[nested] [flat]
* bug report
@ 1998-09-13 20:35 Giuliano A. Tarallo <aniello@tol.it>
0 siblings, 0 replies; 3+ messages in thread
From: Giuliano A. Tarallo @ 1998-09-13 20:35 UTC (permalink / raw)
To: pgsql-interfaces
Hello
The error documented in the next log appear when I try
to use pg as a ODBC Generic SQL Server with a commercial
application developed with Microsoft C++
thanks
Giuliano A.
psqlodbc.log
DSN info:
DSN='PostgreSQL',server='gat',port='5432',dbase='mydb',user='udrl',passwd='qwerty'
readonly='0',protocol='',showoid='1',fakeoidindex='1',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
conn = 33357944, SQLConnect(DSN='PostgreSQL', UID='udrl', PWD='qwerty')
Global Options: fetch=100, socket=4096, unknown_sizes=2,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=33357944, query=' '
conn=33357944, query='set DateStyle to 'ISO''
conn=33357944, query='set geqo to 'OFF''
conn=33357944, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=33357944, query='select relname, usename, relhasrules from
pg_class, pg_user where relkind = 'r' and relname !~ '^pg_|^dd_' and
relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner) order
by relname'
[ fetched 0 rows ]
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE TABLE MovAgeR (IDMovAge int4,Riga
int2,Agente char(8),ImpBase float8,ImpProvv float8,DtaPrevMat
datetime,DtaEffMat datetime,Sospesa char(1),GiaAutoFtt char(1),GiaFttAge
char(1),Storna char(1),Nota char(64))'
conn=33357944, query='COMMIT'
conn=33357944, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from
pg_user u, pg_class c, pg_attribute a, pg_type t where
int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and
a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'MovAgeR' order
by attnum'
[ fetched 0 rows ]
conn=33357944, query='select distinct on attnum a2.attname, a2.attnum
from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where
c.relname = 'MovAgeR_pkey' AND c.oid = i.indexrelid AND a1.attrelid =
c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum OR
i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] =
a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR
i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum'
[ fetched 0 rows ]
STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Null
statement result in SQLFetch.'
------------------------------------------------------------
hdbc=33357944, stmt=33372436, result=0
manual_result=1, prepare=0, internal=0
bindings=33438208, bindings_allocated=6
parameters=0, parameters_allocated=0
statement_type=-2, statement='(null)'
stmt_with_params=''
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=3,
scroll_concurrency=1
cursor_name=''
----------------QResult Info
-------------------------------
CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg=''
------------------------------------------------------------
henv=34410316, conn=33357944, status=1, num_stmts=16
sock=34410332, stmts=34410372, lobj_type=-999
---------------- Socket Info -------------------------------
socket=36, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=33364236, buffer_out=33368336
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE UNIQUE INDEX Idx1 ON MovAgeR
(IDMovAge,Riga)'
conn=33357944, query='COMMIT'
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE INDEX Idx2 ON MovAgeR (Agente,DtaEffMat)'
conn=33357944, query='COMMIT'
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE INDEX Idx3 ON MovAgeR
(DtaEffMat,Agente,GiaAutoFtt,GiaFttAge)'
conn=33357944, query='COMMIT'
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE TABLE CodParlRadiceStato (RadiceCodParl
char(21),ISOStato char(2),Descri char(32),Prezzo float8,Nota char(64))'
conn=33357944, query='COMMIT'
conn=33357944, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from
pg_user u, pg_class c, pg_attribute a, pg_type t where
int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and
a.atttypid = t.oid and (a.attnum > 0) and c.relname like
'CodParlRadiceStato' order by attnum'
[ fetched 0 rows ]
conn=33357944, query='select distinct on attnum a2.attname, a2.attnum
from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where
c.relname = 'CodParlRadiceStato_pkey' AND c.oid = i.indexrelid AND
a1.attrelid = c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum
OR i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] =
a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR
i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum'
[ fetched 0 rows ]
STATEMENT ERROR: func=SQLFetch, desc='', errnum=3, errmsg='Null
statement result in SQLFetch.'
------------------------------------------------------------
hdbc=33357944, stmt=33372436, result=0
manual_result=1, prepare=0, internal=0
bindings=33438620, bindings_allocated=6
parameters=0, parameters_allocated=0
statement_type=-2, statement='(null)'
stmt_with_params=''
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=3,
scroll_concurrency=1
cursor_name=''
----------------QResult Info
-------------------------------
CONN ERROR: func=SQLFetch, desc='', errnum=0, errmsg=''
------------------------------------------------------------
henv=34410316, conn=33357944, status=1, num_stmts=16
sock=34410332, stmts=34410372, lobj_type=-999
---------------- Socket Info -------------------------------
socket=36, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=33364236, buffer_out=33368336
buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45
conn=33357944, query='BEGIN'
conn=33357944, query='CREATE UNIQUE INDEX Idx1 ON CodParlRadiceStato
(RadiceCodParl,ISOStato)'
ERROR from backend during send_query: 'ERROR: Cannot create index:
'idx1' already exists'
conn=33357944, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error
creating the table'
------------------------------------------------------------
hdbc=33357944, stmt=33372436, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE UNIQUE INDEX Idx1
ON CodParlRadiceStato (RadiceCodParl,ISOStato)'
stmt_with_params='CREATE UNIQUE INDEX Idx1 ON
CodParlRadiceStato (RadiceCodParl,ISOStato)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=3,
scroll_concurrency=1
cursor_name='SQL_CUR33372436'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: Cannot
create index: 'idx1' already exists'
------------------------------------------------------------
henv=34410316, conn=33357944, status=1, num_stmts=16
sock=34410332, stmts=34410372, lobj_type=-999
---------------- Socket Info -------------------------------
socket=36, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=33364236, buffer_out=33368336
buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
parameters=0, parameters_allocated=0
statement_type=-2, statement='(null)'
stmt_with_params=''
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
thanks
Giuliano A.
^ permalink raw reply [nested|flat] 3+ messages in thread
* bug report
@ 2002-12-29 23:07 Stephane Paquin <selt@philosophiebleue.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stephane Paquin @ 2002-12-29 23:07 UTC (permalink / raw)
To: pgsql-interfaces
Hi ! Here's a minor(major?) bug I've noticed while using the CPAN module Pg
(pgsql_perl5-1.9.0).
I'm using perl 5.06.1, PostgreSQL 7.1.3 and pgsql_perl5-1.9.0.
When attempting to do the following in perl:
#!/usr/bin/perl -w
#
# Perl sample program
#
use Pg; # load database
routines
$conn = Pg::connectdb("dbname=SIA"); # connect to the
database
# did the database
connection fail?
die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
There appears to be a tolower(str) expression ran against the content of the
connection string in the Pg::connectdb module. With PostgreSQL, I've set up
a database called SIA, and I can't connect to it via this method. If I
create a database called sia, the connection gets established. I take it the
problem would persist with passwords using mixes of UPPER/lowercase
characters and result in connection failures. :(
Hope this helps make the Pg module better ! :)
Here's the output of perl -v & perl -V :
-----------------------------------------------------
$ perl -v
This is perl, v5.6.1 built for i386-openbsd
Copyright 1987-2001, Larry Wall
Perl may be copied only under the terms of either the Artistic License
or the
GNU General Public License, which may be found in the Perl 5 source kit
.
Complete documentation for Perl, including FAQ lists, should be found o
n
this system using `man perl' or `perldoc perl'. If you have access to
the
Internet, point your browser at http://www.perl.com/, the Perl Home Pag
e.
$ perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration
:
Platform:
osname=openbsd, osvers=3.2, archname=i386-openbsd
uname='openbsd'
config_args='-Dopenbsd_distribution=defined -dsE'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultipli
city=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include',
optimize='-O2',
cppflags='-fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='2.95.3 20010125 (prerelease)', gccosa
rs='openbsd3.2'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsiz
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/usr/lib
libs=-lm -lc -lutil
perllibs=-lm -lc -lutil
libc=/usr/lib/libc.so.28.5, so=so, useshrplib=true, libperl=lib
.so.6.1
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=define, ccdlflags='-Wl,
sr/libdata/perl5/i386-openbsd/5.6.1/CORE'
cccdlflags='-DPIC -fPIC ', lddlflags='-shared -fPIC '
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under openbsd
Compiled at Dec 11 2002 07:48:13
@INC:
/usr/libdata/perl5/i386-openbsd/5.6.1
/usr/local/libdata/perl5/i386-openbsd/5.6.1
/usr/libdata/perl5
/usr/local/libdata/perl5
/usr/local/libdata/perl5/site_perl/i386-openbsd
/usr/libdata/perl5/site_perl/i386-openbsd
/usr/local/libdata/perl5/site_perl
/usr/libdata/perl5/site_perl
/usr/local/lib/perl5/site_perl
.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: bug report
@ 2003-01-02 20:38 Tom Lane <tgl@sss.pgh.pa.us>
parent: Stephane Paquin <selt@philosophiebleue.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-01-02 20:38 UTC (permalink / raw)
To: Stephane Paquin <selt@philosophiebleue.com>; +Cc: pgsql-interfaces
"Stephane Paquin" <selt@philosophiebleue.com> writes:
> There appears to be a tolower(str) expression ran against the content of the
> connection string in the Pg::connectdb module.
The source code appears to believe this is a feature. Pg.pm documents it:
When opening a connection a given database name is always converted to
lower-case, unless it is surrounded by double quotes.
I'd call it a misfeature myself, but it's probably too late to change.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-01-02 20:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-13 20:35 bug report Giuliano A. Tarallo <aniello@tol.it>
2002-12-29 23:07 bug report Stephane Paquin <selt@philosophiebleue.com>
2003-01-02 20:38 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox