[SQL] Re: [HACKERS] 7.1beta4 bug creating a certain table

2001-01-30 Thread Stephan Szabo
On Tue, 30 Jan 2001, Kovacs Zoltan wrote: > > It appears to me that this is correct, since there is no constraint > > on the first column that says that those three columns form a unique > > key *by themselves*. I believe there were bugs in the code that checked > > for this error before ... > >

[SQL] Re: [HACKERS] 7.1beta4 bug creating a certain table

2001-01-30 Thread Kovacs Zoltan
On Mon, 29 Jan 2001, Tom Lane wrote: > Kovacs Zoltan <[EMAIL PROTECTED]> writes: > > CREATE TABLE pakolas_cikktetel ( > > pakolas int4 not null, > > cikk int4 not null, > > minoseg int4 not null, > > sorszam int4 check (sorszam > 0), > > helyrol int4, > > helyre int4, > >

Re: [HACKERS] 7.1beta4 bug creating a certain table

2001-01-29 Thread Tom Lane
Kovacs Zoltan <[EMAIL PROTECTED]> writes: > CREATE TABLE pakolas_cikktetel ( > pakolas int4 not null, > cikk int4 not null, > minoseg int4 not null, > sorszam int4 check (sorszam > 0), > helyrol int4, > helyre int4, > mennyi numeric(14,4) not null , > lezarva bool d

[HACKERS] 7.1beta4 bug creating a certain table

2001-01-29 Thread Kovacs Zoltan
I cannot create a certain table in 7.1beta4. With 7.0.2 there was not any problem. -- CREATE TABLE pakolas_cikktetel ( pakolas int4 not null, cikk int4 not null, minoseg int4 not null, sorszam int4 check (