Re: [BUGS] Assertion failure with a subtransaction and cursor

2009-12-01 Thread Heikki Linnakangas
Tom Lane wrote: > Heikki Linnakangas writes: >> On all versions starting from 8.0 where subtransactions were introduced, >> this causes an assertion failure: > > Ugh :-( > > This ties into the more general issue that it's not clear what effect a > subtransaction rollback should have on a cursor.

[BUGS] BUG #5221: errors converting string to utf8

2009-12-01 Thread DM
The following bug has been logged online: Bug reference: 5221 Logged by: DM Email address: dme...@ciseonweb.it PostgreSQL version: 8.2 / 8.4 Operating system: linux ubuntu 9.10 Description:errors converting string to utf8 Details: I'm using 2 version of pg (8.2, 8.4

Re: [BUGS] BUG #5221: errors converting string to utf8

2009-12-01 Thread Craig Ringer
On 1/12/2009 7:36 PM, DM wrote: select convert('Vall\xe9e','LATIN1','UTF8'); You expect the result 'Vallée', right? As in the utf-8 bytes Vall\xc3\xa9e ? ERROR: invalid byte sequence for encoding "UTF8": 0xe965 HINT: This error can also happen if the byte sequence does not match the enc

Re: [BUGS] BUG #5221: errors converting string to utf8

2009-12-01 Thread Tom Lane
Craig Ringer writes: > On 1/12/2009 7:36 PM, DM wrote: >> select convert('Vall\xe9e','LATIN1','UTF8'); > You expect the result 'Vallée', right? As in the utf-8 bytes >Vall\xc3\xa9e > ? The whole thing seems like an exercise in unnecessary pain anyway. Why not just set client_encoding to LAT

[BUGS] bug

2009-12-01 Thread nicolas urtizberea
The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory C:/Program Files/PostgreSQL/8.2/data ... ok creating subdirectories ... ok sel

[BUGS] BUG #5222: failed to run initdb: 1!

2009-12-01 Thread Nicolas urtizberea
The following bug has been logged online: Bug reference: 5222 Logged by: Nicolas urtizberea Email address: nurtizbe...@gmail.com PostgreSQL version: 8.3.1-1 Operating system: Windows XP Fundamentals for Legacy Pc`s SP3 Description:failed to run initdb: 1! Details: T

Re: [BUGS] BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"

2009-12-01 Thread Alvaro Herrera
Guillaume Smet escribió: > Henrik, > > On Fri, Nov 27, 2009 at 4:15 AM, Henrik Pestano wrote: > > I have a problem with the parameter LC_MESSAGES, where its value is > > es_ES.UTF-8 (Spanish), the pgFouine 1.1 not work correctly, because csvlog > > generates a column "duración: 0138 ms sentencia:

Re: [BUGS] psql -1 -f - busted

2009-12-01 Thread Bruce Momjian
Applied. Thanks for the report. --- Bruce Momjian wrote: > Robert Haas wrote: > > On Fri, Nov 27, 2009 at 1:42 AM, Peter Eisentraut wrote: > > > On tor, 2009-11-26 at 22:59 -0500, Robert Haas wrote: > > >> ISTM that if you

Re: [BUGS] BUG #5222: failed to run initdb: 1!

2009-12-01 Thread Craig Ringer
On 2/12/2009 2:25 AM, Nicolas urtizberea wrote: The following bug has been logged online: Bug reference: 5222 Logged by: Nicolas urtizberea Email address: nurtizbe...@gmail.com PostgreSQL version: 8.3.1-1 Operating system: Windows XP Fundamentals for Legacy Pc`s SP3 Wow,

[BUGS] BUG #5224: After upgrading from vista to windows 7, postgres services are missing

2009-12-01 Thread Sriram Gopalan
The following bug has been logged online: Bug reference: 5224 Logged by: Sriram Gopalan Email address: sriramgopa...@gmail.com PostgreSQL version: 8.4.1 Operating system: Windows 7 Description:After upgrading from vista to windows 7, postgres services are missing Deta