PgSqlDump - SET default_with_oids = false;

[damon.cognito]

I am dumping a schema using PgSqlDump but at the top of the dump it has the command

SET default_with_oids = false;

The problem is that the dump does not put 'WITH OID = true' on those tables created with an OID field; I think this is a defect as it is not producing a full back up. Or have I got a setting wrong in the dump command?

There may be an argument that the default line should not be there at all as it should use the default as set in the postgres.conf file.

I am using 5.0.1479.0, postgresql 9.3, VS2015 Professional on Windows

cheers, Damon.

Code: Select all

                        using (var schemaBackup = new PgSqlDump()
                        {
                            Connection = DBAccess.GetConnection(),
                            QuoteIdentifier = true,
                            Mode = DumpMode.Schema,
                            GenerateHeader = false,
                            UseMultirowSyntax = true,
                            ObjectTypes = PgSqlDumpObjects.Schemas | PgSqlDumpObjects.Sequences | PgSqlDumpObjects.Tables | PgSqlDumpObjects.Views
                        })
                        {
                            string name = "dump_schema.backup");
                            schemaBackup.Backup(name);
                        }

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[damon.cognito]

That's great, thanks - it's a huge problem for us.

[Pinturiccio]

We have fixed the bug with not adding "WITH OIDS;" for tables that have this clause when performing their backup with PgSqlDump. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

[Pinturiccio]

New build of dotConnect for PostgreSQL 7.9.946 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=35677