If we have sequences pick new names automatically, it may not pick the same name after dump / restore as it had earlier -- especially across versions (see TODO entry).
So don't we need a way to suggest the *right* name to SERIAL? -- Rod ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Hackers List" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 5:52 PM Subject: Re: [HACKERS] Making serial survive pg_dump > "Rod Taylor" <[EMAIL PROTECTED]> writes: > > Normally I'd agree, but I've found a few people who use normal > > sequence operations with serial sequences. That is, they track down > > the name and use it. > > Sure. But what's this have to do with what pg_dump should emit? > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html