Tagged Questions

1
vote
1answer
37 views

How to log data change in postgresql?

This question may seem to be a possible duplicate of some other questions that are related to this topic. I've found some similar questions(some questions were asked years back and discussion on the ...
0
votes
0answers
20 views

PostgreSQL server not able to start

I am using PostgreSQL server for my application. I am trying to implement secure connection using SSL certificate. I modified ssl property to "on" in postgresql.conf. I am generate self-signed ...
0
votes
0answers
31 views

postgres 8.4 - errors when loading data from file

I'm loading data from files and some of the files have text that is ISO-8859 encoded mixed-in with text that is UTF-8 encoded. postgres stops and shows an error when the ISO-8859 encoded lines are ...
0
votes
0answers
50 views

Converting PostgreSQL mod log into statements

I just recently switched from MySQL to PostgreSQL for a database that is on my local machine. I export the entire database to another machine (laptop) when I do on-site research where I don't have ...
0
votes
0answers
107 views

How does one remove foreign-keys if the table they're on doesn't exist?

Scenario: DELETE FROM table_x WHERE id not in (1,2,3,4) Response: update or delete on table "table_x" violates foreign key constraint "fk1" on table "table_y" DETAIL: Key (table_x_id)=(7) is still ...