Data dodania Pytanie
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
2017-06-14 15:06 postgres functions / extensions not dumped or restored correctly? »
Update Self-answered, see first comment here and my own answer. Original question I'm setting up a local development postgres db with some sql file...
(2) odpowiedzi
2017-06-14 14:06 Postgresql 9.4 - Invalid input syntax when converting to JSONB »
I've made a simple function to update a jsonb with new values: CREATE OR REPLACE FUNCTION jsonupdate( IN "pJson" jsonb, IN "pNewValues" jsonb) ...
(1) odpowiedzi
2017-06-13 20:06 problems with stackdriver monioring postgresql on a GCE »
I installed Stackdriver on a Google Compute Engine (ubuntu) and tried to configure it to monitor the postgresql service installed in that instance. T...
(1) odpowiedzi
2017-06-13 17:06 Changing postgresql start menu location »
As part of an installer that I'm working on, I need to change the default start menu location for the postgresql installation. We're packaging a postg...
(0) odpowiedzi
2017-06-13 11:06 Shell script to monitor postgresql database status and alerts »
I need postgresql shell script to alert me if database is goes down. ...
(1) odpowiedzi
2017-06-12 16:06 PostgreSQL: SELECT * from table WHERE timestamp IS WITHIN THIS MONTH »
For some reason I'm kind of lost on how to archive: SELECT * FROM table WHERE timestamp IS WITHIN THIS MONTH; I've looked at https://www.postgresql...
(2) odpowiedzi
2017-06-12 09:06 postgresql table data movement »
In PostgreSQL i want to create script which can delete old data of before 1 month from A table(which contain many rows) and insert this data into one ...
(2) odpowiedzi
2017-06-12 05:06 Postgresql user defined c function issues »
I have installed postgresql in my ubuntu 14.04 with apt-get command.. postgresql 9.4 libpg 9.4.8 I want to add a user defined c function for dynamic l...
(1) odpowiedzi
2017-06-09 14:06 How to query NOT EXISTS on the same table? »
How to query NOT EXISTS on the same table? I need to create the select to be able to perform the insert with the results. The idea is to only insert ...
(0) odpowiedzi
2017-06-07 19:06 Map column value to table name and join »
I have a composite type that looks like CREATE TYPE member AS ( id BIGINT, type CHAR(1) ); I have a table that relies on this member type w...
(1) odpowiedzi
2017-06-07 14:06 How to get a preview for an image using postgresql? »
I'm using image tables in my database. I want to create a preview for the fetched image using PostgreSQL query. What is the syntax for creating a pre...
(0) odpowiedzi
2017-06-07 11:06 Integration of Jasper Reports with odoo 9 on Google cloud platform »
I have deployed odoo 9 Community version on Google Cloud Platform now i want to integrate Jasper Reports with odoo for BI Reporting i am trying from m...
(0) odpowiedzi
2017-06-06 20:06 EFM - There is already a master node in this cluster »
I am unable to bring up the EFM cluster that I have (managing my postgres DB). 172.29.225.67 Witness 172.29.225.81 Master 172.29.225.82 StandBy I a...
(0) odpowiedzi
2017-06-06 17:06 EFM - FATAL: password authentication failed for user "efm" »
I am currently using EFM to monitor my Postgres cluster. My EFM (Master/StandBy/Wintess) nodes were working perfectly fine until we did a VM migratio...
(0) odpowiedzi
2017-06-01 19:06 postgres is running, but I am not able to uninstall it »
So I originally downloaded PostgreSQL 9.4.10-1. The problem is I am trying to use Vagrant and Virtual Box, however Vagrant defaults to using port 5432...
(0) odpowiedzi
2017-05-31 17:05 Postgres resource usage stats and configs »
I'm using postgres server 9.4. From pg_admin or psql tool, I can do SHOW ALL; this will give me the config of postgres server. For example shared_bu...
(1) odpowiedzi
2017-05-29 20:05 real-time sync between local Postgres instance and Azure Cloud Postgres instance »
I need to set up real time sync process between a on premise postgresql instance with cloud postgresql instance. Please let me know what are all the o...
(1) odpowiedzi
2017-05-29 10:05 How can I reconnect a new PGRS server to an old local database? »
I had to upgrade my OS hard drive and lost my OSX installation and applications. I've recovered almost completely but the very large installation of c...
(0) odpowiedzi
2017-05-25 05:05 How to install oracle_fdw extension in postgresql 9.4 »
I'm trying to installing oracle_fdw packages in postgres 9.4. But it is throwing the exception below. Error: /home/ramesh/Downloads/oracle_fdw-1.2.0...
(0) odpowiedzi
2017-05-24 17:05 Postgres select where in json array containing json »
I have a table in a postgresql 9.4 database with a jsonb field. Some example rows: [{"name": "145119603", "numberOfCarrot": 2}] [{"name": "188459553...
(1) odpowiedzi
2017-05-24 16:05 How to get sub query columns in main query with WHERE EXISTS in PostgreSQL? »
I am stuck with a query which takes more time in JOIN, I want to use WHERE EXISTS in place of JOIN since as performance wise EXISTS takes less time th...
(0) odpowiedzi
2017-05-23 19:05 Casting in Postgres `where` not working as expected when using `!=` »
I have two columns in Postgres that I need to compare in a where. The column datatypes, however, are different. One is text and the other int. I'm try...
(2) odpowiedzi
2017-05-22 19:05 Update with inner join Postgresql »
Because doing this update does not work for the where clause? The update does it for me all. UPDATE ventas SET eav_id = 7 FROM ventas AS A inner joi...
(2) odpowiedzi
2017-05-22 19:05 Serialize/Deserialize list of POJOs using Jackson to/from JSONB column - Postgres 9.4 »
I have created a custom UserType for my class and want to map the list of POJOs to JSONB column in the database. Added JSONB column to my table A...
(0) odpowiedzi
2017-05-22 11:05 postgres trigger creates index: BEFORE INSERT ON hides one row »
I have a trigger AFTER INSERT ON mytable that calls a function CREATE OR REPLACE FUNCTION myfunction() RETURNS trigger AS $BODY$ DECLARE ...
(1) odpowiedzi
2017-05-17 19:05 Pass array of tags to a plpgsql function and use it in WHERE condition »
I'd like to create a function that returns items based on their tags. However, I do not know how to format an array in the IN() clause. I believe that...
(3) odpowiedzi
2017-05-17 18:05 Disable stemming for specific words with Postgres Full Text Search »
With Postgres full text search I'm using the default english dictionary, which mostly works for our purposes but there are a few cases where stemming ...
(0) odpowiedzi