-- Rod ----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Hackers List" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 9:46 AM Subject: Re: [HACKERS] Making serial survive pg_dump
> "Rod Taylor" <[EMAIL PROTECTED]> writes: > > Store sequence information in the SERIAL creation statement: > > CREATE TABLE tab (col1 SERIAL(<start num>, <sequence name>)); > > This is wrong because it loses the separation between schema and data. > I do agree that it would be nice if pg_dump recognized serial columns > and dumped them as such --- but the separate setval call is still the > appropriate technique for messing with the sequence contents. We do > not need a syntax extension in CREATE. Ok, keeping the setval is appropriate. Are there any problems with a SERIAL(<sequence name>) implementation? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
