Re: [BUGS] PostgreSQL 7.4.1 JDBC driver bug

2004-05-06 Thread Kris Jurka
On Wed, 5 May 2004, Declan Lynch wrote: > PostgreSQL 7.4.1 JDBC driver bug > > In the package > > org.postgresql.geometric > > the class PGcircle contains what I think is an "oversight". > > For classes in this package fields are declared "public" allowing direct > access. This is true for

Re: [BUGS] CONNECT BY

2004-05-06 Thread Tom Lane
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > Here's the patch ( http://gppl.terminal.ru/ ), which allow > PostgreSQL use queries like > connect by id = prior parent_id Isn't this the same patch that we rejected a year or two back? > as described in SQL standard... AFAIK there is no such sy

[BUGS] CONNECT BY

2004-05-06 Thread Ruslan A Dautkhanov
Hello ! Here's the patch ( http://gppl.terminal.ru/ ), which allow PostgreSQL use queries like select id from tab start with = connect by id = prior parent_id as described in SQL standard... Developers can look if it's possible to merge this patch with current CVS. --

[BUGS] invalid byte sequence for encoding "EUC_TW"

2004-05-06 Thread Eric Tan
Dear Sir, We use postgresql in our company. We found an error when restoring database. We guess the problem is due to the postgresql version. Source Database: - version: Postgresql 7.3.4 - encoding: EUC_TW - OS: Red Hat 9 Target Database: - version: Postgresql 7.4.2   

Re: [BUGS] Postgre 7.3.x Bug with datetime formatting.

2004-05-06 Thread Tom Lane
"Safwan Hak" <[EMAIL PROTECTED]> writes: > select current_timestamp, to_char(current_timestamp, '-MM-DD > HH:MM:SS:US') > 2004-05-05 13:25:12.332313 2004-05-05 12:05:12:332313 Looks fine to me. I suspect what you are wanting is HH24:MI:SS, not HH:MM:SS.

Re: [BUGS] [GENERAL] cache lookup of relation 165058647 failed

2004-05-06 Thread Jan Wieck
Sean Chittenden wrote: I'v find out that this error occurs in: dependency.c file 2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation 149064743 failed 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exi

Re: [BUGS] [GENERAL] cache lookup of relation 165058647 failed

2004-05-06 Thread Jan Wieck
Sean Chittenden wrote: I'v find out that this error occurs in: dependency.c file 2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation 149064743 failed 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exis

[BUGS] Postgre 7.3.x Bug with datetime formatting.

2004-05-06 Thread Safwan Hak
Hi,   There is a problem with the to_char function when it formats the timestamp; in the example below;  The HH is different between both calls.   select current_timestamp, to_char(current_timestamp, '-MM-DD HH:MM:SS:US')   returns   timestamptz  

Re: [BUGS] BUG #1148: server restarts depending on stats options

2004-05-06 Thread Bruce Momjian
Yes, I am aware of this error and will fix it in a few days. --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1148 > Logged by: Robert Treat > > Email address:

[BUGS] BUG #1148: server restarts depending on stats options

2004-05-06 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1148 Logged by: Robert Treat Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: Slackware Linux 8.1 (Kernel 2.4.18) Description:server restarts depending on stats options Details

Re: [BUGS] BUG #1147: Getting rid of LD_LIBRARY_PATH

2004-05-06 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > ./configure LDFLAGS="-R /usr/local/lib" --with-tcl Actually, the way this is intended to be handled is to set "rpath" in the platform-specific Makefile. It looks to me like src/makefiles/Makefile.solaris does so; can you look into it and see w

[BUGS] BUG #1147: Getting rid of LD_LIBRARY_PATH

2004-05-06 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1147 Logged by: Harald Fricke Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Solaris 8 Description:Getting rid of LD_LIBRARY_PATH Details: I've got a problem with the build pr

[BUGS] BUG #1146: REFERENCES doesn't work on Inherited Tables

2004-05-06 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1146 Logged by: Gábor Katona Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Cygwin Description:REFERENCES doesn't work on Inherited Tables Details: The inserting of a row i