[gnome-db] Invalid GdaDataModelIter
- From: Andrea Zagli <azagli libero it>
- To: gnome-db-list gnome org
- Subject: [gnome-db] Invalid GdaDataModelIter
- Date: Mon, 26 Sep 2011 12:52:11 +0200
what can cause an invalid GdaDataModelIter?
i have some tables, where a simple "SELECT * FROM <tablename>" returns  
an invalid iter after gda_data_model_iter_move_next; on other tables  
of the same db it works
i'm using libgda 4.2.10 from git HEAD, with postgresql 8.3.14, under  
windows (under gnu/linux with postgresql 9.1 it works)
2 examples
CREATE TABLE atti
(
  id integer NOT NULL,
  numero character varying(10) DEFAULT ''::character varying,
  data date,
  anno integer DEFAULT 0,
  protocollo character varying(50) DEFAULT ''::character varying,
  data_protocollo date,
  gen_intervento character varying(255) DEFAULT ''::character varying,
  note character varying(255) DEFAULT ''::character varying,
  abitabilita integer DEFAULT 0,
  n_piani integer DEFAULT 0,
  n_appartamenti integer DEFAULT 0,
  pi_sottosuolo real DEFAULT 0,
  vani_utili real DEFAULT 0,
  accessori real DEFAULT 0,
  altri_vani real DEFAULT 0,
  tot_vani real DEFAULT 0,
  volumetria real DEFAULT 0,
  rec_collegato integer DEFAULT 0,
  visibile boolean DEFAULT false,
  id_tipi_atto integer DEFAULT 0,
  id_efficacia integer DEFAULT 0,
  pr_cod_prat_civilia integer DEFAULT 0,
  id_edifici integer DEFAULT 0,
  CONSTRAINT atti_pkey PRIMARY KEY (id )
)
CREATE TABLE atti_vie
(
  id_atti integer NOT NULL,
  id_vie integer NOT NULL,
  civico character varying(50) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT atti_vie_pkey PRIMARY KEY (id_atti , id_vie , civico )
)
CREATE TABLE visure
(
  id integer NOT NULL,
  data timestamp without time zone,
  id_modalita_richiesta integer DEFAULT 0,
  id_richiedenti integer DEFAULT 0,
  id_qualita_di integer DEFAULT 0,
  protocollo character varying(20) DEFAULT ''::character varying,
  note text DEFAULT ''::text,
  data_conferma_richiesta timestamp without time zone,
  note_conferma_richiesta text DEFAULT ''::text,
  tipo_conferma_richiesta integer DEFAULT 0, -- 1 - confermata...
  status character varying(1) DEFAULT ''::character varying,
  CONSTRAINT visure_pkey PRIMARY KEY (id )
)
CREATE TABLE visura_atti
(
  id integer NOT NULL,
  id_visure integer,
  id_atti integer,
  numero character varying(10) DEFAULT ''::character varying,
  id_tipi_atto integer,
  data date,
  protocollo character varying(50) DEFAULT ''::character varying,
  data_protocollo date,
  intestatari character varying(255) DEFAULT ''::character varying,
  indirizzi character varying(255) DEFAULT ''::character varying,
  note text DEFAULT ''::text,
  status character varying(1) DEFAULT ''::character varying,
  tipo_conferma_richiesta integer DEFAULT 0, -- 1 - confermata...
  data_conferma_richiesta timestamp without time zone,
  note_conferma_richiesta text,
  tipo_esito_ricerca integer DEFAULT 0, -- 1 - pronto...
  data_esito_ricerca timestamp without time zone,
  note_esito_ricerca text DEFAULT ''::text,
  data_da_consegnare timestamp without time zone,
  note_da_consegnare text DEFAULT ''::text,
  data_consegna timestamp without time zone,
  note_consegna text DEFAULT ''::text,
  data_ritiro timestamp without time zone,
  note_ritiro text DEFAULT ''::text,
  data_da_ritirare timestamp without time zone,
  note_da_ritirare text DEFAULT ''::text,
  data_invio_email timestamp without time zone,
  CONSTRAINT visura_atti_pkey PRIMARY KEY (id )
)
with "atti" it returns invalid, but with "atti_vie" it works
with "visure" it works, but with "visura_atti" it returns invalid
thanks in advance
[
Date Prev][
Date Next]   [
Thread Prev][
Thread Next]   
[
Thread Index]
[
Date Index]
[
Author Index]