* Tom Lane <[EMAIL PROTECTED]> [2004-03-04 11:24:11 -0500]:
> Double quotes are for names (identifiers). Single quotes are
> for string literals (constants).
BTW: is this general SQL syntax or just PostgeSQL ?
mysql does no distinction (which is IMHO very unclean), and it gets
even worse si
On 2004.03.04 17:19 Greg Stark wrote:
Greg Stark <[EMAIL PROTECTED]> writes:
> It's great to know which constraint was violated but that doesn't
really help
> you figure out *why* it was violated.
On further thought it would never be feasible to do what the other
poster is
really looking for. At l
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> It'd be nice if the error message from a REFERENCES
> constraint mentioned the column name into which
> the bad data was attempted to be inserted.
You mean like this?
regression=# create table foo (pk int primary key);
NOTICE: CREATE TABLE / PRIMARY K
