On Fri, 2020-07-03 at 12:46 -0500, Ron wrote:
> > This is my favorite example why I like the way PostgreSQL does things:
> >
> > /* poor man's VACUUM (FULL) */
> > BEGIN;
> > CREATTE TABLE t2 AS SELECT * FROM t1;
> > DROP TABLE t1;
> > ALTER TABLE t2 RENAME TO t1;
> > COMMIT;
>
> How so, since it does not carry over indexes, foreign keys, triggers,
> partition references, etc?
It is an example of what a transaction could look like that
would suffer from statement-level rollback.
I am not claimimg that that code as such is very useful.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com