ed on his specification, without
consulting the existing source.
It's available under a BSD license, if there's any use for it.
-- ams
/*
* Abhijit Menon-Sen <[EMAIL PROTECTED]>
* 2006-09-03
*/
#include "postgres.h"
#include "storage/lock.h"
At 2005-08-15 10:09:39 +0300, [EMAIL PROTECTED] wrote:
>
> ./vacuumdb -U username -p password
>
> This way vacuumdb can be run by cron without "trust"-ing any
> user in pg_hba.conf.
http://www.postgresql.org/docs/current/static/libpq-pgpass.html
-- ams
---(end of broadc
I have attached 5 patches (split up for ease of review) to plperl.c.
1. Two minor cleanups:
- We don't need to call hv_exists+hv_fetch; we should just check the
return value of hv_fetch.
- newSVpv("undef",0) is the string "undef", not a real undef.
2. This should fix the bug Andrew
At 2004-10-05 17:48:27 -0400, [EMAIL PROTECTED] wrote:
>
> Searching for all references to one of the existing entry points such
> as PQexecPrepared will probably help you identify what you need to do.
OK. I've attached two additional patches below.
I don't really understand how the *.def files w
;: /* Bind Complete */
case '3': /* Close Complete */
/* Nothing to do for these message types */
/*
* Test program for PQprepare/PQdescribe.
* Abhijit Menon-Sen <[EMAIL PROTECTED]>
At 2005-05-11 10:55:37 +1000, [EMAIL PROTECTED] wrote:
>
> > Here is a small patch that implements a function lastval() [...]
>
> What do people think of this idea? (Tom seems opposed, I'm just
> wondering if there are other opinions out there.)
For what it's worth, I think it's a bad idea.
In t
At 2005-05-10 23:30:05 -0400, pgman@candle.pha.pa.us wrote:
>
> > By the way, what would lastval() do if an insert trigger inserts
> > a row into a table with another serial column?
>
> It fails, just like it would fail now if the trigger inserted into
> the same table that used the trigger, or a
The appended patch fiddles with md5_text() until it handles any varlena,
and adds an entry for md5(bytea) to pg_proc.
-- ams
*** src/include/catalog/pg_proc.h~ 2005-05-19 07:45:05.191855191 +0530
--- src/include/catalog/pg_proc.h 2005-05-19 07:56:45.785482224 +0530
***
***
At 2005-05-18 23:31:27 -0400, [EMAIL PROTECTED] wrote:
>
> Doesn't that change cause the opr_sanity regression test to complain?
Yes, it does. I'm sorry I didn't notice.
As far as I can tell, updating the test as below is the correct thing
to do.
-- ams
*** src/test/regress/expected/opr_sanity.
At 2005-05-19 01:28:31 -0400, [EMAIL PROTECTED] wrote:
>
> No, I don't much care for that, because it gives free license for
> anyone to define pg_proc entries that allow bytea values to be fed
> to functions that are expecting text inputs.
Ah. I misunderstood the comment before the failing opr_sa
At 2005-05-19 11:47:16 +0530, [EMAIL PROTECTED] wrote:
>
> + Datum
> + md5_bytea(PG_FUNCTION_ARGS)
> + {
> + /* It would be nice if we could avoid de-toasting the whole bytea,
> + * and feed it to md5_hash in small chunks instead. */
> + struct varlena *in = PG_DETOAST_DATUM(PG_GETARG_
At 2005-06-04 17:27:10 -0500, [EMAIL PROTECTED] wrote:
>
> > OK, would you please submit a patch to fix it. Thanks.
>
> I will unless someone beats me to it in the next 2 weeks
Here's a patch to do the following:
1. Rename spi_return_next to return_next.
2. Add a new test for return_next.
3. Upda
At 2005-06-06 12:18:22 +1000, [EMAIL PROTECTED] wrote:
>
> Comments?
Could someone who likes this idea please write the documentation for it?
I'd really like to see a concise, complete description of the proposed
function, including potential caveats.
-- ams
---(end of br
The attached patch implements spi_query() and spi_fetchrow() functions
for PL/Perl, to avoid loading the entire result set into memory as the
existing spi_exec_query() function does.
Here's how one might use the new functions:
$x = spi_query("select ...");
while (defined ($y = spi_fetchro
I thought -patches was supposed to die. What happened?
-- ams
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
15 matches
Mail list logo
