Questions tagged as 'postgresql'

Tagged questions
0
answers

Error migrating from SQLite3 to PostGreSQL: No operator matches the given name and argument type (s). You might need to add explicit type casts

SELECT ag.user_id, ag.user_des, ag.user_login, ag.user_pwd, ag.act_readers, ag.h_reader, ag.email, ag.phone, ag.workgroup, ag.suspended, ag.accesstype, ag.firekey, cli.tpdoc FROM agenda ag INNER JOIN Cliente cli ON ag.user_id = cli.doc...
asked by 19.04.2018 / 16:50
0
answers

Error in PostgreSQL LANGUAGE SQL

When trying to create the following function: CREATE OR REPLACE FUNCTION public.sp_busqueda_dgv_ta( v_valor character varying ) RETURNS table(ID INTEGER, NOMBRE VARCHAR(500)) LANGUAGE 'sql' COST 100 VOLATILE ROWS 1000 AS $BODY$ IF TRIM(V_VAL...
asked by 21.02.2018 / 17:29
1
answer

Call sequence in a create table stored in a variable

Hello have the following problem: I have created a sequence in a trigger, and then dynamically instantiate it by create statements of tables in the same trigger. When I try to put NEXTVAL('secuencia') the single quotes tell me the variabl...
asked by 17.01.2018 / 21:08
1
answer

django set client encoding with multiple database

Good I am developing a API by django rest framework and for this I have configured two databases. I need to make a query to the second database configured (postgresql) and get it to return the data but it gives me the spec...
asked by 21.12.2017 / 17:46
2
answers

Query in PostgreSQL with filter in 2 different columns

I have a problem when doing a select with filters to several columns. I have a table with different age groups (days, months, years) and I need to make a consultation where only people who are younger than 2 bring me but the months are greater t...
asked by 28.11.2017 / 14:43
0
answers

Can you create a function within another function in postgres?

I have a database and within it I have the function create_functions and within the function create_functions I want to create another function transaccioncuentas to be able to create it in another database as it looks but it marks me an err...
asked by 29.11.2017 / 19:41
0
answers

Query to order data insertion [closed]

Greetings. When clicking on the + button in the second row of table 1, I get the result of table 2 (new row). I need that when I update the page, the data stays in the position where it was created or deleted. What kind of query would you need?...
asked by 29.11.2017 / 15:33
1
answer

Absence of the first record in the table when filling a Treeview with the result of a query

I am still a novice in Python and I have a problem that has not been solved. I am creating a form to feed / view / modify ... records from a database in PostgreSQL and among other options I want to dump the data from the database to a Treeview...
asked by 11.12.2017 / 20:02
0
answers

DBeaver - Unexpected behavior of the commit when editing components

Good afternoon, I installed the latest version of DBeaver (4.2.5) two days ago. I used to have 4.0.1. I have a connection to a PostgreSQL database. Every time I open the contents of a table it asks me to do "Commit" or "Rollback". However, I ope...
asked by 24.11.2017 / 20:23
0
answers

restoring database in postgresql takes a long time

I have the following problem. I generate the .backup from my database that weighs 210 megabytes. When I restore from the pgadmin 3 it takes an eternity (it's a whole afternoon or an entire night). I've even restored it from the console thinking...
asked by 27.10.2017 / 18:36