TPgDump doesn't work with types
Posted: Thu 17 Oct 2013 15:23
Hello,
we recently purchased some of your great components, MyDAC and PgDAC.
No problem with whit first one, but with PgDAC, we've some backup/restore problems.
It seems the component is not able to backup/restore complex databases. We tried with an empty db with only one table and everything works fine.
Then we tried with the "dvdrental" sample database (http://www.postgresqltutorial.com/postg ... -database/).
Backup works fine, but we cannot restore the dump file in any way. Always we have errors like "type does not exist" or "relation does not exist".
I think because the database contains custom data types. Although we specified "types" in the dump options, it seems the data types are not exported in the dump file.
Could this be the reason of the error ?
Thanks in advance for your support.
we recently purchased some of your great components, MyDAC and PgDAC.
No problem with whit first one, but with PgDAC, we've some backup/restore problems.
It seems the component is not able to backup/restore complex databases. We tried with an empty db with only one table and everything works fine.
Then we tried with the "dvdrental" sample database (http://www.postgresqltutorial.com/postg ... -database/).
Backup works fine, but we cannot restore the dump file in any way. Always we have errors like "type does not exist" or "relation does not exist".
I think because the database contains custom data types. Although we specified "types" in the dump options, it seems the data types are not exported in the dump file.
Could this be the reason of the error ?
Thanks in advance for your support.