Martin Neimeier wrote:
> Hello,
> some additional informations:
>
> - if i execute the subselect alone, it works fine !.
> - The same select statement works with sybase and oracle, so i think its a legal
>statement.
> - After reading in the sql2-standard, i have found nothing which restricts uni
Hello,
I'd like to file the following bug report for two 'bugs' that may (or may
not) have the same origin.
The context is the following :
* PostgreSQL v7.0.2 from RPMs :
' PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 '
postgresql-jdbc-7.0.2-2
postgresql-odbc-7.0.2-2
All:
I have the following table:
create table try (
ordnum int4 primary key,
type char(3),
CONSTRAINT type_check CHECK(type in ('bid', 'ord', 'rma'))
);
The named constraint works find here.
However when I do:
> psql ati -c "alter table try drop constraint type
Yeah, there are a lot of geometric operators that neglect to check for
null inputs :-(. I believe I have fixed this class of problems in
current sources.
regards, tom lane
Hi tom,
Thanks for the answer.
Can you tell me about the files concerned by this fix of yours ? I intend to
make a patch for the 7.0.2 sources, because, 1) I won't use a CVS version on
my production server [ and 2) I'm using the rpm-built postgresql and I didn't
manage to easily turn the CVS v
IIRC, ALTER TABLE ... DROP CONSTRAINT isn't implemented yet,
so that's going to fail in any case. ADD CONSTRAINT is implemented
for foreign keys (in 7.0) and should be implemented for check
constraints in 7.1.
Stephan Szabo
[EMAIL PROTECTED]
Ludovic LANGE <[EMAIL PROTECTED]> writes:
> Can you tell me about the files concerned by this fix of yours ? I intend to
> make a patch for the 7.0.2 sources, because, 1) I won't use a CVS version on
> my production server [ and 2) I'm using the rpm-built postgresql and I didn't
> manage to easi
