Re: Adding constraint to existing table.

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: David Bryan <d_bryan_remove(at)onebox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding constraint to existing table.
Date: 2002-01-15 13:54:55
Message-ID: 20020115135455.D13890@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How about:

> create index recid29 on sales_sales ( recid );

create unique index recid29 on sales_sales ( recid );

> create index sales_id30 on sales_sales_detail ( sales_id );

create unique index sales_id30 on sales_sales_detail ( sales_id );

?

Patrick

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-01-15 14:41:27 Re:
Previous Message Jason Priebe 2002-01-15 12:37:40 Re: Calling a Stored Procedure using PHP