| From: | Rodrigo De León <rdeleonp(at)gmail(dot)com> |
|---|---|
| To: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Change a field to sequence (serial) |
| Date: | 2007-02-25 06:07:35 |
| Message-ID: | a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-sql |
On 2/24/07, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> wrote:
> Hi lists,
>
> Is there possible to change a bigint field (primary key) to a serial ?
> If yes how it is possible ?
>
> I was trying to do that but the pgadmin don't enable the change to sequence.
>
> What is the problem my friends ?
>
> Regards
> Ezequias
> http://ezequiasrocha.blogspot.com/
See:
http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL
http://www.postgresql.org/docs/8.2/static/functions-sequence.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erwin Brandstetter | 2007-02-25 18:46:57 | Re: Crashing v1.6.2 with a syntax error |
| Previous Message | Seb | 2007-02-25 05:22:31 | Re: pgadmin as main postgresql GUI interface |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Jones | 2007-02-25 12:39:14 | Very large IN-clause is slow, but how to rewrite it? |
| Previous Message | Phillip Smith | 2007-02-25 01:23:15 | Re: Insert based in a select |