Questions tagged as 'postgresql'

Tagged questions
1
answer

Can an update be made with dblink?

I want to update from one database to another with the dblink in postgres as seen: SELECT * FROM dblink_exec('dbname=sie7','update catalogo_organizaciones set activacion_tablas=0 where rfc= 'LIMJ930210HDZ' ') in postgresql it runs fine but...
asked by 01.12.2017 / 20:53
0
answers

Drivers not available in QT and PostgreSQL

I am trying to make a connection using QT to a PostgreSQL database. The code I was using is the following: #include <QCoreApplication> #include <QSqlDatabase> #include <QSqlQuery> #include <QDebug> int main(int argc,...
asked by 29.11.2017 / 13:08
0
answers

Failed to raise the server with Composer and django

I'm following the tutorial to raise django in a docker container on this page, django-docker , I can configure the system as it indicates but at the moment of lifting the server with docker-compose up it throws me the following result:...
asked by 22.11.2017 / 03:54
1
answer

modify exception messages in postgresql

How can I change the messages generated by postgresql by default. Example errorcode 42501 permission denied for relation users what errorcode 42501 does not have permissions     
asked by 15.11.2017 / 17:33
2
answers

Error creating POSTGRESQL database

I am trying to create a database POSTGRESQL from Pgadmin4 Version2 . I have three different scenarios and I am not able to solve any of them. My first choice. I try to create it normally by providing a password, including local...
asked by 05.11.2017 / 10:40
0
answers

VB get cursor that returns a function in postgresql

I am using postgresql and vb, and I want to obtner in vb the result of a function that returns a cursor, but I have only been able to make it return the name of the cursor, and I do not want that, but the cursor data. This is the code: Sub...
asked by 08.11.2017 / 00:52
2
answers

I can not connect to my Docker database from pgAdmin 4

With the command "docker-machine ip" I get the ip and I enter it in the "Host name / adreess" field. I get the following error. This is the port of the database.     
asked by 06.11.2017 / 18:35
0
answers

Because the for cycle in Java is executed twice

It turns out that I have this function that contains this for cycle in Java that makes records of the rows in the JTable to the database public void registrarResultado() { DefaultTableModel tbl_model = (DefaultTableModel) vista.tabla_es...
asked by 21.11.2017 / 03:16
2
answers

Operation of a right or left in multiple join (Postgres)

I am trying to create a query for a library database that meets the following requirements: the number of books written by authors of Spanish nationality who they lived in the second half of the 20th century by editorial, together with the name...
asked by 19.10.2017 / 19:49
1
answer

postgresql php connection problem with objects

Hi, I'm having trouble connecting to the DB with postgres using PHP I attach the php code of the class connection, when I create an object connections and I call the method to connect this does not return anything to me, is there any way to see...
asked by 11.10.2017 / 17:20