Bugfix patches in the next CF, was: Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-17 Thread Boszormenyi Zoltan
2013-05-16 23:55 keltezéssel, Alvaro Herrera írta: Josh Kupershmidt escribió: On Thu, May 16, 2013 at 4:34 PM, hubert depesz lubaczewski wrote: only when Pg is started with relative path, and restarted with absolute, the problem shows. It has been a nuisance for me too. Possible patch for pg_

Re: [BUGS] BUG #8167: false EINVAL -22 for opening a file

2013-05-17 Thread Nelson Minar
Thanks for the reply; glad it looks like a probable bug with a straightforward fix. FWIW, here's a discussion from last year that looks like people hitting the same problem. Same mysterious EINVAL logged opening a file, on Macs. No conclusion in that discussion. http://comments.gmane.org/gmane.co

[BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread vladimir . jovanovic
The following bug has been logged on the website: Bug reference: 8168 Logged by: Vladimir Jovanović Email address: vladimir.jovano...@aparteko.com PostgreSQL version: 8.4.11 Operating system: PostgreSQL 8.4.11 on x86_64-redhat-linux-gnu, com Description: Hi, I notice

Re: [BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread Heikki Linnakangas
On 17.05.2013 13:31, vladimir.jovano...@aparteko.com wrote: I noticed that I have two functions with the same signature. sp_get_league_prediction(IN _id bigint, IN _rank integer, IN _log_in_expectence double precision, IN _feathers_gained integer, IN _tokens_all integer, IN _tokens_active intege

Re: Bugfix patches in the next CF, was: Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-17 Thread Heikki Linnakangas
On 17.05.2013 11:57, Boszormenyi Zoltan wrote: Sorry for diverting the thread but if bugfixes are urgent, you can also look at http://www.postgresql.org/message-id/cabuevewx2dqt45x1phhdzd_khy8hz5a9xo95xvghou2ztyn...@mail.gmail.com and the fix at https://commitfest.postgresql.org/action/patch_vie

Re: [BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread Tom Lane
Heikki Linnakangas writes: > On 17.05.2013 13:31, vladimir.jovano...@aparteko.com wrote: >> I noticed that I have two functions with the same signature. >> >> sp_get_league_prediction(IN _id bigint, IN _rank integer, IN >> _log_in_expectence double precision, IN _feathers_gained integer, IN >> _t

Re: [BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread Heikki Linnakangas
On 17.05.2013 18:53, Vladimir Jovanovic wrote: Hi Heikki, Here you can find attached .csv semicolon separated made by :"SELECT * FROM pg_proc WHERE proname LIKE 'sp_get_league_prediction". "\df sp_get_league_prediction" is also attached. Both functions are returning the same setof record:

Re: [BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread Vladimir Jovanovic
It looks I knocked on the wrong address. This is obviously PgAdmin bug which obviously not correctly showing procedures (as I sent previously) and made me waste your time, sorry. On Fri, May 17, 2013 at 6:10 PM, Heikki Linnakangas wrote: > On 17.05.2013 18:53, Vladimir Jovanovic wrote: > >> H

Re: [BUGS] BUG #8168: duplicated function signature

2013-05-17 Thread Vladimir Jovanovic
Hi Heikki, Here you can find attached .csv semicolon separated made by :"SELECT * FROM pg_proc WHERE proname LIKE 'sp_get_league_prediction". "\df sp_get_league_prediction" is also attached. Both functions are returning the same setof record: --- CREATE OR REPLACE FUNCTIO