Re: TRUNCATE on foreign tables

Michael Paquier <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.general
Message-ID <[email protected]> 
On Thu, Jan 02, 2020 at 09:46:44AM -0500, Stephen Frost wrote:
> I agree that the FDW callback should support multiple tables in the
> TRUNCATE, but I think it also should include CASCADE as an option and
> have that be passed on to the FDW to handle.

As much as RESTRICT, ONLY and the INDENTITY clauses, no?  Just think
about postgres_fdw.
--
Michael
signature.asc (application/pgp-signature, 833 B) 
-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4S5gkACgkQnvQgOdby
QH1DphAAkh0q6h2CmUW1Md0OBAfTjWsvkVZHv2Vn5gPp/rAp/h9fAn4ir5UdZfNQ
4frGxr0eSd1F/rt8CEfSA0wURUUbL+d6M9nW0GwhZcYto4ol5XGrNU9p4E4XXgSM
K3ykjXh6nXqzSQSwQFvlVnRCxdPTj60K08nsmEV1jMn3qZA830GcWnqcsgs9vV7G
1xMobeNqpt43wWLADkUmpQmMfYouhdce+hVnCHFcHfVpRG5mLHwpnRcIc868J3Xj
ycN5bzqa8m0phXs7py0zJZZWoJtrwgfqkl5nOE4lwktyL+19uibVyVoqmTALBEMS
k/r1Q2gdjQfJ/zfj+cjq2/9RQ4P3dkARqmXrfAWs24SYBOJ/l+cD3SO2361B1sfO
vKipZ9nAqy5acF7/Nc7z+BHJENQJODa4jGYWLScNvQ+p+H9pg6dIzWj+x/3JcTXd
s3cpzSiQFt5NLNyJ2ayS9OQ+d3BlTkdznge8XEtFhMkZ/BkE3ne0y53jDga8Iac2
V/cmcus7W8stL8tp4GlXr7KsP0q27RNFURVXozJUEl44El1eOvLivVfFb60m3Rbo
XewcB+n7VduwkDKnWrMHtlrVw8aUQOp2/mI4RH7kjfPClfDIBpJF13e4WZU0b6Ae
xotP/2g2cLJTtFYSmrLxgRObzYKWwlaTXDbmSfn4UQXAEQRdFeI=
=2PU5
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.