Re: Using a single sequence for all tables

2021-09-30 Thread Peter J. Holzer
On 2021-09-29 10:21:00 -0600, Michael Lewis wrote: > If your processes somehow allow updates on the wrong table, then fix that. If your processes somehow allow inserting duplicate keys, then fix that (so unique key constraints are unnecessary). If your process somehow allows deletion of records w

Re: ERROR: unrecognized node type

2021-09-30 Thread Tomas Vondra
On 9/30/21 8:38 AM, Amine Tengilimoglu wrote: ... Remarkable thing  the related error occurs when executing sql statements containing where.  The sqls that do not contain a where are not getting an error. Location information as below; ERROR:  XX000: unrecognized node type: 223

Re: Make bloom extension trusted, but can not drop with normal user

2021-09-30 Thread Masahiko Sawada
On Wed, Aug 25, 2021 at 12:38 AM David G. Johnston wrote: > > On Tue, Aug 24, 2021 at 8:17 AM Adrian Klaver > wrote: >> >> >> To me the issue is that the extension was modified to trusted by an end >> user not the extension author. I gotta believe there is more to the >> trusted then a flag in t