[BUGS] BUG #8440: sevices not started automatically

2013-09-09 Thread sabat . jitendra20
The following bug has been logged on the website: Bug reference: 8440 Logged by: Jitendra Sabat Email address: sabat.jitendr...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Window server 2012 Description: Currently i am running postgres8.3 but i

[BUGS] BUG #8441: Recursive function in plpgsql does not seem to handle null values correctly

2013-09-09 Thread tvees
The following bug has been logged on the website: Bug reference: 8441 Logged by: Tom van Ees Email address: tv...@davincigroep.nl PostgreSQL version: 9.0.4 Operating system: Windows Server 2008 R2 Description: The Levenshtein function can only handle strings with leng

Re: [BUGS] BUG #8441: Recursive function in plpgsql does not seem to handle null values correctly

2013-09-09 Thread Pavel Stehule
Hello it works on 9.1.9 postgres=# SELECT longlevenshtein(null, 'foobar'); longlevenshtein - 6 Regards Pavel P.S. unlimitted varchar is "text" type in Postgres 2013/9/9 > The following bug has been logged on the website: > > Bug reference: 8441 > Logge

Re: [BUGS] BUG #8441: Recursive function in plpgsql does not seem to handle null values correctly

2013-09-09 Thread Andres Freund
Hi, On 2013-09-09 17:26:48 +0200, Pavel Stehule wrote: > it works on 9.1.9 That's probably a question of the configured/detected max_stack_depth. I have quite some doubts such a naive implementation implemented in plgsql will work for strings > 255 chars in sensible manner though. Greetings, A

Re: [BUGS] BUG #8441: Recursive function in plpgsql does not seem to handle null values correctly

2013-09-09 Thread Tom Lane
tv...@davincigroep.nl writes: > CREATE OR REPLACE FUNCTION longlevenshtein (string1 character varying > (100), string2 character varying (100)) RETURNS integer AS $$ > BEGIN > IF (length(coalesce($1, '')) = 0 AND length(coalesce($2, '')) = 0) THEN > RETURN 0; > EL

Re: [BUGS] BUG #7817: psql does not relate to footer settings in extended mode

2013-09-09 Thread Bruce Momjian
On Sun, Jan 20, 2013 at 10:33:37AM +, emes...@redhat.com wrote: > The following bug has been logged on the website: > > Bug reference: 7817 > Logged by: Eli Mesika > Email address: emes...@redhat.com > PostgreSQL version: 9.1.7 > Operating system: Fedora 16 > Description:

Re: [BUGS] BUG #7824: documentation bug: Extract DOW

2013-09-09 Thread Bruce Momjian
On Tue, Jan 22, 2013 at 08:40:30PM +, tim.rom...@yahoo.com wrote: > The following bug has been logged on the website: > > Bug reference: 7824 > Logged by: Tim Romano > Email address: tim.rom...@yahoo.com > PostgreSQL version: 9.2.2 > Operating system: Windows 7 x64 > Descr