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

2011-02-01 Thread Tom Lane
vwu98...@lycos.com writes: > When I try to access PG from PC command prompt with the psql command, I get > the following error message: > psql: server closed the connection unexpectedly >This probably mean the server terminated abnormally before or while > processing the request. > This ti

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

2011-02-01 Thread Adrian Klaver
On Tuesday, February 01, 2011 12:03:20 pm vwu98...@lycos.com wrote: > When I try to access PG from PC command prompt with the psql command, I get > the following error message: > > psql: server closed the connection unexpectedly >This probably mean the server terminated abnormally before or w

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

2011-02-01 Thread vwu98034
addr=011D): Invalid argument" As I can tell, the PG log file doesn't tell the whole story. The version of PG is 8.0. - Original Message - From: "Adrian Klaver" To: vwu98...@lycos.com Cc: "pgsql-general" Sent: 2011年1月31日 星期一 下午01时30分09秒 GMT -08:00 US/C

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

2011-01-31 Thread Adrian Klaver
On 01/31/2011 01:18 PM, vwu98...@lycos.com wrote: The DB connection problem has nothing to do with Hibernate. As I have said that the problem can be solved by restarting the DB. This problem occurs with my application as well as DdVisualizer. So know we know it is a generic connection problem.

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

2011-01-31 Thread Adrian Klaver
On 01/31/2011 12:49 PM, vwu98...@lycos.com wrote: 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

Re: [GENERAL] some problems

2000-08-24 Thread Tom Lane
Roodie <[EMAIL PROTECTED]> writes: > ERROR: ExecEvalExpr: unknown expression type 108 Sub-selects in constraint expressions don't work at the moment :-(. An easy workaround is to put the sub-select in a function and call the function from your constraint. regards, tom la