Re: Problem inserting a row containing GUIDs

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Kevin Crenshaw <kcrenshaw(at)viscient(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem inserting a row containing GUIDs
Date: 2005-10-27 18:40:14
Message-ID: 5B4F2DAA-3955-4FBE-9D5A-63B5E92FC70F@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Oct 27, 2005, at 10:29 AM, Kevin Crenshaw wrote:

> I am currently receiving an error message each time I try to insert
> a row. The row contains several GUID values, and when I try to do
> the insert I get an error like ‘Syntax error at or near ‘a45’.
> I’ve tried to enclose the GUIDs in quotes but I still get the error.

Assuming your GUID is defined as varchar or text, are you quoting the
GUID with single quotes like a string?

If that is not the problem, show your table definition and insert/
update statement.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-10-27 18:45:51 Re: Problem inserting a row containing GUIDs
Previous Message Bruce Momjian 2005-10-27 15:22:35 Re: tcpip dumps of txn