| 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: | Whole Thread | Raw Message | 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? |