Re: Insert UUID GEN 4 Value

On Thu, May 31, 2018 at 12:32 PM, tango ward <tangoward15(at)gmail(dot)com> wrote:

>
> On Thu, May 31, 2018 at 12:18 PM, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Wednesday, May 30, 2018, tango ward <tangoward15(at)gmail(dot)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(), '', '', '',)
> ''')
>

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

Hi, this is the query that I am trying to run. I'll try your suggestions
when I arrived in the office.