Re: [ADMIN] Trouble Escaping Quotes

2005-02-12 Thread Haron, Charles
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

Re: [ADMIN] Trouble Escaping Quotes

2005-01-26 Thread Haron, Charles
*** 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

Re: [ADMIN] Trouble Escaping Quotes

2005-01-24 Thread Haron, Charles
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

Re: [ADMIN] Trouble Escaping Quotes

2005-01-21 Thread Haron, Charles
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, > &

[ADMIN] Trouble Escaping Quotes

2005-01-20 Thread Haron, Charles
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

[ADMIN] Perl Modules in PL/Perl functions

2004-07-09 Thread Haron, Charles
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

Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Haron, Charles
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:

[ADMIN] Define function with no return value?

2003-08-29 Thread Haron, Charles
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