* Tom Lane [EMAIL PROTECTED] [2004-03-04 11:24:11 -0500]:
snip
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
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
FYI,
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.
In PostgreSQL 7.3:
sandbox= insert into foo (id, b) values (3, 2);
ERROR: b_is_fkey referential integrity violation - key referenced from
foo not
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 KEY