kimmking commented on issue #4471: Can ado.net connect sharding-proxy?
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4471#issuecomment-592390890
 
 
   I found a description about the above comment in [pgsql doc 
site](https://www.postgresql.org/docs/current/catalog-pg-type.html) :
   
   > 
   If this is a composite type (see typtype), then this column points to the 
pg_class entry that defines the corresponding table. (For a free-standing 
composite type, the pg_class entry doesn't really represent a table, but it is 
needed anyway for the type's pg_attribute entries to link to.) Zero for 
non-composite types.
   
   According to it, this query is not nessesary for ADO.NET of Npgsql 
Connection.
   And now I find it had been imported to [ngpsql 
project](https://github.com/npgsql/npgsq) in file:
   
https://github.com/npgsql/npgsql/blob/2365e83a7b06aa9270ad6c01f573028383bc93f2/src/Npgsql/PostgresDatabaseInfo.cs
   
   There is a parameter to turn it on/off : 
`ServerCompatibilityMode.NoTypeLoading`.
   
   @flzxsqcysyhljt  You can retry with:
   ```
               string ConnectionString = "...............";  
   
               var conf = new NpgsqlConnectionStringBuilder(ConnectionString)
               {
                   ServerCompatibilityMode = 
ServerCompatibilityMode.NoTypeLoading
   
               }.ToString();
   
               using (NpgsqlConnection conn = new NpgsqlConnection(conf))
               {
                   conn.Open();
                   ........
               }
   ```
   
    
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to