laser <laserlist(at)pgsqldb(dot)com> 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 string is parsed, then executed, so you are
trying to parse the insert before foo exists. Break it into multiple
EXECUTEs. Or maybe you want "create table as select ...".
regards, tom lane