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 databa

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

[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:/

[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 timest

[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 postgr

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 wrote: > Simon Riggs writes: >> On 26 May 2013 17:10, Tom Lane wrote: >>> More readable would be to invent an intermediate nonterminal falling >>> between ColId and ColLabel, whose expansion would be "IDENT | >>> unreserved_keyword | col_name_keyword |

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: > >

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 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 serv

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=" l

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 li

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 e

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 vie