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

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 (view raw or flat)
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

pgsql-novice by date

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

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