Re: Is CREATE TABLE non-blocking ?

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: Is CREATE TABLE non-blocking ?
Дата
Msg-id 1406125080365-5812524.post@n5.nabble.com
обсуждение исходный текст
Ответ на Is CREATE TABLE non-blocking ?  (Benjamin Dugast <bdugast@excilys.com>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Is CREATE TABLE non-blocking ?
Следующее
От: Benjamin Dugast
Дата:
Сообщение: Re: Is CREATE TABLE non-blocking ?