Category "postgresql"

Nest.JS TypeORM "SCRAM-SERVER-FIRST-MESSAGE: client password must be a string"

I dont know why, but since I was cloning my working repository I am using on AWS to a local machine and try to run it, I am getting the following error: "SCRAM-

Sqlfluff rule L025 breaks due to postgres `generate_series()`

I'm using sqlfluff to lint my postges code. I'm down to a single linting error, in my test code, that I dont know how to fix by adjusting my sql nor how to conf

Database schema design optimized for scoring rows to sort on

I want a table like this which has scores column, and whenever basket1 or basket2 are added to table I want to update scores of the columns in basket.So say bas

how to modify already defined composite key in liquibase

I need to alter a table to modify the order of the indexes created from the composite key for the below mentioned changeset. <changeSet author="demo (generat

How do I extract a date (dd-mm-yy) from a timestamp with timezone (timestamptz) in postgresql

My date column "timestamp" is currently listed as: 2020-11-16 20:27:38.033 +0000 It's formatted as timestamptz and I've tried every search on here and google to

django create a field that hold array of tupels or array of array

I want to add a field in my models that hold value like this field = [(1,2,3),(6,5,4),(5,6,7)] or field = [[1,2,3],[6,5,4],[5,6,7]] I am using po

PostgreSQL: How to add element to nested JSON array?

select rooms from users where username='test_user'; **returns** {"roomID":[{"1":"test1"}]} I want to add to[{"1":"test1"}] this {"2": "test2"} --> [{"1":"t

Access host database from service located in a docker container

If I have a Postgres database running on the host machine (os: Linux), and some service running in a container of docker-compose. How would I access the databas

Hive/ Impala query group by query for total success and failed record

I am trying to add the group by clause on the impala/Hive table but its not working. I am having the jobs details table which having job name and status column.

jsonpath multiplication operation over entire object

I have an object of the basic structure: [ { "a": 1, "b": 1, "c": 1 }, { "a": 2, "b": 2, "c": 2 }, { "a": 3, "b": 3,

Glue-Spark transform to Postgres time data type

Postgres has a time data type. I am trying to insert rows into postgres from a glue job. Given the code: applymapping1 = ApplyMapping.apply(frame = SelectFromCo

Postgresql error 53300 even though there are fewer connections than maximum allowed

I'm using npgsql on my ASP.NET application to connect to a postgres database. On trying to open a connection, I get the following error: 53300: remaining connec

SELECT DISTINCT, ORDER BY expressions must appear in select list - error when migrating from Oracle to Postgres

I'm in the process of migrating our database from Oracle to Postgres. We have a number of hardcoded queries in our spring boot application that now break as res

Concat rows based on condition [duplicate]

I'm working with a table that has values like this ID Name Value 123 Size 1 123 Size 2 123 Size 3 123 Type Shoes 234 Size 6 234 Size 7 234 Ty

Postgres order civic numbers by digits and letters

I've two columns in text format containing street names and civic numbers. I'd like to set a query to order rows by street name and then by digits and by charac

SQL comparison matching ORDER BY

When one orders results by multiple columns the database has to do something to compare NULL values (e.g. order them first last). But how can I replicate that

Postgres Citus, immutable date conversion

Trying to update some dates programmatically on Citus I always get [0A000] ERROR: STABLE functions used in UPDATE queries cannot be called with column reference

copying a table across servers with psycopg3

I'm working from and example in the psycopg3 documentation to copy a table from one database to another: link dsn_src = 'postgresql:///dev_db' dsn_tgt = 'postgr

PostgreSQL version compatible with Windows 7 32 bit

I have tried to install PostgreSQL 10.6 on Win 7 SP1 32 bit and I got following error after trying to run pgadmin4: "postgresql application server could not be

Django web site URLS gets "?next=" randomly after deployed to heroku

After deploying django app on heroku the url after every form submission or link in site been press resulting with "?next=" inserts into the URL address, I don'