PgSqlLoader Error Event

PgSqlLoader Error Event

Postby craig » Sun 29 Jun 2008 20:02

Hi there,

I have a problem with the PgSqlLoader. I'm trying to load into a database that has a not null constraint on a column (e.g., "date_created"). Say I forget to set the value of the "date_created" column, I should get an error to PgSqlLoader.Error, right? I don't seem to be firing this event. Is this a bug, or am I using it wrong?

this.pgSqlLoader = new CoreLab.PostgreSql.PgSqlLoader();
this.pgSqlLoader.Connection = this.pgSqlConnection;
this.pgSqlLoader.TableName = "pgsqlnet_loader";
this.pgSqlLoader.Error += delegate(object sender, PgSqlLoaderErrorEventArgs e)
{
throw new NotImplementedException("LOADER ERROR");
};
pgSqlLoader.Open();
...
pgSqlLoader.Close();

No errors, but nothing gets in the db either!

Thanks in advance,
-Craig
craig
 
Posts: 3
Joined: Tue 01 Apr 2008 23:02

Postby anton.connect » Tue 01 Jul 2008 11:37

Please send me a complete small sample at antonc*devart*com to reproduce the problem, including script to create and fill tables.
anton.connect
 
Posts: 43
Joined: Thu 19 Jun 2008 14:30

Postby craig » Tue 01 Jul 2008 22:11

Hi Anton,

This is what I get when I try to send email to that address:

-------------------------------------------------------------------

This is an informative message sent by devart*com.

The server was not able to deliver your email message

Subject: FW: PgSqlLoader Error -- Mail returned
Date: Tue, 1 Jul 2008 15:00:39 -0700



to the following addresses:

(devart*com: Mailbox invalid or does not exist)
craig
 
Posts: 3
Joined: Tue 01 Apr 2008 23:02

Postby anton.connect » Wed 02 Jul 2008 07:50

Please make sure that you've sent the test example to antonc*devart*com and not to mail*devart*com.
Also make sure that your letter is not blocked by firewall.
If it is, try to send the letter from another mailbox.

Regards,
Anton
anton.connect
 
Posts: 43
Joined: Thu 19 Jun 2008 14:30


Return to dotConnect for PostgreSQL