| From: | Jason Hihn <jhihn(at)paytimepayroll(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Help with array constraints |
| Date: | 2003-04-03 14:48:26 |
| Message-ID: | NGBBLHANMLKMHPDGJGAPKEGGCGAA.jhihn@paytimepayroll.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Two tables (simplified):
CREATE TABLE _test (
id CHAR(1),
PRIMARY KEY(id)
);
INSERT INTO _test VALUES ('a');
INSERT INTO _test VALUES ('b');
CREATE TABLE test (
letter CHAR(1)[3] NOT NULL REFERENCES _test(id)
PRIMARY KEY(letter)
);
CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey' for table
'test'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Unable to identify an operator '=' for types 'character[]' and
'character'
You will have to retype this query using an explicit cast
Can someone please explain that in English? I want ALL the letter field
values to be checked against what is in the _test table id field when a row
is inserted. For example, 'a' and 'b' is in the _test table now, if I insert
an 'a' or 'b' into test, it will suceed. If I insert a 'c' or 'd' it should
fail.
What must I do?
I am on v7.2.
Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-03 14:48:36 | Re: unable to dump database, toast errors |
| Previous Message | Lonni J Friedman | 2003-04-03 14:42:25 | Re: unable to dump database, toast errors |