Re: [GENERAL] pg/plsql question

2005-03-16 Thread Fred Blaise
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

Re: [GENERAL] pg/plsql question

2005-03-15 Thread Fred Blaise
of PL/pgSQL function "fred_on_all" near line 8 If anyone could shade some lights... Much appreciated. fred On Tue, 2005-03-15 at 15:35 +0100, Fred Blaise wrote: > Hello all > > I am trying to grant privs to a user on all tables. I think I understood > there was no co

Re: [GENERAL] pg/plsql question

2005-03-15 Thread Fred Blaise
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 fol

[GENERAL] pg/plsql question

2005-03-15 Thread Fred Blaise
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"

[GENERAL] replication question

2005-02-14 Thread Fred Blaise
Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base package since 7.3.x. Do you have any good pointers/how-to to direct me to? Thanks for th