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: