Questions tagged as 'postgresql-9.3'

Tagged questions
1
answer

VB.NET receives no response from PostgreSQL 9.3 when inserting duplicate record

I have migrated from PostgreSQL 8.3 to PostgreSQL 9.3 to be able to use the improvements implemented in this version. With version 8.2 I had no problem controlling errors when trying to insert a duplicate record with a unique key since the progr...
asked by 28.02.2017 / 08:23
2
answers

how to link symfony to a postgresql database

I have a project in symfony, but I need it to be with a database in postgresql, but when I try it it gives me the following error I do not have the xampp, in the machine I only have php and I work directly with the server that generates th...
asked by 03.05.2018 / 13:27
1
answer

Problems counting in a Query

The structure of the tables is as follows: child CREATE TABLE CHILD( child_id SMALLINT, child_name VARCHAR(255) NOT NULL, birth_date DATE NOT NULL, gender VARCHAR(255) NOT NULL, address VARCHAR(255), city VARCHAR(255), CONSTRAINT PK_CHILD...
asked by 31.10.2017 / 08:42
1
answer

Error Codeigniter, How to fix it?

I am using codeigniter to develop, the problem is that when I already have the files on the server I get the following error ... An uncaught Exception was encountered Type: RuntimeException Message: Unable to locate the model you ha...
asked by 17.02.2017 / 14:48
2
answers

Error creating Trigger in Postgresql - syntax error at or near "BEGIN"

I am currently trying to create a trigger in postgresql to perform an insert in a table. But when executing the sentence the result throws:    ERROR: syntax error at or near "BEGIN"   LINE 4: BEGIN CREATE TRIGGER TRG_INS_DOCUMETTYPE...
asked by 21.11.2016 / 18:46
1
answer

Massive data upload process in postgresql

I have been researching this and sincerely what I find of information does not convince me (little information, by the way) what I try to do is enter 5000 data in 4 different postgresql tables and I have found that the COPY function works for a...
asked by 16.03.2018 / 21:29
1
answer

Postgresql Sub Query

Greetings. Currently the query I am using (without variables) does the necessary work, but now I need to add variables within it. INSERT INTO tabla2 (a,b,c,d,FK_ID) SELECT a,b,c,d FROM tabla1 In table2 I have a column fK_ID, how could I add...
asked by 15.12.2017 / 19:37
2
answers

Error in postgresql

I have a question about postgresql that does not allow me to move forward and maybe it's something simple that I'm forgetting or omitting. This is the structure of my table: CREATE TABLE public.p_proyecto ( id_proyecto INTEGER NOT NULL...
asked by 14.11.2017 / 14:30
2
answers

Insert data of timestamp type in PostgreSQL database

How can I insert the date and time in a PostgreSQL database where the field is of type timestamp ? I tried the following query in PostgreSQL , but it gives an error that the date is not compatible with timestamp : Code: insert into...
asked by 05.05.2017 / 04:22
1
answer

How to do filtering on datatables ignoring uppercase and lowercase?

I have a table made with server-side datatables but at the time of filtering, eg: "ing" ignores that "Engineer" exists, that is, it takes into account the case. How can I avoid that? Here is the code of my table: var table = $('#table').D...
asked by 09.01.2017 / 20:33