Hanging creating of function

Поиск
Список
Период
Сортировка
От Mikael Carneholm
Тема Hanging creating of function
Дата
Msg-id 7F10D26ECFA1FB458B89C5B4B0D72C2B088204@sesrv12.wirelesscar.com
обсуждение исходный текст
Ответы Re: Hanging creating of function
Re: Hanging creating of function
Список pgsql-general
Can anyone explain why the first one never completes, but the second one does? (the first one just keeps running, I
canceledafter ~1 min) 
PG version: 8.1 final

-- tblname param has type varchar
create or replace function getcolstring (tblname varchar) returns varchar as $$
declare
     table_columns varchar := '';
     column_name record;
begin
     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;

     -- chop the last ','
     table_columns := substr(table_columns,1,(length(table_columns)-1));

     return table_columns;

end;
$$
language plpgsql;


-- tblname param has type text
create or replace function getcolstring (tblname text) returns varchar as $$
declare
     table_columns varchar := '';
     column_name record;
begin
     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;

     -- chop the last ','
     table_columns := substr(table_columns,1,(length(table_columns)-1));

     return table_columns;

end;
$$
language plpgsql;


/Mikael

В списке pgsql-general по дате отправления:

Предыдущее
От: TJ O'Donnell
Дата:
Сообщение: using new bitmap scans to index bit columns?
Следующее
От: "Andrus"
Дата:
Сообщение: Foreign key reference causes invalid DELETE trigger calls