Re: making a rule and know when it is violated - Mailing list pgsql-jdbc

From Nico
Subject Re: making a rule and know when it is violated
Date
Msg-id cvdach$2hd4$1@news.hub.org
Whole thread Raw
In response to making a rule and know when it is violated  ("Nico" <nicohmail-postgresql@yahoo.com>)
List pgsql-jdbc
I don't know how to write it in postgresql.
"Guillaume Cottenceau" <gc@mnc.ch> schreef in bericht
news:87acpxlwkx.fsf@meuh.mnc.ch...
> "Nico" <nicohmail-postgresql 'at' yahoo.com> writes:
>
>> Hello,
>> I want to make a rule in phpPgAdmin(PostgreSQL 7.3.8-RH ).
>> Then I want to intercept any violation on that rule in java.
>> Here is the table creation code:
>> CREATE TABLE "tblUser" (
>>     "UserID" serial NOT NULL,
>>     "UserName" character varying(50) NOT NULL,
>>     "UserPass" character varying(50) NOT NULL,
>>     "UserRoleID" integer DEFAULT 3 NOT NULL
>> );
>> Now it's imperative that the field UserRoleID has maximum one record that
>> contains the integer 1. Possible other values are 2 and 3. They are
>> allowed
>> to exist in more than one record.
>> After that I need to know in java how to know when a violation of this
>> rule
>> occurs.
>
> Why not using a trigger function in postgres?
>
> --
> Guillaume Cottenceau
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>



pgsql-jdbc by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: making a rule and know when it is violated
Next
From: Valentin Rodionov
Date:
Subject: setObject(i,null) and general "setNull" problems