Re: [GENERAL] Some Problems - Shall I reinstall the DB?

2011-02-01 Thread vwu98034
In regarding of log message, I get the following error message on my application for the connection problem and there is NOT any error messages in the PG log file. It is the same with DbVisualizer - not error messages in the PG log file. ~~

[GENERAL] Some Problems - Shall I reinstall the DB?

2011-01-31 Thread vwu98034
The 8.x version of PostgreSQL has been installed on my PC for quite few years. It has been problem free until recently. The first problem I have is that a connection can't be established after the PC just starts up although the DB is started. I have to restart it to solve this problem each time

[GENERAL] Issues on Insert Data From Existing Table

2011-01-01 Thread vwu98034
I need to update the database schema to add a new table based on an original table. The existing table is the following: create table shop_image ( id SERIAL UNIQUE primary key, shop_fk int references vsm_shop (id) on delete cascade, pa