Re: [BUGS] Bug #491: ERROR: RelationClearRelation: relation using JDBC

2001-10-24 Thread Tom Lane
[EMAIL PROTECTED] writes: > ERROR: RelationClearRelation: relation using JDBC What PG version are you running? If it's reasonably current (7.1.*) I would like to see a postmaster log trace of the queries being issued by your application. (Turn on debug_print_query in postgresql.conf to make th

[BUGS] Bug #491: ERROR: RelationClearRelation: relation using JDBC

2001-10-24 Thread pgsql-bugs
Alex Korneyev ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ERROR: RelationClearRelation: relation using JDBC Long Description Hi, I have done a little research and seems like this should have been fixed, but it is not.

Re: [BUGS] New default ignored by pre-exising insert rulesets.

2001-10-24 Thread Tom Lane
Arguile <[EMAIL PROTECTED]> writes: > If a table field is altered to add a default, the default value is > bypassed by pre-existing rules. Yeah, this problem has been known for awhile (to me at least). The difficulty is that default values are added to INSERTs by the parser, which is before ru

Re: [BUGS] Decimal digits in timeofday()

2001-10-24 Thread Tom Lane
Nicola Larosa <[EMAIL PROTECTED]> writes: > There's a cute little bug somewhere. Only that the default display precision for float8 is 15 digits. regression=# SELECT date_part('epoch', now()); date_part -- 1003952920.01861 (1 row) regression=# select '1003952920.01861'::fl

[BUGS] Decimal digits in timeofday()

2001-10-24 Thread Nicola Larosa
There's a cute little bug somewhere. While SELECT timeofday(); returns six decimal digits, SELECT date_part('epoch', timeofday()::timestamp); only returns five, on a Linux Slackware 8.0 x86 machine with PostgreSQL 7.1.1 . Please do not make me dive into C code again, already fixed a si

Re: [BUGS] Bug #490: Can't compile PostgreSQL 7.1.3 with Solaris 2.6

2001-10-24 Thread Tom Lane
"Holger Mitterwald" <[EMAIL PROTECTED]> writes: > Ok, next try. I set LD_LIBRARY_PATH to /usr/local/lib. > Then the configure run clean. > Funny thing about that is that it DID find the related librarys > (libreadline etc.) earlier but failed on the test. Not a big surprise: ld doesn't pay att

[BUGS] New default ignored by pre-exising insert rulesets.

2001-10-24 Thread Arguile
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the proble

[BUGS] Enabling --debug causes regression test failure.

2001-10-24 Thread Bill Studenmund
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the proble