[GENERAL] "pltcl" function.

What is error in this statement of “pltcl” function.   set var   'SENDING EMAIL TO: '||$mailto||' from: '||$mailfrom||' with: '||$emailserver   I am getting this error: ERROR:  wrong # args: should be "set varName ?newValue?" Regards Dinesh Pandey  

Re: [GENERAL] [PATCHES] Exception handling: Oracle's "SQLERRM" keyword option?

"Dinesh Pandey" <[EMAIL PROTECTED]> writes: > Pls help me or send me some example. Please do not post requests for help on pgsql-patches ... there is no Postgres list on which they are further off-topic. regards, tom lane ---(end of broadcast)-

[GENERAL] Exception handling: Oracle's "SQLERRM" keyword option?

Hi,   I have installed PostgreSQL 8.0.1 on Solaris 9.   I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.   In Oracle we can get error message from "SQLERRM" keyword and insert messages into log table.   How can I get error message/error code in P

Re: [GENERAL] "Could not read block" during vacuum

[EMAIL PROTECTED] writes: > 2005-04-16 00:00:53 ERROR: could not read block 52 of > relation "idx_ef_hash": Input/output error > Googling didn't turn up useful information on this problem. Can anyone > tell me whether this error indicates a disk problem, OS problem, known > postgres bug,

[GENERAL] "Could not read block" during vacuum

My company's product is developing a product using postgres 7.4.6 on a Linux 2.6.10 or 11 kernel, (don't have the exact version handy). We do "vacuum verbose analyze" daily. Two days after the database was created and loaded with a small amount of data (megabytes), the postgres logs had this line:

Re: [GENERAL] managing kernel

You'll probably want to take a look at this performance tuning reference: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html and this annotated configuration file: http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html -tfo -- Thomas F. O'Connell Co-Founder, Informatio

Re: [GENERAL] Help! "Access is Denied" Installation on WinXP rolled

log file it tells me to check before it deletes it in the rollback it says repeatedly something about "access is denied". Below is the actual install log (or a small portion of it, near the end where the error occurs). Any ideas? Regards, Abe p.s. this is a repost from my initial post on th

Re: [GENERAL] SQL Question

Julian Scarfe wrote: From: "Alex" <[EMAIL PROTECTED]> - How can i select only the newest record for each ProdId ? 100| 2005-04-01 200| 2005-04-01 DISTINCT ON was made for this and on the similar tables I have performs rather more efficiently than using a subquery. select distinct on (Prod

[GENERAL] Help! "Access is Denied" Installation on WinXP rolled back

Hi All! I googled for a solution to my problem and then searched the PostgreSQL site for solutions and since neither produced an answer I thought I'd see if anyone else out there knows how to resolve my dilemna... Any assistance is appreciated! Essentially what happens is that I just attemp

Re: [GENERAL] managing kernel

OK, I have RTFM:-) SHMALL Total amount of shared memory available (bytes or pages) if bytes, same as SHMMAX; if pages, ceil(SHMMAX/PAGE_SIZE) These values should be the same. I've changed that now. Still my second question is valid though. Are there any other values I should consider chang

[GENERAL] managing kernel

My sysadmin has changed the values for shmall to 256MB (268435456) and shmmax to 1GB (1073741824) and I wonder if these values seem ok to you. We are working on a linux system (2.4 kernel) and have 2 GB RAM at our disposal. I have this large database running (15 million records). Are there any oth