Adding same column to several tables.

Поиск
Список
Период
Сортировка
От Łukasz Brodziak
Тема Adding same column to several tables.
Дата
Msg-id DUB128-W67EFD26DEC27182E9E45319C560@phx.gbl
обсуждение исходный текст
Ответы Re: Adding same column to several tables.
Re: Adding same column to several tables.
Список pgsql-admin
Дерево обсуждения
Hello,

I have a function to add column to all tables from the list:
do
$$
declare 
  relnam pg_class.relname%TYPE;
  kur cursor for select c.relname
  from pg_class as c
    inner join pg_attribute as a on a.attrelid = c.oid
  where a.attname = 'some_id' and c.relkind = 'r';
begin
  open kur;
  LOOP
    Fetch kur into relnam;
    exit when not found;
    EXECUTE 'ALTER TABLE '|| relnam|| ' add column another_id integer default -1';
  END LOOP;
  close kur;
END;
$$

I have 22 table names returned by the query used by cursor. Whe I run the function it executes for 1.5 minutes. Is there a way of doing it faster?

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: MultiXactId xxxxxxxxx has not been created yet -- apparent wraparound
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Adding same column to several tables.