Re: [pgadmin-hackers] reindex action

2003-03-07 Thread Dave Page


 -Original Message-
 From: frank_lupo [mailto:[EMAIL PROTECTED] 
 Sent: 06 March 2003 14:41
 To: Dave Page
 Cc: pgadmin-hackers
 Subject: Re: [pgadmin-hackers] reindex action
 
 
  
  
   -Original Message-
   From: frank_lupo [mailto:[EMAIL PROTECTED]
   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. 

Thanks. I have added the basActions/frmMain code and committed it.

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] reindex action

2003-03-07 Thread Dave Page


 -Original Message-
 From: frank_lupo [mailto:[EMAIL PROTECTED] 
 Sent: 07 March 2003 15:16
 To: Dave Page
 Cc: pgadmin-hackers
 Subject: Re: [pgadmin-hackers] reindex action
 
 
 I change in basAction the reindex.

Ooops, I just did that. Thanks anyway.

 I change in basAction the vacuum.
 I change the vacuum using OO design of pgSchema:

OK, I noticed that broke the rules a minute ago.
 
 pgDatabase.vacuum(...)
 pgTable.vacuum(...)
 pgColumn.vacuum(...)

There's no need for VACUUM VERBOSE as pgAdmin can't display the output
anyway. Can you also create a patch against CVS tip for frmMain to go
with this please (updates for the popup menu and toolbar) - I don't have
much time to work on these things at the moment.

Regards, Dave.


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] reindex action

2003-03-06 Thread frank_lupo
 
 
  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  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. 
How we make to call these actions?  

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-ooo---


--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Stai cercando una casella di posta professionale senza pubblicità e senza scadenza? 
Quello che fa per te è Email.it Pro15 o Pro50, ordinala subito, è proprio forte!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1045d=6-3

pgDatabase.cls
Description: Binary data


pgIndex.cls
Description: Binary data


pgTable.cls
Description: Binary data

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] reindex action

2003-03-06 Thread Dave Page


 -Original Message-
 From: frank_lupo [mailto:[EMAIL PROTECTED] 
 Sent: 06 March 2003 14:41
 To: Dave Page
 Cc: pgadmin-hackers
 Subject: Re: [pgadmin-hackers] reindex action
 
 
  
  
   -Original Message-
   From: frank_lupo [mailto:[EMAIL PROTECTED]
   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.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org