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

Поиск
Список
Период
Сортировка
От stan
Тема Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Дата
Msg-id 20190920110258.GA12885@panix.com
обсуждение исходный текст
Ответ на Re: FW: Re: FW: Re: Shouldn;t this trigger be called?  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
On Thu, Sep 19, 2019 at 03:54:40PM -0600, Michael Lewis wrote:
> You can also look at citext type to avoid the casting.
> 
>     customer_key                integer DEFAULT
> nextval('customer_key_serial') PRIMARY KEY ,
>     cust_no                     smallint NOT NULL UNIQUE ,
>     name                        varchar UNIQUE ,
> 
I am confysed. I am running version 11 which is current I beleive, but when
I try  to use this type, I get:

ERROR:  type "citext" does not exist
LINE 8:     unit          citext UNIQUE NOT NULL ,

 Do I somehow need to enable this type?
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



В списке pgsql-general по дате отправления:

Предыдущее
От: Morris de Oryx
Дата:
Сообщение: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Следующее
От: stan
Дата:
Сообщение: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?