[BUGS] BUG #1695: "select distinct" makes different output

2005-06-01 Thread philip
The following bug has been logged online: Bug reference: 1695 Logged by: philip Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: MS Windows XP sp1 and Linux Fedora core 3 Description:"select distinct" makes different output Details: Hi th

[BUGS] BUG #1693: tsearch2 won't compile

2005-06-01 Thread
The following bug has been logged online: Bug reference: 1693 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: AIX 5200-03 Description:tsearch2 won't compile Details: Trying to compile tsearch2 on AIX 5.2 ML 3 Using: gcc (GCC)

[BUGS] BUG #1692: Drop table in plpgsql

2005-06-01 Thread Jocelyn Turcotte
The following bug has been logged online: Bug reference: 1692 Logged by: Jocelyn Turcotte Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Debian linux 1:3.3.5-12 Description:Drop table in plpgsql Details: I dont know if this bug is known

[BUGS] BUG #1694: LIKE fails on column with domain after ANALYZE

2005-06-01 Thread Kevin J. Grittner
The following bug has been logged online: Bug reference: 1694 Logged by: Kevin J. Grittner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Both Windows 2000 and Linux Description:LIKE fails on column with domain after ANALYZE Details: I

Re: [BUGS] BUG #1692: Drop table in plpgsql

2005-06-01 Thread Michael Fuhr
On Tue, May 31, 2005 at 07:58:50PM +0100, Jocelyn Turcotte wrote: > > ERROR: relation with OID 3374698 does not exist > CONTEXT: SQL statement "INSERT INTO tmp values (1)" > PL/pgSQL function "bugtest" line 8 at SQL statement See "Why do I get 'relation with OID # does not exist' errors whe

Re: [BUGS] BUG #1695: "select distinct" makes different output

2005-06-01 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1695 > Logged by: philip > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: MS Windows XP sp1 and Linux Fedora core 3 > Description:"select distinct" makes different output >

Re: [BUGS] BUG #1695: "select distinct" makes different output

2005-06-01 Thread Tom Lane
"philip" <[EMAIL PROTECTED]> writes: > I installed PostgreSQL 8.0.3 database system on both platforms MS Windows XP > (sp1) and Linux Fedora 3, and both databse settings are exactly the same > with the encoding set to 'UNICODE'. Windows' support for UNICODE is kind of broken I'm afraid :-(. You s

Re: [BUGS] BUG #1694: LIKE fails on column with domain after ANALYZE

2005-06-01 Thread Tom Lane
"Kevin J. Grittner" <[EMAIL PROTECTED]> writes: > postgres=# select * from t1 where f2 like 't%'; > ERROR: unsupported type: 32740963 Confirmed in CVS tip --- looks like we missed a case where we need to flatten out a domain. Thanks for the report! regards, tom lane ---

Re: [BUGS] BUG #1694: LIKE fails on column with domain after ANALYZE

2005-06-01 Thread Tom Lane
"Kevin J. Grittner" <[EMAIL PROTECTED]> writes: > The column searched with the LIKE predicate must be defined with a domain. > Things work fine until ANALYZE or VACUUM ANALYZE is run against the table. Fixed for 8.0.4. Here is the patch if you need it immediately. regard

[BUGS] BUG #1696: Error Installation of PostgreSQL 8.0.2 on NT4

2005-06-01 Thread Marco Sfriso
The following bug has been logged online: Bug reference: 1696 Logged by: Marco Sfriso Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: windows nt4 Description:Error Installation of PostgreSQL 8.0.2 on NT4 Details: How can i install Postgr

Re: [BUGS] BUG #1696: Error Installation of PostgreSQL 8.0.2 on NT4

2005-06-01 Thread Magnus Hagander
>Bug reference: 1696 >Logged by: Marco Sfriso >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0.2 >Operating system: windows nt4 >Description:Error Installation of PostgreSQL 8.0.2 on NT4 >Details: > >How can i install PostgreSQL 8.0.2 on Winows NT4? >With the

[BUGS] Spam Re: Sample

2005-06-01 Thread dpage
I have attached the sample. Potentially Dangerous Attachment Removed. The file "word_doc.txt .pif" has been blocked. File quarantined as: "". A ---(end of broadcast)--- TIP 7: don'