Re: AIX support - alignment issues

On Thu, 7 Jul 2022 at 22:36, Thomas Munro wrote: > > * Since Greg Stark's magnificent Vax talk[1], we became even more > dependent on IEEE 754 via the Ryu algorithm. AFAICT, unless someone > produces a software IEEE math implementation for GCC/VAX... if I had > a pick one to bump off that list,

Re: Support TRUNCATE triggers on foreign tables

On 2022/07/08 11:19, Yugo NAGATA wrote: You added "foreign tables" for BEFORE statement-level trigger as the above, but ISTM that you also needs to do that for AFTER statement-level trigger. No? Oops, I forgot it. I attached the updated patch. Thanks for updating the patch! LGTM. Barring

Re: DropRelFileLocatorBuffers

At Fri, 08 Jul 2022 11:52:45 +0900 (JST), Kyotaro Horiguchi wrote in > > I wouldn't mind if we took "Locator" out of the name of that function > > and just called it DropRelFileBuffers or DropRelationBuffers or > > something. That would be shorter, and maybe more intuitive. > > Thanks. Will pro

Re: pg_parameter_aclcheck() and trusted extensions

On Thu, Jul 07, 2022 at 03:43:03PM -0400, Joe Conway wrote: > On 7/7/22 15:00, Tom Lane wrote: >> The aspect that is a bit more debatable is whether to trouble with >> a set_config_option() wrapper to avoid the API break in v15. >> I think we'd still be making people deal with an API break in v16,

Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns

On Fri, Jul 8, 2022 at 6:45 AM Masahiko Sawada wrote: > > On Thu, Jul 7, 2022 at 3:40 PM Amit Kapila wrote: > > > > On Thu, Jul 7, 2022 at 8:21 AM Masahiko Sawada > > wrote: > > I've attached the new version patch that incorporates the comments and > the optimizations discussed above. > Thanks

Re: [PoC] Improve dead tuple storage for lazy vacuum

On Fri, Jul 8, 2022 at 9:10 AM Masahiko Sawada wrote: > I guess that the tree height is affected by where garbages are, right? > For example, even if all garbage in the table is concentrated in > 0.5GB, if they exist between 2^17 and 2^18 block, we use the first > byte of blockhi. If the table is

ERROR: operator does not exist: json = json

Hi, Comparison of 2 values of type jsonb is allowed. Comparison of 2 values of type json gives an error. That seems like an oversight -- or is it deliberate? Example: select '42'::json = '{}'::json; --> ERROR: operator does not exist: json = json (of course, easily 'solved' by casting but t

Re: Allow file inclusion in pg_hba and pg_ident files

Hi, On Thu, Jun 02, 2022 at 10:08:15AM +0900, Michael Paquier wrote: > On Thu, May 26, 2022 at 03:26:57PM +0800, Julien Rouhaud wrote: > > > After a bit more digging, I think that this comes from the fact that > > there's no > > "official" name for this file. Even the documentation just says "th

<    1   2