Transaction control in SECURITY DEFINER procedures

in future releases? Regards, Chris Sterritt

Re: Check for duplicates before inserting new rows

2meas1'); Now if you repeat the check for new measurements with the same query as at *, you only get 3 rows. Cheers, Chris Sterritt

Re: Check for duplicates before inserting new rows

s.station_id,sd.ameasurement from src_data sd join (SELECT station_id,station_data FROM ins_station UNION SELECT station_id,station_data FROM station)s using (station_data) except select station_id,ameasurement from measurement; select * from station; select * from measurement; Regards, Chris Sterritt

Re: Need explanation on index size

On 24/09/2020 15:08, Guillaume Lelarge wrote: Hi, Le jeu. 24 sept. 2020 à 15:55, Guillaume Luchet > a écrit : Hi, I’m facing of a comportement I don’t understand on indexes, here a quick example to reproduce my problem test=# select version();

Re: PostgreSQL processes use large amount of private memory on Windows

n stays in bounds, or redesign your application. In some cases it might help to restart your sessions when they get too big, but that seems like at best a band-aid. regards, tom lane Would executing DISCARD ALL release the PL cache? Regards, Chris Sterritt

Re: Drop column constraint

alter column loc_nbr drop constraint unique;' also failed. What's the proper syntax to drop the unique constraint on a table column? TIA, Rich You need alter table locations drop constraint ; Cheers, Chris Sterritt

Re: Check constraints do not seem to be working!!!

null Cheers, Chris Sterritt