pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Appliying Rules and Triggers
3+ messages / 2 participants
[nested] [flat]

* Appliying Rules and Triggers
@ 2003-03-07 12:05  Daniel Rubio <drubior@tinet.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Daniel Rubio @ 2003-03-07 12:05 UTC (permalink / raw)
  To: pgsql-admin

Hi!

Does anyone knows if it's possible to apply an determinated rule or 
trigger to all the tables of an databese without having to declare it 
specifically?

I want to apply an rule to all the tables for all my databases 
automatically, it is, that if I create a new table i won't have to apply 
the rule for this table because it is applied for all.

My english is horrible and I don't know how to explain it better, I hope 
you understand.

Thanks in advance

-- 
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio@oasi.org
********************************************************




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Appliying Rules and Triggers
@ 2003-03-07 16:16  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Daniel Rubio <drubior@tinet.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Stephan Szabo @ 2003-03-07 16:16 UTC (permalink / raw)
  To: Daniel Rubio <drubior@tinet.org>; +Cc: pgsql-admin

On Fri, 7 Mar 2003, Daniel Rubio wrote:

> Does anyone knows if it's possible to apply an determinated rule or
> trigger to all the tables of an databese without having to declare it
> specifically?

AFAIK no.What are you trying to do specifically?




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Appliying Rules and Triggers
@ 2003-03-10 08:34  Daniel Rubio <drubior@tinet.org>
  parent: Stephan Szabo <sszabo@megazone23.bigpanda.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Daniel Rubio @ 2003-03-10 08:34 UTC (permalink / raw)
  To: pgsql-admin

> AFAIK no.What are you trying to do specifically?

My plan is to REVOKE insert privileges to an user when his database 
growths more than the quota we assign to them ...

> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 


-- 
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio@oasi.org
********************************************************




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-03-10 08:34 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-07 12:05 Appliying Rules and Triggers Daniel Rubio <drubior@tinet.org>
2003-03-07 16:16 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2003-03-10 08:34   ` Daniel Rubio <drubior@tinet.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox