Re: Is CREATE TABLE non-blocking ?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is CREATE TABLE non-blocking ?
Date: 2014-07-23 15:52:34
Message-ID: 53CFDA42.8010305@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 07/23/2014 09:13 AM, Benjamin Dugast wrote:
> We finally solved our problem,
> Thanks for your help.
>
>
> 2014-07-23 15:43 GMT+02:00 hubert depesz lubaczewski <depesz(at)gmail(dot)com
> <mailto:depesz(at)gmail(dot)com>>:
>
> No, it's not.
> What might happen, though, is that you call your callback before
> the transaction with create table got committed.
>
> depesz
>
>
> On Wed, Jul 23, 2014 at 12:33 PM, Benjamin Dugast
> <bdugast(at)excilys(dot)com <mailto:bdugast(at)excilys(dot)com>> wrote:
>
> Hello,
>
> We have an issue with tables creations in our application.
>
> We think CREATE TABLE returns before the tables are created.
> Because this looks like a non-blocking operation, our inserts
> (in a callback) are actually happening before the tables are
> created.
>
> We tried to use a Thread.sleep() just before the insert and it
> works but we can't stay with this.
>
> What can we do to avoid this problem?
>
>
>
And the solutions was....

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Benjamin Dugast 2014-07-24 08:36:17 Re: Is CREATE TABLE non-blocking ?
Previous Message Benjamin Dugast 2014-07-23 15:13:46 Re: Is CREATE TABLE non-blocking ?