Re: [PATCHES] system catalog relation of a table and a
От | Peter Eisentraut |
---|---|
Тема | Re: [PATCHES] system catalog relation of a table and a |
Дата | |
Msg-id | Pine.LNX.4.30.0112161744310.641-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: [PATCHES] system catalog relation of a table and a serial sequence (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [PATCHES] system catalog relation of a table and a serial sequence
|
Список | pgsql-hackers |
Tom Lane writes: > I think it'd be a bit surprising if "pg_dump -t table" would dump > sequences declared independently of the table. An example where you'd > likely not be happy with that is if the same sequence is being used to > feed multiple tables. > > I agree that dumping all such sequences will often be the desired > behavior, but that doesn't leave me convinced that it's the right > thing to do. > > Any comments out there? The more general question is: Should 'pg_dump -t table' dump all objects that "table" depends on? Keep in mind that this could mean you have to dump the entire database (think foreign keys). In my mind, dumping an arbitrary subset of dependencies is not a proper solution, though. -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: