fix next id in postgres...

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
...
Continue Reading

data from old mysql database...

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....
Continue Reading

A retry at blogging...

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...
Continue Reading