Message-ID: <53CFDA42.8010305@gmail.com>
Date: Wed, 23 Jul 2014 09:52:34 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Is CREATE TABLE non-blocking ?
References: 
 <CAB9ggRr-DJXb6ha7=KDd6W1WZAdcNkmULR0fv1J_TS3WO5+VGw@mail.gmail.com>
	<CAKrjmhfFt7jt9gJowB8eQ8eMnkUwVqNFA2EFhmR9AA+XWvbZbg@mail.gmail.com>
 <CAB9ggRrAHJiVGPBPeYt0b5iDfa88aTML2Y2VwoEgQgXjPUrmFA@mail.gmail.com>
In-Reply-To: 
 <CAB9ggRrAHJiVGPBPeYt0b5iDfa88aTML2Y2VwoEgQgXjPUrmFA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------090109030102090103020005"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------090109030102090103020005
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 07/23/2014 09:13 AM, Benjamin Dugast wrote:
> We finally solved our problem,
> Thanks for your help.
>
>
> 2014-07-23 15:43 GMT+02:00 hubert depesz lubaczewski <depesz@gmail.com 
> <mailto:depesz@gmail.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@excilys.com <mailto:bdugast@excilys.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?
>
>
>
And the solutions was....


--------------090109030102090103020005
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 07/23/2014 09:13 AM, Benjamin Dugast
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAB9ggRrAHJiVGPBPeYt0b5iDfa88aTML2Y2VwoEgQgXjPUrmFA@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>We finally solved our problem,<br>
        </div>
        <div>Thanks for your help.<br>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">2014-07-23 15:43 GMT+02:00 hubert
          depesz lubaczewski <span dir="ltr">&lt;<a
              moz-do-not-send="true" href="mailto:depesz@gmail.com"
              target="_blank">depesz@gmail.com</a>&gt;</span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>
                <div>No, it's not.<br>
                </div>
                What might happen, though, is that you call your
                callback before the transaction with create table got
                committed.<span class="HOEnZb"><font color="#888888"><br>
                    <br>
                  </font></span></div>
              <span class="HOEnZb"><font color="#888888">depesz<br>
                </font></span></div>
            <div class="HOEnZb">
              <div class="h5">
                <div class="gmail_extra"><br>
                  <br>
                  <div class="gmail_quote">On Wed, Jul 23, 2014 at 12:33
                    PM, Benjamin Dugast <span dir="ltr">&lt;<a
                        moz-do-not-send="true"
                        href="mailto:bdugast@excilys.com"
                        target="_blank">bdugast@excilys.com</a>&gt;</span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0
                      .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div dir="ltr">
                        <div>
                          <div>
                            <div>
                              <div>
                                <div>Hello,<br>
                                  <br>
                                </div>
                                We have an issue with tables creations
                                in our application.<br>
                              </div>
                              <br>
                            </div>
                            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.<br>
                            <br>
                          </div>
                          We tried to use a Thread.sleep() just before
                          the insert and it works but we can't stay with
                          this.<br>
                          <br>
                        </div>
                        What can we do to avoid this problem?<br>
                      </div>
                    </blockquote>
                  </div>
                  <br>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    And the solutions was....<br>
    <br>
    <br>
  </body>
</html>

--------------090109030102090103020005--