Questions tagged as 'postgresql'

1
answer

Find and display in a listview a single type of DB information

I'm having trouble fetching a single type of DB information, I've already created a list where I bring all the information in it, but I want to pull only one, for example just fetch the names of the clients and display all of them in a listView,...
asked by 13.09.2016 / 00:45
0
answers

How to install Npgsql as a data provider for ADO.NET Entity Framework?

I've read everything you can imagine, but I'm out of luck. In Visual Studio 2015 Enterprise update 1, I followed exactly the steps as described in the tutorial on link : I downloaded and installed: Setup_NpgsqlDdexProvider; I added the p...
asked by 01.08.2016 / 01:51
1
answer

How to count underage employees?

I use the following code to display the number of active employees: {{ $relatorio->Empresa->Funcionario->where('id_status', 1)->count() }} How do I count only employees who are under the age of 18? In the employee table I hav...
asked by 13.07.2016 / 15:28
0
answers

Error connecting to PostgreSQL

I'm having trouble connecting an Asp.Net MVC application with PostgreSQL (locaweb). error:    28000: no pg_hba.conf entry for host "187.52.54.50", user   "dataportal", database "template1", SSL off Database: dataport. But it always...
asked by 09.08.2016 / 00:53
0
answers

Npgsql failed to call plpgsql function

I'm doing tests of Npgsql . One of the tests tests the return of a plpgsql function. But the test is failing by saying that the function does not exist. In the description of the error the name is given in the function passed and the param...
asked by 19.06.2016 / 17:43
0
answers

Postgres load balancing Windows servers

I'm wondering a bit more about load balancing in Postgres and a bit of failover. I have seen in several sites including in Postgres that there is a program called pgpool i and ii, this program does the balancing and also treats the failover. But...
asked by 08.07.2016 / 03:45
2
answers

How do I put autoincrement

In the database I can only insert if I add a code, but I want it to be auto increment, in the database I use postgre and declare the code as serial String sql = "INSERT INTO tbl_cliente(codigo,nome, cpf, telefone, endereco, sexo, pagamento, mo...
asked by 04.06.2016 / 16:18
0
answers

Problem with connection to postgres database in php

I am making a connection with postgres database but there is an error that I can not determine, following the codes: Config.php : define('DB','sistema_postgres'); define('HOST','localhost'); define('USER','postgres'); define('PASS','123');...
asked by 24.03.2016 / 15:04
0
answers

python relationship in neo4j

I have the following code where I am migrating a relational database to neo4j. I made a node for each latitude and longitude sensor and a distinct node for every rainfall recorded in my database. db = GraphDatabase("http://localhost:7474",...
asked by 29.03.2016 / 20:36
1
answer

How to know the current connection that the system is using in CakePHP 3.0?

Hello, I'm working with two types of connections on databases with different settings. I want to know how I can get the current connection that the page is running dynamically. I currently use this: use Cake\Datasource\ConnectionManager;...
asked by 29.01.2016 / 19:37