SQL:2011 Valid-Time Support
Hello All, I am sure this has been discussed somewhere but I have not found anything specific in the archives. Has there been or is there any current effort to implement SQL:2011 valid-time support in Postgres? I understand that there has been some efforts to implement some valid-time support but now that there is a published standard I think that it would be valuable to try to obtain some level of compatibility. Is this something the community has decided against? Ultimately I am wondering if this is something that would be worth me spending my time on. Thanks Paul
Adding a new table to the system catalog
Hello All, I am exploring and poking at the source code to inform a design for adding valid-time support to postgres. The feature will required updating existing system catalog tables as well as adding one or more new tables. Is there any documentation on how to update the system catalog? What files need to be created/updated? Do I need to run any utilities for generation manually or is this done as part of the build? How do I assign a new OID? Thanks in advance Paul
SQL:2011 Valid-Time Support
Hello All, I am sure this has been discussed somewhere but I have not found anything specific in the archives. Has there been or is there any current effort to implement SQL:2011 valid-time support in Postgres? I understand that there has been some efforts to implement some valid-time support but now that there is a published standard I think that it would be valuable to try to obtain some level of compatibility. Is this something the community has decided against? Ultimately I am wondering if this is something that would be worth me spending my time on. Thanks Paul
Adding a new table to the system catalog
Hello All, I am exploring and poking at the source code to inform a design for adding valid-time support to postgres. The feature will required updating existing system catalog tables as well as adding one or more new tables. Is there any documentation on how to update the system catalog? What files need to be created/updated? Do I need to run any utilities for generation manually or is this done as part of the build? How do I assign a new OID? Thanks in advance Paul