Re: [BUGS] BUG #1720: placeholders do not work with timestamp prefix

2005-06-17 Thread Tom Lane
"Wellie Chao" <[EMAIL PROTECTED]> writes: > I am using DBI 1.48 and DBD::Pg 1.42 (the programming language is obviously > Perl) to connect to PostgreSQL 8.0.0. The following statements cause > problems: > 2005-06-17 16:21:41 EDT LOG: statement: select * from reservation_tbl where > room_id = $1 a

[BUGS] BUG #1720: placeholders do not work with timestamp prefix

2005-06-17 Thread Wellie Chao
The following bug has been logged online: Bug reference: 1720 Logged by: Wellie Chao Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Linux (with kernel 2.4.18) Description:placeholders do not work with timestamp prefix Details: I am usin

[BUGS] plpython regression test leaves /tmp/plpython file

2005-06-17 Thread Kris Jurka
The plpython regression test leaves a file /tmp/plpython around after the tests have completed running. This causes a subsequent failure if the tests are run with another user running the database because a permission denied error will be returned when trying to write the /tmp/plpython file.

Re: [BUGS] PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms

2005-06-17 Thread Tom Lane
Kathir Velu <[EMAIL PROTECTED]> writes: > PostgreSQL-8.0.3 doesnot work with time zone value WAT0 ( for West Africa > Time ). Hmm, is there someplace where that is actually used? The zic timezone database says that WAT generally means GMT+1 not GMT. > So possibly this could be the bug wit

[BUGS] PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms

2005-06-17 Thread Kathir Velu
Hello All,       PostgreSQL-8.0.3 doesnot work with time zone value WAT0 ( for West Africa Time ).  HP Unix 11.23 PA and IPF servers set the time zone value for West Africa Time as "WAT0" in it's "/etc/TIMEZONE" file.    When we try to initialize the database directories using initdb comman

[BUGS] [postgres] dblink für Postgres

2005-06-17 Thread Carsten Sommer
Hallo, ich habe bis jetzt Sachdaten und Kataloge in getrennten Datenbanken gehalten. Eine Tcl/Tk Anwendung bringt beides zusammen. Für Webauskünfte brauche ich aber komplexe SQL Abfragen, die dann die OBJID der Kataloge auflosen. Es gibt nun die Möglichkeit die Tabellen der kataloge in die Sachdat