On Mon, 18 Jan 1999, Valerio Santinelli wrote:
> I've exported a table from an existing MSAccess database to my
> PostgreSQL db.
> I use a serial ID on the table and now I'm getting errors when I add a
> new entry in the table if i don't specify the ID by hand (which should
> be placed automati
It maybe done with next syntax;
drop sequence_name;
create sequence sequence_name start start_no;
But, if you want to increment the sequence_no by one manually, then;
select nextval('sequence_name');
==ooOO /. .\ OOoo==
Dept. of Neurosurg
I've exported a table from an existing MSAccess database to my
PostgreSQL db.
I use a serial ID on the table and now I'm getting errors when I add a
new entry in the table if i don't specify the ID by hand (which should
be placed automatically by the db since it's a serial).
The exact error is t
