From: | Benjamin Dugast <bdugast(at)excilys(dot)com> |
---|---|
To: | hubert depesz lubaczewski <depesz(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Is CREATE TABLE non-blocking ? |
Date: | 2014-07-23 15:13:46 |
Message-ID: | CAB9ggRrAHJiVGPBPeYt0b5iDfa88aTML2Y2VwoEgQgXjPUrmFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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>:
> 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?
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2014-07-23 15:52:34 | Re: Is CREATE TABLE non-blocking ? |
Previous Message | David G Johnston | 2014-07-23 14:18:00 | Re: Is CREATE TABLE non-blocking ? |