Subscribe to RSS

Question 1

I'm using AWS DMS to migrate from PostgreSQL 9.6 to PostgreSQL 17.5 and the DMS task keeps failing on a single table with this error atfo_read: status__ == APR_SUCCESS failed (at_file.c:1000) ...

Question 2

This a follow-up to a question from 9/15/25: Query that checks if an item name contains a substring, and if true, perform a second query that grabs an image with a specific name I have a query that ...

Question 3

I have this simple query that makes an image appear in a report based on its name SELECT image_data FROM image WHERE ((image_name='logo')); I was able to modify this query so that if the name of ...

Question 4

An existing old Windows (currently migrated on a Windows 10) environment uses PostgreSQL 9.6 and I use some of the tools (psql.exe and pg_dump.exe) from the bin dir to do backup/restore operations. ...

Question 5

ON PostgreSQL 9.6.10 (Red Hat 4.8.5-28), 64-bit select string_to_array('file.name.pdf', '.') {file,nome,pdf} select array_length(string_to_array('file.nome.pdf', '.')) [42883]: ERROR: function ...

Question 6

I have an application that is distributed in a deb package. The app uses a certain database structure in PostgreSQL database that may change for different versions of the app. As a result, I would ...

Question 7

I have a column type text, with json object in it, in my table like : {{"name":"MyName","age":10.0, "attribut":{"attack":"20","defence&...

Question 8

i had one project with apache ninja using java 8 and postgres 9.6. I needed to migrate this to spring boot only. I am using spring boot 2.5.x. but when i configured this project it is running 10x ...

Question 9

I have a table that looks like below: CREATE TABLE "time_records" ( startdate timestamp, starttime timestamp, endtime timestamp, timesheetid int, servicestate int, recordcount ...

Question 10

I have the following table: create table table1 ( id serial, workdate date, tanknum1 integer, tanknum2 integer, tanknum3 integer, tank1startingvalue float, ...

Question 11

I have a large table (> 50M rows) that I'm trying to convert into a new table format. As part of this, the row ids returned from the first insert need to be used in a second insert into a second ...

Question 12

I do not know why this isn't working. Is it something about using parameters in the query twice? Using PHP 7.4.33, Postgres PostgreSQL 9.6.22. Error is: Warning: pg_query_params(): Query failed: ...

Question 13

I have a table test_table: Column | Type | ------------+------------------------+ id | integer | attributes | json | With content: ...

Question 14

I have a table which looks like below: CREATE TABLE time_records ( id uuid NOT NULL, employee_id uuid NOT NULL, starttime timestampt NOT NULL, endtime timestampt NOT NULL ) There will be ...

Question 15

I am using Spring boot 2.7.5 and included dependency Flyway core 7.15.0 to execute migrations script on Psotgresql-9.6 but The IntelliJ-Idea external dependencies show Flyway core dependency 7.15.0 ...

Collectives™ on Stack Overflow

AWS DMS Keeps silently failing with resource temporarily unavailable (apr status = 11)

Query result overriding in db<>fiddle and xtuple

Query that checks if an item name contains a substring, and if true, perform a second query that grabs an image with a specific name

Is it safe to copy around PostgreSQL bin dir?

LENGTH of ARRAY [42883]: ERROR: function array_length(text[]) does not exist

Alter PostgreSQL table using create_table

Multiply all values of a json object with postgres 9.6

Spring boot running too slow for postgres 9.6

Postgres 9.6 Find distinct time periods and count of records within a certain time range

Is there a function to return the first null value of a row?

PostgreSQL 9.6 nested INSERT/RETURN statements have unacceptably poor CTE performance

Postgres parameterized query with INSERT ON CONFLICT and geometry not working in PHP

Filtering by JSON type field with Postgres and SQLAlchemy

Query to find unique time periods from list of time ranges

Spring boot Flyway Gradle dependency version auto inclusion

Hot Network Questions