Why do I need to pass value for Serial type in Insert/Update?

Поиск
Список
Период
Сортировка
От Duffey, Kevin
Тема Why do I need to pass value for Serial type in Insert/Update?
Дата
Msg-id 59007C908447154E9D9432A651876F377089DA@bmmail.buymedia.com
обсуждение исходный текст
Ответы Re: Why do I need to pass value for Serial type in Insert/Update?  (Martin Marques <martin@bugs.unl.edu.ar>)
Re: Why do I need to pass value for Serial type in  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
I don't know if jdbc/java code requires this, but when I use two gui admin tools I found, and I insert a row into the
tableusing their row editor feature, both require me to enter a number for the Serial type. I thought this type was
usedto auto-increment an id field and that I would not need to enter anything into it? Basically we need the normal
indexedID field for each table, and we want it to auto-increment. The serial shows a function of nextVal() or something
likethat, so I assume it auto-increments, and it shows unique and not-null. Can someone explain how serial is used, why
wouldI still need to pass a value for it? 

Thanks.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003



***************************************************************************
"The information contained in this e-mail message  may be confidential and
protected from disclosure.  If you are not the intended recipient, any
dissemination, distribution or copying is strictly prohibited.  If you think
that you have received this e-mail message in error, please e-mail the
sender at exadmins@marketron.com."
***************************************************************************

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Regarding constraint database
Следующее
От: Holger Marzen
Дата:
Сообщение: Re: query-question