Re: [GENERAL] visibility rule in a EXECUTE with multi sql

2008-04-10 Thread Tom Lane
laser <[EMAIL PROTECTED]> writes: > 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. Well, yeah. The whole stri

[GENERAL] visibility rule in a EXECUTE with multi sql

2008-04-10 Thread laser
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 cl