> The best guess I have is that this is a failure in > Solaris' syslog. > There is certainly no such message anywhere in the > Postgres backend > code. Try changing your syslog setting to 0 (log > only to stderr) > and see if logging to a plain file works better. > > BTW, PG 7.3.4 is pretty darn old, you really ought > to update. > Dear tom lane Thank you for your advice. I tried it, but nothing change. I tried excuting the long sql on the console and a DB tool called CSE(Common SQL Environment), it worked. but in a java program using JDBC connection it doesn't work. Ken ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend