am Thu, dem 12.10.2006, um 19:39:37 -0400 mailte Tom Lane folgendes:
> I think what you're really wishing for is an error cursor position.
> 8.2 has the infrastructure for this, eg
>
> regression=# create table foo (a int, b int, c int);
> CREATE TABLE
> regression=# select a, b, q from foo;
> ER
On Oct 12, 2006, at 7:39 PM, Tom Lane wrote:
That's not necessarily all that much help, if you've got so many FK
constraints in your command that you don't know exactly where to look.
I think what you're really wishing for is an error cursor position.
8.2 has the infrastructure for this, eg
re
Jonathan Vanasco <[EMAIL PROTECTED]> writes:
> Yes, I know that part. The error message is bad though, because it
> doesn't tell me exactly where the error is.
> I got as an error
> ERROR: column "id" referenced in foreign key constraint does not exist
> I should have gotten something l
On Oct 12, 2006, at 3:44 PM, A. Kretschmer wrote:
Can you show us your SQL? The message is clear: you create a new table
with a foreign key to an other table that doesn't exist. An example:
Yes, I know that part. The error message is bad though, because it
doesn't tell me exactly where the
am Thu, dem 12.10.2006, um 15:27:08 -0400 mailte Jonathan Vanasco folgendes:
>
> I got a really bad error message in postgres on a CREATE TABLE in 8.1.0:
>
> ERROR: column "id" referenced in foreign key constraint does not
> exist
>
> That seems odd-- I mean, I know I obviously ma
