Skip site navigation (1) Skip section navigation (2)

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

From: "Avram" <bogdan(dot)avram(at)ulpmm(dot)u-strasbg(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1530: search on uuid indexed article returns no resultat
Date: 2005-03-08 08:55:45
Message-ID: 20050308085545.66929F0DA3@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1530
Logged by:          Avram
Email address:      bogdan(dot)avram(at)ulpmm(dot)u-strasbg(dot)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> Mthodes
</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> Mthodes
</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> Mthodes </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> Mthodes </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> Mthodes
</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> Mthodes
</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> Mthodes
</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> Mthodes
</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);

Responses

pgsql-bugs by date

Next:From: Markus BertheauDate: 2005-03-08 11:33:32
Subject: BUG #1531: rotated log truncation broken
Previous:From: Tom LaneDate: 2005-03-08 08:07:13
Subject: Re: BUG #1528: Rows returned that should be excluded by WHERE clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group