Questions tagged as 'postgresql'

Tagged questions
0
answers

input gives me the value of null in Java EE and PostgresSQL

help I have already gone from error to error with my code and in all the problem is related to "null", my conclusion is that the input of my form gives me a value null and not the one that I type. import javax.servlet.*; import javax.servlet.h...
asked by 25.06.2018 / 22:52
0
answers

Store variables in Bash from a result in postgreSQL

I have a Bash script on Linux: psql postgresql://postgres:****@****/**** --quiet --no-align --field-separator ' ' -t -c "SELECT * FROM *" | while read -a Datos_Consulta ; do Where I store the data of the variables as follows: DATO1=${Dato...
asked by 29.06.2018 / 16:55
0
answers

Know if a data has dependency without deleting it posgresql codeigniter PHP

I would like to know if there is a way to know if one data has dependence on another without deleting it. I explain if we use delete from and this data has dependency, it does not allow us to delete. but I need to use a logical deletion 1-...
asked by 26.06.2018 / 23:01
0
answers

how to make traces

I have an application whose database engine is the postgres and I have the pgadmin 4 installed but I need to know what tool to create a record of traces made by the user.     
asked by 22.06.2018 / 17:24
0
answers

I have doubts about the traces in the database

I am doing a Database Management System in JAVA using orm and I would like to know what is used to register the traces with the layer of persistence of the Java application? . The Database was created in postgreSQL v9.3     
asked by 18.06.2018 / 08:25
0
answers

problems with pgadmin 3

I am trying to create a new server record in Pgadmin 3 I add a name, then the host added localhost port 5432 maintenance DB postgres, username root password of 9 characters and I get this. regards, I am new, postgres, I have kali linux An...
asked by 18.06.2018 / 06:14
1
answer

ERROR: the time zone p.m. is not recognized, Postgres

I have a table similar to this one: ------------------------------ | id | fecha | ------------------------------ | 1 | 2018-06-18 14:30:00 | | 2 | 2018-06-18 14:31:40 | ------------------------------ The important thin...
asked by 20.06.2018 / 01:49
2
answers

Error creating Database in Java

I try to create and access a java database, I am using the postgresql-42.2.2 library. This is my method: public static void main(String[] args) { Connection c = null; try { Class.forName("org.postgresql.Driver"); c = Driver...
asked by 05.06.2018 / 23:45
0
answers

filling a table from another database

I'm trying to fill a table with information from another from another database, but I get this error cross-database references are not implemented: the code I use to do the copying is this insert into sigestel.public.estado (select * from...
asked by 06.06.2018 / 15:32
1
answer

Why does JPA return the related records in FETCH LAZY?

I'm using JPA and I'm having problems retrieving records from tables that contain foreign keys, my DB is wide but I'll simplify the problem, in a typical REGION - > CITY - > COMUNA REGION Table Primary Key REGION Tabl...
asked by 07.06.2018 / 17:20