Postgres Pro
Downloads
Home   >   mailing lists

Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP - Mailing list pgsql-general

From Rob Sargent
Subject Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP
Date
Msg-id 130628A4-A3E1-4CFC-A704-653A587B818B@gmail.com
Whole thread Raw
In response to Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
I think the table is dropped by end of function

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

On Sunday, January 28, 2018, Rob Sargent <robjsargent@gmail.com> wrote:
The commit in question is the function btw.

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

David J.

pgsql-general by date:

Previous
From: "Igal @ Lucee.org"
Date:
Subject: Consider Spaces in pg_trgm for Better Similarity
Next
From: Andreas Kretschmer
Date:
Subject: Re: FW: Setting up streaming replication problems