Questions tagged as 'postgresql'

Tagged questions
0
answers

Problem connecting Power BI with Postgresql (npgsql)

I am willing to work with Power BI connecting it to the Postgresql database but it gives me an error, which in all forums is said to be normal but the problem comes when I install and run the latest version of npgsql.msi and the same error still...
asked by 28.09.2018 / 13:12
0
answers

Postgresql function with temporary tables

I have a function that has 6 LOOP cycles in it, I need to insert it into a temporary table with data I get RECENT in the last cycle, but when I enter the second LOOP cycle the temporary table disappears and I can not find it. Can I make that tem...
asked by 25.09.2018 / 20:06
0
answers

Show specific data of a Postgresql Database in HTML

I hope you can help me, as part of my project in Django, I must show specific data of my table which is in BD Postgresql, but I do not know how to do it and the truth is that with the Tutorials I get too involved. My code is as follows: base.Htm...
asked by 27.09.2018 / 16:20
0
answers

Put table name in SQL query result

I have a question about whether this can be done in postgresql Let's say I have a table called X which has 3 fields, a, b, c If I do a select * from X it gives me the records in the form: a --- b --- c --------- Okay, so I would l...
asked by 24.09.2018 / 21:23
0
answers

It helps to modify a function sql in postgresql

good day, I have an SP in postgresql and the problem here is to put another case where that case receives as a parameter a 2 that eliminates, what happens is that I do not know much plsql and then I do not know how it goes: This is the functi...
asked by 03.10.2018 / 18:09
0
answers

Define field so it does not allow negatives

I have a problem with a task that I am developing. The problem is this: the application is about a distributor of products in which the employees go to the different stores and place the orders, the problem is what, when making several orders...
asked by 18.09.2018 / 16:51
1
answer

java.lang.IllegalStateException: Local transaction already has 1 non-XA Resource: can not add more resources

throws me that exception when I'm going to add data to a table (Uploads) in postgreSQL. probe in other methods of data insertion but the error only occurs specifically in that method, I continued to investigate is because I must change the trans...
asked by 20.09.2018 / 15:20
1
answer

How to pass data between Includes in the same query of sequelize?

I have a problem with sequelize, I need to consult several tables in the same query, these are nested with Include: [] so fine, but I need to pass the result of a nested table (coins) to another table of another include (prices), since with re...
asked by 23.09.2018 / 21:51
0
answers

cycle foreach duplicates the inserts to the database

I have a JSON that I sent from an android app to a PHP file where I go through it and store it in the PosgreSQL database, the situation is that when there are more than 250 records it always duplicates them ej json takes 300 elements and enters...
asked by 19.09.2018 / 18:56
0
answers

function sum (text) does not exist

I have a very simple function that groups together some values of the Chile 2017 census. The columns of interest say a2007, a2008, a2009, etc that are the years and their population, all are of the numeric type but not the problem that does not...
asked by 12.09.2018 / 19:24