Problem with PgSqlDump DumpMode.Data

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 5
Joined: Wed 17 Jun 2009 04:54

Problem with PgSqlDump DumpMode.Data

Post by blurble » Wed 10 Nov 2010 21:54

I'm using PgSqlDump to dump out my DB to a file. If I use DumpMode.All (or don't specify the DumpMode) then it all works fine. The code I use is like this:

Code: Select all

using (PgSqlDump pgSqlDump = new PgSqlDump())
	pgSqlDump.Connection = connection;
	pgSqlDump.Tables = tableList;
	pgSqlDump.IncludeBlob = true;
	pgSqlDump.IncludeUsers = false;
	pgSqlDump.IncludeDrop = false;
	pgSqlDump.Backup(Path.Combine(saveFolder, "script.backup"));
and I get a complete script containing the table creation statements and the data.

However, if I want to dump out just the data I add

Code: Select all

pgSqlDump.Mode = DumpMode.Data;
but then the output script always only contains the following:

Code: Select all

-- dotConnect for PostgreSQL
-- Server version: PostgreSQL 8.3.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3
-- Script date 11/11/2010 10:15:10 a.m.
-- Server:
-- Database: conductor

SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET default_tablespace = '';
SET default_with_oids = false;
Is there anything I am doing wrong, or is this a bug? I am currently using v4.65.79, but would upgrade to a newer version if I know that this problem is fixed.


Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Fri 12 Nov 2010 17:29

Apparently, this is an error fixed in newer builds. I've reproduced this problem with the 4.65.79 version, but couldn't with the latest 5.0.46 Beta build. Please try dotConnect for PostgreSQL Beta 5.0. You can download it from ... nload.html
(the trial version) or from Registered Users' Area (provided that you have an active subscription):

Posts: 5
Joined: Wed 17 Jun 2009 04:54

Post by blurble » Fri 12 Nov 2010 21:05

Thanks for the info. I will give the newer version a go.

Post Reply