My first attempt at blogging...
Validate that the sequence is out-of-sync
Before we reset the sequence, let us make sure that it is out of sync.SELECT nextval(PG_GET_SERIAL_SEQUENCE('"table"', 'id'));...
SELECT
CURRVAL(PG_GET_SERIAL_SEQUENCE('"table"', 'id')) AS "Current Value",
MAX("id") AS
Data from old mysql database has been simply imported via a INSERT.
The needed modifications to make sure if matched the PostgreSQL expectations had to be done.
It was down to a simple way building up the INSERT statement compatible with PostgreSQL and running in the pgAdmin....
Well, here we are in the beginning of 2023 and it seems a reset again on the little personal projects i have been doing in the past.
I got the old code from subversion, made sure i had a virtual environment with the right versions of python, pyramid and the likes.
Then restarted the sy...
seems to be working just fine?
some other text here to make it a bit longer when comes to more than one sentence and one line.
and we are going to print this all in the correct order and the correct time
another blank line just to see how it makes sense....