postgresql Archives - Page 2 of 9

postgresql, Programming

IT Nursery

PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values

When you are upserting a row (PostgreSQL >= 9.5), and you want the possible INSERT to be exactly the same as the possible ...

May 31, 2022
0 Comments

postgresql, Programming

IT Nursery

Why does PostgreSQL perform sequential scan on indexed column?

Very simple example – one table, one index, one query: CREATE TABLE book ( id bigserial NOT NULL, "year" integer, -- other columns... ...

May 30, 2022
0 Comments

postgresql, Programming

IT Nursery

PostgreSQL ERROR: canceling statement due to conflict with recovery

I’m getting the following error when running a query on a PostgreSQL db in standby mode. The query that causes the error works ...

May 29, 2022
0 Comments

postgresql, Programming

IT Nursery

How to perform update operations on columns of type JSONB in Postgres 9.4

Looking through the documentation for the Postgres 9.4 datatype JSONB, it is not immediately obvious to me how to do updates on JSONB ...

May 29, 2022
0 Comments

postgresql, Programming

IT Nursery

How to add “on delete cascade” constraints?

In PostgreSQL 8 is it possible to add ON DELETE CASCADES to the both foreign keys in the following table without dropping the ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

How to display the function, procedure, triggers source code in postgresql?

How to print functions and triggers sourcecode in postgresql? please let me know if any one know the query to display the function, ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

Find the host name and port using PSQL commands

I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to find the ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

psql: FATAL: Peer authentication failed for user “dev”

when i create a new user, but it cannot login the database. I do that like this: postgres@Aspire:/home/XXX$ createuser dev Shall the new ...

May 28, 2022
0 Comments

postgresql, Programming

IT Nursery

How to see the CREATE VIEW code for a view in PostgreSQL?

Is there an easy way to see the code used to create a view using the PostgreSQL command-line client? Something like the SHOW ...

May 27, 2022
0 Comments

postgresql, Programming

IT Nursery

PSQLException: current transaction is aborted, commands ignored until end of transaction block

I am seeing the following (truncated) stacktrace in the server.log file of JBoss 7.1.1 Final: Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, ...

May 27, 2022
0 Comments