Re: Insert UUID GEN 4 Value
| От | David G. Johnston |
|---|---|
| Тема | Re: Insert UUID GEN 4 Value |
| Дата | |
| Msg-id | CAKFQuwYf=4-9HEt8uteMMCVLuZ59xkCpWwGQU480Q9FzgtRrQw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Insert UUID GEN 4 Value (tango ward <tangoward15@gmail.com>) |
| Ответы |
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(), '', '', '',)
''')
Executing this query is psql does not give the error: Invalid input syntax for UUID: uuid_generate_v4(),
This query is almost correct except you have a trailing comma in your VALUES statement that is going to provoke: syntax error near "," (i.e., you haven't provided a value for cashier_phone_number)
The query, which you have not yet shown, that provoked the "Invalid input syntax for UUID: uuid_generate_v4()" must have had the function call specified within single quotes in order for the server to think it was a literal value instead of an expression to be evaluated.
David J.
В списке pgsql-general по дате отправления: