On 24/02/11 21:09, Jacques Lebrun wrote:
I guess when I do an insert with all the fields (including the RowId),
Postgres does not increment the serial counter.
I cannot remove the RowId field from the Insert of my setup script
because this setup script is also used by customers using MySQL.
Apa
On Feb 25, 2011, at 2:39 AM, Jacques Lebrun wrote:
> What can I do to force PostGres to update the internat serial counter when I
> do an insert with a specified value for the serial?
>
After inserting the all the Data, use ALTER SEQUENCE Command:
http://www.postgresql.org/docs/8.4/static/sql-
