Questions tagged as 'postgresql'

Tagged questions
1
answer

Error trying to access certain bank information

I'm trying to access certain information from my database, but the following error is occurring: Excerpt where debugging occurs: IdHTTP := TIdHTTP.Create(nil); IdHTTP.Port := 80; IdHTTP.Connect(-1); IdHTTP.Request.BasicAuthentication...
asked by 11.11.2016 / 14:43
1
answer

Is it possible to leave connectionString dynamically?

I have read something and know that it is possible to leave a connectionString dynamically in an ASP.NET MVC application. But is it possible to create n connections where each authenticated user on the system has its own connection to a part...
asked by 12.08.2016 / 15:57
1
answer

How to measure the amount of disk space required for an ALTER TABLE operation?

I need to make some changes to one of the tables to add new columns. The problem is that I can not at all. I get the following error:   PG: DiskFull: ERROR: could not extend file "base / 1672994 / 5557167.4":   No space left on device. HINT:...
asked by 08.04.2016 / 12:52
1
answer

Java - Class does not display requested information

Good morning, I need to fix a problem when I request in the "dao.Acess" the get of the Class model.User returns empty = null. When it is called: doLogin (model.Access access) I can see the information through JOptionPane now when I do the...
asked by 02.12.2015 / 12:03
1
answer

How to calculate the time difference between certain hours? [duplicate]

public function checks($request) { $token = $this->count->All(); foreach($token as $tokens){ $tokens->system_contador_user_update_at With this I get the time it is written to the bank with type of field timestamp wit...
asked by 01.08.2017 / 14:29
1
answer

XML configuration

In the configuration of pMapper (Mapserver framework for PHP), there is this configuration which I am in doubt as to how to configure it. <dsn encoding="UTF-8">pgsql://postgres:postgres@localhost/db</dsn> Would it be som...
asked by 27.11.2014 / 20:56
1
answer

Retrieving malformed string when containing accented words

In my application I'm having trouble fetching the data in the PostgreSQL database, accented words being retrieved from the database and dealing with DataReader are coming poorly formatted as in the image below. In the correct formatte...
asked by 03.11.2014 / 22:01
1
answer

Change ids by include in shortcode gallery in Wordpress

I'm using Postgre and when creating image galleries the shortcode is automatically generated like this: [gallery ids="1,2,3,4,5"] . But this database does not accept 'ids', I should put 'include', thus: [gallery include="1,2,3,4,5"]...
asked by 05.08.2014 / 15:49
1
answer

PDO insert does not work

Before you ask me the question, I have already consulted other topics here from the OS and found no solution. I'm trying to make a simple insert and as soon as I squeeze the whole script simply nothing happens, the screen remains blank. I alread...
asked by 03.10.2014 / 21:38
1
answer

Trigger for a Select

I would like to know if it is possible to execute a Trigger when a SELECT is performed in a certain table, for example: CREATE TABLE IF NOT EXISTS "Conversa" ( "idConversa" SERIAL NOT NULL, "idEmissorConversa" INT NOT NULL, "idReceptorCo...
asked by 11.10.2014 / 15:59