Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > visibility rule...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15240 of 17602
Post > Topic >>

visibility rule in a EXECUTE with multi sql

by laserlist@[EMAIL PROTECTED] (laser) Apr 10, 2008 at 04:03 PM

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 re****t 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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 2 Posts in Topic:
visibility rule in a EXECUTE with multi sql
laserlist@[EMAIL PROTECTE  2008-04-10 16:03:15 
Re: visibility rule in a EXECUTE with multi sql
tgl@[EMAIL PROTECTED] (T  2008-04-10 10:23:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:10:43 CST 2008.