Table with Field Serial - Problem

From: Yostin Vargas <yostinv(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Table with Field Serial - Problem
Date: 2013-10-31 14:31:37
Message-ID: CAPMdYjB-DZO7V2oNDV0o+Z=qRtpSQ4vYjPoqg6v1fZqTnBS7dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with only one Field ID type Serial Autonumeric and is a PK,
i want insert a new record but it show me error Not null violation, but if
i put a value the first INSERT work correctly but the next Insert it Show
me error Unique violation,

So i try adding a new field in this table and put a value null to this
field, and the ID Autonumeric work .

Exist a way to do it only with a field, i'm working with PHP???

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-10-31 14:38:38 Re: Explanantion on pgbouncer please
Previous Message si24 2013-10-31 14:25:21 Explanantion on pgbouncer please