[BUGS] "like" and "ilike" not working properly on postgresql 9.0.3 where clause, bug fix not mentioned on 9.0.5 either

2011-11-18 Thread Mlungisi Sincuba
To whom it may concern, like and ilke not working on postgresql 9.0.3. Bug fix is not mentioned on 9.0.5 either. The same statement works very well on postgresql 8.4. Kind Regards, Mlungisi Sincuba

Re: [BUGS] "like" and "ilike" not working properly on postgresql 9.0.3 where clause, bug fix not mentioned on 9.0.5 either

2011-11-18 Thread Pavel Stehule
Hello 2011/11/18 Mlungisi Sincuba : > To whom it may concern, > like and ilke not working on postgresql 9.0.3. Bug fix is not mentioned on > 9.0.5 either. The same statement works very well on postgresql 8.4. > Kind Regards, > Mlungisi Sincuba can you send more informations, please? Can you send

Re: [BUGS] "like" and "ilike" not working properly on postgresql 9.0.3 where clause, bug fix not mentioned on 9.0.5 either

2011-11-18 Thread Kevin Grittner
Mlungisi Sincuba wrote: > To whom it may concern, > > like and ilke not working on postgresql 9.0.3. Bug fix is not > mentioned on 9.0.5 either. The same statement works very well on > postgresql 8.4. They work for me. Perhaps you used a different locale configuration under the new version?

[BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tigran Mkrtchyan
The following bug has been logged online: Bug reference: 6300 Logged by: Tigran Mkrtchyan Email address: tigran.mkrtch...@desy.de PostgreSQL version: 9.0.4 Operating system: Linux x86_64 Description:duplicate key value violates unique constraint Details: Hi, our ap

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tomas Vondra
On 18 Listopad 2011, 17:42, Tigran Mkrtchyan wrote: > > The following bug has been logged online: > > Bug reference: 6300 > Logged by: Tigran Mkrtchyan > Email address: tigran.mkrtch...@desy.de > PostgreSQL version: 9.0.4 > Operating system: Linux x86_64 > Description:d

[BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread M
The following bug has been logged online: Bug reference: 6301 Logged by: M Email address: sitr...@email.com PostgreSQL version: 8.4.9 Operating system: Linux Description:extra space in psql variable expansion Details: First of all, thank you for supporting a very us

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tigran Mkrtchyan
On Fri, Nov 18, 2011 at 6:52 PM, Tomas Vondra wrote: > On 18 Listopad 2011, 17:42, Tigran Mkrtchyan wrote: >> >> The following bug has been logged online: >> >> Bug reference:      6300 >> Logged by:          Tigran Mkrtchyan >> Email address:      tigran.mkrtch...@desy.de >> PostgreSQL version: 9

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Fri, Nov 18, 2011 at 1:12 PM, M wrote: > > When psql expands a :variable into a string it appends a space to the > expansion string. For example: > > psql (8.4.9) > Type "help" for help. > > testdb=> \set my_home /home/crazy > testdb=> \echo :my_home/my-script.sql > /home/crazy /my-script.sql >

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tomas Vondra
On 18 Listopad 2011, 20:38, Tigran Mkrtchyan wrote: > On Fri, Nov 18, 2011 at 6:52 PM, Tomas Vondra wrote: >> On 18 Listopad 2011, 17:42, Tigran Mkrtchyan wrote: >>> >>> The following bug has been logged online: >>> >>> Bug reference:      6300 >>> Logged by:          Tigran Mkrtchyan >>> Email ad

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Fri, Nov 18, 2011 at 4:53 PM, Michael Smolsky wrote: > Could you please also confirm that variable expansion works correctly for > psql's \i command as well? > > Test case (type on psql client prompt): > > \set my_dir /some/path/to/sql/script/dir > \i :my_dir/my-script.sql > > I expect the pars

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tigran Mkrtchyan
On Fri, Nov 18, 2011 at 9:52 PM, Tomas Vondra wrote: > On 18 Listopad 2011, 20:38, Tigran Mkrtchyan wrote: >> On Fri, Nov 18, 2011 at 6:52 PM, Tomas Vondra wrote: >>> On 18 Listopad 2011, 17:42, Tigran Mkrtchyan wrote: The following bug has been logged online: Bug reference:  

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Alex Hunsaker
On Fri, Nov 18, 2011 at 14:31, Tigran Mkrtchyan wrote: > > On Fri, Nov 18, 2011 at 9:52 PM, Tomas Vondra wrote: > > Anyway this definitely is not a bug, > > Still not convinced. You are unlikely to convince anyone here otherwise... Its works that way by design. > [...] I don't think you will

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-18 Thread lindebg
Thanks, in this case works :-) However, this does not solve all cases. Unlikely, but possible to create, cyclic case can not be restored: $ psql create database test; \connect test create function fn1(param1 int) returns int as $$ select $1 $$ language sql immutable; create function fn2(param

Re: [BUGS] BUG #6300: duplicate key value violates unique constraint

2011-11-18 Thread Tom Lane
"Tomas Vondra" writes: > On 18 Listopad 2011, 20:38, Tigran Mkrtchyan wrote: >> I think it's a bug to log with level ERROR absolute valid SQL >> statement. But it's *not* valid ... it failed. > If you don't want to see those messages in the log, there are ways to do > that correctly - Has anybo

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Sat, Nov 19, 2011 at 12:34 AM, Michael Smolsky > Now waiting for 9.2 package to ship for Ubuntu... Oh - 9.2 won't be released for a while; I tested on a recent git checkout of the main branch. It's possible that the next 9.1 point release (9.1.2) would contain this fix, but I haven't verified