| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pet Peeves? |
| Date: | 2009-02-06 13:53:25 |
| Message-ID: | 498C40D5.9050409@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera wrote:
> A trivial, stupid implementation is perhaps not too difficult. The
> problem is getting the smarts right, i.e. an optimized version. You
> certainly don't want to be executing a query against a large table for
> every INSERT on another one, for example; it's better if if you can
> figure out when to skip it.
If you do it using the constraint trigger mechanism, it would work very
similar to foreign keys, I'd imagine. Instead of running a query
against the primary key table, you'd run the check constraint expression.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Dooley | 2009-02-06 13:59:24 | Searching a gin index |
| Previous Message | Oleg Bartunov | 2009-02-06 12:37:54 | Re: Turning off automatic ranking on words |