I am trying to deploy OpenProject 14 on Azure but using Azure Postgres Felxible Database server. But I get the below error, looks like our Azure tenant is FIPS complaint and below is the error message it is throwing. Any…
is it possible to run this query jdbcTemplate.update( "UPDATE SOME_TABLE SET MY_NAME=?,MY_FILE=?" + "WHERE MY_ID = ?", new Object[] { "TestME",null,ID }); Note that there is no space between the 2nd ? and WHERE keyword. I can add a space…
I have two tables, one which I will call D and one which I will call S, with a 1:N relationship between D and S. I currently have the following query that runs on these two: SELECT d.*, s.* FROM…
Please take a look at this query: SELECT COUNT(*) FROM events e WHERE (e.event_data -> 'state')::int = -1; The query works and everything is actually ok, but... This is how the JSON object looks like when I read it from…
I can't figure out where i made a mistake. I have 2 schemas in my db (Postgre): BooksStore and PollHub. My project should use BooksStore. I use ef code-first method to create tables in schema. So I google for two…
Let's say i've a simple queryBuilder like: const workout = await this.workouts .createQueryBuilder('workout') .select(['workout.uuid', `workout.name ->> 'it'` as name]) .where('workout.uuid = :workoutUuid', { workoutUuid }) .getOne(); return workout; By using getRawOne() i see that typeorm is correctly taking the value…
I have a local PG instance populated with 10's of millions of rows of data and need to run some relatively complex queries for some data analysis work. These queries are currently taking 10+ minutes to return (even after adding…
I am working in Postgresql and am trying to find what table a specific word is in. For example, I am trying to find out what table the word "banana" is in. The database is agriculture and schema is fruit.…
When I run this request I get an error recursive query "cte_0" column 1 has type date in non-recursive term but type timestamp without time zone overall LINE 4: select min(to_char(date_trunc('month', day), 'yyyy-mm-d... ^ HINT: Cast the output of the…
I'm working with EF Core 6 and PostgreSQL, and I need to construct a query that efficiently retrieves author names along with an array of their book titles. My database schema: Books BookId (number) AuthorId (number) BookName (string) Authors AuthorId…