| From: | Vassiliadis Spyros <aceteam(at)it(dot)teithe(dot)gr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | referencial integrity constraint bug in version 7.0 beta 5 |
| Date: | 2000-04-27 12:10:55 |
| Message-ID: | Pine.SGI.4.05.10004271450360.7627-100000@aetos.it.teithe.gr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am running a slackware 7 linux box (kernel 2.2.14 g++2.91.66) and i 've
installed the ver 7 beta 5. So i had the following problem
I suppose when you make a constraint statement for reference key theere
should be a check for the fields names , example:
create table tbl1 (p1 int2 primary key,p2 int4);
and:
create table tbl2(p1 int2 primary key, p2 int2, constraint lala foreign
key (p2) references tbl1(po1));
(the o in po1 was misstyped)
there was no error message( i didn't noticed it too)
when i 've tryed the :
insert into tbl1 values (1,1);
i got the the error that the there was no field 'po1' for the constraint
procedure to check.
maybe that's because it's a beta version ........
if this was reported earlier excuse me but i am new to the list
Spyros Vasileiadis
Salonika Greece
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 2000-04-27 14:53:53 | Re: Revisited: Transactions, insert unique. |
| Previous Message | Michael Ansley | 2000-04-27 11:39:58 | RE: sequences and Transactions |