934 questions
0
votes
0
answers
56
views
AWS DMS Keeps silently failing with resource temporarily unavailable (apr status = 11)
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)
...
- 361
-1
votes
1
answer
129
views
Query result overriding in db<>fiddle and xtuple
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 ...
- 21
1
vote
1
answer
166
views
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 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 ...
- 21
1
vote
1
answer
42
views
Is it safe to copy around PostgreSQL bin dir?
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.
...
- 540
0
votes
1
answer
282
views
LENGTH of ARRAY [42883]: ERROR: function array_length(text[]) does not exist
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 ...
- 1
0
votes
0
answers
103
views
Alter PostgreSQL table using create_table
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 ...
- 367
2
votes
1
answer
79
views
Multiply all values of a json object with postgres 9.6
I have a column type text, with json object in it, in my table like :
{{"name":"MyName","age":10.0, "attribut":{"attack":"20","defence&...
- 66
0
votes
0
answers
104
views
Spring boot running too slow for postgres 9.6
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 ...
1
vote
0
answers
33
views
Postgres 9.6 Find distinct time periods and count of records within a certain time range
I have a table that looks like below:
CREATE TABLE "time_records" (
startdate timestamp,
starttime timestamp,
endtime timestamp,
timesheetid int,
servicestate int,
recordcount ...
- 33
1
vote
1
answer
551
views
Is there a function to return the first null value of a row?
I have the following table:
create table table1
(
id serial,
workdate date,
tanknum1 integer,
tanknum2 integer,
tanknum3 integer,
tank1startingvalue float,
...
1
vote
1
answer
37
views
PostgreSQL 9.6 nested INSERT/RETURN statements have unacceptably poor CTE performance
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 ...
- 9,511
1
vote
2
answers
380
views
Postgres parameterized query with INSERT ON CONFLICT and geometry not working in PHP
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: ...
- 171
0
votes
2
answers
290
views
Filtering by JSON type field with Postgres and SQLAlchemy
I have a table test_table:
Column | Type |
------------+------------------------+
id | integer |
attributes | json |
With content:
...
- 277
2
votes
2
answers
93
views
Query to find unique time periods from list of time ranges
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 ...
- 33
0
votes
1
answer
461
views
Spring boot Flyway Gradle dependency version auto inclusion
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 ...
- 617