Re: reindex action

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "frank_lupo" <frank_lupo(at)email(dot)it>
Cc: "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: reindex action
Date: 2003-03-06 15:04:29
Message-ID: 03AF4E498C591348A42FC93DEA9661B885CE@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> Sent: 06 March 2003 14:41
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] reindex action
>
>
> >
> >
> > > -----Original Message-----
> > > From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> > > Sent: 05 March 2003 21:13
> > > To: pgadmin-hackers
> > > Subject: [pgadmin-hackers] reindex action
> > >
> > >
> > > I developed a reindex command (table,index no database).
> >
> > Sorry Frank - this breaks the OO design of pgSchema. Unless
> there are
> > exceptional circumstances, anything that occurs to an
> object should be
> > implemented as a method of that object, so I would expect to see
> > methods
> > like:
> >
> > pgIndex.ReIndex()
> > pgDatabase.ReIndex()
> > pgTable.ReIndex()
> >
> > Can you recode it in that fashion please?
> >
> > Thanks, Dave.
> >
>
> Excuse, I have corrected the schema.

Looks good.

> How we make to call these actions?

In basActions.bas, you need a Reindex() sub which will be similar to
Drop(). In there, check the object type, and if appropriate call the
reindex method eg:

ctx.CurrentObject.ReIndex

In clsContext, there needs to be code to enable/disable the reindex
option in Property Set CurrentObject/CurrentDB.

Regards, Dave.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Gastón Micheri 2003-03-06 21:14:41 Pgadmin Error
Previous Message frank_lupo 2003-03-06 14:40:52 Re: reindex action