Data dodania Pytanie
2017-10-11 18:10 PostgreSQL Materialized View Refresh "stacking" »
Version: 9.4.10 Do requests to refresh a materialized view stack? Ex: I have a materialized view which refreshes concurrently based off of an INSERT/...
(1) odpowiedzi
2017-10-10 17:10 Postgresql equivalent to sp_MSforeachdb »
I am working in a complex PostgreSQL 9.4 environment, and I need to run the equivalent of the command below using pgAdmin III exec sp_MSforeachdb 'SE...
(0) odpowiedzi
2017-10-10 11:10 How to have SQL query with 2 subqueries divided »
I have a database which has these tables: Users (id, email) Trips (id, driver_id) MatchedTrips (id, trip_id) I need to get for each user the total...
(2) odpowiedzi
2017-10-10 07:10 How to append object in postgresql jsonb field while update »
I want to update my jsonb field it store array of object. i want to add new object in it. CREATE TABLE justjson ( id INTEGER, doc JSONB); INSERT INTO...
(1) odpowiedzi
2017-10-06 19:10 Getting a ComSpec error when trying to install Postgres 9.4? »
when I try to install Postgres on my Windows 10 machine it has an error saying that the environment variable COMSPEC does not point to cmd.exe. image...
(0) odpowiedzi
2017-10-06 00:10 Hibernate 3.3 and Postgres 9.4 »
I have a project, where I have to use Postgres 9.6, having Hibernate 3.3 in legacy code. The bestchoice for me is NOT to upgrade hibernate, but since ...
(0) odpowiedzi
2017-10-05 08:10 Postgres select highest of ordered settings with default (sql fiddle) »
Say I have a few settings scoped to users, but always having a default (when user_id is NULL): settings: name | value | user_id | confirmed __...
(2) odpowiedzi
2017-10-04 14:10 Get second last row for every record in postgresql query »
I had table lets say table_inventory. On the table_inventory i put a trigger for every update of stock insert new row in audit_inventory table: table...
(1) odpowiedzi
2017-10-04 09:10 How to do global exception handler in postgres? »
I have search exception handler in postgres it says to add DECLARE text_var1 text; text_var2 text; text_var3 text; BEGIN -- some processing ...
(1) odpowiedzi
2017-10-04 03:10 Postgres conditional unique constraint without select »
I have the following table: Cars: id, name, status I want to enforce a conditional constraint on the car's name as soon as we have a record for that...
(1) odpowiedzi
2017-10-03 12:10 Postgresql,multiXact member wraparound protections are now enabled »
I'm using postgresql 9.4.8 . In pg_log, i found a statement like, LOG: MultiXact member wraparound protections are now enabled. I can't find w...
(1) odpowiedzi
2017-10-02 18:10 Postgresql 9.4 Cascading replication failover »
Environment: Ubuntu14.04 + Postgresql9.4. The following is my setup: ('->' denotes physical streaming replication PSR) Master1 -> Slave1 (prima...
(1) odpowiedzi
2017-10-02 11:10 pg_dump with dbname - invalid port number? »
When using the dbname parameter with pg_dump.exe, I get the following error: Error: pg_dump: [archiver (db)] connection to database "my_database"...
(1) odpowiedzi
2017-09-29 12:09 I have data duplicates when I try to import data from database Access to my database Postgresql, by c++ code »
In my code I use a simple INSERT after take data by database access This is my function where I create a query INSERT. When I open the table in pgadmi...
(0) odpowiedzi
2017-09-28 16:09 Postgres - Missing FROM-clause entry for table »rowtype« »
I am currently writing a function in the plpgsql language to create partitions which will hold sensor data for each month (one partition for one month...
(0) odpowiedzi
2017-09-28 12:09 Sql function or bash script to get the memory usage of each query in postgres »
How to get memory usage and cpu utilization of of each query in postgres, I'm wondering if there is any sql function or script for the same ...
(1) odpowiedzi
2017-09-25 15:09 Force GIN index scan in postgresql 9.4 »
I'm having a table of locations(29 million rows approx) Table "public.locations" Column | Type| Modifiers ------------------------------------+...
(1) odpowiedzi
2017-09-20 13:09 Insert Rows in the Database which should be conditional if exist then update value else insert »
I have function where I insert rows in mapping table without any validation but I am facing an issue that if the value already exist in the database, ...
(0) odpowiedzi
2017-09-19 08:09 How to Store List of Java Objects/Json into Postgres Jsonb using JPA? »
How do we define List of objects into postgres 9.6 jsonb data type using JPA? I'm trying to put list of products into order table's products column wh...
(0) odpowiedzi
2017-09-19 07:09 Retrieving file data from database »
I am trying to get file data from database to HTML using a Java servlet. The file data is in binary format. I am converting binary format data to stri...
(1) odpowiedzi
2017-09-19 00:09 PostgreSQL: How to write a query for this schenario »
I have this below table. +_______+________+__________+________+ |Playid |billid| amount | Date | +_______+________+__________+________+ |123 ...
(2) odpowiedzi
2017-09-18 11:09 How to query PostgreSQL nested JSONB in deeper level? »
I'm new to JSON/JSONB datatypes and I'm having some problems selecting the JSONB elements from deeper levels. Here is an example table: CREATE TABLE...
(1) odpowiedzi
2017-09-15 09:09 Speed up search for date with subrecords recent date (postgresql) »
I want to find old jobs that is still open with no recent activity. The tables are as following: CREATE TABLE job (jobid int4, jobname text, job...
(2) odpowiedzi
2017-09-13 06:09 Write a shell script for importing file CSV files into a postgres table »
We are using Postgres 9.4. Following is the requirement. Can Anyone share me the shell script for importing CSV files into a table. Which ever CSV f...
(1) odpowiedzi
2017-09-13 06:09 Unable to pass arguments in crosstab function postgres »
I know that I have to pass text to crosstab function in postgres. But somehow I am unable to do it. I am not sure what am I doing wrong please Help. T...
(1) odpowiedzi
2017-09-12 16:09 Postgresql select 5 rows even if there is 3 row of data »
How to Select 5 row even if there is 3 row of data and next 2 row should be empty row. ...
(2) odpowiedzi
2017-09-12 16:09 Alternative for EXTERNAL TABLES in PostgreSQL »
I'm having a question in external table concept in PostgreSQL. I'm using Enterprise version (EDB). CREATE OR REPLACE DIRECTORY bdump AS '/u01/app/ora...
(0) odpowiedzi
2017-09-12 14:09 restrict the number of connections in postgres using an ip address »
Is it possible to restrict the number of connections in postgres, using the ip address of machine, since i'm not able to find which ip address is tagg...
(1) odpowiedzi
2017-09-11 15:09 json error when pass it from php to javascript »
When i retrieve data from table with json field then it comes as text. And i store it to an object property by PHP. My problem is when i call that obj...
(0) odpowiedzi
2017-09-11 13:09 Nested Filration not working in postgres query »
This is my json which is stored in postgres table with json type {"layer_name":"rooms","properties":{"fillOpacity":1,"strokeColor":"#606576","id":"WK...
(0) odpowiedzi
2017-09-10 20:09 postgres - insert gen_random_uuid() for the column "key" if the count(key) < 1 »
Generate gen_random_uuid() for the column key if there count(key) < 1 My table name is keytable and column is key. I am using the below insert st...
(2) odpowiedzi
2017-09-09 10:09 java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null' for Postgres database »
I am using JNDI datasource to connect to Postgres database. This is the code to of my ServletContextListener public void contextInitialized(ServletCo...
(0) odpowiedzi
2017-09-07 15:09 The table column "id" cannot auto-generate although I use @SequenceGenerator and @GeneratedValue »
I use postgreSQL and Spring Boot. Here is part of my java code.: @Entity @Table(catalog = "postgres2", name = "user_info") @SequenceGenerator(name = ...
(0) odpowiedzi
2017-09-07 10:09 How to embed postgres database with a application »
I am looking for a way to ship my java application with its embedded postgres database like H2/SQLite. Application is quite complex and its carry ove...
(0) odpowiedzi
2017-09-06 14:09 Postgres - How to create an alphanumeric sequence like AAAA0000 and so on »
I want to create an alphanumeric sequence like this: AAAA0000 AAAA0001 AAAA0002 AAAA0003 . . . AAAA9999 AAAB0000 AAAB0001 and so on I have create...
(1) odpowiedzi