Questions tagged as 'postgresql'

Tagged questions
2
answers

Update date for each update in a table

I have a pessoa table. In it I have a field called pe_modified that aims to have the date of the last modification in the table. Instead of having to refresh in the query, is it possible to be automatic? Is there any type of fie...
asked by 22.11.2016 / 15:23
1
answer

Error trying to access database information

I'm migrating an application that was developed in Delphi 7, which previously used the Firebird database, hence I'm making the application communicate with the PostgreSQL database. I have managed to make the communication correctly with the bank...
asked by 03.11.2016 / 17:02
1
answer

ERROR: column "type" of relation "tb_people" does not exist

Hello. I'm trying to persist a record, but when I run it, it is returning the error below: // ... @Inheritance(strategy = InheritanceType.JOINED) @DiscriminatorColumn(name = "tipo", discriminatorType = DiscriminatorType.STRING) @Discriminat...
asked by 21.01.2017 / 14:55
1
answer

Send text file to PgAdmin

I need a little help, I'm a beginner. I have to send a txt file that I open in netbeans to a PgAdmin table. If you see the code, you will understand me. I tried to put my method that shows the txt file in INSERT but it did not work. I do not...
asked by 09.11.2016 / 17:53
1
answer

Problems with not null fields creation with FluentNHibernate

I have a problem creating fields using FluentNhibernate and Postgres. User Class: public class Usuario { public virtual int idUsuario { get; set; } public virtual string nome { get; set; } [NotNullNotEmpty] public virtual str...
asked by 01.10.2016 / 18:52
0
answers

Mysql doubts in fk null (Election candidate blank)

I am doing a voting system and need to accept blank votes What is the best option to do this? accept passing a null value in the cd_candidate column? I can not create a blank candidate in the candidate table reason: they will have a...
asked by 21.10.2016 / 15:44
1
answer

Problem with accentuation in postgresql with npgsql [duplicate]

I have a postgresql database created with encoding SQL_ASCII and template0 . When I try to select rows with accents like NOT it gives error, however if the records do not have an accent it works normally. Errors:    Error parsing...
asked by 25.08.2016 / 14:44
1
answer

PostgreSQL problem [closed]

After a power outage we restart the server on which the database is located, and although we try to raise the bank manually the bank does not get up. The message that occurs is this below:    FATAL: The database system is starting up. Can...
asked by 27.10.2016 / 19:49
0
answers

New fields added after scaffold do not persist in bank even while being strong params

I have a problem here that I have not resolved for 3 days. Very strange. It is in editing a record. It is only updating the first record and not the 2nd onwards. The curious thing is that this only happens with the field quatidade_dev (added aft...
asked by 22.09.2016 / 00:50
3
answers

How to do an update with a join?

Hello, I'm new to the forum and need help with PostgreSQL DBMS. My question is the following, in the following code used in the MySQL DBMS the execution happens perfectly, because in PostgreSQL it shows an error. MySQL Code: UPDATE user...
asked by 25.03.2016 / 23:59