From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Karen Goh <karenworld(at)yahoo(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ron <ronljohnsonjr(at)gmail(dot)com> |
Subject: | Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
Date: | 2019-07-21 14:54:54 |
Message-ID: | CAKFQuwYwO4EdGQ_H6avBUQaeUTOyoLFw17OicCXsFzVVri4aUw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
On Sunday, July 21, 2019, Karen Goh <karenworld(at)yahoo(dot)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.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Karen Goh | 2019-07-21 14:56:07 | Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
Previous Message | Tom Lane | 2019-07-21 14:36:06 | Re: Database.Schema.Table |
From | Date | Subject | |
---|---|---|---|
Next Message | Karen Goh | 2019-07-21 14:56:07 | Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? |
Previous Message | Karen Goh | 2019-07-21 14:24:35 | Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? |