Re: Is CREATE TABLE non-blocking ?

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: Benjamin Dugast <bdugast(at)excilys(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is CREATE TABLE non-blocking ?
Date: 2014-07-23 13:43:17
Message-ID: CAKrjmhfFt7jt9gJowB8eQ8eMnkUwVqNFA2EFhmR9AA+XWvbZbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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>
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?
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G Johnston 2014-07-23 14:18:00 Re: Is CREATE TABLE non-blocking ?
Previous Message Benjamin Dugast 2014-07-23 10:33:06 Is CREATE TABLE non-blocking ?