visibility rule in a EXECUTE with multi sql - Mailing list pgsql-general

From laser
Subject visibility rule in a EXECUTE with multi sql
Date
Msg-id 47FDC9C3.20000@pgsqldb.com
Whole thread Raw
Responses Re: visibility rule in a EXECUTE with multi sql  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Abhishek MANDHANA"
Date:
Subject: Re: connecting VB to postgreSQL
Next
From: Shane Ambler
Date:
Subject: Re: include PostgreSQL utilities into 3rd party program package