FW: [ADMIN] pgsql function doesn't work

I don't understand this. Can anybody translate? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:51 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] pgsql function doesn't work Witam Jestem na urlopie (nie czytam maili). Wracam

Re: [ADMIN] pgsql function doesn't work

FROM pg_tables WHERE tablename = $1; IF FOUND THEN EXECUTE ''DROP TABLE'' || '' '' || $1; RETURN true; END IF; RETURN false; END;' LANGUAGE 'plpgsql'; HTH. -- Mel Jamero -Original Message- From: [EMAIL PROTECTED] [mailto:[EMA

[ADMIN] psql DBNAME -U USER (how to disable -U option?)

to get to the psql interface we execute: psql dbname -U user is it possible to disable the -U option such that a user cannot invoke the privileges of a database superuser such as postgres? tried looking up pg_hba.conf regarding 'password' authentication, the man pages and the archives but didn't

[ADMIN] best way to make incremental back-ups?

Hi! What's the best way to make incremental back-ups? Is there a tool (GUI or otherwise, open source perhaps) for this? Red Hat Linux 7.2. PostgreSQL 7.1 thanks, Mel ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr

Re: [ADMIN] function in place of sub-select

Hi Bhuvan! One way might be to create a C (or C++) program that emulates your my_func function. We've tried doing this and did some benchmarks that show that the system works quite faster when you take out the stored procedures/functions and "translate" them into C programs.