From: | Jiří Pavlovský <jiri(at)pavlovsky(dot)eu> |
---|---|
To: | Alban Hertroys <haramrae(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: utf8 errors |
Date: | 2013-06-26 10:39:33 |
Message-ID: | 51CAC4E5.3090808@pavlovsky.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 26.6.2013 12:19, Alban Hertroys wrote:
> On 26 June 2013 11:17, Jiří Pavlovský <jiri(at)pavlovsky(dot)eu
> <mailto:jiri(at)pavlovsky(dot)eu>> wrote:
>
> On 26.6.2013 10:58, Albe Laurenz wrote:
> > Jirí Pavlovský wrote:
> >> I have a win32 application.
> >> LOG: statement: INSERT INTO recipients (DealID,
> >> Contactid) VALUES (29009, 9387)
> >> ERROR: invalid byte sequence for encoding "UTF8": 0x9c
> >>
> >>
> >> But the query is clean ascii and it doesn't even contain the
> mentioned
> >> character.
>
>
> Can you show a \d+ of the recipients table? I suspect there is a
> trigger attached to inserts on the table or some other side-effect
> that's causing the issue.
>
Here you go. But I don't think that is the cause. I'm getting these
errors on tables as well. Actually when I copy and paste the offending
queries from log into pgAdmin it runs without an error.
Table "public.recipients"
Column | Type | Modifiers | Storage | Stats target | Description
-----------+---------+-----------+---------+--------------+-------------
contactid | integer | | plain | |
dealid | integer | | plain | |
Indexes:
"recipients_dealid_key" UNIQUE CONSTRAINT, btree (dealid, contactid)
"fki_recipients_contactid" btree (contactid)
Foreign-key constraints:
"$1" FOREIGN KEY (contactid) REFERENCES contacts(contactid) ON
UPDATE CASCADE ON DELETE CASCADE
"recipients_dealid_fk" FOREIGN KEY (dealid) REFERENCES
subscription(dealid) ON UPDATE CASCADE ON DELETE CASCADE
Has OIDs: yes
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2013-06-26 11:32:02 | Re: utf8 errors |
Previous Message | Alban Hertroys | 2013-06-26 10:19:24 | Re: utf8 errors |