Update command generated in MONO for PostgeSQL does not include
schema name before table name.
The following code running under MONO 1.1.16.1 in Windows returns
update "mytable" set ....
but when running under .NET it returns correctly schema also:
update "myschema"."mytable" set ...
How to force mono to add schema name to update command ?
Andrus.
private void Form1_Load(object sender, EventArgs e)
{
...
this.npgsqlCommand1.CommandText = "select * FROM myschema.mytable order by
1";
this.npgsqlDataAdapter1.Fill(this.dataSet1);
}
private void button1_Click(object sender, EventArgs e)
{
Npgsql.NpgsqlCommandBuilder builder;
builder = new Npgsql.NpgsqlCommandBuilder(this.npgsqlDataAdapter1);
this.npgsqlDataAdapter1.InsertCommand =
builder.GetUpdateCommand(this.dataSet1.Tables[1].Rows[1]);
MessageBox.Show(this.npgsqlDataAdapter1.UpdateCommand.CommandText.Substring(0,50)
);
}
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
