that worked :) thanks for your input
fred
On Tue, 2005-03-15 at 18:00 +, Ragnar Hafstað wrote:
> On Tue, 2005-03-15 at 18:18 +0100, Fred Blaise wrote:
> > While I have accomplished what I needed with the pgedit script given by
> > John, I am still curious as to why mine is not working...
> >
On Tue, 2005-03-15 at 18:18 +0100, Fred Blaise wrote:
> While I have accomplished what I needed with the pgedit script given by
> John, I am still curious as to why mine is not working...
> Here is the latest version:
>
> /* */
> create or replace function fred_on_all() RETURNS integer AS '
> decl
While I have accomplished what I needed with the pgedit script given by
John, I am still curious as to why mine is not working...
Here is the latest version:
/* */
create or replace function fred_on_all() RETURNS integer AS '
declare
v_schema varchar;
v_user varchar;
v_t va
Fred Blaise <[EMAIL PROTECTED]> writes:
> On Tue, 2005-03-15 at 09:58 -0500, John DeSoi wrote:
>> raise log ''t is %'', t;
> Yes, that's what I thought... but oddly nothing gets written.
Fred, your original example made it look like you were writing "
(one double quote mark) where what you need t
On Mar 15, 2005, at 10:19 AM, Fred Blaise wrote:
Just to make sure... Once the function is created, you would call it as
'execute function()' from psql, correct?
Try: select function();
As a top level SQL command, EXECUTE is for executing prepared
statements:
http://www.postgresql.org/docs/8.0/i
On Tue, 2005-03-15 at 09:58 -0500, John DeSoi wrote:
> 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
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
Hello all
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:
create or replace function granting() RETURNS integer AS '
declare
v_schema varchar;
v_user varchar;
begin
v_user := "user"
