Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 12:39 AM Brice André wrote: Dear all, I found what I really think is a bug in the postgresql 8.4. I have an sql database structure in which a real table has a column that is used to mark the entries as deleted without really deleting them. Then, I have a view that

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Guillaume Lelarge
On Tue, 2013-05-28 at 12:41 +0530, Amit Kapila wrote: On Tuesday, May 28, 2013 12:39 AM Brice André wrote: Dear all, I found what I really think is a bug in the postgresql 8.4. I have an sql database structure in which a real table has a column that is used to mark the entries as

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 1:28 PM Brice André wrote: I shall look into it today in later half of the day. Dear Amit, Thanks for your answer. I performed the same test as you and I get the same result (on my linux server, debian, postgresql 8.4). Maybe the problem is related to libpq ?

Re: [BUGS] BUG #7659: LDAP auth does not search the subtree

2013-05-28 Thread Peter Eisentraut
On 5/21/13 2:54 AM, Andrzej Cedro wrote: I use PostgeSQL 9.1 32-bit on Windows 7 Professional with Active Directory as LDAP. I have following configration in pg_hba.conf: host all all all ldapldapserver=192.168.155.157 ldapbinddn=CN=aa,OU=b,DC=,DC=

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 1:54 PM Brice André wrote: On Tuesday, May 28, 2013 1:28 PM Brice André wrote: I shall look into it today in later half of the day. Dear Amit, Thanks for your answer. I performed the same test as you and I get the same result (on my linux server, debian,

Re: [BUGS] BUG #8172: entering the hostname in the address column in pg_hba.conf doesn't work as it should

2013-05-28 Thread Peter Eisentraut
On 5/21/13 3:41 AM, tudorbara...@yahoo.com wrote: In pg_hba.conf I have the following setup: hostall all laptop md5 Although the hostname gets resolved by the system (LAN DNS server) I still get the no pg_hba.conf entry error. Check that the following works: $ host

Re: [BUGS] BUG #8174: Ownership reassigned public schema restored with postgres as owner

2013-05-28 Thread Peter Eisentraut
On 5/21/13 6:25 PM, pol...@yahoo.com wrote: The following bug has been logged on the website: Bug reference: 8174 Logged by: David Johnston Email address: pol...@yahoo.com PostgreSQL version: 9.0.13 Operating system: Ubuntu Linux 10.04 Description: Having

Re: [HACKERS] [BUGS] COPY .... (FORMAT binary) syntax doesn't work

2013-05-28 Thread Robert Haas
On Mon, May 27, 2013 at 10:31 AM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On 26 May 2013 17:10, Tom Lane t...@sss.pgh.pa.us wrote: More readable would be to invent an intermediate nonterminal falling between ColId and ColLabel, whose expansion would be

[BUGS] BUG #8182: Database name duplicate in one postgres instance

2013-05-28 Thread sachinthana . anuradha
The following bug has been logged on the website: Bug reference: 8182 Logged by: Sachinthana Rajapaksha Email address: sachinthana.anura...@yahoo.com PostgreSQL version: Unsupported/Unknown Operating system: redhat Description: Hi, We are having a problem with

[BUGS] BUG #8183: field timestamp result to date

2013-05-28 Thread bkhamphousone
The following bug has been logged on the website: Bug reference: 8183 Logged by: khamphousone Email address: bkhamphous...@sopragroup.com PostgreSQL version: 9.2.3 Operating system: Linux debian Description: In a SQL script, I've got a create table command with

[BUGS] query regardinf pgadmin3

2013-05-28 Thread Himanshu Rana
  hi, how i can make plugins icon active in pgadmin3 in ubuntu??   Thanks Regards, Himanshu Rana Project Officer, GIS Department, Foundation of Ecological Security, Anand, Gujarat- 388001 -- Dave Page PostgreSQL Core Team http://www.postgresql.org/

Re: [BUGS] BUG #8183: field timestamp result to date

2013-05-28 Thread hubert depesz lubaczewski
On wto, maj 28, 2013 at 01:36:48 +, bkhamphous...@sopragroup.com wrote: The following bug has been logged on the website: Bug reference: 8183 Logged by: khamphousone Email address: bkhamphous...@sopragroup.com PostgreSQL version: 9.2.3 Operating system: Linux

Re: [BUGS] bug in Prepared statement with DELETE RETURNING and rule on view

2013-05-28 Thread Amit Kapila
On Tuesday, May 28, 2013 6:50 PM Brice André wrote: Hello Amit, Thanks for your answer. The reason why it does not work is still not really clear for me .What I find very strange is that, if you perform exactly same request, with exactly same C++ code, but that you change the database