pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Rodrigo De León <rdeleonp@gmail.com>
To: Pgadmin-Support <pgadmin-support@postgresql.org>
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Change a field to sequence (serial)
Date: Sun, 25 Feb 2007 01:07:35 -0500
Message-ID: <a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com> (raw)
In-Reply-To: <55c095e90702241537q50704797g36665b6c0b2dd81b@mail.gmail.com>
References: <55c095e90702241537q50704797g36665b6c0b2dd81b@mail.gmail.com>

On 2/24/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.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

view thread (2+ messages)

Message-ID: <a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com>
Permalink:  ../a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com/
Also on:    postgresql.org/message-id/a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rdeleonp@gmail.com, pgadmin-support@postgresql.org
  Subject: Re: [SQL] Change a field to sequence (serial)
  In-Reply-To: <a55915760702242207u7165360dr2b19129a489ef6e8@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox