[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

[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

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] 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.

[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

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