[pgadmin-support] * Warning - virus alert relating to the pgadmin list. - FW: AntiVir ALERT [mail from: Dave Page ]

2002-10-04 Thread Serkan Bektaş
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 2:30 PM To: [EMAIL PROTECTED] Subject: AntiVir ALERT [mail from: Dave Page <[EMAIL PROTECTED]>] * * * * * * * * * * * * * * * AntiVir ALERT * * * * * * * * * * * * * * * This version of

Re: [pgadmin-support] run-time error 50003

2002-10-04 Thread Dave Page
Title: Message Sorry, I thought you said there was no pgAdmin II key? Where did all the other values come from?   Anyway, can you check where the following files on your system are please (and check for duplicates), and let me know what versions they are?   comctl32.ocx comdlg32.ocx comct23

Re: [pgadmin-support] [GENERAL] Fast Deletion For Large Tables

2002-10-04 Thread Roland Roberts
> "rc" == Raymond Chui <[EMAIL PROTECTED]> writes: rc> Everything is running fine, except take long time to finish. rc> Because some tables stored values from 50,000 to 100,000 rows rc> Some deletion need to deleted up to 45,000 rows. Is column_time indexed? roland --

Re: [pgadmin-support] [GENERAL] Fast Deletion For Large Tables

2002-10-04 Thread Roland Roberts
> "rc" == Raymond Chui <[EMAIL PROTECTED]> writes: roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises [EMAIL PROTECTED] 76-15 113th Street, Apt 3B [EMAIL PROTECTED] Forest Hills,

Re: [pgadmin-support] [ADMIN] Fast Deletion For Large Tables

2002-10-04 Thread Stephan Szabo
On Wed, 2 Oct 2002, Raymond Chui wrote: > I have some tables with huge data. > The tables have column timestamp and float. > I am try to keep up to 6 day of data values. > What I do is execute SQL below from crontab (UNIX to > schedule commands). > > BEGIN; > DELETE FROM table_1 WHERE column_time