pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUse of Stored Procedures and
6+ messages / 3 participants
[nested] [flat]
* Use of Stored Procedures and
@ 2006-01-17 09:04 Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Re: Use of Stored Procedures and Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 6+ messages in thread
From: Marcos @ 2006-01-17 09:04 UTC (permalink / raw)
To: pgsql-performance
Hi,
I already read the documentation for to use the SPI_PREPARE and
SPI_EXEC... but sincerely I don't understand how I will use this
resource in my statements.
I looked for examples, but I din't good examples :(..
Somebody can help me?
Thanks.
Marcos.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Use of Stored Procedures and
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
@ 2006-01-18 20:28 ` Michael Fuhr <mike@fuhr.org>
2006-01-19 08:44 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Michael Fuhr @ 2006-01-18 20:28 UTC (permalink / raw)
To: Marcos <mjs_ops@gmx.net>; +Cc: pgsql-performance
On Tue, Jan 17, 2006 at 09:04:53AM +0000, Marcos wrote:
> I already read the documentation for to use the SPI_PREPARE and
> SPI_EXEC... but sincerely I don't understand how I will use this
> resource in my statements.
What statements? What problem are you trying to solve?
--
Michael Fuhr
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Use of Stored Procedures and
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Re: Use of Stored Procedures and Michael Fuhr <mike@fuhr.org>
@ 2006-01-19 08:44 ` Marcos <mjs_ops@gmx.net>
2006-01-19 11:15 ` Re: Use of Stored Procedures and Markus Schaber <schabi@logix-tt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Marcos @ 2006-01-19 08:44 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-performance
> What statements?
Sorry. Statements is my code.
> What problem are you trying to solve?
I want know how I make to use a prepared plan
( http://www.postgresql.org/docs/8.1/static/sql-prepare.html ). I read
that I need to use the SPI_PREPARE and SPI_EXEC in my code, but I didn't
understand how make it.
Thanks
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Use of Stored Procedures and
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Re: Use of Stored Procedures and Michael Fuhr <mike@fuhr.org>
2006-01-19 08:44 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
@ 2006-01-19 11:15 ` Markus Schaber <schabi@logix-tt.com>
2006-01-19 09:42 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Markus Schaber @ 2006-01-19 11:15 UTC (permalink / raw)
To: Marcos <mjs_ops@gmx.net>; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-performance
Hi, Marcos,
Marcos wrote:
>>What problem are you trying to solve?
>
> I want know how I make to use a prepared plan
> ( http://www.postgresql.org/docs/8.1/static/sql-prepare.html ). I read
> that I need to use the SPI_PREPARE and SPI_EXEC in my code, but I didn't
> understand how make it.
Which interface are you using to connect to PostgreSQL? libpq, libpqxx,
pgjdbc, python-popy?
E. G. PGJDBC handles prepared plans transparently by using the
PreparedStatement class.
If you use command line PSQL, you can use the PREPARE commands.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Use of Stored Procedures and
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Re: Use of Stored Procedures and Michael Fuhr <mike@fuhr.org>
2006-01-19 08:44 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-19 11:15 ` Re: Use of Stored Procedures and Markus Schaber <schabi@logix-tt.com>
@ 2006-01-19 09:42 ` Marcos <mjs_ops@gmx.net>
2006-01-19 12:20 ` Re: Use of Stored Procedures and Markus Schaber <schabi@logix-tt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Marcos @ 2006-01-19 09:42 UTC (permalink / raw)
To: Markus Schaber <schabi@logix-tt.com>; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-performance
> Which interface are you using to connect to PostgreSQL? libpq, libpqxx,
> pgjdbc, python-popy?
>
> E. G. PGJDBC handles prepared plans transparently by using the
> PreparedStatement class.
>
> If you use command line PSQL, you can use the PREPARE commands.
I'm using the adodb to call the stored procedure (plpgsql).
Thanks..
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Use of Stored Procedures and
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Re: Use of Stored Procedures and Michael Fuhr <mike@fuhr.org>
2006-01-19 08:44 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-19 11:15 ` Re: Use of Stored Procedures and Markus Schaber <schabi@logix-tt.com>
2006-01-19 09:42 ` Re: Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
@ 2006-01-19 12:20 ` Markus Schaber <schabi@logix-tt.com>
0 siblings, 0 replies; 6+ messages in thread
From: Markus Schaber @ 2006-01-19 12:20 UTC (permalink / raw)
To: Marcos <mjs_ops@gmx.net>; pgsql-performance
Hi, Marcos,
Marcos wrote:
>>Which interface are you using to connect to PostgreSQL? libpq, libpqxx,
>>pgjdbc, python-popy?
>>
>>E. G. PGJDBC handles prepared plans transparently by using the
>>PreparedStatement class.
>>
>>If you use command line PSQL, you can use the PREPARE commands.
>
> I'm using the adodb to call the stored procedure (plpgsql).
So your statements are inside a plpgsql stored procedure, important to
know that.
AFAIK, plpgsql uses prepared statements internally, so it should not be
necessary to use them explicitly.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-01-19 12:20 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-17 09:04 Use of Stored Procedures and Marcos <mjs_ops@gmx.net>
2006-01-18 20:28 ` Michael Fuhr <mike@fuhr.org>
2006-01-19 08:44 ` Marcos <mjs_ops@gmx.net>
2006-01-19 11:15 ` Markus Schaber <schabi@logix-tt.com>
2006-01-19 09:42 ` Marcos <mjs_ops@gmx.net>
2006-01-19 12:20 ` Markus Schaber <schabi@logix-tt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox