Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
From: Rob Sargent <robjsargent@xxxxxxxxx>
Date: Sun, 28 Jan 2018 23:02:40 -0700
Cc: Andy Colson <andy@xxxxxxxxxxxxxxx>, Ryan Murphy <ryanfmurphy@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAKFQuwakSzOiejcLqTdFO_sUizF7LYguWO=r3RWN7zDC=hGBbg@mail.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> <CAKFQuwakSzOiejcLqTdFO_sUizF7LYguWO=r3RWN7zDC=hGBbg@mail.gmail.com>

I think the table is dropped by end of function

On Jan 28, 2018, at 2:45 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
- Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
  - From: David G. Johnston

Prev by Date: Consider Spaces in pg_trgm for Better Similarity
Next by Date: Re: FW: Setting up streaming replication problems
Previous by thread: Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
Next by thread: pg_trgm Extension Installed but Operators and Functions do not exist
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]