voila le message erreur dans la nouvelle monture de postgres9.3 et postgis 2.1 il n'existe plus srid (contrainte)
mais remplacé par st_srid dans les nouvelles versions donc erreur ci dessous

pg_restore: [archiver (db)] could not execute query: ERROR:  function public.srid(public.geometry) does not exist

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    Command was: CREATE TABLE pente_expo (
    x double precision,
    y double precision,
    pente double precision,
    exposition double ...
pg_restore: [archiver (db)] Error from TOC entry 8005; 0 206822 TABLE DATA pente_expo geniaux
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "pente_expo" does not exist
    Command was: COPY pente_expo (x, y, pente, exposition, exposition_dist_nord, gid, the_geom) FROM stdin;

la vrai structure de cette table d'origine dans la version postgres9.0.11 postgis 1.3  est
CREATE TABLE occupsol.pente_expo
(
  x double precision,
  y double precision,
  pente double precision,
  exposition double precision,
  exposition_dist_nord double precision,
  gid integer NOT NULL DEFAULT nextval('pente_expo_gid_seq'::regclass),
  the_geom geometry,
  CONSTRAINT pente_expo_pkey PRIMARY KEY (gid ),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 2154)
)
WITH (
  OIDS=FALSE
);

donc existe t'il une manip pour pallier ce probleme , merci beaucoup

ok merci
pn va passer par un pg_restore

bon Merci , peut etre une evolution que postgres pourrait prendre en compte !!!

merci rjuju je verrais cela !

jean Paul ton lien est mort @+

pour les doublons il faut faire
create table new_batiart as
(
select a.* from  batiart a
union
select b.* from  batiart b
);

et c'est fini cela va trés vite
Merci Gleu

merci c 'est plus rapide j'ai une autre table ou il y plus de 32 champs ,  comment faire creer 2 index multiples ?? merci
la voici ci dessous
voici ma seconde table ou il y a des doublons

CREATE TABLE locaux
(
  id_invar text,
  codpar text,
  ccodep character varying(2),
  ccodir character varying(1),
  ccocom character varying(3),
  invar character varying(10),
  cenr character varying(2),
  ccopre character varying(3),
  ccosec character varying(2),
  dnupla character varying(4),
  dnubat character varying(2),
  descr character varying(2),
  dniv character varying(2),
  dpor character varying(5),
  ccoriv character varying(4),
  ccovoi character varying(5),
  dnvoiri character varying(4),
  dindic character varying(1),
  ccocif character varying(4),
  dvoilib character varying(30),
  cleinvar character varying(1),
  locinc character varying(1),
  codparc character varying(14),
  id_insee character varying(5),
  codpro text,
  gpdl character varying(1),
  dsrpar character varying(1),
  dnupro character varying(6),
  jdatat character varying(8),
  dnufnl character varying(6),
  ccoeva character varying(1),
  ccitlv character varying(1),
  dteloc character varying(1),
  gtauom character varying(2),
  dcomrd character varying(3),
  ccoplc character varying(1),
  cconlc character varying(2),
  dvltrt character varying(9),
  cc48lc character varying(2),
  dloy48a character varying(9),
  top48a character varying(1),
  dnatlc character varying(1),
  dnupas character varying(8),
  gnexcf character varying(2),
  dtaucf character varying(3),
  cchpr character varying(1),
  jannat character varying(4),
  dnbniv character varying(2),
  hlmsem character varying(1),
  postel character varying(1),
  dnatcg character varying(2),
  jdatcgl character varying(8),
  dnutbx character varying(6),
  dvltla character varying(9),
  janloc character varying(4),
  ccsloc character varying(2),
  fburx character varying(1),
  gimtom character varying(1),
  cbtabt character varying(2),
  jdtabt character varying(4),
  jrtabt character varying(4),
  jacloc character varying(4),
  pphsd bigint,
  pphad bigint,
  depdist bigint,
  pnh bigint,
  pnhsd bigint,
  dnbppr numeric,
  dnbsam numeric,
  dnbcha numeric,
  dnbcu8 numeric,
  dnbcu9 numeric,
  dnbsea numeric,
  dnbann numeric,
  dnbpdc numeric,
  dsupdc numeric,
  dsueic bigint,
  vsurzt numeric,
  dsudep numeric,
  typologt integer,
  invar2 character varying(20)

entreprise db ( linux-x86 64)
a cette adresses la http://www.enterprisedb.com/products-se … pgdownload
on telecharge le .bin , et stackbuilder s'ouvre

version
Installer version Version 9.1.1-1
Installer version Version 9.0.5-1 
ne passe pas sous kubuntu
merci

merci