Questions tagged as 'postgresql'

Tagged questions
0
answers

Package to make reverse migration in Laravel 5.6

I want to know if there is any package that allows me to create the migrate from my database in postgresql in Laravel 5.6 and if so, how to use it. Edit1: The database is already created, the idea is to generate the migrate files based on t...
asked by 11.09.2018 / 23:01
0
answers

problem when trying to create this table in sql, I get an error in the Identity

CREATE TABLE Materia (codigoMateria INT IDENTITY(1,1) NOT NULL , nombre VARCHAR(40) NULL , estado BIT NOT NULL CONSTRAINT DF_Materia_estado DEFAULT (getdate()), CONSTRAINT PK_Order PRIMARY KEY (codigoMateria ), CONSTRAINT AK1_...
asked by 09.09.2018 / 03:12
1
answer

How can I connect my front (localhost) with my back in (localhost)

The case is as follows, I have a front made in angular and I already managed to make the connection between the back and the database, all this locally ... the problem is the following, when I try to obtain back information from my front with a...
asked by 06.09.2018 / 22:14
0
answers

Show an array in Google Charts Postgresql, PHP, Google Charts

I want to be able to go through a sql query where I group the emails sent during certain years, the sent ones, the returned ones, etc ... For respective specific years for example for 2014, 2015, 2016, 2017, 2018. For this I designed the followi...
asked by 27.08.2018 / 16:44
2
answers

cURL error 56: Recv failure: Connection was reset

I'm getting data from a csv (approx 9450 rows), and sending it by Guzzle from a Laravel 5.4 to a Lumen 5.4, but when I try to do it, I get this error "cURL error 56: Recv failure: Connection was reset" I use 2 local servers, the native of lar...
asked by 26.08.2018 / 03:12
0
answers

PostgreSQL ERROR: set-returning functions are not allowed in CASE

I have tried to implement this formula: CASE WHEN T."Net Changes" <> '0.00' THEN unnest(array['Net Changes',"Ending Release Reason Type"]) ELSE T."Ending Release Reason Type" END "Ending Reason Type Final" from T I get the following e...
asked by 23.08.2018 / 18:35
0
answers

How can I make my entrypoint.sh not add any errors once I have generated the logs command in dockers?

**    I'm having problems directly with the entrypoint, it does not let me access the link . Once it looks for the entrypoint, this error occurs:   users_1 | sh: /usr/src/app/entrypoint.sh: not found   I'm working on Windows. When I run...
asked by 16.08.2018 / 01:19
2
answers

Get latest registered email - SQL

I ask you a question, I have a table of this type: Basically the user can have several emails. What I need to do is bring all the users, without repeating them and that the email that I bring is the last one registered. For example,...
asked by 16.08.2018 / 19:54
0
answers

Column type TIME postgresql, returns object

I have a table that has columns that are of type TIME I work with symfony, so what I need is for this field to be filled in a form generated with symfony, but when it is generated I get this error:    Type error: Return value of App...
asked by 14.08.2018 / 16:23
0
answers

Problem when creating a database using the template of another (PostgreSQL)

I am creating a platform in java, where one of the needs is to create a new bd using the template of another existing one. For this I try to use the following query: CREATE DATABASE bd_copia WITH TEMPLATE bd_original; When executing the scr...
asked by 09.08.2018 / 21:00