Partitioned tables, rules, triggers
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
2. When using trigger, any examples on how to update the trigger
dynamically when tables are added or deleted from the partitioned?
Thanks,
Amin
On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/eggyknap
On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote:
On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
Wow, that is a great presentation. I now feel like I'll be missing
out on not going to the pgsql conference this year.
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote:
On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdfWow, that is a great presentation. I now feel like I'll be missing
out on not going to the pgsql conference this year.
I'm with you on that. Since I went to Portland for the mini-Postgres
Day and OSCON just a couple of months ago I couldn't really ask my
company to cover another trip to the same place so soon. But,
there's always PGCon next May!
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Erik Jones wrote:
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley <eggyknap@gmail.com> wrote:
On 10/3/07, Goboxe <hadzramin.ar@gmail.com> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdfWow, that is a great presentation. I now feel like I'll be missing
out on not going to the pgsql conference this year.I'm with you on that. Since I went to Portland for the mini-Postgres
Day and OSCON just a couple of months ago I couldn't really ask my
company to cover another trip to the same place so soon. But, there's
always PGCon next May!
And:
PostgreSQL Conference Winter (Los Angeles)
PostgreSQL Conference Spring (East cost somewhere undecided)
Sincerely,
Joshua D. Drake
Erik Jones
Software Developer | Emma�
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHBm1wATb/zqfZUUQRAuwjAJ9b7E0fyY2E2FfngrkI+Seifjvu5wCfSQ7T
TQG1OGww3urR+fN+TQ95X/A=
=OWRg
-----END PGP SIGNATURE-----
Josh,
Thanks for sharing a very good info on partitioning.
Show quoted text
On Oct 5, 10:08 pm, eggyk...@gmail.com ("Josh Tolley") wrote:
On 10/3/07, Goboxe <hadzramin...@gmail.com> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?A howto is available athttp://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/eggyknap
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match