Questions tagged as 'postgresql'

Tagged questions
0
answers

Error persisting byte array in postgresql

Gentlemen, I receive an exception ERROR SqlExceptionHelper:131 - ERRO: coluna "ds_inddir" é do tipo bytea mas expressão é do tipo bigint the mapping of the table this way @Lob @Basic(fetch= FetchType.EAGER) @Column(name = "ds_poldir") pri...
asked by 25.05.2018 / 01:59
0
answers

Reverse engineering pg_catalog

The teacher of my college has launched a challenge for students, which consists of from the pg_catalog of a generic database of PostgreSQL we make a script to reverse engineer the bank, from that engineering generate a file that can be opened in...
asked by 23.05.2018 / 16:38
1
answer

Search with Ruby on Rails to generate a report

Well I have a project with scaffolds of books and loans and I need to do a search for a specific book and as a result show all the loans in that book had I have no idea how to start doing this.
asked by 17.05.2018 / 20:58
1
answer

Filtering results in PostgreSQL from the lowest value of only one column

It's a matter of logic and knowledge of PostgreSQL features. I have the following query result: I need to do a filtering, grouping by [hour] so that only the closest [real_time] remains, and consequently the whole corresponding line (I...
asked by 15.05.2018 / 14:51
0
answers

Problem with postgresql server version mismatch

I'm trying to restore a small, backup base on my machine in version 9.6, but it claims error when trying to create the backup via pgadmin III, I run through a bat: pg_dump.exe -h localhost -p 5432 -U Nome -n protocolo -F c -b -v -f "C:\Elote...
asked by 18.05.2018 / 21:27
0
answers

Error due to cancel sale in POSTGRESQL

Good afternoon, I'm implementing a sell rebate function that is as follows: CREATE OR REPLACE FUNCTION estorna_venda(p_id_venda INTEGER) RETURNS VARCHAR AS $BODY$ DECLARE v_id_prod INTEGER; DECLARE v_prod_qtd INTEGER; DECLARE v_contador INTEG...
asked by 18.05.2018 / 21:20
0
answers

php query postgresql with return in ajax

I want to make a php / postgresql query and return the values in a form already filled with ajax, so that there is no page refresh where I can edit the information and update in the database. I can bring the form but the input comes empty. On...
asked by 11.05.2018 / 15:07
1
answer

What is the safe way to work with TRicheEdit Database?

I'm asking this question because the days I'm having a huge headache with this RichEdit junk, time it saves correct time it saves a lot of ???????????? in the base ... I know it may be an error in the conversion of characters but the detail is t...
asked by 03.05.2018 / 20:20
1
answer

Connect in bank sql a bank postgres

Scenario: I have the database postgres A, however I need to connect to bank A from sql server 2017. How can I do this?     
asked by 10.05.2018 / 23:38
0
answers

org postgresql util PSQLException ERROR syntax error at or near auto_increment in a JSF project

What could be the problem? 2018-04-30 14:50:08,218 [http-nio-8080-exec-8] WARN org.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; us...
asked by 30.04.2018 / 19:58