Questions tagged as 'postgresql'

Tagged questions
1
answer

Purpose of the name of a foreign key

I'm creating tables for a system I'm developing and by entering the add foreign key part through the PostgreSQL 9.3.17 interface I noticed that it has the nome field to identify this key, I never paid much attention to it and alway...
asked by 01.08.2018 / 19:36
0
answers

Restarting Postgres in Windows

I am trying to create a database in Postgres, but it is giving the following message ERROR: cannot execute CREATE DATABASE in a read-only transaction I have reinstalled and nothing. I have already put this line in the postgresql.conf fil...
asked by 01.08.2018 / 23:19
0
answers

postgresql query between

Table X has the following information: (id serial unique, vlinicial numeric(10,2), vlfinal numeri(10,2)) ID VLINICIAL VLFINAL -------------------- 1 0.01 10000.00 2 10000.01 20000.00 3 20000.01 30000.00 4 30000.01 40000.00 5 400...
asked by 24.07.2018 / 22:35
2
answers

For better performance in the PostgreSQL database is it better to have the products split into smaller tables?

Hello, I am developing a system to manage the sale of various real estate developments. In this system each venture has a group of units available, type "Apt 21 - 2nd Floor, Apt 34 - 3rd Floor" etc.    I need performance for the broker to acc...
asked by 16.07.2018 / 20:14
0
answers

Materialized view

I have a problem creating a view CREATE MATERIALIZED VIEW table_name You're giving this error:    ERROR: syntax error at or near "MATERIALIZED" LINE 1: CREATE   MATERIALIZED VIEW sige.view_geral_lote AS ^ ********** Error       ERROR:...
asked by 16.07.2018 / 15:06
0
answers

Restore Postgre .BAT

Hello, good afternoon! I am doing a .bat for Backup and Restore of a database in PostegreSQL, the Backup .bat works perfectly but the Restore of the problem by the bank owning data, would have some way to when starting the .bat it delete all...
asked by 19.07.2018 / 20:43
1
answer

Simultaneous insertion of items and sales with C #, Windows Forms and PostgreSQL

Hello, I'm developing a sales screen in C # Windows Forms. I'm just in the beginning of the project, but I came across a situation where I'm not sure what to do. I am using a PostgreSQL database, I created a table called SALE and another ITEMSEN...
asked by 12.07.2018 / 00:46
0
answers

Data Persistence with Swagger

I need to use Swagger to send and receive JSONs. In addition, the API must do persistence and selection of data in a PostgreSQL database. I have already completed, in javascript the AJAX methods for sending and receiving JSONs, and the database...
asked by 25.07.2018 / 03:59
0
answers

Get a REFCURSOR with JPA 2.1

I'm running a Stored Procedure in Postgre using JPA 2.1 I need to return REF_CURSOR only that an error occurs and I've been trying to resolve it without success. I already use procedures being called by JPA but not to return a cursor I though...
asked by 10.07.2018 / 21:52
2
answers

I can not make the LIST page work in JSF

I have the following code that I'm developing with JAVA JSF, primefaces, postgre, cdi, tomcat: BUSCARBEAN package controller; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.annotation.PostCons...
asked by 10.07.2018 / 21:03