Re: [ADMIN] Can someone please send me an original

2001-08-15 Thread Oliver Elphick
[EMAIL PROTECTED] wrote: >pg_hba.confg? > >My Postgresql is unable to read the one which i have. Do give more details than that! What is the error? Spelling? It is pg_hba.conf If you have that, are the file permissions right? Is the file in the right place? -- Oliver Elphick

Re: [ADMIN] ever growing pkey files

2001-08-15 Thread matthew . copeland
Well, I reindexed on 7.0.3, and that worked. I also upgraded, and that worked with my code also, so ignore the not working comment. Thanks for the help, Matthew M. Copeland On Tue, 14 Aug 2001 [EMAIL PROTECTED] wrote: > > Yeah, VACUUM doesn't shrink indexes presently (it's on the TODO > >

[ADMIN] insert failed

2001-08-15 Thread Srinivasa Rao Chava
Hi, when we try insert into a table, the inset is failing with cach look up failure error. Below is the complete statement and error generated. DEPG=> insert into EXTRANET_SECTION (ID, section_name, parent,extranetname) values (255,' Main',0, 'test'); ERROR: fmgr_info: function 19464: cache

Re: [ADMIN] insert failed

2001-08-15 Thread Stephan Szabo
On 15 Aug 2001, Srinivasa Rao Chava wrote: > Hi, > when we try insert into a table, the inset is failing with cach look > up failure error. > > > Below is the complete statement and error generated. > > DEPG=> insert into EXTRANET_SECTION (ID, section_name, > parent,extranetname) values (255

Re: [ADMIN] insert failed

2001-08-15 Thread Srinivasa R Chava
Yes, there is a trigger on the table. Is there any problem with triggers? -- Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississ

Re: [ADMIN] insert failed

2001-08-15 Thread Stephan Szabo
On Wed, 15 Aug 2001, Srinivasa R Chava wrote: > Yes, there is a trigger on the table. Is there any problem with > triggers? It probably is saying it can't find the trigger function. This usually happens if you drop and recreate the function without dropping and recreating the trigger. --