From: | "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com> |
---|---|
To: | "'Michael Fuhr'" <mike(at)fuhr(dot)org> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problem inserting a row containing GUIDs |
Date: | 2005-10-31 18:11:27 |
Message-ID: | 20051031181131.DC69BDB56F@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks to everyone for replying to my question. I recently installed the
TreeList control from DevExpress and the only time that I have the problem
is when I try to update the database using values that are modified by the
TreeList control. If I submit the updates without using the control, the
update succeeds as expected. I am currently working with DevExpress to find
a solution since it looks like it's their software that is causing the
problem.
Has anyone else had a problem making inserts or updates to a database while
using a DevExpress TreeList control that uses a string value in the
ParentField and KeyField properties?
Thanks again for your help,
kevin crenshaw
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Michael Fuhr
Sent: Thursday, October 27, 2005 2:46 PM
To: Kevin Crenshaw
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Problem inserting a row containing GUIDs
On Thu, Oct 27, 2005 at 10:29:51AM -0400, 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.
What's the exact insert statement? A simple but complete test case
might reveal the problem. That is, all SQL statements that somebody
could execute in an empty database to create a table and perform an
insert that fails as you describe.
> OS - Windows XP Pro SP2
> Postgresql v8.0.3
> Provider - NPGSQL
What's your code look like? Have you tried the same insert using
psql or some other client?
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Faulhaber | 2005-10-31 21:19:16 | Reverse order sort in multi-column indexes |
Previous Message | Michael Fuhr | 2005-10-31 15:24:02 | Re: PL/pgSQL Trigger - Variable for shema? Like TG_RELNAME |