Re: Insert UUID GEN 4 Value

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 05/31/2018 07:39 PM, tango ward wrote:

On Thu, May 31, 2018 at 12:32 PM, tango ward <tangoward15@xxxxxxxxx> wrote:

On Thu, May 31, 2018 at 12:18 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wednesday, May 30, 2018, tango ward <tangoward15@xxxxxxxxx> 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.

Honestly, I'd try it in psql first.  That will eliminate all possible problems due to quoting errors, etc.

--
Angular momentum makes the world go 'round.