Postgre SQL
14 results found
How to compare date without time with now() in PostgreSQL?
How to compare date without time with now() in PostgreSQL? It's only wrong when compare date and current date are the same.
ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
An exception throw ERROR: column "m.displayname" must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL.
Exception: Sequence contains more than one element in Asp.net Core
I get an exception throw System.InvalidOperationException: Sequence contains more than one element in Asp.Net Core 3.1 when try to get data from database.
Error 42702: column reference "id" is ambiguous in PostgreSQL
I get an exception throw 42702: column reference "id" is ambiguous in Asp.Net Core when using PostgreSQL database to select data from a single table
InvalidOperationException: Connection property has not been initialized in Asp.Net Core
I get an exception throw System.InvalidOperationException: Connection property has not been initialized in Asp.net Core when I trying to get data from the database
System.InvalidOperationException: 'No row is available' in PostgreSQL
System.InvalidOperationException: No row is available, it throws when trying to get an object in C# and PostgreSql
Npgsql Error: exception while reading from stream in Asp.net Core
Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Asp.Net Core: The connection pool has been exhausted
Npgsql.NpgsqlException (0x80004005): The connection pool has been exhausted, either raise MaxPoolSize (currently 100) or Timeout (currently 15 seconds) in Asp.Net Core
PostgreSQL: A command is already in progress in Asp.Net Core
PostgreSQL: A command is already in progress in Asp.Net Core when push many user access at the same time
How to get the total of current connection in PostgreSQL?
Help to best solution: How to get the total of the current connection in PostgreSQL? I need to make a service warning when it's full.
ERROR: OFFSET must not be negative in PostgreSQL
ERROR: OFFSET must not be negative in SELECT command PostgreSQL. I want to make paging in postgreSql but it does not work for me.
How to update top N records for a table in PostgreSQL?
How to update top N records for a table in PostgreSQL? UPDATE command only filter and update base on WHERE command. it does not allow TOP command
PostgreSQL Error: Terminating connection due to administrator command
PostgreSQL Error: Terminating connection due to administrator command when executing an insert command
[PostgreSQL] ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in the select list in Postgre SQL when distinct in select query.