Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert UUID GEN 4 Value - Mailing list pgsql-general

From tango ward
Subject Re: Insert UUID GEN 4 Value
Date
Msg-id CAA6wQLLVpjtxAhPy3K1f63WtvqjK4QrzBLKjeh0PDUOyCvbT2Q@mail.gmail.com
Whole thread Raw
In response to Re: Insert UUID GEN 4 Value  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Insert UUID GEN 4 Value  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Insert UUID GEN 4 Value  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view

On Thu, May 31, 2018 at 12:18 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, May 30, 2018, tango ward <tangoward15@gmail.com> wrote:
Okay I will try it.

When I tried it, I am getting an error: Invalid input syntax for UUID: uuid_generate_v4(),

Avoid references to "it" and just show the code you tried to run.

David J.


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(), '', '', '',)
                                                         ''')

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Insert UUID GEN 4 Value
Next
From: tango ward
Date:
Subject: Re: Insert UUID GEN 4 Value