Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Schema variables - new implementation for Postgres 15
Date
Msg-id CAFj8pRCvyO-MBdCbGmrGPdaE95awKWvV7+14W8N=iz-a_iz8Tw@mail.gmail.com
Whole thread Raw
In response to Re: Schema variables - new implementation for Postgres 15  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Schema variables - new implementation for Postgres 15
List pgsql-hackers
Tree view


Hi


- For sessionvariable.c (in 0002), I see that there are still all the comments
  and code about checking type validity based on a generation number and other
  heuristics.  I still fail to understand why this is needed at all as the
  stored datum should remain compatible as long as we prevent the few
  incompatible DDL that are also prevented when there's a relation dependency.
  As an example, I try to quickly disable all that code with the following:



I am sending an alternative implementation based on using own int8 sequence as protection against unwanted oid equation of different session's variables.

This code is much shorter, and, I think better, but now, the creating sequence in bootstrap time is dirty. Maybe instead the sequence can be used 64bite timestamp or some else - it needs a unique combination of oid, 8byte.

Regards

Pavel


 
Attachment

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: postgres_fdw hint messages
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: SYSTEM_USER reserved word implementation