Subject: Re: How do I alter an existing column and add a foreign key which is
 a Primary key to a table?
To: pgsql-admin@lists.postgresql.org
References: <820008379.2579287.1563670685484@mail.yahoo.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <24840698-956d-31fe-96dd-9e9427890e39@gmail.com>
Date: Sat, 20 Jul 2019 20:25:33 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.2
MIME-Version: 1.0
In-Reply-To: <820008379.2579287.1563670685484@mail.yahoo.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 7/20/19 7:58 PM, Karen Goh wrote:
> Hi all,
>
> I used to write a script in MYSQL and foreign and primary key will be created.
>
> With PG4Admin, I am lost.
>
> I realised now that the keys are not created and perhaps that is why the join query is not working out.
>
> Please let me know what is the correct way to alter a column in a table to have foreign key to a tutor_id which is also the primary key of that table.
>
> So, meaning I need to create a foreign key as well as primary key for tutor_id.
>
> So far, this is what I have attempted but it is not working.
> ALTER TABLE tutor_subject
>    ADD CONSTRAINT tutor_subject_pk
>      PRIMARY KEY (tutor_id)
> 	ADD CONSTRAINT tutor_subject_fk
> 	FOREIGN KEY (tutor_id)

What error message do you get?

Does tutor_id already exist in tutor_subject?

What foreign table are you referencing?  (I don't see that referenced in 
your example.)

Have you read the documentation?
https://www.postgresql.org/docs/9.6/sql-altertable.html
http://www.postgresqltutorial.com/postgresql-primary-key/
http://www.postgresqltutorial.com/postgresql-foreign-key/


-- 
Angular momentum makes the world go 'round.