Questions tagged as 'postgresql'

Tagged questions
1
answer

Scalability Apps

I do not have much knowledge about servers and business models for apps. Develop an app that has at the moment 9 users these enter from the android app or the web. I have a SSD VPS on ovh.com and its features are: 1 core to 2.4 Ghz 2 GB...
asked by 01.04.2018 / 00:54
0
answers

update and concatenate columns POSTGRESSQL

I would like you to help me with this doubt. I want to make an update in a new attribute that I add to my table, the situation is the following when doing that update I want to concatenate three columns. when I execute this code: update saber2...
asked by 01.04.2018 / 07:58
0
answers

generating a union view

I am creating a view in postgresql 9.3 with union this is the code select codigo_persona, nombres_apellidos, cedula, fecha_nacimiento, edad, meses, dias, genero, '' as codigo_evaluacion, '' as codigo_descripcion_situacion, '' as cbi, '' as pe...
asked by 27.03.2018 / 20:14
0
answers

How to save datapicker date in postgresql

I find this small problem when saving the date it saves me from the present and not the one selected in java. Controller code fac.setFecha_fin(dateFecha.getConverter().toString()); Sentence code insert into factura (fecha_fin) values (...
asked by 23.03.2018 / 16:36
0
answers

Functions / Stored Procedures PostgreSQL Entity Framework

I'm doing a WebAPI project with Postresql, and integrate the tables and the connection works fine, but when doing functions in postgres and wanting to import them I get the following error:    Error 6046: Unable to generate function import re...
asked by 21.03.2018 / 19:04
1
answer

Subtract columns from different tables

Companions, I have this because my logic is not giving me. This my query: (select count(distinct (case when sno_personalnomina.codnom::int in (1,2,3,5,6,7,8) then sno_personalnomina.codper end)) as sin_renumeracion from sno_personalnomina...
asked by 22.03.2018 / 16:38
0
answers

Connections opened by Tomcat 9 exceeds the value of the maxIdle

I am currently developing a web application, using tomcat 9 and Postgres SQL 9.4, in the context.xml of the server conf folder create the following pool of connections. <Resource name="jdbc/DBApp" factory="org.apache.tomcat.jdbc.pool.Data...
asked by 20.03.2018 / 22:53
0
answers

Merge parent-child tables in postgresql

I hope you can help me with this. I have 3 tables: vehicle (father), car (son), motorcycle (son) with the following fields. Vehículo(id,marca,anio,precio) Carro(nro_puertas integer) (Heredada de vehículo) Moto(incluye_access boolean) (Heredada...
asked by 16.03.2018 / 07:08
0
answers

PARAMETER TABLE IN A POSTGRESQL FUNCTION

I am trying to send a table as a parameter in a postgresql function, and in visual basic I get the following error:    "There is no assignment of object type System.Data.DataTable to a native type of a known managed provider." this is the...
asked by 01.03.2018 / 23:00
0
answers

Backup of triggers only

Good morning friends, I made a backup in a database, it is not the first time I do it, I used this command: pg_dump db -f /backup/agosto_31.sql And I do the restore with: psql -d agosto_31 -f agosto_31.sql But this last time I did it,...
asked by 27.02.2018 / 21:02