Data dodania Pytanie
2017-04-07 16:04 Laravel 5 configure timezone not define the timezone at postgres connection »
I have a question: How you usually work on timezone in the sites with laravel 5? Postgres is in localtime and the local timezone of my notebook is in...
(2) odpowiedzi
2017-04-07 14:04 Invalid status code : 0 in node.js API »
I am building a simple api in node and express with postgre as Db following a tutorial.I am still learning and new to this tech.I followed everything ...
(1) odpowiedzi
2017-04-07 12:04 how to do update data in 1 table from another table using with clause,select,storing language id's in json_array and join in postgresql »
if EXISTS (SELECT 1 FROM lt_transmap_patient_language l left join lt_transmas_patient p on p.patient_id=l.patient_language_pat...
(0) odpowiedzi
2017-04-06 19:04 Hibernate 5.2.9:@Basic(fetch = FetchType.LAZY) is not working »
I saw there are lot of questions asked earlier on the same thing in stack overflow in different ways. I looked at one of this issue on Hibernate forum...
(1) odpowiedzi
2017-04-06 14:04 dblink_build_sql_delete . I need to be able to delete the data with <= condition »
SELECT xyz.* FROM PUBLIC.DBLINK ('dbname=LiveDB port=5432 host=127.0.0.1 user=postgres password=root','SELECT dblink_build_sql_delete(''"folderstatus...
(1) odpowiedzi
2017-04-06 14:04 Postgresql's json_each()/jsonb_each() equivalent in MySQL 5.7.*? »
Is there any json_each()/jsonb_each() equivalent in MySQL 5.7.*? According to the article I found: "Not supported, cannot be implemented using UDFs o...
(0) odpowiedzi
2017-04-05 20:04 how does ordering by UUID works on postgresql? »
Is there any ordering guarantee on using uuid_generate_v1() on postgresql? If yes, The guarantees are per machine or it does not matter on which mach...
(1) odpowiedzi
2017-04-04 01:04 Get the last line for a specific variable »
I am applying a windows function similar to the query on the example below. I would like to know how can I extract only the last row for each depname....
(0) odpowiedzi
2017-04-02 22:04 Postgresql Updating Modified_on (Default Time stamp) column without a Trigger »
How can I update the Modified_on column which is defined as DEFAULT TIMESTAMP without the use of a Trigger in Postgresql. ...
(0) odpowiedzi
2017-04-02 14:04 Merging records in a table with 2-columns primary key »
I have prepared a simple test case for my question - In a game player ids and names are stored in the table users: CREATE TABLE users ( uid ...
(1) odpowiedzi
2017-03-30 14:03 pgpool is doing failover even when only one node of pgpool not able to reach postgresql master »
We have a PostgreSQL setup with 2 nodes master slave PostgreSQL and 3 node pgpool cluster. The cluster works and does failover in normal scenarios. N...
(0) odpowiedzi
2017-03-28 19:03 How to create tables with millions of rows with fast performance in PostgreSQL? »
I have data that correspond to 400 millions of rows in a table and it will certainly keep increasing, I would like to know what can I do to have such ...
(1) odpowiedzi
2017-03-28 01:03 Differentiate null and empty in Postgres JOIN query »
If I have tables like this: t1: id | name ----+------ 1 | a 2 | b 3 | c 4 | d t2: id | value ----+------- 10 | xxx 20 | yyy 30 | zzz ...
(1) odpowiedzi
2017-03-27 08:03 How to detect the database is backup mode or not in postgresql 9.4 »
Currently we scheduled backup job at morning by using pg_basebackup. Is it possible to detect a database mode during backup time. ...
(1) odpowiedzi
2017-03-26 21:03 How to JOIN using LIKE '<column>%' »
I have a list of items, each of which has a category code: id | name | category_code ---+------------+-------------- 11 | 'Cookies' | '43040' ...
(1) odpowiedzi
2017-03-24 09:03 Infinity recursive function exception in Postgresql »
I have a table Answer and Many to Many table Link (Answer n-n Answer) Link have 2 column : from_id and to_id reference to answer_id. I want get all d...
(1) odpowiedzi
2017-03-23 14:03 Postgres Query giving ERROR: invalid input syntax for integer: "" »
I am trying to execute following query but failing to get the result in postgres My query is SELECT BP.BULLETIN_NUM,BP.REV_ID FROM cct.CCTT_BULLETI...
(0) odpowiedzi
2017-03-23 13:03 POSTGRES: String is being cast as unknown »
I have 2 functions: First: CREATE OR REPLACE FUNCTION parking_main_analysis(park_id_p text, zone_parameter integer, org_id integer, number_of_days i...
(0) odpowiedzi
2017-03-22 18:03 How to convert english date to nepali date using SQL any help would be appreciated »
How to convert english date to nepali date using SQL any help would be appreciated. example: Year Month Day English Date 2017 ...
(0) odpowiedzi
2017-03-21 15:03 Pass dynamic parameter to crosstab subquery »
I have table like there: table: | id | key | label | amount | |----|------|--------|--------| | 1 | 1 | label1 | 10 | | 2 | 1 | la...
(1) odpowiedzi
2017-03-21 11:03 Sorting in PostgreSQL with UTF-8 »
I have a funny sorting problem with a UTF-8 database in PostgreSQL 9.4 My DB settings are: Collation en_US.utf8 Character type en_US.utf8 Encodin...
(0) odpowiedzi
2017-03-17 12:03 Checking uniqueness of Entities based on contents of collection »
I have the following Entity structure and am looking for the most efficient way in a multi-instance environment (cloud) to check that there exists onl...
(0) odpowiedzi
2017-03-16 21:03 Can't connect to postgresql server after moving database files »
I want to move my postgresql databases to an external hard drive (HDD 2TB USB 3.0). I copied the whole directory: /var/lib/postgresql/9.4/main/ to ...
(0) odpowiedzi
2017-03-15 09:03 Postgres jsonb, nested array querying to hide specific fields »
I have a jsonb data of following format, with nested arrays { "outerArray": [ { "price": { "amount": 108.95, "currencyCod...
(1) odpowiedzi
2017-03-12 17:03 Postgresql is the server running locally and accepting connection on Unix domain »
I am trying to install postgresql-9.5 or postgresql-9.6 on my ubuntu 16.04 or 14.04 machine, after following the installation process using below comm...
(2) odpowiedzi
2017-03-12 16:03 FATAL: password authentication failed for user "root" postgresql »
I use PostgreSQL and Django (format Heroku) and have error FATAL: password authentication failed for user "root" Traceback (most recent call las...
(1) odpowiedzi
2017-03-12 00:03 postgresql create bitset from query by primary key »
I have a big table with primary autoincrement key. Sometimes i need to build bitmask for current filtering query on this table(which rows suit for my ...
(0) odpowiedzi
2017-03-10 21:03 guarantee uniqueness of table relationship »
So I have a table of states. CREATE TABLE public.states( state_code char(2) NOT NULL ); I have several different ways of grouping those states i...
(2) odpowiedzi
2017-03-10 03:03 Load .json file data to Postgres for Rails 5 API »
The terminal objective is to have 1.6 million records ingested into Postgres for discovery in my Rails 5 API app. I have 45 .json files each containin...
(0) odpowiedzi
2017-03-08 16:03 django models use multiple foreign keys vs integerfield »
I have a situation where I have multiple foreign keys in one table to other tables (a parent and a non related field. I have to come to find that if ...
(0) odpowiedzi
2017-03-08 10:03 Hibernate, PostgreSQL : Could not extract resultset, SQLState 25P02 »
I am working on one of our test-servers and getting an error from the hibernate when I am trying to call a method, where I get the Person object by it...
(1) odpowiedzi
2017-03-06 20:03 Filter a top level JSONB array document in Postgres? »
I have a Postgres table named 'events' with a column of 'id', 'name', 'invoices': Table "public.events" ...
(1) odpowiedzi
2017-03-02 23:03 Port 5432 doesn't listen on Raspberry PI »
I'm trying to run postgresql 9.4 on my Raspberry PI 3, but without success. My /etc/postgresql/9.4/main/pg_hba.conf host all all 10.0.1.0...
(1) odpowiedzi
2017-02-27 07:02 Store random data in Postgres database from Python »
I have the data in this form: data={'[{"info": "No", "uid": null, "links": ["";, ""], "task_id": 1, "created": "2017-02-15T09:07:09.068145", "fin...
(1) odpowiedzi
2017-02-25 12:02 How to track changes in any function in PostgreSQL »
I want track changes in any function in PostgreSQL. Example - Suppose, i have function fun_name() in postgesql database and i am doing modifications ...
(2) odpowiedzi