Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 6:04 PM, stan wrote: On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: On 9/15/19 10:46 AM, stan wrote: Forgot to cc the list again. Have to look at settings in mutt. What validity check? The check to see if it is the type enum. This would get solved a lot qu

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Tom Lane
stan writes: > On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: >> On 9/15/19 10:46 AM, stan wrote: >>> So, my test tell me that the validity check is done BEFORE an attempt to >>> insert (thus firing the trigger) occurs. >> What validity check? > The check to see if it is the type

Re: kind of a bag of attributes in a DB . . .

2019-09-15 Thread Chris Travers
On Sat, Sep 14, 2019 at 5:11 PM Albretch Mueller wrote: > just download a bunch of json info files from youtube data Feeds > > Actually, does postgresql has a json Driver of import feature? > Sort of There are a bunch of features around JSON and JSONB data types which could be useful. >

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Olivier Gautherot
Hi Stan, On Sun, Sep 15, 2019 at 2:47 PM stan wrote: > Forgot to cc the list again. Have to look at settings in mutt. > > > > > > > > > Sorry forgot to cc the list > > > > > > > > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: > > > > > On 9/15/19 8:33 AM, stan wrote: > > > > > >

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread stan
On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote: > On 9/15/19 10:46 AM, stan wrote: > > Forgot to cc the list again. Have to look at settings in mutt. > > > > > > > > > > > > Sorry forgot to cc the list > > > > > > > > > > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wro

Re: Variable constants ?

2019-09-15 Thread Peter J. Holzer
On 2019-08-15 16:56:57 -0400, stan wrote: > bossiness constants On 2019-09-02 13:31:14 -0400, stan wrote: > bossiness plan > bossiness model On 2019-09-13 05:57:33 -0400, stan wrote: > bossiness work I'm starting to think that this is not a typo :-) SCNR, hp -- _ | Peter J. Ho

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 10:46 AM, stan wrote: Forgot to cc the list again. Have to look at settings in mutt. Sorry forgot to cc the list On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: On 9/15/19 8:33 AM, stan wrote: I have defined this function: CREATE FUNCTION fix_customer_types_case()

PostgreSQL License

2019-09-15 Thread Ashkar Dev
*Can anyone explain the PostgreSQL License to me?* *Can I create a database with it and sell the database also preventing the buyer from reselling it?* *Can I change in the logos of the PostgreSQL system and its name?*

FW: Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread stan
Forgot to cc the list again. Have to look at settings in mutt. > > > > > > Sorry forgot to cc the list > > > > > > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: > > > > On 9/15/19 8:33 AM, stan wrote: > > > > > I have defined this function: > > > > > > > > > > CREATE FUNCTION f

Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread stan
On Sun, Sep 15, 2019 at 08:59:43AM -0700, Adrian Klaver wrote: > On 9/15/19 8:55 AM, stan wrote: > > > > Sorry forgot to cc the list > > > > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: > > > On 9/15/19 8:33 AM, stan wrote: > > > > I have defined this function: > > > > > > > >

Re: FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 8:55 AM, stan wrote: Sorry forgot to cc the list On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: On 9/15/19 8:33 AM, stan wrote: I have defined this function: CREATE FUNCTION fix_customer_types_case() and this trigger: CREATE TRIGGER fix_customer_types_case_trig B

FW: Re: Shouldn;t this trigger be called?

2019-09-15 Thread stan
Sorry forgot to cc the list On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote: > On 9/15/19 8:33 AM, stan wrote: > > I have defined this function: > > > > CREATE FUNCTION fix_customer_types_case() > > > > and this trigger: > > > > CREATE TRIGGER fix_customer_types_case_trig BEFORE

Re: Shouldn;t this trigger be called?

2019-09-15 Thread Adrian Klaver
On 9/15/19 8:33 AM, stan wrote: I have defined this function: CREATE FUNCTION fix_customer_types_case() and this trigger: CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON customer FOR EACH ROW EXECUTE FUNCTION fix_customer_types_case(); and I put a RAISE NOTICE so I cna

Re: Shouldn;t this trigger be called?

2019-09-15 Thread stan
On Sun, Sep 15, 2019 at 11:33:09AM -0400, stan wrote: > I have defined this function: > > CREATE FUNCTION fix_customer_types_case() > > and this trigger: > > CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON > customer > FOR EACH ROW EXECUTE FUNCTION fix_customer_types_case

Shouldn;t this trigger be called?

2019-09-15 Thread stan
I have defined this function: CREATE FUNCTION fix_customer_types_case() and this trigger: CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON customer FOR EACH ROW EXECUTE FUNCTION fix_customer_types_case(); and I put a RAISE NOTICE so I cna tell if the function is called. Ye

Re: Handling case variatiions on a user defined type?

2019-09-15 Thread stan
On Sun, Sep 15, 2019 at 09:58:45AM -0300, Olivier Gautherot wrote: > El dom., 15 de septiembre de 2019 09:37, stan escribi??: > > > I have several enumerated types that look like: > > > > CREATE TYPE confidence_level AS ENUM ('HIGH' , > > 'MEDIUM' , > >

Re: Handling case variatiions on a user defined type?

2019-09-15 Thread Olivier Gautherot
El dom., 15 de septiembre de 2019 09:37, stan escribió: > I have several enumerated types that look like: > > CREATE TYPE confidence_level AS ENUM ('HIGH' , > 'MEDIUM' , > 'LOW' , >

Handling case variatiions on a user defined type?

2019-09-15 Thread stan
I have several enumerated types that look like: CREATE TYPE confidence_level AS ENUM ('HIGH' , 'MEDIUM' , 'LOW' , 'WAG'); I have someone cr