Paul Tillotson <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org