Data dodania Pytanie
2017-09-05 00:09 ERROR: more than one row returned by a subquery used as an expression »
I am doing an example from the pgrouting a Practical Guide book but with my own tables and I have run into this error. I have used LIMIT 1 to avoid th...
(1) odpowiedzi
2017-09-04 22:09 Postgres Group and order by range (specific values) »
I have a table like this: id simcard simcard_order 80769 56407503370245588410 1 80788 66329183922439284822 2 80803 209...
(1) odpowiedzi
2017-09-01 18:09 Why does vacuum analyze change query plan while analyze does not? »
I wanted to utilize the power of index-only scans in Postgres and experimented with one table: CREATE TABLE dest.contexts ( id integer NOT NULL, ...
(0) odpowiedzi
2017-08-31 20:08 Comprehending ALTER DEFAULT PRIVILEGES »
I have reviewed this well-asked and answered PG permission question, and I use it as a starting point for my question: https://dba.stackexchange.com/q...
(1) odpowiedzi
2017-08-31 13:08 Get the row with the max value in sql »
I want to get the row with the maximum value on a column. I my case I want to ptint only X that has 31. This is my code and also the output. create t...
(2) odpowiedzi
2017-08-30 20:08 Why can 'create table' in Postgres take several seconds? »
In my project we have to sometimes copy all the data from one schema into another. I automated this by simple truncate / insert into select * script, ...
(0) odpowiedzi
2017-08-30 16:08 Check if data has a default length and it's numeric in sql »
In my table I have a column that is a code of 6 digits. myCode CHAR(6) PRIMARY KEY CHECK ( SUBSTRING ( myCode ,1 ,1) >='0' AND SUBSTRING ( myCode...
(2) odpowiedzi
2017-08-29 12:08 PostgreSQL query to find total number of objects and its count »
i need to check number of object inside PostgreSQL database and its count.so please tell me query to count total number of object and its count. ...
(0) odpowiedzi
2017-08-29 07:08 Not connecting to database through java »
Actually I am trying to insert values from java servlet to postgres DB but they are not inserting. Thanks in advance. My html page is <div class=...
(0) odpowiedzi
2017-08-28 12:08 PostgreSQL 9.5 installation using ./configure and using installer and yum difference »
I want to know difference between PostgreSQL installation types ./configure and using run installer and yum installation? ...
(0) odpowiedzi
2017-08-28 03:08 error postgresql 9.4 when dumping data »
I have error like at the picture when I dump the data. I change ssl_renegotiation_limit=0 but I have same error. I have error pg_dump: Dumping th...
(0) odpowiedzi
2017-08-27 21:08 POSTGRESQL ERROR:more than one row returned by a subquery used as an expression »
SELECT (SELECT vch_message FROM TABLE1 WHERE vch_message like 'DONE%' ) as Status, (SELECT vch_Type FROM TABLE2 WHERE...
(1) odpowiedzi
2017-08-26 18:08 Cannot create temporary table in view definition PostgreSQL »
CREATE VIEW viewRebalancingLog AS CREATE TEMP TABLE newSessionID ( ilog_id INT,vch_service_name VARCHAR(200), vch_service_id VARCHAR(200),iuser...
(1) odpowiedzi
2017-08-25 19:08 Postgres BDR - ALTER COLUMN TYPE works on some nodes but not on others »
I have a BDR group with 4 nodes. I'm having problems applying a DDL command to change the type of a column in a table that is not a member of any repl...
(0) odpowiedzi
2017-08-24 13:08 Want to create user defined aggregate function in postgressql »
I want to create an aggregate function which will return same value which is passed to it mostly int or bigint type of value. The purpose for doing t...
(0) odpowiedzi
2017-08-24 08:08 Postgresql, get value for Index[0] in select command »
I am struggling with a Postgresql query. Please refer to the image uploaded with this post. I am not getting any value at Index[0] for a float[] typ...
(0) odpowiedzi
2017-08-23 17:08 Where is bdr.remove_bdr_from_local_node()? »
I'm trying to remove a node from a PostgreSQL-BDR group. The documentation says to use remove_bdr_from_local_node. It's documented, but missing. ht...
(0) odpowiedzi
2017-08-23 11:08 Group by specific column in postgressql »
I trying to get a count of person depending on the org_id. Let's say I have 10 people in my people coming in from different organization. I want to ...
(2) odpowiedzi
2017-08-23 08:08 Multiple database backup using pg_dump »
Is it possible to backup multiple databases with a single pg_dump command, instead of running a pg_dump command for each database ...
(0) odpowiedzi
2017-08-19 15:08 PostgreSQL JSONB versus keeping a separate table »
I'm thinking through a database design and I was wondering if anyone could chime in. I have some structured data that I will occasionally be filtering...
(0) odpowiedzi
2017-08-18 18:08 invalid input syntax for integer: "E00001"-PostgreSQL »
I'm trying to implement the following code in PostgreSQL and the error below: select distinct * from ( select distinct vendor,lag(cast(ve...
(0) odpowiedzi
2017-08-17 04:08 PostgresSQL 9.4.10 - CREATE DATABASE throws ERROR: permission denied to create database »
Postgres version: PostgreSQL 9.4.10 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Postgres server is installed ...
(0) odpowiedzi
2017-08-16 04:08 Pyspark unable to insert to a DB table from data frame »
PySpark throws the error ": org.postgresql.util.PSQLException: ERROR: must be owner of relation " However using the same creds I am able to perform In...
(0) odpowiedzi
2017-08-15 15:08 Postgres query running very slow »
SELECT st.id FROM station st, strike s WHERE s.srikedatetime > (current_timestamp - interval '20 seconds') and srikedatetime < current_t...
(2) odpowiedzi
2017-08-15 08:08 Detecting the change on the certain column in the history table »
Consider the following data: history.data ======================================= id |data_id| col1 | col2 | date ---+-------+-------+-------+-----...
(3) odpowiedzi
2017-08-14 19:08 Using python psychopg2 to get a count on all variables in the database that contain a specific string »
I have a list, words = [word1, word2, word3, ...] I want to use sql to return the number of times each word appears in Column A of an sql file. I can...
(1) odpowiedzi
2017-08-14 05:08 Storage consumption RDS Postgres »
Is there any way to see whats in the RDS storage? I have a Postgres instance on RDS. The Database in itself is very tiny, around 50MBs but the storage...
(0) odpowiedzi
2017-08-11 16:08 storing client datimetime with zone in postgresql table »
I want to store visitor last visit to my flask web page. for which I created db class TempTable(db.Model): __tablename__ = "tempTable" time...
(1) odpowiedzi
2017-08-11 15:08 postgress : SQLQuery : Week start and End date »
How to find out start and end date of week when Event Date is known. DATEADD(dd, -(DATEPART(dw, eventDate)-1), eventDate) [WeekStart] DATEADD(dd, 7...
(1) odpowiedzi
2017-08-10 11:08 classoid column in pg_description »
What is the "classoid" column in pg_description table? I see it changing for different kinds of objects like table, function etc., The PostgreSQL Off...
(1) odpowiedzi
2017-08-09 12:08 How to retrieve csv data stored in a 'text' field into another table in postgresql? »
For example Please suggest a solution ...
(1) odpowiedzi
2017-08-04 16:08 Postgres create temp table for each request from web application and that temp table will be accessible across all functions inside Postgresql.? »
I want to create a temp table for each request from a web application. The temp table should be accessible to all the functions present inside the Pos...
(0) odpowiedzi
2017-08-03 08:08 geometry matching and update »
I am trying to match geometries from two tables and update one table based on the match. But this is taking huge time. Table1 +-------------+------...
(1) odpowiedzi
2017-08-02 10:08 How to call table function from another function in PostgreSQL? »
I am new to PostgreSQL. I have a function CREATE OR REPLACE FUNCTION func1 ( a_person_id integer) RETURNS TABLE (granted_group_id varchar(10)) AS $b...
(2) odpowiedzi
2017-08-01 09:08 Not able to create Collation on windows »
Hi I am trying to create collation on Windows but not able to create it, I getting error as shown in screenshot. I am using deafult POSIX collati...
(1) odpowiedzi