Re: Multiple statements in one prepare

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Robert Turnbull" <rturnbull(at)strategicmind(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multiple statements in one prepare
Date: 2004-04-25 05:06:49
Message-ID: 5B6D3490-9676-11D8-AF9F-000A95AB279E@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 15-Apr-04, at 9:26 AM, Robert Turnbull wrote:
> How can multiple SQL statements be included in one prepare command?
> The goal is to reduce chatter between the client and server by
> submitting an atomic tranasaction set.

You can submit multiple PREPARE commands in one query string (separated
by semi-colons), so the difference in FE/BE traffic should be
negligible.

-Neil

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message wespvp 2004-04-25 05:16:06 Re: thread_test.c problems
Previous Message Gaetano Mendola 2004-04-25 02:25:25 Re: Invalid pg_hba.conf => Postgres crash