unique constraint on multiple colums does not work

#41

Coniglio Sgabbiato ha scritto:

Quote:

[CUT]
can you post the definition of your table, so we can see what's
unknown> to
us?

CREATE TABLE interfaces
(
unknown
CONSTRAINT if_uniq UNIQUE (name, device)
)
;

here:

CREATE TABLE interfaces
(
id serial NOT NULL,
device integer NOT NULL,
name character varying(255) NOT NULL,
inet_addr inet,
CONSTRAINT interfaces_pkey PRIMARY KEY (id),
CONSTRAINT interfaces_device_fkey FOREIGN KEY (device)
REFERENCES devices (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT if_uniq UNIQUE (name, device),
CONSTRAINT interfaces_inet_addr_key UNIQUE (inet_addr)
)
WITH (OIDS=FALSE);
ALTER TABLE interfaces OWNER TO postgres;
I'm sorry, I finally found the problem and fixed it by myself: among

thousands of records collected on the network and inserted in automated
way there was only one I missed that held "dirty" data.
Sorry for the waste of your time, and thank you very much for the help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

unique constraint on multiple colums does not work

comp.databases.postgresql comp.databases.postgresql

Re: unique constraint on multiple colums does not work - 01-22-2008 , 08:29 AM