[BUGS] BUG #3641: Concat fails in update

2007-09-28 Thread Curt
The following bug has been logged online: Bug reference: 3641 Logged by: Curt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9-1.el5 Operating system: Centos 5 Description:Concat fails in update Details: UPDATE table content=content || 'constant' where idx

Re: [BUGS] BUG #3641: Concat fails in update

2007-09-28 Thread Milen A. Radev
Curt написа: > The following bug has been logged online: > > Bug reference: 3641 > Logged by: Curt > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.9-1.el5 > Operating system: Centos 5 > Description:Concat fails in update > Details: > > UPDATE table conte

Re: [BUGS] BUG #3641: Concat fails in update

2007-09-28 Thread Heikki Linnakangas
Curt wrote: > The following bug has been logged online: > > Bug reference: 3641 > Logged by: Curt > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.9-1.el5 > Operating system: Centos 5 > Description:Concat fails in update > Details: > > UPDATE table conten

Re: [BUGS] BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded

2007-09-28 Thread Tom Lane
"Antonio Mari" <[EMAIL PROTECTED]> writes: > LC_COLLATE: [EMAIL PROTECTED] > LC_CTYPE: [EMAIL PROTECTED] > As you see the initdb was initialized with [EMAIL PROTECTED] locale (LATIN9). > When connecting via psql to a database encoded in UTF8 a

[BUGS] Nasty tsvector can make dumps unrestorable

2007-09-28 Thread Stuart Bishop
To continue our streak of bad luck, here is the second tsearch2 bug we found this week. The attached script creates a tsvector with a value that can be dumped using pg_dump, but not loaded again using pg_restore. This causes restores of a dump containing this value to fail. This script only teste

[BUGS] BUG #3642: Tiempos de consultas diferentes

2007-09-28 Thread Arley Wilches Marcelo
The following bug has been logged online: Bug reference: 3642 Logged by: Arley Wilches Marcelo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Linux Ubuntu Server 7.04 Description:Tiempos de consultas diferentes Details: Hola, tengo una ap

[BUGS] BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded

2007-09-28 Thread Antonio Mari
The following bug has been logged online: Bug reference: 3640 Logged by: Antonio Mari Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux x 2.6.17-gentoo-r7 #1 SMP Tue Aug 29 15:01:36 CEST 2006 i686 Intel(R) Xeon(TM) CPU 3.00GHz GenuineI

Re: [BUGS] BUG #3641: Concat fails in update

2007-09-28 Thread Kevin Grittner
>>> On Fri, Sep 28, 2007 at 8:39 AM, in message <[EMAIL PROTECTED]>, "Curt" <[EMAIL PROTECTED]> wrote: > UPDATE table content=content || 'constant' where idx=101; > > Content field is overwritten with 'constant'. test=> create temp table t1 (idx int not null primary key, content text); NOTIC

Re: [BUGS] BUG #3638: UTF8 Character encoding does NOT work

2007-09-28 Thread Tatsuo Ishii
> Tatsuo Ishii wrote: > > Why do you think that an UTF-8 encoded string starting with 0x92 is > > valid? > > > > 0x92 can appear in the second, third or fourth octet, but should never > > appear in the first octet. > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > > > > >> The following bug ha

[BUGS] BUG #3643: problems downloading from mirrors

2007-09-28 Thread Lori
The following bug has been logged online: Bug reference: 3643 Logged by: Lori Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.6 Operating system: Windows XP Pro Description:problems downloading from mirrors Details: I have been trying to download this versi

Re: [BUGS] BUG #3642: Tiempos de consultas diferentes

2007-09-28 Thread Alvaro Herrera
Arley, lo tuyo no es un bug sino un problema de rendimiento. Deberias reportarlo a una lista de correo que podria ser pgsql-performance (pero tendira que ser en ingles) o pgsql-es-ayuda. Tambien podrias preguntar en el canal de IRC #postgresql-es en irc.freenode.net. -- Alvaro Herrera

Re: [BUGS] BUG #3643: problems downloading from mirrors

2007-09-28 Thread Kevin Grittner
>>> On Fri, Sep 28, 2007 at 1:29 PM, in message <[EMAIL PROTECTED]>, "Lori" <[EMAIL PROTECTED]> wrote: > PostgreSQL version: 8.1.6 > I have been trying to download this version of your database software, but > there are no mirrors that work. That's probably because it contains bugs which ha