Data dodania Pytanie
2017-10-29 09:10 How to make unit tests on local and on build server using postgres? »
I'm tyring to make unit tests for my node application. I'm using a postgresql database for the development and SQLite for the tests. However Sqlite do...
(1) odpowiedzi
2017-10-28 10:10 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42601]: »
I am new to postgresql/postgis and am unable to solve this problem. I have lat long values which I retrieve by the click event and split using lonla...
(1) odpowiedzi
2017-10-27 23:10 Restore postgresql 9.4 database in C # »
I created a .bat to perform the restoration of a database in PostgreSQL and it worked perfectly using the following command: set PGPASSWORD=postgres1...
(0) odpowiedzi
2017-10-27 22:10 How to tell if a table has been used in Postgres (9.4) »
I am using Postgres 9.4 and I am doing some table clean-up. Specifically I need to do the clean-up to free up some hard disk space so I am looking at...
(0) odpowiedzi
2017-10-25 12:10 how to load postgresql schema into spark-sql »
I am working with spark-sql and trying to load entire postgres database tables schema into spark-sql so that from there i can perform computations on ...
(0) odpowiedzi
2017-10-24 12:10 How to differenciate (and format) "empty" text fields »
Recently end users have started to notice explicit simple quotes couples ('') on empty fields. I have no idea what would have caused that, and was not...
(1) odpowiedzi
2017-10-24 12:10 QSqlrelationalTableModel.SubmitAll() returns an error »
I'm working on postgreSQL 9.5, QT4 and Python2. I've brought data from a PostgreSQL query to a QTableView with this code : self.nomtable = resultQue...
(0) odpowiedzi
2017-10-21 08:10 Postgres PSQL Import file from certain location »
I have my dump file of DB Dump via psql, I want to import it to my windows Postgres via PSQL from a certain location. However when I try the following...
(0) odpowiedzi
2017-10-19 11:10 Postgres_fdw LEFT JOIN with foreign table »
I have this base query and execution time around 400ms: SELECT s.parcelno FROM export.scans s INNER JOIN plnum_customerno cp ON cp.pl_number = s....
(0) odpowiedzi
2017-10-18 23:10 split_part function from nth split till end of string »
After the second space, I need to fetch the values till the particular position in the string. Source: "8 115 MACKIE STREET VICTORIA PARK WA 6100 AU...
(1) odpowiedzi
2017-10-17 08:10 PostgreSQL- fetching record without using column name »
How could I fetch record returns from the query executed by the cursor without using column name? As I don't know what all columns will be returned. I...
(0) odpowiedzi
2017-10-16 23:10 Postgresql jsonb multiple lateral joins »
I'm very new to postgresql jsonb and am trying to setup a query without having to have multiple subqueries as I want this to be readable as much as po...
(0) odpowiedzi
2017-10-15 09:10 how to apply split_part function from end of string in postgres »
I want to split the below string (present in a single column) separated by spaces from the end. For the below 3 rows, I want the following output OUT...
(1) odpowiedzi
2017-10-14 18:10 retrieving data from jsonb column in postgresql DB functions as an array, return empty result »
I have table users in a postgresql DB, The table contains a column settings of type jsonb. and here it is the json format: { "device": { "352fe...
(1) odpowiedzi
2017-10-12 07:10 Find last inserted record - Postgresql »
The database structure is not optimally constructed, so this is about getting the best out of the current condition. I just want to find the last in...
(1) odpowiedzi
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