postgresql Archives - Page 6 of 21

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

Programming, sql

IT Nursery

Postgres unique constraint vs index

As I can understand documentation the following definitions are equivalent: create table foo ( id serial primary key, code integer, label text, constraint ...

May 27, 2022
0 Comments

Programming, sql

IT Nursery

ERROR: there is no unique constraint matching given keys for referenced table “bar”

Trying to create this example table structure in Postgres 9.1: CREATE TABLE foo ( name VARCHAR(256) PRIMARY KEY ); CREATE TABLE bar ( ...

May 27, 2022
0 Comments

Programming, sql

IT Nursery

Select rows which are not present in other table

I’ve got two postgresql tables: table name column names ----------- ------------------------ login_log ip | etc. ip_location ip | location | hostname | etc. ...

May 27, 2022
0 Comments

postgresql, Programming

IT Nursery

Get PostGIS version

How can I find out which version of PostGIS I have? 7 Answers 7

May 26, 2022
0 Comments

How to upgrade PostgreSQL from version 9.6 to version 10.1 without losing data? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, ...

May 26, 2022
0 Comments

What is the difference between LATERAL JOIN and a subquery in PostgreSQL?

Since Postgres came out with the ability to do LATERAL joins, I’ve been reading up on it, since I currently do complex data ...

May 26, 2022
0 Comments

django test app error – Got an error creating the test database: permission denied to create database

When I try to test any app with command (I noticed it when I tried to deploy myproject using fabric, which uses this ...

May 25, 2022
0 Comments

How to create user for a db in postgresql? [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for ...

May 25, 2022
0 Comments

Using current time in UTC as default value in PostgreSQL

I have a column of the TIMESTAMP WITHOUT TIME ZONE type and would like to have that default to the current time in ...

May 25, 2022
0 Comments