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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Insert UUID GEN 4 Value  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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(), '', '', '',)
                                                         ''')

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Insert UUID GEN 4 Value
Следующее
От: tango ward
Дата:
Сообщение: Re: Insert UUID GEN 4 Value