| From: | Kenneth Downs <ken(at)secdat(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SQL Rule |
| Date: | 2006-04-27 11:05:00 |
| Message-ID: | 4450A55C.3060604@secdat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bert wrote:
>This rule is creating first of all the insert and then i can run an
>Update on this insert, so far its functioning. Your definition is quite
>good but what are doing when you change the table definition? Rewrite
>all Rules?
>
>
I actually use a data dictionary processor that automatically generates
the trigger code and also modifies table structures. Your example would
look like this:
table example {
column { col_A; col_B; }
column col_C {
chain calc {
test { return: @col_A + @col_B; }
}
}
This tool, called "Andromeda" is available for download if you like, but
we consider the current version "pre-Alpha". The entire feature set is
defined and I use it for all of my projects, but we are still
stabilizing and documenting. If you are interested in being a very
early adopter, drop me a line off-list.
| Attachment | Content-Type | Size |
|---|---|---|
| ken.vcf | text/x-vcard | 186 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Schnabl, Sebastian | 2006-04-27 11:13:38 | FW: Postgres 8.1 sequences and 'CALL'-syntax |
| Previous Message | Shoaib Mir | 2006-04-27 11:04:32 | Re: CREATE TYPE |