PgSqlDump - SET default_with_oids = false;
Posted: 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.
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);
}