hi, thanks for your help i found the mistake:
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried nextval('adr_adr_id_seq') but get an error message
i create the database and load it then with the command:
copy adr from stdin using delimiters ',' with this command i also load my serial field. even that i load 14 rows the currval stays on 1 so the two lines
insert into adr (id) values (setval('adr_adr_id_seq',15)); select currval('adr_adr_id_seq');
get the value to the right level. olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com