[Mono-devel-list] Postgresql access

[Daniel Morgan]

Some changes were made to DataTable, DataRow, etc...  So, this may
inadvertently caused Mono.Data.PostgreSqlClient to not work correctly.

The BuildSchemaTable() method in PgSqlConnection.cs needs to be fixed.
I would suggest removing the AcceptChanges() call on the data row.

By the way, Mono.Data.PostgreSqlClient is deprecated.  As far as I know, no
one has been maintaining it.

A much better provider for PostgreSQL is Npgsql.

-----Original Message-----
From: mono-devel-list-admin at lists.ximian.com
[mailto:mono-devel-list-admin at lists.ximian.com]On Behalf Of Les Ferguson
Sent: Tuesday, December 02, 2003 8:20 AM
To: mono-devel-list at lists.ximian.com
Subject: [Mono-devel-list] Postgresql access


I am trying out the test set of aspx pages, I set up postgresql as per
instructed in dbpage1.aspx, and it appears to make the database connection,
but it fails to retrieve a reader when selecting the table.
Is this dbpage1.aspx supposed to be working ?

The exception below appears to happen when it first hits
	while (reader.Read ())

System.Data.RowNotInTableException: Cannot perform this operation on a row
not
in the table.
in <0x000b1> System.Data.DataRow:AcceptChanges ()
in <0x009f2> Mono.Data.PostgreSqlClient.PgSqlResult:BuildTableSchema
(intptr)
in <0x000c9> Mono.Data.PostgreSqlClient.PgSqlCommand:ExecuteQuery
(string,Mono.Data.PostgreSqlClient.PgSqlResult)
in <0x00168> Mono.Data.PostgreSqlClient.PgSqlCommand:NextResult ()
in <0x0006d> Mono.Data.PostgreSqlClient.PgSqlDataReader:NextResult ()
in <0x0005d> (wrapper remoting-invoke-with-check)
Mono.Data.PostgreSqlClient.PgSqlDataReader:NextResult ()
in <0x000fd> Mono.Data.PostgreSqlClient.PgSqlCommand:ExecuteReader
(System.Data.CommandBehavior)
in <0x00016> Mono.Data.PostgreSqlClient.PgSqlCommand:ExecuteReader ()
in <0x00011>
Mono.Data.PostgreSqlClient.PgSqlCommand:System.Data.IDbCommand.ExecuteReader
()
in <0x0015f> ASP.dbpage1_aspx:UpdateTable (string,string)


--
Les Ferguson

_______________________________________________
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list