pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAppliying 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