Page 1 of 1

dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Posted: Wed 22 Nov 2017 13:23
by Feneck91
I use PgSqlDump.Backup function to backup the database. Before this latest version, I could write a database backup, now all entries are empty : PgSqlDump.Backup function will not work anymore with version dotConnect for PostgreSQL 7.10
-- dotConnect for PostgreSQL 7.10.1013.0
-- Server version: PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit
-- Script date 22/11/2017 14:17:44
-- Server: W267153
-- Database: postgis_geomaps

SET client_encoding = 'UTF8';
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;

CREATE TABLE public."DMGeneral"
(
"GeneralID" bigint,
"SchemaVersion" smallint NOT NULL,
"DataVersion" smallint NOT NULL,
"DataManagerLatestVersion" text NOT NULL,
"MinimalVersionDataManagerForSchema" text NOT NULL
);

INSERT INTO public."DMGeneral" VALUES ();

CREATE TABLE public."DMVerificationConfiguration"
(
"VerificationConfigurationID" bigint,
"MD5" text NOT NULL
);

INSERT INTO public."DMVerificationConfiguration" VALUES ();

CREATE TABLE public.spatial_ref_sys
(
srid integer,
auth_name varchar(256),
auth_srid integer,
srtext varchar(2048),
proj4text varchar(2048)
);

INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
.... more lines
NSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();

CREATE TABLE public."DMFamille"
(
"FamilleID" bigint,
"Type" smallint NOT NULL,
"NomCourt" varchar(32) NOT NULL,
"NomLong" varchar(64) NOT NULL,
"Tag" varchar(32) NOT NULL,
"ExcelContentString" varchar(1024) NOT NULL
);

INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
.... more lines
I
I cut some piece of same lines with ".... more lines" but the backup file has this look !
No way to backup a database with this version now !

A problem with the backup for this version ?

Re: dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Posted: Mon 27 Nov 2017 16:29
by Pinturiccio
There is an issue with empty insert statements in a dump backup script in dotConnect for PostgreSQL 7.10.1013. However, we could not reproduce the issue in the latest dotConnect for PostgreSQL 7.10.1031. You can download the latest dotConnect for PostgreSQL 7.10.1031 from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
Try using the latest dotConnect for PostgreSQL version and post here about the results.

Re: dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Posted: Thu 14 Dec 2017 09:16
by Feneck91
It's work like a charm with the PostgreSQL 7.10.1031 version.
Thanks for all.