On Monday 19 January 2009 23:28:08 Reg Me Please wrote:
> On Monday 19 January 2009 22:49:17 Gerhard Heift wrote:
> > On Mon, Jan 19, 2009 at 08:19:06PM +0100, Reg Me Please wrote:
> > > Hi all.
> > >
> > > I have a maintenance PL/pgSQL function that needs to recreate a partial
> > > index (not a R
On Monday 19 January 2009 22:49:17 Gerhard Heift wrote:
> On Mon, Jan 19, 2009 at 08:19:06PM +0100, Reg Me Please wrote:
> > Hi all.
> >
> > I have a maintenance PL/pgSQL function that needs to recreate a partial
> > index (not a REINDEX, though).
> > In the WHERE condition of the index I have one
On Mon, Jan 19, 2009 at 08:19:06PM +0100, Reg Me Please wrote:
> Hi all.
>
> I have a maintenance PL/pgSQL function that needs to recreate a partial index
> (not a REINDEX, though).
> In the WHERE condition of the index I have one of the function arguments.
> A plain "CREATE INDEX ... WHERE ..." w
Hi all.
I have a maintenance PL/pgSQL function that needs to recreate a partial index
(not a REINDEX, though).
In the WHERE condition of the index I have one of the function arguments.
A plain "CREATE INDEX ... WHERE ..." will lead to a runtime error like this:
tmp2=# SELECT * FROM f_maint1( '200
