From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Is CREATE TABLE non-blocking ? |
Date: | 2014-07-23 14:18:00 |
Message-ID: | 1406125080365-5812524.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Benjamin Dugast 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?
Nothing in the server is asynchronous (expect maybe notify/listen) but that
doesn't prevent you from interacting with the server in an asynchronous way
client-side.
Showing code usually helps people provide suggestions on how to avoid a
problem.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Is-CREATE-TABLE-non-blocking-tp5812506p5812524.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Benjamin Dugast | 2014-07-23 15:13:46 | Re: Is CREATE TABLE non-blocking ? |
Previous Message | hubert depesz lubaczewski | 2014-07-23 13:43:17 | Re: Is CREATE TABLE non-blocking ? |