Search Postgresql Archives

Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP

Subject: Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sun, 28 Jan 2018 14:45:31 -0700
Cc: Andy Colson <andy@xxxxxxxxxxxxxxx>, Ryan Murphy <ryanfmurphy@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <EAE90B70-970D-491A-A82A-971E50A1DF5D@gmail.com>
References: <CAHeEsBd5LJfHDkawj9VHfhbtMkrQ-npFw8pyVg2T7mv4=7nkzw@mail.gmail.com> <CAKFQuwbu-cO8kC6LhFXmuPYMH+3UNXBHNT0YHOV6L6v-RvYxdQ@mail.gmail.com> <CAHeEsBfRXy15hQVUi_3BP=6mjr46pc+SDwvxpGn5So3_wheZJQ@mail.gmail.com> <e011c9de-4239-0205-3c6e-94b60d20a057@squeakycode.net> <EAE90B70-970D-491A-A82A-971E50A1DF5D@gmail.com>

On Sunday, January 28, 2018, Rob Sargent <robjsargent@xxxxxxxxx> wrote:

The commit in question is the function btw.

That doesn't make sense - functions can't commit.

David J.

Follow-Ups:
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: Rob Sargent

References:
- Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: Ryan Murphy
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: David G. Johnston
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: Ryan Murphy
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: Andy Colson
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: Rob Sargent