0
votes

Npgsql v3.0.0-beta0001 (Prerelease) was having below issue while opening connection.

NpgsqlConnection conn = new NpgsqlConnection(@"Server=xx.xx.xx.xx;Port=9996;Database=xxx;User Id=xx;Password=xx;CommandTimeout=40;"); conn.Open();

  • ex {" : View 'pg_type' not found"} System.Exception {Npgsql.NpgsqlException}

StackTrace " at Npgsql.NpgsqlConnector.DoReadSingleMessage(DataRowLoadingMode dataRowLoadingMode, Boolean returnNullForAsyncMessage)\r\n at Npgsql.NpgsqlConnector.ReadSingleMessage(DataRowLoadingMode dataRowLoadingMode, Boolean returnNullForAsyncMessage)\r\n at Npgsql.NpgsqlConnector.SkipUntil(BackendMessageCode stopAt1, BackendMessageCode stopAt2)\r\n at Npgsql.NpgsqlDataReader.SkipUntil(BackendMessageCode stopAt1, BackendMessageCode stopAt2)\r\n at Npgsql.NpgsqlDataReader.NextResultInternal()\r\n at Npgsql.NpgsqlDataReader.NextResult()\r\n at Npgsql.NpgsqlDataReader.Init()\r\n at Npgsql.NpgsqlCommand.Execute(CommandBehavior behavior)\r\n at Npgsql.NpgsqlCommand.ExecuteDbDataReaderInternal(CommandBehavior behavior)\r\n at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)\r\n at Npgsql.TypeHandlerRegistry.LoadBackendTypes(NpgsqlConnector connector)\r\n at Npgsql.TypeHandlerRegistry.Setup(NpgsqlConnector connector)\r\n at Npgsql.NpgsqlConnector.Open()\r\n at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)\r\n at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection connection)\r\n at Npgsql.NpgsqlConnection.Open()\r\n at Test.Program.MssDenodoUpdate(String ssConnectionName, String ssTableName, TestDenodoUpdate ssUpdateRecord, String ssWhereClause, Int32 ssTimeout, Int32& ssUpdatedRows) in d:\EMRP\EMRP\DenodoConnector\Source\ConsoleApplication2\Program.cs:line 66" string

1
What exact server are you using, PostgreSQL or something less (e.g. Amazon Redshift)? Could you post the exact version as well? - Shay Rojansky
Can you please create an issue at github.com/npgsql/npgsql? I can't commit to looking at this in the very near future but I'll definitely try. - Shay Rojansky
Sure, Shay. I will post there. - Min
Thanks. Note that Npgsql has never been tested with Denodo, I have no idea how near or far it is to PostgreSQL... If anyone familiar with Denodo can help out that would be great. - Shay Rojansky

1 Answers

0
votes

EntityFramework needs a "maintenance" DB in order to create databases, etc. Before npgsql version 2.2.5. this maintenance DB was "postgres" but, since then this maintenance DB is "template1", which exists on all PostgreSQL versions.

To make EF work with Denodo you have to create in VDP the dummy database called template1.

Hope this helps!