Re: Insert UUID GEN 4 Value

On 05/30/2018 09:32 PM, tango ward wrote:
> 

> 
> I'm testing this code:
> 
> curr_pgsql.execute('''CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; ''')
> curr_pgsql.execute('''
>                      INSERT INTO enrollmentinfo (
>                                                           created, modified,
>                                                           secure_id,
>                                                           relationship,
>                                                           tuition_bill,
>                                                           cashier_name,
>                                                           
> cashier_phone_number
>                                                           )
>                      VALUES (current_timestamp, current_timestamp,
>                              uuid_generate_v4(), '', '', '',)
>                                                           ''')

I just noticed something, the fields you show above do not match the 
description of the table you showed here:

https://www.postgresql.org/message-id/CAA6wQLJr6fjzx%2BZK6N4yiViZYdFuGGkMT27zsp-mR1SjAzbGEg%40mail.gmail.com

CREATE TABLE enrollmentinfo (
id integer NOT NULL,
created timestamp with time zone NOT NULL,
modified timestamp with time zone NOT NULL,
secure_id uuid NOT NULL,
relationship character varying(50) NOT NULL,
tuition_bill character varying(255) NOT NULL
);

So which is correct?


-- 
Adrian Klaver
adrian.klaver@aklaver.com