Questions tagged as 'postgresql'

Tagged questions
1
answer

Postgresql connection with JDBC in eclipse

Appears on the console: java.sql.SQLException: No suitable driver found for jdbc:AulaFBD://localhost:5432/TrabalhoFBD at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager...
asked by 26.11.2018 / 04:53
0
answers

Query pagination with LIKE function

Good afternoon. I am having an error in the query with pagination when I pass a search parameter. Here's the problem: When I'm on page 2 and search for an item on page 20 my sql does not return anything. Follow sql : SELECT * FR...
asked by 30.11.2018 / 17:12
1
answer

PostgreSQL - use custom loopback select

I have a function that does a select like this: SELECT a.nome, b.email into nome, email FROM tabela1 a INNER JOIN tabela2 b ON b.fk = a.fk Is there any way to create a "temporary table" that I can temporarily store the various possible retu...
asked by 23.11.2018 / 13:22
0
answers

Postgres does not accept commands. "Invalid binary" error

Good afternoon, folks. I am installing Postgres and when trying to create the database through the command line interface, postgres gives me the following message incaseheisnotacceptinganycommand.InprintIgavethefollowingcommand:createdb-ESQL_AS...
asked by 10.12.2018 / 22:54
0
answers

Error creating GIN type index

When trying to create an index of type GIN in a table I came across the following error: CREATE INDEX idx_descricao on produtos USING gin (descricao gin_trgm_ops); ERRO: classe de operadores "gin_trgm_ops" não existe para método de acesso "...
asked by 20.11.2018 / 13:42
0
answers

Wildfly with postgresql, does not access the last database

I am setting up a datasource in Wildfly and when hibernate will create the tables, it is creating in the postgres database instead of the last database. Below is part of XML: <datasource jndi-name="java:/Teste" pool-name="Teste" enabled="tr...
asked by 21.11.2018 / 11:47
1
answer

How can I make a procedure to update the balance in postgres?

Mine has been giving a mistake that I can not understand talking about having a bug in $, but when I used another example procedure from the internet almost in the same way as mine did, then the error is being in how to do it procedure. The o...
asked by 22.11.2018 / 23:13
0
answers

Problem with python in postgres on mac

People, I'm testing trigger functions with python in Postgres and I'm having problems when I test on my Mac. Here's the function: create function sendchange() returns trigger as $$ import requests import json url = "http://localhost:8080/send...
asked by 22.11.2018 / 13:58
0
answers

Permission in PostgreSQL

I want to run a query on a PostgreSQL-type database. The query is as follows: select *from pg_stat_activity; But I want this to be done by a user who only has read permission. The user should not be allowed to select in the tables because i...
asked by 31.10.2018 / 18:48
0
answers

How to pass data from a JTextField to a Postgresql Date field [duplicate]

I would strongly urge you to help me solve a Date (SQL) data insertion problem for new student enrollment in the Crud project developed by me in the code below. The method containing the INSERT INTO command does not insert a new record in the...
asked by 07.11.2018 / 19:00