Hello,
I need to perform a dump of a simple schema, but with inherited tables.
Regardless of the options I tried, the sql provided by the pgDump component does not handle inherited tables:
- the create table statement doesn't include the inherits (mySchema.myTable) statement
- the base table is managed as if it was a regular table, i.e. insert statements are generated for this table but they should not
- the base table is created in the middle of the script, but it should be created first, as other tables inherit from it
How can I proceed to generate sql dump that takes into account inherited tables?
Edit: I use the latest pgDac version 6.2.4, and postgre 12
Thanks!
g.
PgDump and inherited tables
Re: PgDump and inherited tables
Hello,
Inherited tables are not supported in TPgDump.
You can request this feature on our UserVoice page: https://devart.uservoice.com/forums/104 ... y_id=18923
Feature suggestions that receive more votes are given higher priority on our roadmap.
wbr, Oleg
Devart Team
Inherited tables are not supported in TPgDump.
You can request this feature on our UserVoice page: https://devart.uservoice.com/forums/104 ... y_id=18923
Feature suggestions that receive more votes are given higher priority on our roadmap.
wbr, Oleg
Devart Team
Re: PgDump and inherited tables
Well, that's not good news. I suggest that you update the pgdac features webpage, and the online documentation page, to communicate on this limitation.
Ok for UserVoice, I'll post a feature request.
I need to duplicate a schema (structure and data), ie schema1 needs to be duplicated to schema2. This is not a maintenance operation that could be done manually by using the pg_dump utility. It has to be done through the Delphi app, by the app admin.
What should be your recommended way to do this with PgDac components?
Thanks,
Ok for UserVoice, I'll post a feature request.
I need to duplicate a schema (structure and data), ie schema1 needs to be duplicated to schema2. This is not a maintenance operation that could be done manually by using the pg_dump utility. It has to be done through the Delphi app, by the app admin.
What should be your recommended way to do this with PgDac components?
Thanks,
Re: PgDump and inherited tables
Hello,
As we wrote earlier, PgDump doesn't support inherited tables. You can request this feature on our UserVoice page https://devart.uservoice.com/forums/104 ... y_id=18923 - features that receive more upvotes, are given higher priority on our roadmap.
wbr, Oleg
Devart Team
As we wrote earlier, PgDump doesn't support inherited tables. You can request this feature on our UserVoice page https://devart.uservoice.com/forums/104 ... y_id=18923 - features that receive more upvotes, are given higher priority on our roadmap.
wbr, Oleg
Devart Team
Re: PgDump and inherited tables
Hello,
In my last message, I was not asking for an advice on how to duplicate a schema with pgDump, but with pgDAC.
Nevertheless, I have writen a pgDump alternative.
Have a nice day
In my last message, I was not asking for an advice on how to duplicate a schema with pgDump, but with pgDAC.
Nevertheless, I have writen a pgDump alternative.
Have a nice day