In PostgreSQL 16.1 I have a very large table mytable with a column _modified with type Timestamp with time zone. When I run below query on the whole table, it returns a lower timestamp value compared to when I run…
I have a table in a postgres database with data that looks like this: XX-001111111-11-Q011111o_ABC_90001u-0000101-9 The table has 1000 rows with similar looking strings. I want to update every row to add the 'AB-' prefix to it. So XX-001111111-11-Q011111o_ABC_90001u-0000101-9 would…
I have an app written in TS with a PostgreSQL database that I access using Prisma. In the database I have a table called Points with columns X and Y that represents points on the cartesian plane. I need to…
Here's a scenario: Users are saving time only in a database as a string, e.g. 20:00. They expect something to happen every day at 8 PM. But 8 PM means a different time for different people given each lives in…
I am working with an Azure Database for PostgreSQL Flexible Server that contains a table where new data is inserted daily. Over time, this has led to the accumulation of millions of rows, and the process of writing data to…
I keep receiving 404 Not Found error for my MVC app. Here are my code: application.properties spring.datasource.url=jdbc:postgresql://localhost:5432/demo1 spring.datasource.username=demo1 spring.datasource.password=demo1 spring.datasource.driver-class-name=org.postgresql.Driver spring.jpa.generate-ddl=true spring.jpa.show-sql=true server.port=5000 ## Hibernate Properties # The SQL dialect makes Hibernate generate better SQL for the chosen database spring.jpa.properties.hibernate.dialect…
I struggle with adding ToLower() to the Contains LINQ Expressions: Here is the code of mine with dynamic LINQ Expressions (Contains): private static Expression GetExpressionCase<T>(ParameterExpression param, SearchCriteria searchCriteria) { MethodInfo containsMethod = typeof(string).GetMethod("Contains", new[] { typeof(string) }); MemberExpression member =…
I have a table race_racer that contains time serialized logs for each racer in a race. I am trying to select the lastest record for a given racer in x number of races prior to a date. Basically selecting their…
In a postgres logical replication setup, how do I know the hostname and db of the subscriber? I can find the publisher details from the subscriber but how do I find subscriber details from publisher? postgres=> select * from pg_subscription;…
I have setup separate config file and run postgres=# ALTER DATABASE s2409 SET config_file = 'E:/App/PostgreSQL/16/data/s2409/s2409_postgresql.conf' ; ERROR: parameter "config_file" cannot be changed without restarting the server. The same error coming even after restart. Can somebody suggest I have done…