Questions tagged as 'postgresql'

Tagged questions
0
answers

External serial key is self-generated when inserting

I have a table "clients" : CREATE TABLE clients ( id serial NOT NULL, name character(25), user_id serial NOT NULL, CONSTRAINT "Client_pkey" PRIMARY KEY (id), CONSTRAINT clients_id_key UNIQUE (id) ) WITH ( OIDS=FALSE ); ALTER TABLE...
asked by 28.11.2018 / 17:21
0
answers

Synchronize contacts with remote database

I try to synchronize the contacts of the mobile device with a database in this case Postgresql, the way I do it does not seem to be the most convenient. public void sincronizarcontactos(){ // Se tiene permiso final String[] projec...
asked by 26.11.2018 / 16:29
0
answers

Error making a php PDO query with postgresql

Good I am trying to make a web service with php and postgresql as a database, but I want to do it by the PDO method and I get errors. <?php require "database.class.php"; class Users { private $con; public function __construct() { //en...
asked by 12.12.2018 / 22:33
1
answer

Problem when retrieving data from a table

I created the branch model: <?php namespace App; use Illuminate\Database\Eloquent\Model; class Sucursal extends Model { protected $table = "sucursal"; public $primaryKey = 'ID_SUC'; public $timestamps = false; } I created...
asked by 22.11.2018 / 03:17
0
answers

Obsolete code? PostgreSQL - Triggers - SQL - It does not work

I currently have an obsolete postgresql code. I do not have much experience with functions or triggers, I only ask for help to get possible obsolete commands or functions since it is a somewhat old code and I am working with a server in postg...
asked by 13.11.2018 / 20:31
1
answer

psqlexception syntax error near "="

I am creating a method to obtain the records of clients that have a certain userid , the client table contains the columns: clientid, name, userid strong> likewise the Client class contains the 3 parameters clientid, name, userid . But...
asked by 11.11.2018 / 16:42
0
answers

AbstractMethodError

At the time of uploading to production I get the following error:    java.lang.AbstractMethodError: Method   org / postgresql / jdbc3g / Jdbc3gPreparedStatement.isClosed () Z is abstract I understand that it may be because some abstract m...
asked by 09.11.2018 / 23:40
0
answers

SonarQube with PostgreSQL

I want to use SonarQube with PostgreSQL, create a user with the name sonar, a sonar database and configure sonar.propiertes sonar.jdbc.username = SONAR sonar.jdbc.password = SONAR sonar.jdbc.url = jdbc: postgresql: // localhost / sonarqube? c...
asked by 09.11.2018 / 03:25
0
answers

Insert in postgres

insert into ciudad values( (nextval('id_ciudad_sequence')), -> Primer valor viene de una sequencia ('Barcelona','Una ciudad bonita','España', -> hasta aqui son campos normales '{"(default,El palacio,7,(calle,1,00000))"}') ->Empieza la...
asked by 31.10.2018 / 20:58
0
answers

I can not insert records in function postgresql with jdbc

Good morning friends, I have a problem when I want to insert records from a call to a postgresql function that receives 2 parameters and I want to do it from Java Server Faces and JDBC this is my java code: DAO: @Override public boolea...
asked by 29.10.2018 / 18:08