> > I don't find this particularly suprising. Nothing looks at that field in > sequences, there imo is no point on having the name inside at all. > > Do you need that for some usecase or did you just happen to notice it? >
> I personally don't see any way to nicely fix that. We can add code to > also change the contents, but currently thats generic code. Or we could > just remove the column in the next release? > Well, this story began with one very bad named sequence. After database structure audit the developers were asked to rename this sequence to something more appropriate. And when they performed alter ... rename they found that the name still same. After that they came to me with questions. Task is remove that very bad name from the production database altogether. It seems that the easiest way is drop sequence and create new sequece. +1 for "just remove the column in the next release" -- Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/ <http://www.postgresql-consulting.com/> Phone RU: +7 910 405 4718 Phone AU: +61 45 218 5678 Skype: maxim.boguk Jabber: maxim.bo...@gmail.com МойКруг: http://mboguk.moikrug.ru/ "People problems are solved with people. If people cannot solve the problem, try technology. People will then wish they'd listened at the first stage."