Re: libpq and transactions

Поиск
Список
Период
Сортировка
От Alex du Plessis
Тема Re: libpq and transactions
Дата
Msg-id 44DC838C.5030003@telkomsa.net
обсуждение исходный текст
Ответ на Re: libpq and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Thanks Tom - I'll try that straightaway

Tom Lane wrote:
> Alex du Plessis <alexdup01@telkomsa.net> writes:
>> I wish to use libpq to create a new database using a sql statement
>> "CREATE DATABSE".  However, it seems this command cannot be enclosed
>> within a transaction.  How do I go about executing such a statement via
>> libpq i.e. which function should I use.  (Any information would be helpful)
>
> Use PQexec(), same as any other SQL command.  The no-transaction
> restriction just means you can't put it between BEGIN and COMMIT
> commands.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Minimising disk writes
Следующее
От: "ben sewell"
Дата:
Сообщение: executing a procedure withing a procedure?