On Nov 25, 2007 7:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> What about the table schemas?
The schema is in the dump. That's the main reason why I've sent the
dump to both of you.
Anyway, here it is:
db=# \d themelang
Table "public.themelang"
Column | Type | Modifiers
------------------+------------------------+-----------
codeth | character varying(3) | not null
codelang | character varying(3) | not null
libtheme | character varying(70) | not null
motsclesmetatags | character varying(500) |
descriptifmeta | character varying(500) |
motcleoverture_l | character varying(100) |
motcleoverture_c | character varying(100) |
liencourt | character varying(30) |
baselinetheme | character varying(300) |
ordrenewsletter | integer |
Indexes:
"pk_themelang" PRIMARY KEY, btree (codeth, codelang)
db=# \d vilsite
Table "public.vilsite"
Column | Type | Modifiers
---------------------+-----------------------+--------------------
codevil | character varying(3) | not null
codelang | character varying(3) | not null
codepays | character varying(3) | not null
regionwap | character varying(3) |
codedep | character varying(3) |
codetypevil | character varying(1) | not null
ouverte | integer | not null
codeinteret | character varying(1) | not null
familleville | character varying(1) | not null
codevilpostale | character varying(8) |
capitale | integer | not null
codemeteodirect | character varying(5) |
libvilpubwoo | character varying(10) |
population | integer |
codeinsee | character varying(5) |
petiteville | integer | not null default 0
logincommercial | character varying(20) |
logincommercialprec | character varying(20) |
Indexes:
"pk_vilsite" PRIMARY KEY, btree (codevil)
db=# \d vilsitelang
Table "public.vilsitelang"
Column | Type | Modifiers
----------+-----------------------+-----------
codevil | character varying(3) | not null
codelang | character varying(3) | not null
libvil | character varying(50) | not null
trafic | integer |
Indexes:
"pk_vilsitelang" PRIMARY KEY, btree (codevil, codelang)
Foreign-key constraints:
"fk_vilsitel_vilsitela_vilsite" FOREIGN KEY (codevil) REFERENCES
vilsite(codevil) ON DELETE CASCADE
--
Guillaume
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
