Skip site navigation (1) Skip section navigation (2)

SQL error in PostgreSQL 6.5.3

From: Bradford Hovinen <hovinen(at)webinbox(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: SQL error in PostgreSQL 6.5.3
Date: 1999-11-30 04:49:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I am trying to enter the following query from a Perl script:

insert into messages (subject, cc_addr, priority, owner_id, date_sent,
reply_to_addr, to_addr, date_stored, body, from_addr, id) values ('Re:
Unplugging pessimism', '', '3', '1048578', 'Thu, 07 Oct 1999 08:04:46
-0700', '', 'Peter Herz <peter(at)websocietyinc(dot)com>', 'now', 'Thanks Peter
-- and thanks for passing that on to Slashdot. Glad you liked
it, it\'s a very rich topic.


>From: Peter Herz <peter(at)websocietyinc(dot)com>
>To: janelle(at)salon(dot)com
>Subject: Unplugging pessimism
>Date: Thu, Oct 7, 1999, 2:38 AM

>Wonderful article! I especially enjoyed your inference towards the end.
>- Peter Herz
', '"Janelle Brown" <janelle(at)mail(dot)salonmagazine(dot)com>', '1048628')

When I run it from the Perl script, it results in the error `parameter
unknown'. However, when I paste it in an xterm and invoke it in the
command line client, it works perfectly. Any ideas what might be causing

I'm running PostgreSQL 6.5.3 with DBI 1.06 and DBD::Pg 0.93 on Perl
5.00503 all on Red Hat Linux 6.0. Thanks in advance for your help.

-Bradford Hovinen

"Prudence is a rich, ugly old maid courted by Incapacity."

        - William Blake, "Proverbs of Hell," 1793


pgsql-general by date

Next:From: Adriaan JoubertDate: 1999-11-30 06:23:05
Subject: Re: [HACKERS] Re: [GENERAL] Update of bitmask type
Previous:From: Bradford HovinenDate: 1999-11-30 04:33:41
Subject: SQL error in PostgreSQL 6.5.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group