> --- On Tue, 6/29/10, Diez B. Roggisch <[email protected]> wrote:
> What does the reflection of
> the table say, if you say
>
> psql > \d cities;
>
>
> ?
>
> Diez
Hello,
Here's my psql session
(Sorry, french locales)
<psql>
testdb=> \d cities;
Table « public.cities »
Colonne | Type | Modificateurs
------------+-------------------+---------------------------------------------------------
id | integer | non NULL Par défaut,
nextval('cities_id_seq'::regclass)
name | character varying |
country_id | integer |
Index :
"cities_pkey" PRIMARY KEY, btree (id)
"ix_cities_country_id" btree (country_id)
Contraintes de clés étrangères :
"cities_country_id_fk" FOREIGN KEY (country_id) REFERENCES countries(id)
testdb=>
</psql>
It seems that the FK Constraint doesn't forbid Null values. I also tried to put
a nullable=False on the relation, but it seems to be an unrecognized keyword
argument. (Got : TypeError: __init__() got an unexpected keyword argument
'nullable').
Y.Chaouche
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en.
