Paul Tillotson <pntil@shentel.net> writes:
> I use this type of approach when mirroring data from a foxpro database
> (yuck) to a read-only postgres database. It is quicker and cleaner than
> deleting all of the rows and inserting them again (TRUNCATE is not
> transaction safe, which I need).
Just FYI, TRUNCATE *is* transaction safe as of 7.4.
regards, tom lane