Re: Hanging creating of function

Postgres machine OS: RHEL release 2.1 (Panama)
PGAdminIII client OS: WinXP Pro 2002 SP2
Clients: psql, PGAdminIII Query tool

dfol=> select version();
version
-------------------------------------------------------------
PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC 2.96

The original versions looked like this (same behaviour though):

create or replace function dfol.getcolstring (tblname varchar) returns varchar as $$
declare
table_columns text;
column_name record;
begin
-- skapa kolumnnamns-strängarna
for column_name in select pga.attname from pg_attribute pga, pg_class pgc
where pga.attrelid = pgc.relfilenode and pgc.relname = tblname and pga.attnum > 0 loop
table_columns := table_columns || column_name.attname || ',';
end loop;

-- kapa av sista kommatecknet
table_columns := substring(table_columns from 1 for length(table_columns)-1);

return table_columns;

end;
$$
language plpgsql;

create or replace function dfol.getcolstring (tblname text) returns varchar as $$
declare
table_columns text;
column_name record;
begin
-- skapa kolumnnamns-strängarna
for column_name in select pga.attname from pg_attribute pga, pg_class pgc
where pga.attrelid = pgc.relfilenode and pgc.relname = tblname and pga.attnum > 0 loop
table_columns := table_columns || column_name.attname || ',';
end loop;

-- kapa av sista kommatecknet
table_columns := substring(table_columns from 1 for length(table_columns)-1);

return table_columns;

end;
$$
language plpgsql;

-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
Sent: den 9 november 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 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 and
Solaris 9/sparc. What client are you using? If not psql, have
you tried with psql? What platform are you on?

--
Michael Fuhr