Request a Demo
Home   >   mailing lists

Re: CREATE TABLE LIKE INCLUDING POLICIES - Mailing list pgsql-hackers

From jian he
Subject Re: CREATE TABLE LIKE INCLUDING POLICIES
Date
Msg-id CACJufxFLwhACUsOnywmZ=npLR44Egg=sivxnq4Giu_YJ4ZGT_A@mail.gmail.com
Whole thread Raw
In response to Re: CREATE TABLE LIKE INCLUDING POLICIES  (jian he <jian.universality@gmail.com>)
Responses Re: CREATE TABLE LIKE INCLUDING POLICIES
List pgsql-hackers
Tree view 
hi.

inspired by this message [1], now, v3 logic is more like other CREATE
TABLE LIKE INCLUDING commands.

Since policy queries can include SubLinks, we first acquire
AccessShareLock lock on all the referenced relations.
Only then we copy the USING and WITH CHECK clauses from the source relation.

[1] https://postgr.es/m/CA+TgmoY8v44Y8j--b7e72kuvupZdtMEZf6FVjRfeqsG4gunpzw@mail.gmail.com


--
jian
https://www.enterprisedb.com
Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: More speedups for tuple deformation
Next
From: jian he
Date:
Subject: Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint