[GENERAL] Cursor Not Found

I have an embedded sql program with a while loop. I declare and open a cursor before the while. The fetch forward next is inside the while. The first time through the while the cursor works perfectly the second time I get the error: sql error PerformPortalFetch: portal "foo_crsr" not found I h

[GENERAL] Installing Postgres w/RH9

I just installed RH9 on a new machine and installed postgres in the installation process. I got the following error when trying to start the postmaster so... I tried removing the postgres software then reinstalling. rpm first said the software was not installed then when I tried to reinstall r

[GENERAL] EMBEDDED VACUUM SOLVED!!!!!!!!!!!

Michael, The -t option for ecpg DOES work like a charm THANK YOU!! I am also posting this to GENERAL, I noticed 2-3 other people who have been having the same exact problem! Thanks Again, Lynn Quoting Michael Meskes <[EMAIL PROTECTED]>: > On Sun, Nov 30, 2003 at 11:08:51PM -0700, [EMAIL

Re: [GENERAL] Better Unilization of Memory

Doug, Thanks... Looks like I need to do some tuning! Lynn Quoting Doug McNaught <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] writes: > > > In looking at top, I have noticed when doing some > > long queries that RAM memory is only being used > > at 1-3%. While, CPU often jumps to 97, 98, even > >

[GENERAL] Better Unilization of Memory

processing? Thanks for your help! Lynn Tilby [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: 7.3.5 release (was: Re: [GENERAL] SELECT with row>32k hangs over

Quoting Bruce Momjian <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > > > Perhaps I am not the appropriate one to mention this (and if you > already > > have a QA group,GREAT!!!) since I am not a > > Postgres developer but... Is there any QA group that looks at the > > design specs and does

Re: [GENERAL] Recomended FS

Really solid microcode actually reads the sectors just written and confirms the write at the hardware level by comparing it with what is in the controller memory. It then returns with a successfull confirmation or an error if differences were detected. Any data storage device controller, disk,

Re: 7.3.5 release (was: Re: [GENERAL] SELECT with row>32k hangs over

Perhaps I am not the appropriate one to mention this (and if you already have a QA group,GREAT!!!) since I am not a Postgres developer but... Is there any QA group that looks at the design specs and does independent desk checking and test writting according to those specs and then tests the code

[GENERAL] Attribute 'rtrim' is repeated

s.strk_sym_cmplt) AND s.c_p = 'C'; ERROR: Attribute 'rtrim' is repeated I understand that rtrim is an underlying function to trim. Is this a BUG??? How do I fix this problem? Thanks for your help! Lynn Tilby ---(end of broadcast)-

[GENERAL] no records returned

running - (PostgreSQL) 7.1.3 I have loaded a table with stock market data. - - - ZRAN|2003-09-29|20030929| 731487| 20.81| 20. ZRAN|2003-09-30|20030930| 731488| 19.43| 20.1 ZRAN|2003-10-01|20031001| 731489| 19.82| 19.9 ZRAN|2003