An easy question about creating a primary key

From: "Ligia Pimentel" <lmpimentel(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: An easy question about creating a primary key
Date: 2001-11-29 23:22:22
Message-ID: 9u6gco$7fb$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-odbc pgsql-sql

Hello.

I'm using postgres 7.1. I have an easy question...

I want to create a primary key constraint on an existing table. The
documentation says I can't . Please confirm. If this is true... How can I
rename the existing table so I can create the new one and copy the data?

Thank you

Ligia

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-11-29 23:26:40 Re: Second call for platform testing
Previous Message Joe Conway 2001-11-29 23:06:21 Re: Second call for platform testing

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-11-29 23:53:26 Re: connect error
Previous Message Igor Kovalenko 2001-11-29 21:01:04 Re: Getting Started with ODBC

Browse pgsql-sql by date

  From Date Subject
Next Message Peter T. Brown 2001-11-29 23:50:44 contracting tables
Previous Message Tom Lane 2001-11-29 23:13:05 Re: PL/pgSQL loops?