Re: libpq and transactions - Mailing list pgsql-novice

From Alex du Plessis
Subject Re: libpq and transactions
Date
Msg-id 44DC838C.5030003@telkomsa.net
Whole thread Raw
In response to Re: libpq and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Minimising disk writes
Next
From: "ben sewell"
Date:
Subject: executing a procedure withing a procedure?