Questions tagged as 'postgresql'

Tagged questions
1
answer

PostgreSQL - Foreign Key after import

I have a database in Firebird and I'm passing the data to PostgreSQL, so I made an application that reads Firebird data and inserts it in PostgreSQL. The database is from a supermarket but has little time to use, the bank in FB weighs just ov...
asked by 24.11.2017 / 01:17
0
answers

Doubt with Image fields in Postgres

I used the sql down to view the size of all the tables in the database, it returned me a total of 98 MB, but since the database has images that are written as Binary and they are not in a table, I would like to do a backup of the bank without th...
asked by 23.11.2017 / 18:43
1
answer

Postgres - Permissions within the function

I'm setting up a system where the user will have very limited access, just view and perform certain specific functions. Scenario (with root user) It has three tables: Person Device Access And three 4 functions: sync_person (...
asked by 05.12.2017 / 20:24
0
answers

PostgreSQL connection problem

My newly installed PostgreSQl gave this error:    Could not connect to server: Connection refused (0x0000274D / 10061) Is   the server running on host "localhost" (:: 1) and accepting TCP / IP   connections on port 5432? could not connect to...
asked by 13.11.2017 / 18:25
0
answers

The pgsql driver is not currently installed

I'm using WampServer with Postgres installed on my local machine and when I go to the application the following error occurs:    Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'The pgsql driver is not c...
asked by 06.11.2017 / 16:35
0
answers

PostgreSQL compare time between two hours, and if you exceed the hours of the day, limit until 23:59

I am making a query sql on ruby-on-rails on PostgreSQL where I check if user input is between hora_entrada and hora_entrada + (hora_entrada + limite_banco_horas) and same for hora_fim , in a certain...
asked by 09.11.2017 / 17:35
2
answers

Xamarin (Visual Studio) x POSTGRESQL

Good evening guys, I work in a commercial automation software development company, Alterdata, and today I work directly with PostgreSql, and I have a lot of affinity with it. I would like to know if I have how to sync Postgres with Visual Stu...
asked by 04.11.2017 / 04:43
1
answer

Inserting data into the bank gives the error "duplicate key value violates uniqueness constraint"

I tried to insert the data, but it gives the Duplicate value of the key violates the uniqueness constraint . I've already put all the primary and secondary keys. Error MSG:    rg.postgresql.util.PSQLException: ERROR: Duplicate Viola key v...
asked by 23.10.2017 / 13:44
1
answer

Permission to change only one table column in PostgreSQL

Good evening! I'm using PostgreSQL and it has a table called Products. When the user visits a product through the site I give an UPDATE on that table to increment the visits column. The problem is that the database user can only have read...
asked by 27.10.2017 / 04:57
1
answer

Problem with the relationship in the Motherboard (Inheritance) in PostgreSql

I have the Mother Table Payment: CREATE TABLE pagamento ( pagcod serial not null, CONSTRAINT pk_pag PRIMARY KEY (pagcod) ) And the two daughters tables Money and Credit Card: CREATE TABLE dinheiro ( desconto numeric(10,2) DEFA...
asked by 02.11.2017 / 06:32