Re: PostgreSQL server does not increment a SERIAL internally

2020-07-06 Thread Adrian Klaver
On 7/6/20 2:43 AM, Matthias Apitz wrote: Hello, Me and my team passed a full weekend hunting a bug in our Perl written software were rows have been inserted with the same id 'acq_haushalt.hnr' which should not have been the case because any budget year in that table has a single internal number

Re: PostgreSQL server does not increment a SERIAL internally

2020-07-06 Thread Matthias Apitz
El día Montag, Juli 06, 2020 a las 01:58:04 +0200, Sándor Daku escribió: > > We update the serial 'acq_haushalt_hnr_seq' with this statement after > > loading: > > > > What does "loading" mean, and why do you reset the sequence after loading? > (And as I can see you setting it to the value it mos

Re: PostgreSQL server does not increment a SERIAL internally

2020-07-06 Thread Sándor Daku
Hi Matthias, On Mon, 6 Jul 2020 at 11:43, Matthias Apitz wrote: > > Hello, > > Me and my team passed a full weekend hunting a bug in our Perl written > software were rows have been inserted with the same id 'acq_haushalt.hnr' > which should not have been the case because any budget year in that

PostgreSQL server does not increment a SERIAL internally

2020-07-06 Thread Matthias Apitz
Hello, Me and my team passed a full weekend hunting a bug in our Perl written software were rows have been inserted with the same id 'acq_haushalt.hnr' which should not have been the case because any budget year in that table has a single internal number 'hnr' The table in the 11.4 server is cr