Questions tagged as 'postgresql'

Tagged questions
0
answers

invalid byte sequence for encoding utf8

I'm doing a query in the PostgreSQL database. The database encoding is SQL_ASCII . When I make a query that returns special characters like "Ç" and "~", the following error occurs: Error Code: 500 Error Desscription: ERROR: invalid byte...
asked by 11.07.2018 / 15:00
0
answers

take photo with webcam and save in postgresql database with php and java

I want to take a photo with the webcam and save it to a postgresql database. So far, I have the page to activate the camera and take photo and pre-view mounted and the upload script done, but the image recorded in the bank is 0 Kb. Below the...
asked by 18.07.2018 / 14:10
1
answer

Trigger and another field

In postgres I have two tables, test1 (id_test1, name) and test2 (id_test2, test1_id_test1, phone) In the PHP form I have the field name and phone number. When I write name in test1, a trigger replicates the primary key in test2 (test1_id_test...
asked by 06.07.2018 / 17:22
0
answers

"Django celery beat" table is not filled

I started in a Django project that already had Django Celery Beat and some records of some Task's in their tables: django_celery_beat_crontabschedule django_celery_beat_intervalschedule django_celery_beat_periodictask django_celery_b...
asked by 10.07.2018 / 14:58
0
answers

Postgis - Invalid Geometries in Cutouts

Objective: To calculate the area of shp1 that intersects (st_intersection) with shp2 in continental proportion. The shp1 and shp2 are present information for the Brazilian biome of the whole Cerrado, that is, they are relatively large. shp...
asked by 05.07.2018 / 17:28
1
answer

Create an Oracle Agent / Job for PostgreSQL

I would like to know if it is possible to create an agent / job in Oracle to query the data of a given table and insert the data of this table into another table that is in PostgreSQL. Or you can get through the PostgreSQL PGAgent to create a...
asked by 21.06.2018 / 15:34
4
answers

Select with columns reporting incorrect data

Hello I have one more problem regarding a search in the database. I want to make a SELECT that searches for information such as company code, social reason, year and values (summed). At first, the search for information without the company na...
asked by 08.06.2018 / 15:38
2
answers

How to Pass Parameters in JasperReports

Hello everyone, good afternoon, I have a question that is killing me. I have a project that has to print a report that contains two lists and two tables. My problem is this, I'm not intresting how jasper interprets the data that is passed to it,...
asked by 02.06.2018 / 02:01
0
answers

Modeling Banks Financial Institution

I am starting a personal project for my apprenticeship, an application simulating a financial institution system, I would first use the following products: checking account, credit agreement (loans). I came across the following difficulty, what...
asked by 29.05.2018 / 18:19
1
answer

Loss of access to the database after restarting the virtual machine

I have a database in a VM, could restart the VM and access the database after this normally But now if I restart the VM, when I try to access the database with pgAdmin III I get the following message:    Server does not listen   ...
asked by 30.05.2018 / 22:22