| From: | "von Schwerdtner, Thomas (GXS, FPI)" <Thomas(dot)vonSchwerdtner(at)gxs(dot)com> |
|---|---|
| To: | "'Setyo Nugroho'" <snugroho(at)gmx(dot)net>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Can't add records |
| Date: | 2002-11-13 18:42:50 |
| Message-ID: | 3D808EC801AED111B0100008C75D5DDC13E453ED@roc05bxgeisge.is.ge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
>
> Wrote a small program using Qt. After some tests with another
> database,
> usingthe very same program, I found something erroneous in my
> program.
> - editing & deleting records: OK
> - adding records: NO
> I got this eror message:
>
> "QPSQL:unable to create query.
> Error: cannot insert a duplicate key into unique index route_pkey."
<snip/>
This usually means that your insert command is attempting to duplicate a
value in a sequence, which for your table looks to be the route_id column.
-Tom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Setyo Nugroho | 2002-11-13 18:44:50 | Can't add records |
| Previous Message | Joel Rodrigues | 2002-11-13 18:05:40 | Re: Display a function |