Re: [ADMIN] Help with Error

2009-09-19 Thread Tom Lane
John P Weatherman writes: > I am intermittently seeing a job fail with: > ERROR: Too many updates/deletes within transaction. Reader gang not able > to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002 > pid=15588) > SQL state: XX000 A bit of searching of the archives would've

Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl

2009-09-19 Thread u235sentinel
I'm curious if there are any thoughts on what I'm missing here. The 64 bit postgres runs just fine without openssl. As soon as I tie that in I get headaches :/ Thanks! u235sentinel wrote: John P Weatherman wrote: It would also be helpful to know what your LD_LIBRARY_PATH looks like and if

[ADMIN] Wrong column default values

2009-09-19 Thread Andre Rothe
Hi, I have installed Postgres 8.3.8 on Fedora Linux. If I create a table, the default values will be set by the database to NULL::timestamp without time zone for a timezone column and to NULL::character varying for a varchar column. How I can prevent such a behaviour? Both column defaults shou

[ADMIN] Help with Error

2009-09-19 Thread John P Weatherman
All, I am intermittently seeing a job fail with: ERROR: Too many updates/deletes within transaction. Reader gang not able to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002 pid=15588) SQL state: XX000 Does anyone have any ideas what this really means? So far, waiting until

Re: [ADMIN] PostgreSQL 8.3

2009-09-19 Thread brahma tiwari
Hi John u need to give connection  details in hba.conf file With Regards!   Brahma Prakash Tiwari DBA Diginatives Content Solutions Pvt Ltd An ISO 9001:2000 certified company Think before you print. --- On Thu, 17/9/09, Johan Greyling wrote: From: Johan Greyling Subject: [ADMIN] PostgreS