I'm getting ERROR: missing FROM-clause entry for table "t3" when trying to use the following JPQL:
SELECT primeira FROM PrimeiraClasse primeira
LEFT JOIN primeira.segunda.terceira.quarta quarta ON (quarta.quinta = primeira.quinta)
ORDE...
I need to import several files to a postgresql database but I could only mount the script to import the files on the local server and now I plan to do it via url.
Listing the files via url I can see them in the browser.
The script I mounted f...
According to the structure below, I would like it when I update it to memorize only the differences. Example in the product table I have the fields
prodcode = 1
proddescricao = 'OLEO FILTER'
prodestoque = 33
If I do an update changing the sto...
I have a table mapping (Entity Framework Core 2.0) in which the Id field needs to be AutoIncrement.
The problem is that PostgreSQL is starting with high value and often jumps to very high sequences, type, increasing by 10 from 10.
What am...
Today I have an application with a database server that needs to be '99 .98% 'available, but as this issue depends on several factors (third-party services) I could hardly get to that level.
Researching the subject, I was advised to create 2 or...
Greetings, I'm trying to create a função em postgresql that allows me to check if a word or a set of words exists in a database.
To achieve this, I am using a table that holds the keywords.
My table:
CREATE TABLE IF NOT EXISTS key...
I'm trying to create a database in postgres but I'm getting the following message:
ERROR: can not set transaction read-write mode during recovery
I've uninstalled, cleaned the registry, installed a new password, but it always rescues u...
The database in question has data replication, the same database, but on another server, can you guarantee a user (user_bi) access to the replica only?
REVOKE ALL ON ALL TABLES IN SCHEMA public FROM user_bi;
This revokes the permissions of...
I made a query to search for a user. It worked!
But I tried to make another query, he gave this message
Error: Cannot use a pool after calling end on the pool
Because every time I make a connection, I close it later, and it seems that o...
I have a sales table (id, date, store, customer, value), which is the SQL command to return me the 3 largest customers (highest value) of each store. Anyone know?