I upgraded to 7.3.9, and that fixed the problem.
Thanks,
Chuck
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 26, 2005 10:12 AM
> To: Haron, Charles
> Cc: pgsql-admin@postgresql.org; Richard Poole
> Subject: Re: [ADMIN
***
BTW, I'm using v7.3.3
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 24, 2005 12:14 PM
> To: Haron, Charles
> Cc: pgsql-admin@postgresql.org; Richard Poole
> Subject: Re: [ADMIN] Trouble Escaping Quotes
>
> "H
and exit.
Please reconnect to the database system and repeat your query.
Failed.
> -Original Message-
> From: Richard Poole [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 23, 2005 11:59 AM
> To: pgsql-admin@postgresql.org
> Cc: Haron, Charles
> Subject: Re: Troub
Chuck
> -Original Message-
> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 20, 2005 3:12 PM
> To: Haron, Charles
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Trouble Escaping Quotes
>
> Haron, Charles wrote:
> > Hello,
> &
Hello,
I'm using a perl function in my PosgreSQL database to send an email.
However, field data containing single quotes causes the function to fail.
I'm having trouble escaping the quotes. Sample function definition follows.
If company_name is Bob's Fixit, the function will fail.
CREATE OR R
Hello,
I want to use Mail::Sender in a PL/Perl function. In order to use the
Mail::Sender module, do I simply use a 'use' statement in the function
definition (i.e. "use Maile::Sender;")?
Regards,
Charles
---(end of broadcast)---
TIP 9: the planne
Not only will you have performance and corruption issues, you'll also have
problems with the lock file. And security is a pain to manage. We have
replaced all of our multi-user Access databases with PostgreSQL.
Chuck
> -Original Message-
> From: Geoffrey [mailto:[EMAIL PROTECTED]
> Sent:
Is it posible to define a function with no return value?
I've something like "CREATE FUNCTION set_to_active(int4) RETURNS NULL AS
..." but I get an parse error at or near "NULL"
Thanks,
Chuck
---(end of broadcast)---
TIP 7: don't forget to increase