Problem with PgSqlDump DumpMode.Data

[blurble]

Hi,
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 4.65.79.0
-- 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: 192.168.1.31
-- 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.

Thanks,
Simon.

[StanislavK]

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
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (provided that you have an active subscription):
http://secure.devart.com/

[blurble]

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