Questions tagged as 'postgresql'

Tagged questions
0
answers

how to prevent pgadmin III from disconnecting from postgresql every 15 minutes or so?

What happens is that I leave the desk for a few minutes and when I want to restart or use pgadmin III again to access my postgresql database, I get an error message saying that the connection has been lost and I have to close the pgadmin and reo...
asked by 26.04.2018 / 18:59
0
answers

Qt: Problems with QPSQL driver not loaded

This is my code for the main.ccp : #include <QCoreApplication> #include<QtSql> #include<QtDebug> #include<Iostream> #include <QSqlDatabase> #include <QSqlError> #include <QSqlQuery> int main(int argc...
asked by 24.04.2018 / 19:14
0
answers

Postgres - SQL state: 22P02

In the following query: SELECT t1.codigo FROM tabla1 AS t1 INNER JOIN tabla2 AS t2 ON t1.codigo = t2.codigo WHERE CASE WHEN POSITION( '-' IN t1.codigo ) = 0 THEN CAST((t1.codigo) AS INTEGER) ELSE CAST(SUBSTRING( t1.codigo,...
asked by 19.04.2018 / 17:12
0
answers

Jboss connection pool does not connect to the DataBase

I am using JBoss 7.1, and I am trying to create a Database Connection Pool through Application Server. Right now I am trying it with a mySQL Db, but I have also tried with a Postgre DB, but the error is still the same. The problem is that appare...
asked by 20.04.2018 / 10:51
2
answers

Convert SQL query into one for Django ORM

My question is this: I want to convert this query sql : SELECT "misuper_calendareventsretailerdelivery"."id", "misuper_calendareventsretailerdelivery"."normal_retailer_delivery_id", "misuper_calendareventsretailerdelivery"."deli...
asked by 18.04.2018 / 19:08
1
answer

How to use join in Postgrest

I have the Table A: ------------------- * fechaA * ------------------- * 2017-09-01 * * 2017-09-02 * * 2017-09-03 * * 2017-09-04 * * 2017-09-05 * * 2017-09-06 * * 2017-09-07 * * 2017-09-08 * *...
asked by 16.04.2018 / 05:21
0
answers

How can I combine old / new with a variable in postgres?

I'm doing as a type of blog, and I'm trying to save the record id the table that triggers my function. There are two tables, customers and orders, I want that if customers shoot my function, I saved the customerid that was inserted, modified or...
asked by 16.04.2018 / 08:38
1
answer

Change date of birth PostgresSQL

Hello good day I have the following problem, I have a database in which the dates of birth have been entered in a different way as shown in the image. My question is how can I get the same format on all birth dates, because I have dates this way...
asked by 08.04.2018 / 17:32
0
answers

How to add new check type column in postgres?

I am working under a database that already has content, so I just need to add a role column in the user table, this column should only allow 3 values: [alumno,academico,administrador] . When I create a table I usually only do the follow...
asked by 07.04.2018 / 02:05
1
answer

Error 500 apache in centos 6

I have a data server and another one of applications in virtual machines in centos 6 that use postgresql 9.1, in the applications one I have a .war and .ear files inside some jboss nodes that are the pages I want to be able to connect, when plac...
asked by 05.04.2018 / 21:29