Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: Karen Goh <karenworld@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@lists.postgresql.org, Ron <ronljohnsonjr@gmail.com>
Subject: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
Date: Sun, 21 Jul 2019 15:00:13 +0000 (UTC)
Message-ID: <905425626.2686338.1563721213121@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwYwO4EdGQ_H6avBUQaeUTOyoLFw17OicCXsFzVVri4aUw@mail.gmail.com>
References: <820008379.2579287.1563670685484@mail.yahoo.com>
	<5CE41E80-274A-44DA-9553-E2DCA260F751@jakobs.com>
	<385857992.2643116.1563717238725@mail.yahoo.com>
	<923fb3b1-90e9-e0b5-bc5b-d896128c3f28@gmail.com>
	<1745586001.2633224.1563719075867@mail.yahoo.com>
	<CAKFQuwYwO4EdGQ_H6avBUQaeUTOyoLFw17OicCXsFzVVri4aUw@mail.gmail.com>

On Sunday, July 21, 2019, 10:55:13 PM GMT+8, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Sunday, July 21, 2019, Karen Goh <karenworld@yahoo.com> wrote:

 You can't Select s_tutor.zip_code from subject_tutor as zip_code belongs to s_tutor table.

 Hence, I wrote my last message about my confusion.

You need to show your entire schema and the queries that are giving you trouble if you want to get help that is less confusing. Though as I wrote before I think your immediate problem is that you don’t have a “tutor” table on which to create the PK.

Is there a way for me to generate an entity table diagram vis pgAdmin4 or PSQL ?

David J.

view thread (26+ messages)  latest in thread

Message-ID: <905425626.2686338.1563721213121@mail.yahoo.com>
Permalink:  ../905425626.2686338.1563721213121@mail.yahoo.com/
Also on:    postgresql.org/message-id/905425626.2686338.1563721213121@mail.yahoo.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: karenworld@yahoo.com, david.g.johnston@gmail.com, ronljohnsonjr@gmail.com
  Subject: Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?
  In-Reply-To: <905425626.2686338.1563721213121@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox