Re: frustrated by plpgsql procedure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: frustrated by plpgsql procedure
Дата
Msg-id 16520.1143487685@sss.pgh.pa.us
обсуждение исходный текст
Ответ на frustrated by plpgsql procedure  (Dino Vliet <dino_vliet@yahoo.com>)
Список pgsql-general
Dino Vliet <dino_vliet@yahoo.com> writes:
> I trying for days to get this simple plpgsql procedure
> to run but I keep getting this error:

You can't ordinarily use a variable to supply a table (or field) name
in a plpgsql query; that doesn't work because plpgsql wants to cache a
plan for the query.  A workaround is to build the query as a string
value, then use EXECUTE.

            regards, tom lane

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

Предыдущее
От: Bricklen Anderson
Дата:
Сообщение: Re: frustrated by plpgsql procedure
Следующее
От: "Mark Feller"
Дата:
Сообщение: General advice on database/web applications