Content-Type: multipart/alternative;
 boundary="------------Q0qTzORZBG0f20J0ExJ0Ugs9"
Message-ID: <868eea77-7a0c-4fca-b9a3-7a38ffe5087f@gmail.com>
Date: Tue, 4 Feb 2025 10:05:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Lookup tables
To: pgsql-general@lists.postgresql.org
References: <4e7a338-c7d3-e944-20bd-a6e346e175c7@appl-ecosys.com>
 <C7F5BFD3-929B-46CC-B20C-893189F154D5@kleczek.org>
 <CANzqJaC83XvJOzCH+3Au5LgMOCMGMNXdTDLU6_tPJmLjO5rGZg@mail.gmail.com>
Content-Language: en-CA
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: 
 <CANzqJaC83XvJOzCH+3Au5LgMOCMGMNXdTDLU6_tPJmLjO5rGZg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/868eea77-7a0c-4fca-b9a3-7a38ffe5087f%40gmail.com>
Precedence: bulk

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


On 2/4/25 10:03, Ron Johnson wrote:
> On Tue, Feb 4, 2025 at 11:31 AM Michał Kłeczek <michal@kleczek.org> wrote:
> [snip]
>
>
>     The query to register a visit is:
>     insert into restaurant_visit
>     select $user, current_date, restaurant_id, $rating
>     from restaurant where name = $restaurant_name
>
>
>     It is now completely unclear what it means to change the name of
>     the restaurant for already registered visits.
>     Is it still the same restaurant with a different name or a
>     different restaurant?
>
>     Or let say someone swaps names of two restaurants.
>     That means a user that goes to the same restaurant every day would
>     register visits to two different restaurants!
>
>
> Valid concerns, which means that you add a new restaurant record when 
> the name changes.
>

And there goes your unique index on phone number :)

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

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <br>
    <br>
    <br>
    <div class="moz-cite-prefix">On 2/4/25 10:03, Ron Johnson wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CANzqJaC83XvJOzCH+3Au5LgMOCMGMNXdTDLU6_tPJmLjO5rGZg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">On Tue, Feb 4, 2025 at 11:31 AM Michał Kłeczek
          &lt;<a href="mailto:michal@kleczek.org" moz-do-not-send="true"
            class="moz-txt-link-freetext">michal@kleczek.org</a>&gt;
          wrote:</div>
        <div class="gmail_quote gmail_quote_container">
          <div>[snip] </div>
          <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <br>
            The query to register a visit is:<br>
            insert into restaurant_visit<br>
            select $user, current_date, restaurant_id, $rating<br>
            from restaurant where name = $restaurant_name<br>
            <br>
            <br>
            It is now completely unclear what it means to change the
            name of the restaurant for already registered visits.<br>
            Is it still the same restaurant with a different name or a
            different restaurant?<br>
            <br>
            Or let say someone swaps names of two restaurants.<br>
            That means a user that goes to the same restaurant every day
            would register visits to two different restaurants!<br>
          </blockquote>
        </div>
        <div><br>
        </div>
        <div>Valid concerns, which means that you add a new restaurant
          record when the name changes.</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <br>
    And there goes your unique index on phone number :)<br>
    <br>
  </body>
</html>

--------------Q0qTzORZBG0f20J0ExJ0Ugs9--