visibility rule in a EXECUTE with multi sql

Поиск
Список
Период
Сортировка
От laser
Тема visibility rule in a EXECUTE with multi sql
Дата
Msg-id 47FDC9C3.20000@pgsqldb.com
обсуждение исходный текст
Ответы Re: visibility rule in a EXECUTE with multi sql
Список pgsql-general
hi all,

 when I do a:

 execute 'set search_path to bar; create table foo(f1 int);insert into
table foo blah..blah;'

in plpgsql, I found that the insert statement always report that "can't
found table foo" or something
like that. I guess it's visibility rule in PostgreSQL, but I can't found
clear docs, can someone
give me some hint about that?

thanks and best regards

laser

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

Предыдущее
От: "Abhishek MANDHANA"
Дата:
Сообщение: Re: connecting VB to postgreSQL
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: include PostgreSQL utilities into 3rd party program package