pgsql: Remove incorrect Assert introduced in c8aeaf3ab.

2024-03-23 Thread Jeff Davis
Remove incorrect Assert introduced in c8aeaf3ab. Already removed incidentally in version 15 (c4649cce3), so this commit is only applied to versions 13 and 14. The comment above is misleading in all versions 13 and later, so that will be fixed in a separate commit. Discussion: https://postgr.es/

pgsql: Remove incorrect Assert introduced in c8aeaf3ab.

2024-03-23 Thread Jeff Davis
Remove incorrect Assert introduced in c8aeaf3ab. Already removed incidentally in version 15 (c4649cce3), so this commit is only applied to versions 13 and 14. The comment above is misleading in all versions 13 and later, so that will be fixed in a separate commit. Discussion: https://postgr.es/

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Normalize index tuples containing uncompressed varlena

2024-03-23 Thread Alexander Korotkov
amcheck: Normalize index tuples containing uncompressed varlena It might happen that the varlena value wasn't compressed by index_form_tuple() due to current storage parameters. If compression is currently enabled, we need to compress such values to match index tuple coming from the heap. Backpa

pgsql: amcheck: Support for different header sizes of short varlena dat

2024-03-23 Thread Alexander Korotkov
amcheck: Support for different header sizes of short varlena datum In the heap, tuples may contain short varlena datum with both 1B header and 4B headers. But the corresponding index tuple should always have such varlena's with 1B headers. So, for fingerprinting, we need to convert. Backpatch t

pgsql: Add temporal FOREIGN KEY contraints

2024-03-23 Thread Peter Eisentraut
Add temporal FOREIGN KEY contraints Add PERIOD clause to foreign key constraint definitions. This is supported for range and multirange types. Temporal foreign keys check for range containment instead of equality. This feature matches the behavior of the SQL standard temporal foreign keys, but