TPgDump doesn't work with types

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
deviloper
Posts: 1
Joined: Thu 17 Oct 2013 15:19

TPgDump doesn't work with types

Post by deviloper » 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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: TPgDump doesn't work with types

Post by AlexP » Fri 18 Oct 2013 08:16

Hello,

Thank you for the information. We will try to fix this behaviour in the nearest future

Post Reply