Questions tagged as 'postgresql'

Tagged questions
1
answer

How do I enable Rails to support multiple connections open to the database?

I use PostgreSQL in my API and if my GUI (Navicat) is open accessing the application database and try to run the command db:drop db:create db:migrate db:seed I get the error below: ActiveRecord::StatementInvalid: PG::ObjectInUse: ERROR:...
asked by 03.01.2017 / 12:00
1
answer

Join the database with the java application [duplicate]

Hello, I did a college job using java screens using ide netbeans, I made crud in the database, using postgresql as the main bank, I got it done and everything, but I would like to just send the jar to the teacher, in my computer the jar works,...
asked by 24.11.2016 / 17:19
1
answer

How to extract data from a Django QuerySet

I have a table with some information, the name of the employee, pis, date and time, the time field records the time of the record in the point clock, these records are all in the same column, for example: Employee 1, has four check in, check in,...
asked by 21.11.2016 / 21:24
1
answer

Create Server in pgAdmin 4 with external IP

I'm trying to create a server with external IP in my pgAdmin 4, however the following error occurs when I try to save it: Accessing the file pg_hba.conf I checked that it is currently so: TYPE DATABASE USER ADDRESS METHOD I...
asked by 01.12.2016 / 12:02
1
answer

Doubt when changing fields automatically subSelect

I would like to know how I can change all the fields in my sales table. By modifying the field total_coin that will receive the quantity * preco_unitario. Remembering that I have 150 records in my sales table, then I would like to automati...
asked by 03.12.2016 / 02:09
0
answers

Postgre error trying to access externally

I'm using NO-IP to connect to an internal server in my office. I have already freed port 5432 on the machine firewall and also configured the pg_hba.conf and postgresql.conf files (I will leave the 2 here). I tried the door on insert the link d...
asked by 01.02.2017 / 07:06
1
answer

Bring data postgresql data field recorded as string

I wonder if it's possible to convert this data to select time Finding this data brings wrong information: select * from vendas where data_venda between '01/03/2016' and '16/10/2016'; I would like to know if you can do this: se...
asked by 27.11.2016 / 23:25
0
answers

Query delay to be finalized

Good afternoon, I have a problem executing a query in C # using NPGSQL. try { bdConn.Open(); NpgsqlCommand sql = new NpgsqlCommand(); sql.Connection = bdConn;...
asked by 14.10.2016 / 20:34
0
answers

Liquibase .sql file not found

When I run liquibase it does not find .slq files configured by the tag. SQLFile. How do you solve this? Problem data: Use in the project Liquibase 3.4.2. Configure the maven plugin Run script in Maven Ok everything works (Windows +...
asked by 03.11.2016 / 16:48
0
answers

How can I generate a report in php that is not a table?

I need to create a report / form from a query to php . I have a membership database of a leisure club. From this query : SELECT DISTINCT utilizador.nome, utilizador.data_nascimento, utilizador.nif, morada.r...
asked by 02.11.2016 / 20:29