Re: Problem inserting a row containing GUIDs - Mailing list pgsql-novice

From John DeSoi
Subject Re: Problem inserting a row containing GUIDs
Date
Msg-id 5B4F2DAA-3955-4FBE-9D5A-63B5E92FC70F@pgedit.com
Whole thread Raw
In response to Problem inserting a row containing GUIDs  ("Kevin Crenshaw" <kcrenshaw@viscient.com>)
List 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


pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: tcpip dumps of txn
Next
From: Michael Fuhr
Date:
Subject: Re: Problem inserting a row containing GUIDs