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

From Kevin Crenshaw
Subject Problem inserting a row containing GUIDs
Date
Msg-id 20051027144058.2CCFDD6D71@svr1.postgresql.org
Whole thread Raw
Responses Re: Problem inserting a row containing GUIDs
Re: Problem inserting a row containing GUIDs
List pgsql-novice

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. 

 

Any help would be appreciated.

 

Here is a little more info:

 

OS – Windows XP Pro SP2

Postgresql v8.0.3

Provider – NPGSQL

 

Pg_log entries –

 

2005-10-27 09:23:16 LOG:  unexpected EOF on client connection

2005-10-27 09:23:44 ERROR:  syntax error at or near "dd72" at character 440

2005-10-27 09:24:07 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 09:24:07 LOG:  unexpected EOF on client connection

2005-10-27 09:26:46 NOTICE:  drop cascades to function sp_get_stakeholders(text)

2005-10-27 09:27:10 ERROR:  syntax error at or near "fd93b5" at character 466

2005-10-27 09:28:21 LOG:  unexpected EOF on client connection

2005-10-27 09:51:01 ERROR:  syntax error at or near "b3" at character 43

2005-10-27 09:51:45 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 09:51:45 LOG:  unexpected EOF on client connection

2005-10-27 09:52:32 ERROR:  syntax error at or near "a5" at character 48

2005-10-27 09:52:56 LOG:  unexpected EOF on client connection

2005-10-27 09:53:40 ERROR:  syntax error at or near "b6" at character 126

2005-10-27 09:54:44 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 09:54:44 LOG:  unexpected EOF on client connection

2005-10-27 09:56:36 ERROR:  syntax error at or near "b6" at character 126

2005-10-27 09:57:11 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 09:57:11 LOG:  unexpected EOF on client connection

2005-10-27 09:58:37 ERROR:  syntax error at or near "b6" at character 126

2005-10-27 09:59:22 LOG:  unexpected EOF on client connection

2005-10-27 10:00:14 ERROR:  syntax error at or near "43" at character 75

2005-10-27 10:00:50 LOG:  unexpected EOF on client connection

2005-10-27 10:01:40 ERROR:  syntax error at or near "43" at character 75

2005-10-27 10:01:49 LOG:  unexpected EOF on client connection

2005-10-27 10:03:24 ERROR:  syntax error at or near "43" at character 75

2005-10-27 10:04:43 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 10:04:43 LOG:  unexpected EOF on client connection

2005-10-27 10:05:11 ERROR:  syntax error at or near "10" at character 216

2005-10-27 10:06:43 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

     

2005-10-27 10:06:43 LOG:  unexpected EOF on client connection

2005-10-27 10:08:09 ERROR:  syntax error at or near "af13e9" at character 438

 

SAMPLE GUID:

40af13e9-71dd-4e41-8e8a-2d323066e7d9

 

Thanks again for you help,

 

Kevin

pgsql-novice by date:

Previous
From: Neil Saunders
Date:
Subject: Re: Database design advice
Next
From: Ted Rolle
Date:
Subject: tcpip dumps of txn