Postgres' REFERENCES

[Anon]

Ciao,

I have a table ville (id_ville, name_ville)
id_ville name_ville
1 London
4 Berlin

id_ville is a PRIMARY KEY for ville

I also have a user table (id_user, name, id_ville), and id_ville is REFERENCES ville

When I make an
INSERT INTO user VALUES ('10', 'John', '4');

I have an error which tells me that '4' is a reference that does not exists in table ville.

Is it normal or is it a know bug ?
I use PostgreSQL 7.1.2.

Thank you for your help,

[[deleted]]

Try using a number instead of a string:

INSERT INTO user VALUES (10, 'John', 4);