Data dodania Pytanie
2017-07-27 20:07 Spring JPA Sorting and Paging with PostgreSQL JSONB »
I am using Spring JPA in order to manage my PostgreSQL data. This data makes heavy use of the jsonb data type in PostgreSQL 9.4. My table (called job...
(0) odpowiedzi
2017-07-25 18:07 psycopg2 kills query after 3 minutes »
I am using psycopg2 version 2.6.1, whenever I run a query to a remote server, if its less than 3 minutes it will run perfectly, but if it runs for mor...
(0) odpowiedzi
2017-07-24 19:07 Custom query on sequelize seeder »
Any one know how to custom select query on sequelize seeder I have tried two ways, but no one work First attempt up: function(queryInterface, Seq...
(1) odpowiedzi
2017-07-23 16:07 What should I do with my pg_log? »
I have two database server, one for main usage and the second is for standby. The log file is being recorded every day. About last week, when I found ...
(1) odpowiedzi
2017-07-22 01:07 Postgres 9.4.12 Slow queries »
I'm having slow queries with my postgres in a table with 9 million rows. Query: EXPLAIN (ANALYZE, BUFFERS) SELECT date_point, geo, alarms, status FRO...
(1) odpowiedzi
2017-07-21 11:07 postgres, create database from template on external server »
I have two servers with same version of postgres(9.4). I would like to make fast clone database (backup and restore). As i understand "create database...
(2) odpowiedzi
2017-07-20 01:07 Return first entry in table for every row given a specifc column sort order »
I have a table with three columns, hostname, address, and virtual. The address column is unique, but a host can have up to two address entries, one vi...
(2) odpowiedzi
2017-07-18 21:07 How to match Object field with String in in Django template? »
Initially, when I am saving this 'status' field in database it is (=models.CharField(max_length=200)) So, Now When I am trying to get this data in HT...
(0) odpowiedzi
2017-07-18 17:07 Expand a jsonb array proprietie »
By selecting from a jsonb field in a pg3 database, i'm getting results like this one: res text ["card", "dog", "chair"] ["house", ] ...
(0) odpowiedzi
2017-07-18 13:07 get till end of string after first space »
I need to split a string as follows, when I try with with split_part no luck select split_part('8 HAMPSHIRE RD',' ',2) Expected output: HAMPS...
(2) odpowiedzi
2017-07-17 12:07 sequelize include returns only one result »
I have a Users table and a Groups table, when I retrieve a single user, I want to get a list of all the groups that user belongs to. I created a joins...
(1) odpowiedzi
2017-07-14 17:07 how to get multiple rows as a parameter - postgresql »
In Postgresql,I have a problem to insert json record into table. [{"cls_id":54,"ins_count":57,"dbase_id":1,"select_db":[1],"total_count":1}, {"cls_id...
(0) odpowiedzi
2017-07-14 04:07 Postgres 9.4 sql query timeout »
Below query times out after adding these two lines or any single one of it AND final IS NOT NULL ORDER BY tmodified ASC Query keeps running more t...
(2) odpowiedzi
2017-07-13 20:07 "duplicate key value violates unique constraint" despite existence check »
On PostgreSQL 9.4. I was surprised to see that error in our server logs, pinpointed to the sole statement inside a pl/pgsql function: CREATE OR REPL...
(1) odpowiedzi
2017-07-12 09:07 pg_dump: aborting because of server version mismatch »
I am running ubuntu 14.04. while backing up a database on postgreSQL i am following error: /usr/bin/pg_dump --host 127.0.0.1 --port 5432 --username "...
(1) odpowiedzi
2017-07-12 06:07 RR MILLENNIUM equivalent in Postgres »
Is there a built in function in PostgreSQL 9.5 version to calculate the appropriate century/millenium? When I use birth_date::TIMESTAMP from a table,...
(1) odpowiedzi
2017-07-11 15:07 EF postgre check if database exists »
With the Entity Frameworks' DbConetxt I am trying to check if the database exists with the query below. public async Task<bool> CheckIfExistsAs...
(1) odpowiedzi
2017-07-10 19:07 Efficiently join tables by expression »
I apologize for the vague question, I'm not entirely sure how to convery what I am wondering. Let's say I want to find all values in table t1 that ca...
(0) odpowiedzi
2017-07-10 10:07 Delete a record if the associated Join entry does not exist »
I'm trying to delete a record from a table if the parent table record does not exist. The table in question are merchants and merchant_configuration...
(2) odpowiedzi
2017-07-07 22:07 Users can't search on DSpace after log in (Upgrade DSpace 6.0) »
We have migrated from DSpace 4.1 to DSpace 6.0 and after the migration, our users (excepts Admins) can't search, see items, collections, communities. ...
(0) odpowiedzi
2017-07-07 20:07 Psycopg2 copy command vs Pandas DFto SQL for a list of dictionaries in Python »
I want to insert a list of dictionaries from python to Postgres. I dont want to split dictionary anyways so think as json column. I have two options...
(0) odpowiedzi
2017-07-07 10:07 PostgreSQl pg_dump permission error? »
Why a postgresql pg_dump not permitted with sudo which is producing permission denied error? Even root user is unable to pg_dump? ...
(1) odpowiedzi
2017-07-06 18:07 How avoid the scan in the main table »
I have a table partitioned using inherit in multiple tables for days. There is one insert trigger to insert the data to the proper table, so in the...
(1) odpowiedzi
2017-07-06 11:07 How can i get the logs of past months in postgres DB . »
Issue : Someone has added a junk column in one of my table.I want to figure it out from the logs as when and from where this activity has been perfo...
(1) odpowiedzi
2017-07-05 18:07 psycopg2 change schema does not work »
I am writing a simple python prog to connect and display results from Postgres table this is on AWS RDS. I have table mytest in public schema. connec...
(1) odpowiedzi
2017-07-05 10:07 How to split string then compare it to fill id's in relation? »
I have 2 Tables: Molecule containing : -id -MainName (ex: caffeine) JsonTextMining containing : -id -solrId (ex: PMC54233) -MoleculeName (ex...
(1) odpowiedzi
2017-07-02 11:07 Postgres return array from stored function »
I am trying to return array from stored function and use it's output in a where clause , for a query. But it is not working for unknown reason. I real...
(1) odpowiedzi
2017-07-01 11:07 Postgresql jsonb column joins across two table first one is object and second one is array of objects »
I'm trying to do following thing,I lost some days working on this... I think following code snippets are enough in order to understand the issue, if n...
(0) odpowiedzi
2017-06-30 21:06 WAL file is from different database system »
Am using WAL E and trying to restore a postgresql database i get the error WAL file is from different database system: WAL file database syste...
(1) odpowiedzi
2017-06-30 07:06 How to encrypt date in postgresql »
I need to encrypt date column in postgresql. for String am using like below select encode(encrypt('foo', '0123456789012345678901', 'bf'), 'hex'); ...
(2) odpowiedzi
2017-06-29 23:06 How does the SessionFactory connection work with pgbouncer pool? »
We have a large simulation that is developed in java and each run of this simulation is a jar being run on a node in a grid. Typically ~3 thousand job...
(0) odpowiedzi
2017-06-28 19:06 PostgresSQL connection issue »
I am new to PostgreSQL and I am trying to create a connection but I dont know for some reason my connection is not being established. At first it sa...
(0) odpowiedzi
2017-06-27 19:06 java.sql.SQLException: No suitable driver - PostgreSQL jdbc driver »
Edit 3: Fix following the Spark 2.1.1 documentation Solution: #Spark 2.1.1 version main.py from pyspark.sql import SparkSession fro...
(0) odpowiedzi
2017-06-26 13:06 SQL query executed through Windows batch: missing table »
I execute a SQL query (for PostgreSQL) via psql.exe inside a Windows batch. I get an error I can't explain, saying that a FROM clause is missing for a...
(1) odpowiedzi
2017-06-26 08:06 Specifying columns that have to be ignored in the result data »
I have a CTE that returns the following table: m_ids |gp_id |id |m_id |id |type|id |type|qty|... ------|------|---|-----|---|----|---|----|---|--- ...
(1) odpowiedzi