[BUGS] JDBC-Driver produces wrong output.

2000-11-02 Thread pgsql-bugs
Jan Thomae ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC-Driver produces wrong output. Long Description Hi, I recently downloaded the last snapshot of PostgreSQL and also the newest JDBC-Driver for it. I played a bit a

[BUGS] My Bug report: JDBC-Driver produces wrong output.

2000-11-02 Thread Jan Thomae
Hi, I had a look over the JDBC-Driver and was able to remove the bug. It seems, that the formatting of the timestamp caused the malfunction. I'd like to send you my modifications, since you might be interested in them: File: ResultSet.java Directory: src/interfaces/jdbc/org/postgresql/jdbc2

[BUGS] LIKE(~~) OR regular pattern(~) deliver incomplete output

2000-11-02 Thread pgsql-bugs
ernst reeh ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description LIKE(~~) OR regular pattern(~) deliver incomplete output Long Description I work with POSTGRES version 6.4, so maybe the bug is already fixed. Please tell me if it's s

[BUGS] version info to bug#94 (LIKE(~~) ...)

2000-11-02 Thread pgsql-bugs
ernst reeh ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description version info to bug#94 (LIKE(~~) ...) Long Description Sorry, i didn't give you the complete version info for my bug-report: PostgreSQL 6.4.2 on i686-pc-linux-gnu, comp

[BUGS] Bug#94 is related to compiler-version

2000-11-02 Thread pgsql-bugs
ernst.reeh ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Bug#94 is related to compiler-version Long Description Sorry again, The bug didn't appear on another machine with the following version-info: --

Re: [BUGS] RPM install weirdness & BugreportPage Bug

2000-11-02 Thread Lamar Owen
Thomas Linden wrote: > I suggest a little bit more investigation and testing before publishing > rpm packages, a rpm package must be installable unless it cannot find a > required package. if this is the case, then this package must be You must put all the RPM's on the same command line invocatio

[BUGS] Bug in Time/Date routines

2000-11-02 Thread Moritz Gmelin
Hi Folks ! I just found a bug in the postgresql time/date routines. Try the following in the psql shell : select ('10-01-2000'::date + ('1 month')::timespan)::date; The result is going to be 10-31-2000 But it should be 11-01-2000 If you take any other month than October, it is working fine

Re: [BUGS] Bug#94 is related to compiler-version

2000-11-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > So, its not a POSTGRES-Bug, it's a mess with different SUSE-, kernel-, >Compiler-Versions. More likely, it's related to what LOCALE you are using. There are known problems with LIKE optimization in non-ASCII locales, particularly in 6.4.*. Try updating to 7.0.*

Re: [BUGS] Bug in Time/Date routines

2000-11-02 Thread Tom Lane
Moritz Gmelin <[EMAIL PROTECTED]> writes: > If you take any other month than October, it is working fine. So > 09-01-2000 + 1 month => 10-01-2000. Hmm, I was expecting to find that fixed in current sources, but it's still broken: regression=# select ('10-01-2000'::timestamp + ('1 month')::timesp

Re: [BUGS] Bug in Time/Date routines

2000-11-02 Thread Thomas Lockhart
> > If you take any other month than October, it is working fine. So > > 09-01-2000 + 1 month => 10-01-2000. > regression=# select ('10-01-2000'::timestamp + ('1 month')::timespan); > ?column? > > 2000-10-31 23:00:00-05 > (1 row) > Thomas, isn't the addition of '1

[BUGS] waiting for lock?

2000-11-02 Thread Lennert Buytenhek
Hi, this evening I found a whole bunch of cron jobs hanging on a VACUUM of a database. I killed them off and retried manually: ulsec=> vacuum; NOTICE: Skipping "pg_type" --- only table owner can VACUUM it NOTICE: Skipping "pg_attribute" --- only table owner can VACUUM it NOTICE: Skipping "pg

Re: [BUGS] RPM install weirdness & BugreportPage Bug

2000-11-02 Thread Thomas Linden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yes, you are right, 6.3.2 was installed (which I never knew!) and contained that postgresql-clients package. After removing the old packages, everything worked very well. Thanks a lot for the help! regards, Thomas - -- => PGP key: http://daemon.de/

[BUGS] psql client segfault

2000-11-02 Thread Thomas Linden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi, me again :-) ok, after installing the rpm's everything was fine except connecting to the database using the supplied client program psql. It ended with a segmentation fault. So I thought it would be a good idea to try to install the software fro

Re: [BUGS] psql client segfault

2000-11-02 Thread Tom Lane
A corefile is of no value to anyone running on a platform even slightly different from your own. Could you please compile psql with -g, reproduce the problem, and then send in a gdb backtrace from that core? Also, what exactly are you doing that provokes the coredump? FWIW, I have a RedHat 5.1

Re: [BUGS] performace about your search engine

2000-11-02 Thread The Hermit Hacker
On Thu, 2 Nov 2000 [EMAIL PROTECTED] wrote: > P. Ashok Kumar ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > performace about your search engine > > Long Description > You search engine takes long time to give results