Re: Is CREATE TABLE non-blocking ?

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.