List sequence assigned to primary key

Поиск
Список
Период
Сортировка
От Brian Johnson
Тема List sequence assigned to primary key
Дата
Msg-id 20021105.WhT.79991700@192.168.0.1
обсуждение исходный текст
Список pgsql-novice
I added a few records to a table and assigned numbers to the id field - now when I
try to add records properly, it says that it can't accept duplicate values on the
primary field (id)

Although there were only a few records and I could just redo them, I wonder if
there is another method (for future reference)

So here are my two questions

1. How can you list (find out) the sequence name assigned to a primary key?

2. How can you change that sequence value?


I searched a bunch of web sites but had trouble narrowing my search to less than
about 30,000 hits


В списке pgsql-novice по дате отправления:

Предыдущее
От: Kassel Ben CRBE
Дата:
Сообщение: Re: AutoIncrement not working on this table only
Следующее
От: "Henshall, Stuart - Design & Print"
Дата:
Сообщение: Re: List sequence assigned to primary key