Questions tagged as 'postgresql'

Tagged questions
1
answer

Postgresq-9.2 failed to connect to the Unix Domain Socket

I configured the database postgresql-9.2 in my Ubuntu 14.04 and it presents the following error when communicating with the bank    Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.54...
asked by 05.06.2014 / 21:00
1
answer

Deploy with Capistrano

I have to run my rails app on a machine and the DBMS (in this case PostgreSQL) on another server. I configured database.yml as follows: production: <<: *default database: nomedobanco username: username password: senha host: ban...
asked by 29.05.2014 / 00:09
1
answer

Override Hibernate Primary Key Generator

I would like to know if you can override the generator of a primary key in Hibernate, in my case I make a top class where id is, and the rest extend it. In my case this subclass, which extends from this one containing the primar...
asked by 03.04.2014 / 03:17
0
answers

How to call a Postgres Store Procedures in laravel

I'm not able to call a Function from my Postgres code on my Laravel system. CREATE OR REPLACE FUNCTION usuario.funsetsessao( login_p text, ip_p text, sistema_p text, logar_p boolean) RETURNS boolean AS $BODY$ BEGIN DROP...
asked by 27.12.2018 / 13:59
0
answers

Doubt how to make a thread with select and cancel query executed in the database

I'm running a query within a thread and set a timeout for it to execute, or another way of stopping it would be for the user to cancel the select . The problem is that I stop the thread but the query continues to run in the database. I...
asked by 11.12.2018 / 23:00
0
answers

Integration between two databases

I have an idea of integrating two databases, at one point I have the PostGresSql with system A and on the other side a Firebird in system B.    For example: I wrote a client on system A and I need to export to   system B. In addition...
asked by 08.12.2018 / 00:29
2
answers

Postgre query error: ERROR: syntax error at or near "WHERE"

I was working with mysql on this project and the query worked normally. At the moment, I'm migrating to postgresql. However, the query stopped working and returns the following error:    ERROR: syntax error at or near "WHERE" My code...
asked by 15.12.2018 / 12:36
1
answer

Django: PostgreSQL local and in Heroku?

I'd like to use PostgreSQL locally and in Heroku. How do I set my settings.py to know which setting to use? I have tried to put it as an environment variable, but I still can not. Today I have this: #Conectar localmente no sqlite def...
asked by 05.12.2018 / 21:14
0
answers

Laravel Custom Authentication with Postgres

I created a custom provider , called CustomUserProvider , extended from EloquentUserProvider and brought the fields perfectly. But login does not persist public function validateCredentials(UserContract $user, array $c...
asked by 04.12.2018 / 13:01
1
answer

how to capture an id dynamically and in sequence in postgresql?

It refers to an audit table that I am creating, the purpose is to register the fields of the table in question. But I can not capture the ex id: create or replace function audit_unidade.log_unidade_escola() returns trigger as $body$ begin --...
asked by 07.12.2018 / 14:17