Thread: BUG #1530: search on uuid indexed article returns no resultat

BUG #1530: search on uuid indexed article returns no resultat

From
"Avram"
Date:
The following bug has been logged online:

Bug reference:      1530
Logged by:          Avram
Email address:      bogdan.avram@ulpmm.u-strasbg.fr
PostgreSQL version: 7.4.6 testing
Operating system:   Debian kernel 2.4.18 testing (pg-uuid 0.01)
Description:        search on uuid indexed article returns no resultat
Details:

The SELECT command using a 'uuid' field indexed with pk_situation returns no
result. The error dissapear after the backup and the restore of the database
or after deleting the index.


--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 2211 (class 0 OID 0)
-- Name: DUMP TIMESTAMP; Type: DUMP TIMESTAMP; Schema: -; Owner:
--

-- Started on 2005-03-08 09:57:21 Paris, Madrid


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- TOC entry 1967 (class 1259 OID 43638)
-- Dependencies: 2206 2 903 903
-- Name: situation; Type: TABLE; Schema: public; Owner: postgres;
Tablespace:
--

CREATE TABLE situation (
    id uuid DEFAULT newid() NOT NULL,
    nom character varying(100) NOT NULL,
    description text,
    texteexpositif text NOT NULL,
    resultatattendu text NOT NULL,
    bibliographie text,
    datecreation timestamp without time zone NOT NULL,
    idseminaire uuid NOT NULL
);


ALTER TABLE public.situation OWNER TO postgres;

--
-- TOC entry 2210 (class 0 OID 43638)
-- Dependencies: 1967
-- Data for Name: situation; Type: TABLE DATA; Schema: public; Owner:
postgres
--

COPY situation (id, nom, description, texteexpositif, resultatattendu,
bibliographie, datecreation, idseminaire) FROM stdin;
47aa019e-8040-11d9-98e1-00e0180dcd8e    sdds    dsdsds    ds    dsds    dsdss    2005-02-16
17:29:15.27033    05a7c92a-4dbe-11d9-825d-00e0180dcd8e
f30351de-80b9-11d9-9d32-00e0180dcd8e    dssdsdd    fsdds    fdsfd    dsfsdf    dsfdsf    2005-
02-17 08:00:11.821739    05a7c92a-4dbe-11d9-825d-00e0180dcd8e
1a3f3eaa-80e4-11d9-9899-00e0180dcd8e    sdf    dsfdfs    sdf    sdf    dfsdfs    2005-02-17
13:01:56.537195    23693990-803f-11d9-8135-00e0180dcd8e
19105950-81d5-11d9-8d4b-00e0180dcd8e    dsf    sdfdsf    dsf    dsf    dsf    2005-02-18
18:47:03.25149    23693990-803f-11d9-8135-00e0180dcd8e
1f97042c-81d5-11d9-8d4b-00e0180dcd8e    fsd    sdfsdf    dfsfsd    sdffsd    dsffdsfds    2005
-02-18 18:47:14.214234    23693990-803f-11d9-8135-00e0180dcd8e
a6e6e062-8042-11d9-9818-00e0180dcd8e    dsf    dsfsdf    dsf    dfs    dsfdsf    2005-02-16
17:46:14.04676    23693990-803f-11d9-8135-00e0180dcd8e
f37e7418-8041-11d9-9f4e-00e0180dcd8e    dsf    dsf dsf    sdf sdf    sdf <FONT
size=2>\r\n<P></FONT><FONT color=#0000ff size=2>public</FONT><FONT size=2>
DataSet ListeSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}<FONT size=2></P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> DataSet
ListeSituationSeminaire(Guid IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>try</P></FONT><FONT
size=2>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2> Méthodes
</P></FONT></FONT><FONT color=#0000ff size=2><FONT
size=2>\r\n<P></FONT><FONT color=#0000ff size=2>public</FONT><FONT size=2>
DataSet ListeSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2><FONT color=#000000> Méthodes
</FONT></P>\r\n<P></FONT>public</FONT><FONT size=2> </FONT><FONT
color=#0000ff size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2> Méthodes </P></FONT>    sdf <FONT
size=2>\r\n<P></FONT><FONT color=#0000ff size=2>public</FONT><FONT size=2>
DataSet ListeSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2> Méthodes </P></FONT><FONT
size=2></FONT><FONT color=#0000ff size=2><FONT size=2>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> DataSet
ListeSituationSeminaire(Guid IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>try</P></FONT><FONT
size=2>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2><FONT color=#000000> Méthodes
</FONT></P></FONT><FONT size=2>\r\n<P></FONT><FONT color=#0000ff
size=2>public</FONT><FONT size=2> DataSet ListeSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2><FONT color=#000000> Méthodes
</FONT></P></FONT><FONT size=2>\r\n<P></FONT><FONT color=#0000ff
size=2>public</FONT><FONT size=2> DataSet ListeSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2><FONT color=#000000> Méthodes
</FONT></P>\r\n<P></FONT>public</FONT><FONT size=2> DataSet
ListeSituationSeminaire(Guid IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>try</P></FONT><FONT
size=2>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>return</FONT><FONT size=2>
PostgreSqlHelper.ExecuteDataset(</FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_ListeSituationSeminaire(:a)
as (Id uuid, DateCreation timestamp, IdSeminaire
uuid)",</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter("a", IdSeminaire)});</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>}</P>\r\n<P>}</P>\r\n<P></FONT><FONT
color=#0000ff size=2>public</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2> NombreSituationSeminaire(Guid
IdSeminaire)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>try</P></FONT><FONT size=2>\r\n<P>{</P>\r\n<P></FONT><FONT
color=#0000ff size=2>return</FONT><FONT size=2> (</FONT><FONT color=#0000ff
size=2>int</FONT><FONT size=2>)
PostgreSqlHelper.ExecuteScalar(</P>\r\n<P></FONT><FONT color=#0000ff
size=2>this</FONT><FONT
size=2>._ChaineConnexion,</P>\r\n<P>"Situation_NombreSituationSeminaire(:a)"
,</P>\r\n<P></FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2>
NpgsqlParameter[] {</P>\r\n<P></FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> NpgsqlParameter("a",
IdSeminaire)</P>\r\n<P>});</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (NpgsqlException
ExceptionSql)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2> ApplicationException(_MessageErreurSql,
ExceptionSql);</P>\r\n<P>}</P>\r\n<P></FONT><FONT color=#0000ff
size=2>catch</FONT><FONT size=2> (InvalidOperationException
ExceptionOperationInvalide)</P>\r\n<P>{</P>\r\n<P></FONT><FONT color=#0000ff
size=2>throw</FONT><FONT size=2> </FONT><FONT color=#0000ff
size=2>new</FONT><FONT size=2>
ApplicationException(_MessageErreurOperationInvalide,</P>\r\n<P>ExceptionOpe
rationInvalide);</P>\r\n<P>} </P>\r\n<P>}</P></FONT><FONT color=#0000ff
size=2>\r\n<P>#endregion</FONT><FONT size=2> Méthodes
</P></FONT>    2005-02-16 17:41:13.050158    05a7c92a-4dbe-11d9-825d-00e0180dcd8e
\.


--
-- TOC entry 2208 (class 16386 OID 43645)
-- Dependencies: 1967 1967
-- Name: pk_situation; Type: CONSTRAINT; Schema: public; Owner: postgres;
Tablespace:
--

ALTER TABLE ONLY situation
    ADD CONSTRAINT pk_situation PRIMARY KEY (id);


ALTER INDEX public.pk_situation OWNER TO postgres;

--
-- TOC entry 2209 (class 16386 OID 43646)
-- Dependencies: 1967 1940
-- Name: fk_situation_seminaire_idseminaire; Type: FK CONSTRAINT; Schema:
public; Owner: postgres
--

ALTER TABLE ONLY situation
    ADD CONSTRAINT fk_situation_seminaire_idseminaire FOREIGN KEY
(idseminaire) REFERENCES seminaire(id) ON DELETE CASCADE;


--
-- TOC entry 2215 (class 0 OID 0)
-- Name: DUMP TIMESTAMP; Type: DUMP TIMESTAMP; Schema: -; Owner:
--

-- Completed on 2005-03-08 09:57:21 Paris, Madrid


--
-- TOC entry 2214 (class 0 OID 0)
-- Dependencies: 1967
-- Name: situation; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE situation FROM PUBLIC;




CREATE UNIQUE INDEX pk_situation
  ON situation
  USING btree
  (id);
-- Operator Class: "uuid_ops"

-- DROP OPERATOR CLASS uuid_ops USING btree;

CREATE OPERATOR CLASS uuid_ops DEFAULT
   FOR TYPE uuid USING btree AS
   OPERATOR 1  <,
   OPERATOR 2  <=,
   OPERATOR 3  =,
   OPERATOR 4  >=,
   OPERATOR 5  >,
   FUNCTION 1  uuid_cmp(uuid, uuid);

Re: BUG #1530: search on uuid indexed article returns no resultat

From
Tom Lane
Date:
"Avram" <bogdan.avram@ulpmm.u-strasbg.fr> writes:
> The SELECT command using a 'uuid' field indexed with pk_situation returns no
> result. The error dissapear after the backup and the restore of the database
> or after deleting the index.

There is no uuid datatype in the standard Postgres distribution.  I
suppose this is a bug in uuid's comparison routines; I suggest reporting
it to wherever you got the uuid datatype from.

            regards, tom lane