Re: [BUGS] BUG #1646: ERROR: column "mycolumn" is of type boolean

2005-05-04 Thread Oliver Jowett
Kjh wrote: > The following bug has been logged online: > > Bug reference: 1646 > Logged by: Kjh > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: windows XP > Description:ERROR: column "mycolumn" is of type boolean but > expression is of

Re: [BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-04 Thread Tom Lane
Boris van Schooten <[EMAIL PROTECTED]> writes: > Don't know anything about nulls in dbf though. I am not a dbase expert, I > just run into dbfs often when trying to enter gis data into postgis. I'm considering the following patch, which turns around the test: check for an empty string and if so b

Re: [BUGS] BUG #1645: Auto complete SQL "COPY" have problems.

2005-05-04 Thread Tom Lane
"Seamus Dean" <[EMAIL PROTECTED]> writes: > When I using the TAB key to auto complete the 'copy' command,I found that > the psql create the following sql: > COPY student FROM '/home/pgsql/student.txt' DELIMETER ''; Ooops. Thanks for the report --- will fix this. regards,

Re: [BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-04 Thread Boris van Schooten
I can't find anything about dbase nulls either. Never seen one. I'll report it when I find nulls (or other bugs in the code). I'm using some 5-10 different db formats, and noticed most of the converters need some work (as usual). The isinteger seems to be made to do double duty, but it doesn't

Re: [BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-04 Thread Boris van Schooten
It only does the integer check for numbers of type integer (when # of decimals = 0), noninteger numbers are not checked in any way. If isinteger returns 0, the program does give a warning, suggesting it thinks it detected an illegal field rather than a null field. Contrary to the isinteger check

[BUGS] BUG #1645: Auto complete SQL "COPY" have problems.

2005-05-04 Thread Seamus Dean
The following bug has been logged online: Bug reference: 1645 Logged by: Seamus Dean Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Red Hat Linux 7.3 Description:Auto complete SQL "COPY" have problems. Details: When I using the TAB key

[BUGS] BUG 1614 and BUG 1616 : Inadequate GIST Behaviour

2005-05-04 Thread Sokolov Yura
People!!! Please !!! Just answer me: Someone working on it or not?!!! Or it isn't a bug? I'm going to put this bug report to PostgreSQL related forums in 10 days (if no one will answer me) Sokolov Yura [EMAIL PROTECTED] ---(end of broadcast)---

[BUGS] BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character

2005-05-04 Thread Kjh
The following bug has been logged online: Bug reference: 1646 Logged by: Kjh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows XP Description:ERROR: column "mycolumn" is of type boolean but expression is of type character Details: ne