From: | Marco Giraldo <m(dot)giraldo(at)stt-telefonia(dot)it> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | R: BUG #14121: Constraint UNIQUE |
Date: | 2016-05-05 10:45:45 |
Message-ID: | A337E1A4B98E9F49B4AE7A95D0583FB60196D9EDE9@SRV11.stt-telefonia.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
Excuse me for the late but I have many work problem.
I hope I understand what you mean.
But I do this constraint CREATE TABLE (pippo date UNIQUE, pluto date) etc…
And I don’t can remove this restriction.
Da: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Inviato: venerdì 29 aprile 2016 17:59
A: Marco Giraldo <m(dot)giraldo(at)stt-telefonia(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Oggetto: Re: [BUGS] BUG #14121: Constraint UNIQUE
On Fri, Apr 29, 2016 at 3:35 AM, <m(dot)giraldo(at)stt-telefonia(dot)it<mailto:m(dot)giraldo(at)stt-telefonia(dot)it>> wrote:
The following bug has been logged on the website:
Bug reference: 14121
Logged by: Marco
Email address: m(dot)giraldo(at)stt-telefonia(dot)it<mailto:m(dot)giraldo(at)stt-telefonia(dot)it>
PostgreSQL version: 9.5.0
Operating system: Windows 7
Description:
Hi
I have a problem with UNIQUE constraint.
I don't understand the difference from TYPE type UNIQUE(when I declare a
column of the table) and ALTER TABLE table ADD CONSTRAINT column UNIQUE
(column).
How can I remove the UNIQUE option from TYPE declaration?
You might want to try re-phrasing your question.
Specification of a constraint within the column specification of CREATE TABLE is optional. If you don't want to do it there, don't.
There is no difference between specifying a single-column constraint on the column definition or as a table constraint.
I'd suggest you upgrade to 9.5.2 - and 9.5.3 in a couple of weeks.
David J.
________________________________
DICHIARAZIONE DI ESONERO DI RESPONSABILITA'
Le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservate e sono, comunque, destinate esclusivamente alle persone o alla Societa' sopraindicati.
La diffusione, distribuzione e/o copiatura del documento trasmesso da parte di qualsiasi soggetto diverso dal destinatario e' proibita, sia ai sensi dell'art. 616 c.p., che ai sensi del D.Lgs. n. 196/2003.
Se avete ricevuto questo messaggio per errore, vi preghiamo di distruggerlo e di informarci immediatamente per telefono al +39 036226941
From | Date | Subject | |
---|---|---|---|
Next Message | John McKown | 2016-05-05 11:37:06 | Re: BUG #14121: Constraint UNIQUE |
Previous Message | Fabien COELHO | 2016-05-05 07:32:48 | Re: [BUGS] Breakage with VACUUM ANALYSE + partitions |