CODEWITHSUNDEEP
sqlpostgresqlforeign-keys
user6640983
user6640983

Reputation:

postgreSQL returns blank

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);

Upvotes: 3

Views: 690

Answers (1)

e4c5
e4c5

Reputation: 53774

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)

Upvotes: 1

Related Questions