Re: pg/plsql question

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