Hello again patchers,
Here is a proposed patch against 7.4.1 to check exact match
of foreign key types wrt the referenced keys, and to show
a warning if this is not the case.
This is an attempt to prevent stupid bugs such as :
CREATE TABLE foo(id INT4 NOT NULL PRIMARY KEY);
CREATE TABLE
Fabien COELHO [EMAIL PROTECTED] writes:
Here is a proposed patch against 7.4.1 to check exact match
of foreign key types wrt the referenced keys, and to show
a warning if this is not the case.
I think that this concern may be obsolete in CVS tip, at least for the
cases where we have indexable
Stephan Szabo [EMAIL PROTECTED] writes:
I'm really not sure that it makes sense to warn for the fk cases where the
semantics should be correct (if they're not we need to fix it or make it
an error) but in which an error might have been made by the user because
the types are different given
I can think of several cases where it might be reasonable for the types
to be different.
Sure. It's all about a warning, not about an error.
--
Fabien Coelho - [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your
Jon Jensen wrote:
On Sun, 29 Feb 2004, Andrew Dunstan wrote:
. changed source port reporting from host:port to host(port) to avoid
IP6 address ambiguity.
I have no idea how widespread this is, but recent versions of BIND write
it this way:
127.0.0.1#953
::1#953
Personally I'd kind