On 05/31/2018 07:39 PM, tango ward wrote:
On Thu, May 31, 2018 at 12:32 PM, tango ward <tangowar...@gmail.com
<mailto:tangowar...@gmail.com>> wrote:
On Thu, May 31, 2018 at 12:18 PM, David G. Johnston
<david.g.johns...@gmail.com <mailto:david.g.johns...@gmail.com>> wrote:
On Wednesday, May 30, 2018, tango ward <tangowar...@gmail.com
<mailto:tangowar...@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(), '', '', '',)
''')
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.
