[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Logical replication
From:       Yambu <hyambu () gmail ! com>
Date:       2020-11-19 21:14:17
Message-ID: CALhHtcDpGL1GLKgf3uFGxawBEBKvWVkAt-nd5D93s3Hdb9g5Qw () mail ! gmail ! com
[Download RAW message or body]

Oh yes i meant primary key.

Thanks

On Thu, Nov 19, 2020 at 10:46 PM Holger Jakobs <holger@jakobs.com> wrote:

> I think he refers to a table without a PRIMARY KEY.
>
> No, that's not a good idea, as it is never a good idea having a table
> without a PRIMARY KEY.
>
> PRIMARY KEYs are not an optional feature.
> Am 19.11.20 um 21:40 schrieb David G. Johnston:
>
> On Thu, Nov 19, 2020 at 1:39 PM Yambu <hyambu@gmail.com> wrote:
>
>> Is it recommended to do logical replication on a table without a primary?
>>
>>
> primary what?
>
> David J.
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>

[Attachment #3 (text/html)]

<div dir="ltr"><div>Oh yes i meant primary \
key.</div><div><br></div><div>Thanks</div></div><br><div class="gmail_quote"><div \
class="gmail_attr" dir="ltr">On Thu, Nov 19, 2020 at 10:46 PM Holger Jakobs &lt;<a \
href="mailto:holger@jakobs.com">holger@jakobs.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
  
    
  
  <div>
    <p>I think he refers to a table without a PRIMARY KEY.</p>
    <p>No, that&#39;s not a good idea, as it is never a good idea having a
      table without a PRIMARY KEY.</p>
    <p>PRIMARY KEYs are not an optional feature.<br>
    </p>
    <div>Am 19.11.20 um 21:40 schrieb David G.
      Johnston:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">
        <div dir="ltr">
          <div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><span \
                style="font-family:Arial,Helvetica,sans-serif">On Thu, Nov
              19, 2020 at 1:39 PM Yambu &lt;<a href="mailto:hyambu@gmail.com" \
target="_blank">hyambu@gmail.com</a>&gt;  wrote:</span></div>
        </div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
  <div dir="ltr">
              <div>Is it recommended to do logical replication on a
                table without a primary?</div>
              <div><br>
              </div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div class="gmail_default" \
                style="font-family:arial,helvetica,sans-serif">primary what?</div>
          <div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br>  </div>
          <div class="gmail_default" \
                style="font-family:arial,helvetica,sans-serif">David J.</div>
          <div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br>  </div>
        </div>
      </div>
    </blockquote>
    <pre cols="72">-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </div>

</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]