I've tried to migrate scheme from oracle and see errors like this:
Error Creating Constraint FK_BASE_PAY_RECEIPT: ERROR: syntax error at or near ")" at position 111
ALTER TABLE PAY_RECEIPT ADD CONSTRAINT FK_BASE_PAY_RECEIPT FOREIGN KEY (PAYRECEIPT_ID) REFERENCES TIGER.null () MATCH FULL ON DELETE NO ACTION
After removing "()" and adding schema name to table:
ALTER TABLE tiger.CALC_ERROR ADD CONSTRAINT FK_CALC_ERROR_TYPE FOREIGN KEY (CALC_ERROR_TYPE_CODE) references tiger.null MATCH FULL ON DELETE NO ACTION;
ERROR: relation "tiger.null" does not exist
Google doesn't know about this problem or may be I ask wrong questions.
Give me some glues how to solve this problem.
Thanks.