visibility rule in a EXECUTE with multi sql

From: laser <laserlist(at)pgsqldb(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: visibility rule in a EXECUTE with multi sql
Date: 2008-04-10 08:03:15
Message-ID: 47FDC9C3.20000@pgsqldb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-04-10 08:13:33 Re: select statement fails
Previous Message Abhishek MANDHANA 2008-04-10 07:25:34 Re: connecting VB to postgreSQL