Questions tagged as 'postgresql'

Tagged questions
0
answers

Npgsql - Problem with Entity Framework 6

I'm having trouble using PostgreSQL with Entity Framework 6. When trying to fetch the data from my repository I get the following message:    The context can not be used while the model is being created. This   exception may be thrown if t...
asked by 24.01.2016 / 02:45
0
answers

Play Framework JPA postgres

Hello, I'm learning to work with Play! framework and I'm having difficulty integrating my application with the Postgres database, using hibernate. The application does not use the persistence, the bank is working because if I use a standard conn...
asked by 03.03.2016 / 20:03
0
answers

how to insert insert in postgres sql where

I am inserting data into a table in postgres, it happens that I have a field that does not exist in the referenced table and then the error when trying to insert a record that does not exist. I need to put a where ... INSERT INTO sexo(i...
asked by 18.12.2015 / 11:40
1
answer

Problem loading only needed fields using ResultSetTransformer in Hibernate

I'm trying to develop a method for using a SQL pure, fetch just the required fields from my query and finally, already bring the object already mapped. In case the object would be PropostaCartao and inside it would have a...
asked by 04.11.2015 / 15:39
1
answer

How to see the disk space that the index occupies in the database?

I have the table maintenance with the column product_id (varchar (MAX)) , but it is not the primary key, the table has 900 thousand records so I decided to create indexes to optimize searches. I've done the following tests: create index...
asked by 04.11.2015 / 18:28
1
answer

Error when querying postgres table using Jpa, Hibernate and Postgres

I made a small project to test a small register in a postgres table, using jpa, with hibernate, I managed to make the registration class work, it inserts into the table without problems but I can not make the query work because I get the followi...
asked by 16.10.2015 / 20:40
1
answer

EF6 and NPGSQL: Foreign key violation error

Good afternoon! I'm new to ASP.NET and EF6. Developed earlier in PHP. I created a project (ASP.NET MVC) using EF6 and NPGSQL. I picked up a little while creating the relationships between two tables but it worked. The persona table will have...
asked by 05.10.2015 / 22:58
0
answers

Laravel 5 whereRaw returns error but the final query executes correctly in postgres

You are returning the following error when I run my query using whereRaw : SQLSTATE [42P18]: Indeterminate datatype: 7 ERROR: could not determine data type of parameter $ 2 The code snippet responsible for this error is as below: $re...
asked by 21.08.2015 / 21:59
1
answer

C # + Postgresql = strange character

Greetings Galera I'm working with C # Windows Forms and have already done some testing with postgresql using version 9.1 and everything seemingly normal. But I came across a bank that is in version 8.4, using Encoding="SQL_ASCII". In th...
asked by 20.07.2015 / 21:22
1
answer

replication error

I'm trying to use a command in shell in PostgreSQL (Windows) with the following syntax: select pg_start_backup('nome do meu banco de dados', true); It responds to a record. Now, when I type the following command nothing happens: pg_base...
asked by 06.03.2015 / 15:42