[BUGS] JDBC-Interface - Behaviour on Update, Insert or Delete returning ResultSets - Inconsistency to Console & ODBC

2007-08-18 Thread Otto Weichselbaum
Dear Ladies and Gentlemen, I do not know if this can even be considered a bug, but I would be pleased, if somebody could make a statement on this: environment: PostgreSQL 8.1 and 8.2 Redhat and WinXP While using views calling functions on INSERT, UPDATE and DELETE via according rules,

Fwd: [BUGS] error while starting database

2007-08-18 Thread Nitin Saxena
Hi, When i m using ps -ax |grep postgres [EMAIL PROTECTED] /root]# ps -ax |grep postgres 994 tty1 S 0:00 su - postgres when i am using netstat -a , it gives Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address Sta

Re: [BUGS] error while starting database

2007-08-18 Thread Nitin Saxena
Hi All the command such asgives following output; 1: :ls -a/tmp: No such file or directory 2 : "rm -f/tmp/.s.PGSQL.5432" bash: rm -f/tmp/.s.PGSQL.5432: No such file or directory 3:"ps -ax|grep postgres" bash: ps -ax|grep postgres: command not found Does PID in postmast

Re: [BUGS] error while starting database

2007-08-18 Thread Douglas Toltzman
Since you do not have a /tmp folder in your filesystem, it may be that the server cannot create the socket file and so it will not start. You cannot telnet to port 5432, because no service is listening on that port. The PostgreSQL server is not started. I'm sorry I didn't answer you last

Re: [BUGS] error while starting database

2007-08-18 Thread Gregory Stark
"Douglas Toltzman" <[EMAIL PROTECTED]> writes: > In any case, the server specifically calls out an error creating > "/tmp/.s.PGSQL.5432". I would start by creating a world-writable /tmp > folder. FWIW the correct permissions for /tmp on Unix machines is 1777. It should look like this (note the "t

Re: [BUGS] error while starting database

2007-08-18 Thread Tom Lane
"Nitin Saxena" <[EMAIL PROTECTED]> writes: > All the command such asgives following output; > 1: :ls -a/tmp: No such file or directory >2 : "rm -f/tmp/.s.PGSQL.5432" > bash: rm -f/tmp/.s.PGSQL.5432: No such file or directory The reason these commands aren't working for you is

Re: [BUGS] error while starting database

2007-08-18 Thread Douglas Toltzman
All I can tell you, based on this information, Nitin, is that your postmaster is not started, and it is failing to start for some reason. Without any additional information, there is absolutely nothing I can tell you. Try listing the /var/lib/pgsql/data folder. Verify that it does exist

Re: [BUGS] JDBC-Interface - Behaviour on Update, Insert or Delete returning ResultSets - Inconsistency to Console & ODBC

2007-08-18 Thread Kris Jurka
On Sat, 18 Aug 2007, Otto Weichselbaum wrote: While using views calling functions on INSERT, UPDATE and DELETE via according rules, I noticed an inconsistent behaviour of the JDBC-interface of postgres;  an INSERT-, UPDATE- or DELETE-statement producing tuples as return-value (in our case thro

[BUGS] reindexdb in Windows

2007-08-18 Thread Euler Taveira de Oliveira
Hi, reindexdb.exe is not installed with PostgreSQL in Windows. Is it intentional or a bug? -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.pos