[BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-02-08 Thread David Schmitt
The following bug has been logged online: Bug reference: 5869 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.5 Operating system: Windows 7 Description:postgresql corrupts unquoted non-ascii chars in column aliases Details: Example quer

[BUGS] Duplicate table name within the sme schema

2011-02-08 Thread Cyril DE MURCIA
Good morning, We use postgresql 7.3.2 under Linux Red Hat 9.0. We periodically dump and restore our database. I don't know if an error occured during a dump restore but our DB seems to be corrupted. Our base contains many pair of table with the same name. Schema are the same = public. How is

[BUGS] BUG #5870: Cannot get the first popup window during install

2011-02-08 Thread T Zimmerman
The following bug has been logged online: Bug reference: 5870 Logged by: T Zimmerman Email address: zimmee_freep...@hotmail.com PostgreSQL version: 8.4.1-2 Operating system: Vista Home Premium with SP2 Description:Cannot get the first popup window during install Detai

[BUGS] BUG #5871: database connecting failed

2011-02-08 Thread cheerag
The following bug has been logged online: Bug reference: 5871 Logged by: cheerag Email address: kavis...@gmail.com PostgreSQL version: 8.3.1 Operating system: Windows XP professional service pack 3 Description:database connecting failed Details: I have been installi

Re: [BUGS] Duplicate table name within the sme schema

2011-02-08 Thread Tom Lane
Cyril DE MURCIA writes: > We use postgresql 7.3.2 under Linux Red Hat 9.0. > We periodically dump and restore our database. I don't know if an error > occured during a dump restore but our DB seems to be corrupted. > Our base contains many pair of table with the same name. My goodness, that's a

Re: [BUGS] Duplicate table name within the sme schema

2011-02-08 Thread John R Pierce
On 02/08/11 10:20 AM, Tom Lane wrote: Cyril DE MURCIA writes: We use postgresql 7.3.2 under Linux Red Hat 9.0. We periodically dump and restore our database. I don't know if an error occured during a dump restore but our DB seems to be corrupted. Our base contains many pair of table with the sa

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-02-08 Thread mark
On Sun, Jan 30, 2011 at 12:45 PM, mark wrote: > > >> -Original Message- >> From: Robert Haas [mailto:robertmh...@gmail.com] >> Sent: Sunday, January 30, 2011 12:19 PM >> To: mark >> Cc: pgsql-bugs@postgresql.org >> Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be >>

[BUGS] BUG #5872: Function call in SQL function executed only once

2011-02-08 Thread Rodolfo Campero
The following bug has been logged online: Bug reference: 5872 Logged by: Rodolfo Campero Email address: rodolfo.camp...@anachronics.com PostgreSQL version: 8.4.5 Operating system: Debian 6.0 - Linux 2.6.32-5-amd64 Description:Function call in SQL function executed onl

Re: [BUGS] BUG #5872: Function call in SQL function executed only once

2011-02-08 Thread Tom Lane
"Rodolfo Campero" writes: > I stumbled upon a weird behavior of postgresql, I don't know if it's a bug > or not, but I find it counterintuitive: when then last statement of a SQL > function is a SELECT statement with calls another function, the call is > executed only once, regardless of the numbe

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-02-08 Thread Fujii Masao
On Wed, Feb 9, 2011 at 6:36 AM, mark wrote: > this is the recovery.conf file, see any problems with it? maybe I > didn't do some syntax right right ? > > [postgres@ data9.0]$ cat recovery.conf > standby_mode = 'on' > primary_conninfo = 'host= port=5432 user=postgres > keepalives_idle=30 keepalives

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-02-08 Thread mark
> -Original Message- > From: Fujii Masao [mailto:masao.fu...@gmail.com] > Sent: Tuesday, February 08, 2011 4:00 PM > To: mark > Cc: Robert Haas; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be > restarted manually in somecases. > > On We

Re: [BUGS] BUG #5862: Postgres dumps core upon a connection attempt

2011-02-08 Thread Matthew Zinicola
On Thu, 2011-02-03 at 22:23 -0500, Tom Lane wrote: > Craig Ringer writes: > > On 02/03/2011 11:15 PM, Matt Zinicola wrote: > >> I re-compiled with '--enable-debug' and got the symbols. The pastebin is > >> at > >> http://pastebin.com/xMhEHFdT > > > That's really interesting. It's getting a NULL

Re: [BUGS] BUG #5862: Postgres dumps core upon a connection attempt

2011-02-08 Thread Mark Kirkwood
On 04/02/11 15:11, Craig Ringer wrote: On 02/03/2011 11:15 PM, Matt Zinicola wrote: I re-compiled with '--enable-debug' and got the symbols. The pastebin is at http://pastebin.com/xMhEHFdT That's really interesting. It's getting a NULL path pointer when - I think - it tries to determine t

Re: [BUGS] [Fwd: DBD::Pg on HP-UX 11.31 64bit]

2011-02-08 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 (yes, I'm going through old emails tonight) > Spinning off into the off-topic based on the question - if you do > this, please make it *optional*. Unless you plan to actually implement > all the libpq functionality and also shoulder the burden

Re: [BUGS] BUG #5862: Postgres dumps core upon a connection attempt

2011-02-08 Thread Tom Lane
Matthew Zinicola writes: > It wasn't an unusual filesystem (other than being within a logical > volume). Nothing out of the ordinary -- a local /ext3 filesystem. I > did a clean re-install of Fedora from scratch, and boom! Postgres > compiled and installed just fine. > Two interesting tidits