On 11/05/10 9:23 AM, rmd22 wrote:
> Well what i mean by print out is that it should print out the old and new
> tuples on postgres terminal after the update is complete.
> I tried it with triggers and I got what I wanted. But my professor for some
> reason wants me to mess around with the source code :(
> Do you think it's possible?
what is the 'postgres terminal' ? its a service, running as a daemon,
it has no console normally, just a logfile.
should that only be printing tuples that are committed? that becomes a
LOT harder.
a single UPDATE statement can modify a huge number of tuples. also
ALTER TABLE statements can modify tuples, and of course INSERT
statements create new tuples.