Re: [BUGS] BUG #6723: Exception for correct query

2012-07-09 Thread Tom Lane
heiko.helmbre...@xclinical.com writes: > The optimizer is using a where condition for a full table, not to the > results of a join/subselect result, that's why it is tried to use casts, > that cannot work on the whole table, here are the easy steps to reproduce > the problems: This is not a bug.

Re: [BUGS] BUG #6724: EXCEPTION syntax not recgonised

2012-07-09 Thread Pavel Stehule
Hello This is not bug keyword EXCEPTION is supported only in plpgsql. Regards Pavel Stehule 2012/7/9 : > The following bug has been logged on the website: > > Bug reference: 6724 > Logged by: Chine Bleu > Email address: chine.b...@yahoo.com > PostgreSQL version: 9.0.4 > Ope

[BUGS] BUG #6724: EXCEPTION syntax not recgonised

2012-07-09 Thread chine . bleu
The following bug has been logged on the website: Bug reference: 6724 Logged by: Chine Bleu Email address: chine.b...@yahoo.com PostgreSQL version: 9.0.4 Operating system: macosx Description: query: BEGIN INSERT INTO config (name, value) VALUES (E'dbexp', E'10'); EXCE

[BUGS] BUG #6723: Exception for correct query

2012-07-09 Thread heiko . helmbrecht
The following bug has been logged on the website: Bug reference: 6723 Logged by: Heiko Helmbrecht Email address: heiko.helmbre...@xclinical.com PostgreSQL version: 8.4.12 Operating system: Linux Description: The optimizer is using a where condition for a full table, n

Re: [BUGS] BUG #6725: hot-standby slave repeatable crashed after restart (GIN error)

2012-07-09 Thread Maxim Boguk
> > > 2012-07-10 03:31:35 MSK 12202 @ from [vxid:1/0 txid:0] [] PANIC: GIN > > metapage disappeared > > This is fixed in current minor releases. > > > http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=268ca4f57ea2dc3bf0dfb0f5c17fbda269b5d462 > > regards, to

Re: [BUGS] BUG #6725: hot-standby slave repeatable crashed after restart (GIN error)

2012-07-09 Thread Tom Lane
maxim.bo...@gmail.com writes: > On one of my production databases hot-standby server start repeatable crash > after restart. > 2012-07-10 03:31:35 MSK 12202 @ from [vxid:1/0 txid:0] [] PANIC: GIN > metapage disappeared This is fixed in current minor releases. http://git.postgresql.org/gitweb/?

[BUGS] BUG #6725: hot-standby slave repeatable crashed after restart (GIN error)

2012-07-09 Thread maxim . boguk
The following bug has been logged on the website: Bug reference: 6725 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.0.7 Operating system: Debian Linux Description: Hi, On one of my production databases hot-standby server start repe

Re: [BUGS] BUG #6722: Debugger broken?

2012-07-09 Thread Dave Page
Hi On Mon, Jul 9, 2012 at 12:58 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 6722 > Logged by: Jan-Peter Seifert > Email address: jan-peter.seif...@gmx.de > PostgreSQL version: 9.1.4 > Operating system: Windows 7 Enterprise (64-bit) > Des

[BUGS] BUG #6722: Debugger broken?

2012-07-09 Thread jan-peter . seifert
The following bug has been logged on the website: Bug reference: 6722 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@gmx.de PostgreSQL version: 9.1.4 Operating system: Windows 7 Enterprise (64-bit) Description: Hello, it seems that the debugger doesn't