Error: "insufficient data left in message"
Posted: Mon 09 Jun 2008 14:33
I use trial PostgreSQL CF .NET, I get following error "insufficient data left in message" in some specific situation
1) Table for example "pz" have trigger running on DELETE
2) In trigger function we use RAISE EXCEPTION when DELETE is not possible
3) In .NET on mobile device we have
try{
PgSqlCommand sql3 = new PgSqlCommand("DELETE FROM pz WHERE id = :id", pgsqlconnection);
sql3.Parameters.Add("id", id_pz);
sql3.ExecuteNonQuery();
}
catch (Exception e)
{
lasterror = e.Message;
}
In lasterror we get probapbly value from RAISE EXCEPTION from trigger, but when we would like to run another SQL like
PgSqlCommand sql1 = new PgSqlCommand("SELECT * FROM pz WHERE id=:id", pgsqlconnection);
sql1.Parameters.Add("id", id_pz);
PgSqlDataTable dt = new PgSqlDataTable(sql1, pgsqlconnection);
dt.FetchAll = true;
dt.Open();
On dt.Open() we get "insufficient data left in message".
1) Table for example "pz" have trigger running on DELETE
2) In trigger function we use RAISE EXCEPTION when DELETE is not possible
3) In .NET on mobile device we have
try{
PgSqlCommand sql3 = new PgSqlCommand("DELETE FROM pz WHERE id = :id", pgsqlconnection);
sql3.Parameters.Add("id", id_pz);
sql3.ExecuteNonQuery();
}
catch (Exception e)
{
lasterror = e.Message;
}
In lasterror we get probapbly value from RAISE EXCEPTION from trigger, but when we would like to run another SQL like
PgSqlCommand sql1 = new PgSqlCommand("SELECT * FROM pz WHERE id=:id", pgsqlconnection);
sql1.Parameters.Add("id", id_pz);
PgSqlDataTable dt = new PgSqlDataTable(sql1, pgsqlconnection);
dt.FetchAll = true;
dt.Open();
On dt.Open() we get "insufficient data left in message".