On Mon, Oct 29, 2007 at 12:53:00PM -0400, Andrew Sullivan wrote:
> > after all - insert/update/delete happens trigger *knows* the structure
> > of the table the event took place on.
> No, it doesn't.  That's exactly the problem.  It looks like it to a

ok, sorry for refreshing the thread, but i just checked sl_log_* (for
different reason) and column names *are* there.
so - since they are inserted by trigger - it means trigger knows them!

example:
# select * from _friendnet.sl_log_2 limit 3;
-[ RECORD 1 ]-+----------------------------------------------------------------------------
log_origin    | 1
log_xid       | 732269653
log_tableid   | 202
log_actionseq | 34868612
log_cmdtype   | U
log_cmddata   | count='1',cover='391396' where id='263780'
-[ RECORD 2 ]-+----------------------------------------------------------------------------
log_origin    | 1
log_xid       | 732269849
log_tableid   | 69
log_actionseq | 34868617
log_cmdtype   | I
log_cmddata   | (a,b,added) values ('1151711','1072820','2007-11-16 09:44:15.003328+01')
-[ RECORD 3 ]-+----------------------------------------------------------------------------
log_origin    | 1
log_xid       | 732269849
log_tableid   | 69
log_actionseq | 34868618
log_cmdtype   | I
log_cmddata   | (a,b,added) values ('1072820','1151711','2007-11-16 09:44:15.003328+01')

so, the question is - what am i missing?

best regards,

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)