Re: Insert UUID GEN 4 Value
| От | tango ward |
|---|---|
| Тема | Re: Insert UUID GEN 4 Value |
| Дата | |
| Msg-id | CAA6wQLLVpjtxAhPy3K1f63WtvqjK4QrzBLKjeh0PDUOyCvbT2Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Insert UUID GEN 4 Value ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Insert UUID GEN 4 Value
Re: Insert UUID GEN 4 Value |
| Список | pgsql-general |
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(), '', '', '',)
''')
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 по дате отправления: