On Fri, Nov 16, 2007 at 10:57:25AM -0500, Andrew Sullivan wrote:
> Yes they are.
> > so - since they are inserted by trigger - it means trigger knows them!
> Only sort of.  Not the way you think.  If you look at the trigger
> definitions on the tables, you'll see that there are funny little symbols
> there.  That's how the columns get represented.

ok, but the trigger inserts column names to sl_log_x tables.

inserted data contains *real* column names.

so - combining these two statements would generate "trigger knows *real*
column names".

knowing this - why can't we/slony abandon these "funny little symbols"
and store key-column-names directly?

please do not take this question as offensive. i'm merely asking because
i dont udnerstand, and in my understanding this would lead to much
easier working with slony (i.e. no "execute script" neccessity for
adding columns).

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)