PgSqlDump - SET default_with_oids = false;

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
damon.cognito
Posts: 50
Joined: Wed 22 Jul 2009 09:30

PgSqlDump - SET default_with_oids = false;

Post by 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);
                        }

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDump - SET default_with_oids = false;

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

damon.cognito
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Re: PgSqlDump - SET default_with_oids = false;

Post by damon.cognito » Tue 11 Jul 2017 07:36

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

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDump - SET default_with_oids = false;

Post by 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: 2192
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlDump - SET default_with_oids = false;

Post by 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/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

Post Reply