Hi Fred,
On Mar 15, 2005, at 9:35 AM, Fred Blaise wrote:
I am trying to grant privs to a user on all tables. I think I understood
there was no command to do that.... :// so I wrote the following:
You can find some code to do this here:
http://pgedit.com/node/view/20
I then login to psql, and do a \i myscript.sql. It returns CREATE FUNCTION, but I cannot see anything. The tables are not granted, etc... Also I am trying to find out how to debug this. How can I print out to STDOUT the value of t for example?
Unfortunately, you can't print to stdout because the procedure is executed on the database server. About the best you can do is to is to use a raise log statement:
raise log ''t is %'', t;
This will write to the PostgreSQL log. Be sure to declare t -- this may be one of your problems.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq