Re: [SQL] nexval error duplicate key

>Hi Ron,
>
>On Thu, 14 Feb 2002, ron wrote:
>
>> I set up a table
>>
>> field
>> id
>> name_insert
>>
>> I used the code something like the following:
>>
>> CREATE TABLE name_table (
>> id SERIAL,
>> name_insert TEXT
>> );
>>
>>
>> When I use postgresql admin I get DATA 2
>> the number is OUT of order
>
>Order doesn't matter.

**** some how it got deleted here ****

I would update one of the records in the middle so that the number
sheme would be like

1 john
2 mary
3 smith

then in the modification it would be (if I modified 2 mary)

1 john
3 smith
2 bertha

Then if I added a new record I would get a duplication error

>
>> NOW when I add a new value
>>
>> it give me an error that states:
>>
>> --------------------------------------------------------
>>
>> Error Occurred While Processing Request
>>
>> Error Diagnostic Information
>>
>> ODBC Error Code = 08S01 (Communication link failure)
>>
>> Error while executing the query; ERROR: Cannot insert a duplicate key
>> into unique index name_pkey
>>
>> The error occurred while processing an element with a general
>> identifier of (CFQUERY), occupying document position (1:61) to
>> (1:110).
>> --------------------------------------------------------
>
>What does your INSERT statement look like? You'd want something like
>this ...
>
>INSERT INTO name_table (name_insert) VALUES ("Mary");
>
>This lets postgres deal with the id numbering itself.
>
>- James

Yip I use

<CFQUERY datasource="data_name" NAME="field_name">

INSERT INTO field_here

(
field_go_here
)

VALUES

(
'information'
)

</cfquery>

this is here then when I update then insert that's when I get the error

Ron Sattar

--

Sattar Group, Inc. ICQ 153 46 249
Voice 773 725 3445 Fax 773 442 0064
http://www.SattarGroup.com