Paul Tillotson 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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 9 of 11 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedFeb 24, '04 at 4:49p
activeMar 25, '04 at 1:00p
posts11
users9
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase