Andrew Dunstan wrote:
> Why not create the audit tables with composite types rather than strings?
>
> create table audit_foo_table as (who text, when timestamptz, old foo,
> new foo);
Because this would lead to having a log/shadow/audit table for every
table I wish to log. (or is there an opaque "generic row" data type?
"record" and "any" generate syntax errors).
> Or you could use an hstore (see contrib).
Doesn't seem applicable.
> Or you could possibly use some of the XML support in 8.3 for serialization.
I need this for 8.1 :)
> This is a usage question, so it really doesn't belong on -hackers.
Thank you - I'm reading the list through gmane and I didn't notice its
name "gmane.comp.db.postgresql.devel.general" is incorrect. I'll find a
more suitable list.