Questions tagged as 'postgresql'

Tagged questions
2
answers

Is there any incompatibility and errors between Internet explorer and PostgreSQL?

In my work we used PostgreSQL version 9.0 as a database for several systems. Some clients tell us that sometimes they can not find certain search data using Internet Explorer 9, 10 and 11. I as a developer use Firefox and sometimes Chrome and ca...
asked by 11.03.2015 / 18:27
2
answers

Django + Python update and not insert

I'm using a filter to return some student and update their data, however when I try to save I get the following error:    Student with this CPF already exists and Student with this RA already exists. My views.py : from django.s...
asked by 03.09.2018 / 16:34
4
answers

Help with distinct

I have the following sql query: select nome, data, situacao from cadastro The result is like this: MARIA 01/01/2018 0 MARIA 15/01/2018 1 GISELE 15/01/2018 0 CICERA 08/01/2018 1 ANTONIA 20/01/2018 0 ANTONIA 15/01/2018 1...
asked by 29.01.2018 / 14:12
3
answers

Is it possible to perform update on 1 table using another condition?

I have the following query: update ivr_contatos,ivr_campanha set ivr_contatos.tentativas = 0 where ivr_contatos.status = 0 and ivr_contatos.tentativas >= ivr_campanha.qtdtentativas The question is, if I can update in the field tries ivr_...
asked by 18.05.2018 / 14:20
3
answers

Capture which unique key was violated

I have a function that does insert in a table. This table has two columns that are unique 'email' and 'login'. In other tables there are also unique composite keys. Therefore, a UNIQUE_VIOLATION code: 23505 exception can hap...
asked by 09.11.2016 / 15:23
1
answer

Displaying quarterly data until the current date POSTGRESQL

As the SQL Fiddle , I'm displaying the quarterly data of a table, but that query is showing only when it has value in the quarter (3, 6, 9 or 12), when it has value for example in the current month (5), nothing is displayed, then ... How can...
asked by 12.05.2017 / 22:26
1
answer

Timeout while getting a connection from pool

You're giving this error. I'm using postgres Erro ao buscar servidor por id: Timeout while getting a connection from pool. A first chance exception of type 'System.Exception' occurred in BackupDAO.dll Method public Servidor buscarPorID(in...
asked by 13.01.2015 / 15:49
2
answers

How to do if in sql - Postgres

I need to do an if in postgres example. SELECT log."data" AS log_data, log."tipomovimento" AS log_tipomovimento, log."nomefornecedor" AS log_nomefornecedor, log."nomeproduto" AS log_nomeproduto FROM "public"."log" log WHERE if(l...
asked by 27.06.2018 / 16:27
1
answer

"Java exception has occurred" error while running PostgreSQL JDBC driver

Here's my problem: 1 - I'm using the Postgre 9.6 database. 2 - I downloaded and opened in ECLIPSE a project with Java application example with the use of Hibernate and Postgre that the teacher created (that is, the code is correct) I put t...
asked by 16.03.2018 / 02:28
1
answer

PSQLException: No result returned by query

I can not identify the error that is returning when trying to insert data into the DB. I believe the error is in the insert function. The error returned is:    Exception in thread "main" org.postgresql.util.PSQLException: No result retu...
asked by 15.02.2018 / 14:20