PgSqlDump - SET default_with_oids = false;

PgSqlDump - SET default_with_oids = false;

Postby damon.cognito » Fri 07 Jul 2017 15:13

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);
                        }
damon.cognito
 
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Re: PgSqlDump - SET default_with_oids = false;

Postby Pinturiccio » Mon 10 Jul 2017 14:31

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDump - SET default_with_oids = false;

Postby damon.cognito » Tue 11 Jul 2017 07:36

That's great, thanks - it's a huge problem for us.
damon.cognito
 
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Re: PgSqlDump - SET default_with_oids = false;

Postby Pinturiccio » Thu 13 Jul 2017 11:58

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
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDump - SET default_with_oids = false;

Postby Pinturiccio » Thu 20 Jul 2017 08:07

New build of dotConnect for PostgreSQL 7.9.946 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=35677
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL