| От | Alvaro Herrera |
|---|---|
| Тема | ALTER TABLE .. OWNER TO and sequences |
| Дата | |
| Msg-id | 20040922191427.GA14404@dcc.uchile.cl обсуждение исходный текст |
| Ответы |
Re: ALTER TABLE .. OWNER TO and sequences
|
| Список | pgsql-patches |
Patchers, Here is a patch regarding ALTER TABLE ... OWNER and the sequences that were created by a SERIAL column. It uses pg_depend to find SERIAL sequences, and recurses the ChangeOwner to them. Additionally, it forbids directly changing the owner of a SERIAL sequence (the error message of this last action needs to be perfected). I also added some regression tests for ALTER TABLE ... OWNER, because previously there wasn't any. According to my testing, this fixes the issue with pg_dump not restoring the ownership of SERIAL sequences and the annoyance of having to alter the sequence manually (the principle of least surprise indicates that the sequence should be altered automatically). Please review. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Now I have my system running, not a byte was off the shelf; It rarely breaks and when it does I fix the code myself. It's stable, clean and elegant, and lightning fast as well, And it doesn't cost a nickel, so Bill Gates can go to hell."
В списке pgsql-patches по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера