postgresql/src/test/modules/test_ddl_deparse
Alvaro Herrera 6f8bb7c1e9
Revert structural changes to not-null constraints
There are some problems with the new way to handle these constraints
that were detected at the last minute, and require fixes that appear too
invasive to be doing this late in the cycle.  Revert this (again) for
now, we'll try again with these problems fixed.

The following commits are reverted:

    b0e96f3119  Catalog not-null constraints
    9b581c5341  Disallow changing NO INHERIT status of a not-null constraint
    d0ec2ddbe0  Fix not-null constraint test
    ac22a9545c  Move privilege check to the right place
    b0f7dd915b  Check stack depth in new recursive functions
    3af7217942  Update information_schema definition for not-null constraints
    c3709100be  Fix propagating attnotnull in multiple inheritance
    d9f686a72e  Fix restore of not-null constraints with inheritance
    d72d32f52d  Don't try to assign smart names to constraints
    0cd711271d  Better handle indirect constraint drops
    13daa33fa5  Disallow NO INHERIT not-null constraints on partitioned tables
    d45597f72f  Disallow direct change of NO INHERIT of not-null constraints
    21ac38f498  Fix inconsistencies in error messages

Discussion: https://postgr.es/m/202405110940.joxlqcx4dogd@alvherre.pgsql
2024-05-13 11:31:09 +02:00
..
expected Revert structural changes to not-null constraints 2024-05-13 11:31:09 +02:00
sql Remove logic for converting a table to a view. 2022-12-02 12:14:32 -05:00
.gitignore Make modules/test_ddl_deparse/.gitignore match its siblings. 2015-08-03 00:02:26 -04:00
Makefile Use TSConfigRelationId in AlterTSConfiguration() 2016-12-22 17:08:43 -05:00
README Fix various common mispellings. 2016-06-03 16:08:45 +01:00
meson.build Update copyright for 2024 2024-01-03 20:49:05 -05:00
test_ddl_deparse--1.0.sql Expand tests of test_ddl_deparse/ for ALTER TABLE 2022-07-31 11:48:14 +09:00
test_ddl_deparse.c Revert structural changes to not-null constraints 2024-05-13 11:31:09 +02:00
test_ddl_deparse.control

README

test_ddl_deparse is an example of how to use the pg_ddl_command datatype.
It is not intended to do anything useful on its own; rather, it is a
demonstration of how to use the datatype, and to provide some unit tests for
it.

The functions in this extension are intended to be able to process some
part of the struct and produce some readable output, preferably handling
all possible cases so that SQL test code can be written.