Re: [GENERAL] Hanging creating of function

2005-11-10 Thread Mikael Carneholm
005 16:46 To: Mikael Carneholm Cc: 'Pgsql-General (E-mail) Subject: Re: [GENERAL] Hanging creating of function On Wed, Nov 09, 2005 at 08:19:32PM +0100, Mikael Carneholm wrote: > Postgres machine OS: RHEL release 2.1 (Panama) > PGAdminIII client OS: WinXP Pro 2002 SP2 > Clients: psql, P

Re: [GENERAL] Hanging creating of function

2005-11-10 Thread Michael Fuhr
On Wed, Nov 09, 2005 at 08:19:32PM +0100, Mikael Carneholm wrote: > Postgres machine OS: RHEL release 2.1 (Panama) > PGAdminIII client OS: WinXP Pro 2002 SP2 > Clients: psql, PGAdminIII Query tool The function creation hangs even with psql? Where did you run psql from -- the Windows box, the Linu

Re: [GENERAL] Hanging creating of function

2005-11-09 Thread Mikael Carneholm
ovember 2005 19:56 To: Mikael Carneholm Cc: 'Pgsql-General (E-mail) Subject: Re: [GENERAL] Hanging creating of function On Wed, Nov 09, 2005 at 07:38:53PM +0100, Mikael Carneholm wrote: > Can anyone explain why the first one never completes, but the second > one does? (the first one jus

Re: [GENERAL] Hanging creating of function

2005-11-09 Thread Tom Lane
"Mikael Carneholm" <[EMAIL PROTECTED]> writes: > Can anyone explain why the first one never completes, but the second > one does? They both work fine for me ... regards, tom lane ---(end of broadcast)--- TIP 1: if posting/re

Re: [GENERAL] Hanging creating of function

2005-11-09 Thread Michael Fuhr
On Wed, Nov 09, 2005 at 07:38:53PM +0100, Mikael Carneholm wrote: > Can anyone explain why the first one never completes, but the second > one does? (the first one just keeps running, I canceled after ~1 min) > > PG version: 8.1 final Both functions create fine here in 8.1.0 on FreeBSD 6.0/i386 an

[GENERAL] Hanging creating of function

2005-11-09 Thread Mikael Carneholm
Can anyone explain why the first one never completes, but the second one does? (the first one just keeps running, I canceled after ~1 min) PG version: 8.1 final -- tblname param has type varchar create or replace function getcolstring (tblname varchar) returns varchar as $$ declare table_col