Questions tagged as 'postgresql'

Tagged questions
1
answer

INSERT command in php is not working [closed]

I'm passing a PHP project I made on the local server to a paid server. When I was using only the location of my machine, everything worked. But when the whole program was passed to the new server, the problem appeared. I am using the PostgreSQL...
asked by 25.08.2016 / 20:27
2
answers

UTF8 issues in postgres

I have a JSF project with JPA, Postgres 9 bank The information with acendo is being recorded with problems in the accent.    Shark records as Shark The Bank is with:    Ecoding = UTF8   Collation = English_Brazil, 1252   Character...
asked by 17.08.2016 / 19:03
2
answers

Prohibit duplicate registration

Hello everyone. I have a program that works with user registration. In this program I would like to implement a function that prohibits cpf or email registration that already exists in the database. As a database I'm using postgreSQL and Java...
asked by 24.08.2016 / 06:27
1
answer

ID Sequence advances +1 during error [PostgreSQL]

I have the following table in the database in postgreSQL ThefactisthattheDescriptioncolumnisunique_keysobytestingquestionsIdecidedtoinsertsomerecordswiththerepeatedvaluesinthedescriptioncolumntocheckifitwasworkingwell,problemisthatevenwhenth...
asked by 15.10.2016 / 19:02
2
answers

Finding data not registered in postgres

I have field records that have fields with years and months of this type: id mes ano ---------- 1 1 2005 ---------- 2 2 2005 ---------- 3 4 2005 ---------- 4 5 2006 ---------- My question is: Is it possible to find in...
asked by 14.09.2016 / 14:46
1
answer

Problem deleting a table field

When I try to delete a row from my table, it returns me this error ERROR: update or delete on table "menu" violates foreign key constraint "fk_menu_id" on table "view_menu" DETAIL: Key (menu_id)=(2370) is still referenced from table "vie...
asked by 19.10.2016 / 13:18
1
answer

Add different columns in the same result

I'm trying to generate a SELECT in PostgreSQL that pulls columns from different tables into the same column as the result. Home Example: Usuario ----------------------- | id | nome | regra | |---------------------| | 1| João | ADM | |-...
asked by 22.07.2016 / 18:13
1
answer

How to Save the Data to Generate a PDF?

There is a part of the system where the user will fill in a series of information just by choosing between selects options, these selects are fed with information that I have registered in my database. When I store this informat...
asked by 20.04.2016 / 17:29
2
answers

Hibernate jumping id string

I generated a project by JHipster which uses Java , Spring and Hibernate in the backend, I created a class as follows: Liquibase: <changeSet id="20160504131602" author="jhipster"> <createTable ta...
asked by 06.05.2016 / 14:02
2
answers

PostgreSQL - Query data from a range and bring a boundary of more spaced lines

Good morning guys, how are you? I have a performance problem on a system and need to solve customizing a SQL. Let's imagine the following scenario: - A table with millions of records, each record has an ID (PK) and a TIMESTAMP. I curr...
asked by 31.03.2016 / 15:39