Re: Making serial survive pg_dump
От | Rod Taylor |
---|---|
Тема | Re: Making serial survive pg_dump |
Дата | |
Msg-id | 06bb01c21327$3683ba10$fe01a8c0@jester обсуждение исходный текст |
Ответ на | Making serial survive pg_dump ("Rod Taylor" <rbt@zort.ca>) |
Список | pgsql-hackers |
Thats fair, and makes the job a heck of a lot simpler. We do need to change the sequence naming once. They have a tendency to conflict at the moment. -- Rod ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Rod Taylor" <rbt@zort.ca> Cc: "Hackers List" <pgsql-hackers@postgresql.org> Sent: Thursday, June 13, 2002 6:05 PM Subject: Re: [HACKERS] Making serial survive pg_dump > "Rod Taylor" <rbt@zort.ca> writes: > > 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? > > No. IMHO, if we change the naming convention for serial sequences (which > seems unlikely, except that it might be indirectly affected by changing > NAMEDATALEN), then we'd *want* the new naming convention to take effect, > not to have pg_dump scripts force an old naming convention to be > preserved. > > I realize there's a potential for failing to restore the setval() > information if the name actually does change, but I'm willing to live > with that. > > regards, tom lane >
В списке pgsql-hackers по дате отправления: