postgreSQL returns blank

Question

I'm trying to make a foreign key. When I execute the query below, it returns blank with neither an explanation nor an error.

alter table MySQL."GrossHomeSales"
    add constraint fk_zip_code
        foreign key (nhs_prev_zip) references MySQL."Location" (zip_code);

Alter table is not famous for its verbose output. Are you expecting something in particular? — Gordon Linoff
– Gordon Linoff, Commented Aug 2, 2016 at 19:47
You can activate debugging in postgresql, maybe you see there more messages. Error Reporting and Logging — Victorqedu
– Victorqedu, Commented Aug 2, 2016 at 19:51
I've used this technique to create other foreign keys for other tables and it had proved to be fruition but I don't know why the one above returns nothing. And also I'm new to this community can you guide me towards how you can have sample queries or codes copied in the gray shaded area you helped edit. — user6640983
– user6640983, Commented Aug 2, 2016 at 19:56
What exactly is your question? Is the foreign key not created? Did you commit the alter table? — user330315
– user330315, Commented Aug 2, 2016 at 20:59
When I'm running the above query neither does it show an error nor an explanation; it just shows blank. I've used the exact same query to assign foreign keys for other tables but for some odd reason it shows blank for this one. If it'd show an error I would try to work on removing the error but since it just shows blank I have no headway. — user6640983
– user6640983, Commented Aug 2, 2016 at 21:31

e4c5 · Accepted Answer · 2016-08-02 23:32:23Z

1

You have not mentioned what your sql client is. If you are using psql, it does say ALTER TABLE when you make an alteration to a table. If instead you were using pgadmin 3, it would say something like

Query returned successfully with no result in 345 msec.

The reason that you are not seeing any output could be because this is really large table with several million rows, Then it could take a few minutes to create the index so don't expect instant output.

The other likely reason for not receiving any immediate response is because the table has been locked by another long running query.

Finally your question title says postgresql but your table has mysql in it's name?? (this is not related, just curious)

answered Aug 2, 2016 at 23:32

e4c5

53.9k11 gold badges110 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgreSQL returns blank

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related