Re: [BUGS] BUG #2024: Wrong Greek ISO-encoding assignment

2005-11-14 Thread Nikolaos Papageorgiou
Unfortunately it has the same behaviour both under Windows 2000 and XP alike! To confirm my suspicion I have concurrently used EnterpriseDB in both enviroments, which works perfectly well with ISO-8859-7 for Greek. I would very much appreciate if you could take another look to this issue! B

Re: [BUGS] BUG #2024: Wrong Greek ISO-encoding assignment

2005-11-14 Thread Bruce Momjian
Nikolaos Papageorgiou wrote: > > The following bug has been logged online: > > Bug reference: 2024 > Logged by: Nikolaos Papageorgiou > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.0.1 > Operating system: Windows 2000 Professional & XP Pro > Description:

Re: [BUGS] field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included

2005-11-14 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > (NB what would be the best way to get to such a patch without bothering you? > I > looked at the webcsv, but I wasn't sure whether you changed anything outside > of execMain.c and execUtils.c and I'm not sure how to find out ;)) Looking at the pgsql-

Re: [BUGS] field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included

2005-11-14 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > The following statement causes an error due to the fact that the distinct > isn't producing distinct values anymore. > This seems to be caused by the update of 'value' in the before-trigger. Fix committed --- thanks for the report!

Re: [BUGS] BUG #2040: buggy cast of INT8 to text

2005-11-14 Thread Tom Lane
"Sebastien MAYER" <[EMAIL PROTECTED]> writes: > -- next line give some strange result... but not always >var_text := 'the value of var_int8 is ' || var_int8; Couldn't duplicate a problem here ... you need to give a reproducible test case if you want anyone to look into this.

Re: [BUGS] BUG #2039: Problem with Installation

2005-11-14 Thread Magnus Hagander
> Bug reference: 2039 > Logged by: Ramesh Nagu Tummala > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: WinXP Professional > Description:Problem with Installation > Details: > > Iam trying to install postgresql in my system but my sy

Re: [BUGS] BUG #2042: Installation failed

2005-11-14 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 2042 > Logged by: mattias > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.0.2. > Operating system: Windows XP Pro > Description:Installation failed > Details: > > Downloaded postgresql-8.1.0-

[BUGS] BUG #2040: buggy cast of INT8 to text

2005-11-14 Thread Sebastien MAYER
The following bug has been logged online: Bug reference: 2040 Logged by: Sebastien MAYER Email address: [EMAIL PROTECTED] PostgreSQL version: 8.04 Operating system: Linux Fedora core 4 Description:buggy cast of INT8 to text Details: in plpgsql : declare var_tex

[BUGS] BUG #2042: Installation failed

2005-11-14 Thread mattias
The following bug has been logged online: Bug reference: 2042 Logged by: mattias Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0.2. Operating system: Windows XP Pro Description:Installation failed Details: Downloaded postgresql-8.1.0-2.zip and installed

[BUGS] BUG #2041: annoyance with COPY

2005-11-14 Thread sebastien mayer
The following bug has been logged online: Bug reference: 2041 Logged by: sebastien mayer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.04 Operating system: linux fedora core 4 Description:annoyance with COPY Details: in : copy table to file got the constra

[BUGS] BUG #2039: Problem with Installation

2005-11-14 Thread Ramesh Nagu Tummala
The following bug has been logged online: Bug reference: 2039 Logged by: Ramesh Nagu Tummala Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: WinXP Professional Description:Problem with Installation Details: Iam trying to install postgre

[BUGS] field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included

2005-11-14 Thread Frank van Vugt
L.S. I noticed that after creating these necessary objects: create table t_src(value int); create table t_dest(value int primary key); create or replace function tr_t_dest_before_iud() returns trigger language 'plpgsql' vola