Re: [BUGS] SELECT bug?

2003-06-27 Thread Jacek Kalinski
Dnia 06/26/2003 11:12 PM, Ace napisał(a): Check the CREATE TABLE statement. Possibly you use VARCHAR type and your data has trailling spaces. Try to TRIM all the data in your database or remove trailling spaces using text editor. I don't use VARCHAR, but TEXT type. I also checked, but there are no

[BUGS] DBCP borrowObject failed

2003-06-27 Thread Azam .
hi all   I don't know if this is the right list to ask this question or not but however I'm using postgres and tomcat4.1.24, I got this error   DBCP borrowObject failed: Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL

Re: [BUGS] SELECT bug?

2003-06-27 Thread Hubert Lubaczewski
On Thu, 26 Jun 2003 23:12:53 +0200 "Ace" <[EMAIL PROTECTED]> wrote: > Check the CREATE TABLE statement. Possibly you use VARCHAR type and your > data has trailling spaces. Try to TRIM all the data in your database or > remove trailling spaces using text editor. since the code is mine, let's cast

Re: [BUGS] DBCP borrowObject failed

2003-06-27 Thread Tom Lane
"Azam ." <[EMAIL PROTECTED]> writes: > DBCP borrowObject failed: Something unusual has occured to cause the > driver to fail. Please report this exception: Exception: > java.sql.SQLException: FATAL 1: Sorry, too many clients already ^^

[BUGS] Problem with duplicate file.

2003-06-27 Thread [EMAIL PROTECTED]
Hi, I work with a database PostgreSQL 7.3.1 on Linux. I observe that the size of my database is bigger and when I verify the size for each file on the database directory, I remark that one of this files (16404) is duplicate in two files : 16404.1 and 16404.2. Moreover, the files 16404 and 16404.1

[BUGS] Problem with timezones

2003-06-27 Thread Kay-Uwe Genz
Hi, I've created a table with a column 'utc time with time zone' and then INSERT '0:00:00 XXX' where XXX is the tiemzone. In the table are all timezones and if I select with SELECT (timezone_hour FROM utc) FROM timezones; PostGreSQL return all timeszones with sign (example for IDLW it shoul

Re: [BUGS] Problem with timezones

2003-06-27 Thread Tom Lane
Kay-Uwe Genz <[EMAIL PROTECTED]> writes: > Is this a bug or is this me mistake? Yours I think. Type TIME WITH TIME ZONE stores a time of day (from 00:00:00 to 23:59:59) plus a time zone (some offset east or west of Greenwich --- I think we allow up to plus or minus 13 hours). I see nothing in th