Skip site navigation (1) Skip section navigation (2)

Re: How to catch a command

From: Humberto Carvalho <carvalho(dot)humberto(at)gmail(dot)com>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to catch a command
Date: 2005-07-22 16:01:36
Message-ID: 84c833550507220901790a3ced@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
ok...

in this case the rules don't work, because the db that i use don't
have any data, only the structure. So i need to send the command to
the real databases that are in a diferente server.

So if i use triggers i can't execute select's.

Thks

Humberto Carvalho

On 7/22/05, John DeSoi <desoi(at)pgedit(dot)com> wrote:
> 
> On Jul 22, 2005, at 9:13 AM, Humberto Carvalho wrote:
> 
> > Anyone know if it's possible to catch a Select, delete, update or
> > insert command before he takes effect in the postgres database?
> >
> > I hope someone can help me.
> 
> You can use triggers for delete, update, and insert. Rules can work
> on everything including select statements. See
> 
> http://www.postgresql.org/docs/8.0/interactive/sql-createrule.html
> 
> 
> 
> 
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 
> 


-- 
Humberto Carvalho

In response to

Responses

pgsql-novice by date

Next:From: Mike FahrenkrogDate: 2005-07-22 17:26:47
Subject: Re: How to catch a command
Previous:From: John DeSoiDate: 2005-07-22 15:56:19
Subject: Re: How to catch a command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group