On 25/01/2008 16:51, johnf wrote:
The issue I have with pgAdmin3 and backing up a table is with the restore. The associated sequences are not restored. Granted that might be a different problem. But from a users perspective I see it as a major problem.
Oh? Works fine for me, on PG 8.2.5 - pg_dump exports the SQL to recreate the sequence, and a setval() to reset it to where it was.
Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
