The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/ddl-partitioning.html
Description:
I would like to add a sentence like this into the description of
partitions:
You receive the name of the partition table data is from using
tableoid::re
Thanks! Perhaps this behavior should also be explained elsewhere. It didn't
occur to me to look in the "Compatibility" section.
On Wed, Jul 14, 2021 at 3:33 AM Pantelis Theodosiou
wrote:
> UNIQUE constraints have this behaviour. It is explained in the section:
>
> Non-Deferred Uniqueness Constra
UNIQUE constraints have this behaviour. It is explained in the section:
Non-Deferred Uniqueness Constraints
When a UNIQUE or PRIMARY KEY constraint is not deferrable, PostgreSQL checks
for uniqueness immediately whenever a row is inserted or modified. The SQL
standard says that uniqueness should
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createtable.html
Description:
According to the docs:
A constraint that is not deferrable will be checked immediately after every
command.
But this is the behavior I observe on PG 13.
