Data dodania Pytanie
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
2017-06-25 19:06 Uniting data into one row »
I have the following data: materials ========================== id | quantity |type ---------+----------+----- 1 |111 |1 2 ...
(2) odpowiedzi
2017-06-24 16:06 Create Extension in PostgreSQL 9.4 »
I am getting following error while creating extension in PostgreSQL 9.4. could not load library "C:/Program Files/PostgreSQL/9.4/lib/pltcl.dll": The s...
(0) odpowiedzi
2017-06-24 15:06 postgres function : copy from txt file to database »
I found below function which copy data from csv to Postgres, it also creates table dynamically from csv, I want similar function but it should do for ...
(2) odpowiedzi
2017-06-23 14:06 How to collect warnings/notices while JDBC statement is being executed? »
I am experiencing an issue with the latest version of PostgreSQL JDBC driver: I can not collect warnings/notices while the prepared statement is still...
(0) odpowiedzi
2017-06-23 11:06 Iterating over groups in table »
I have the following data: cte1 =========================== m_ids |p_id |level ---------|-----------|----- {123} |98 |1 {123} ...
(1) odpowiedzi
2017-06-23 08:06 Iterating over the table with recursive query »
I have the following data: cte1 ================= gp_id | m_ids ------|---------- 1 | {123} 2 | {432,222} 3 | {123,222} And a function ...
(1) odpowiedzi
2017-06-22 13:06 Handling multiple return values in subquery »
I have the following data: cte ================= gp_id | m_ids ------|---------- 1 | {123} 2 | {432,222} 3 | {123,222} And a function w...
(1) odpowiedzi
2017-06-22 10:06 Multiple case statement for grouping values 0-9, 10.20 »
I have this first case statement below which I need to merge with the case statement below this for grouping values together like this: days range ...
(1) odpowiedzi
2017-06-22 09:06 Aggregating data by column in array »
Let's say I have the following data: gp_id | p_id ------|------- 1 | 123 2 | 432 2 | 222 For the purposes of business logic I have to t...
(2) odpowiedzi
2017-06-20 09:06 postgresql settings to speed up Pentaho reports »
I am preparing new pentaho server in my company and I was thinking how could I make my postgres run faster. The only option I am using so far is incre...
(0) odpowiedzi
2017-06-19 15:06 SQL SUM and GROUP BY based on WHERE clause »
I'm running PostgreSQL 9.4 and have the following table structure for invoicing: id BIGINT, time UNIX_TIMESTAMP, customer TEXT, amount BIGINT, status...
(2) odpowiedzi
2017-06-19 11:06 How to convert below query from Oracle to Postgres having connect by? »
I am converting my application DB from oracle to postgres. I am stuck on a function having connect by syntax. Below is the Oracle query. PROCEDURE Ge...
(2) odpowiedzi
2017-06-18 23:06 Rails 4.2 -- Reuse polymorphic association but not its unique index? »
I'm new to Rails and extending an existing application. I want to reuse a polymorphic association and all its views, but I don't want to reuse its dat...
(0) odpowiedzi
2017-06-17 00:06 PostgreSQL ETL to SQL Server 2014 using SSIS »
I have a package that uses an odbc connection to retrieve data from a PostgreSQL table and then I sort it and perform a outer merge join so I can brin...
(0) odpowiedzi
2017-06-16 16:06 python 3.5 selecting and using results from postgres database »
I need to write a program which can,firstly, for ip adresses of people who saw my campaign on google, and then give me detailed information about each...
(2) odpowiedzi
2017-06-15 12:06 FULL OUTER JOIN to merge tables with PostgreSQL »
Following this post, I still have an issue when I apply the answer given by @Vao Tsun to a bigger dataset made this time of 4 tables instead of 2 tabl...
(3) odpowiedzi
2017-06-15 10:06 Merge tables with PostgreSQL »
The title of this question is not accurate but I didn't know how to summarize it. Please feel free to write it again if you can! Here is an extract o...
(1) odpowiedzi
2017-06-14 19:06 POSTGRESQL - ERROR: could not load library pgafis.so : undefined symbol: lfsparms_V2 »
I'm using PGAFIS library for fingerprint matching. For this i have installed postgresql and having some user defined c functions. PGAFIS contain make...
(1) odpowiedzi