[pgadmin-support] * Warning - virus alert relating to the pgadmin list. - FW: AntiVir ALERT [mail from: Dave Page ]
-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 AntiVir is licensed for private and non-commercial use. AntiVir has detected the following in a mail sent through your server: Worm/Tanatos.1 virus The mail was not delivered. It has been quarantined with the following queue id: 71951-56AF8E16 Mail-Info: --8<-- From: Dave Page <[EMAIL PROTECTED]> Subject: Re: [pgadmin-support] run-time error 429 Mail-From: [EMAIL PROTECTED] Rcpt: [EMAIL PROTECTED] Queue-Id: 71951-56AF8E16 Status: The mail was not delivered! --8<-- Log-File: --8<-- info: extracting attachment 1 to /var/tmp/av-71994-cArwtn/av-0 (encoding="quoted-printable", name="(no name)", filename="(no name)") info: extracting attachment 2 to /var/tmp/av-71994-cArwtn/av-1 (encoding="base64", name="G&T_LISTA", filename="(no name)") checking file "/var/tmp/av-71994-cArwtn/av-0" checking file "/var/tmp/av-71994-cArwtn/av-1" --8<-- -- AntiVir for UNIX Copyright (C) 1994-2002 by H+BEDV Datentechnik GmbH. All rights reserved. For more information see http://www.antivir.de/ or http://www.hbedv.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] run-time error 50003
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 comct232.ocx comct332.ocx Regards, Dave. -Original Message-From: Marcia Abade [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 21:41To: Dave PageSubject: Re: [pgadmin-support] run-time error 50003I did it. Do not work. No logs, no Pgadmin... Dave Page wrote: Hi, If the key is not there, just create it manually then add the value to it. Regards, Dave. _Original message Subject: Re: [pgadmin-support] run-time error 50003 Sender: "Marcia Abade" <[EMAIL PROTECTED]> Date: Thu, 3 Oct 2002 21:33:32 + Name: Attachment.html Attachment.html Type: Hypertext Markup Language (text/html) Encoding: base64
Re: [pgadmin-support] [GENERAL] Fast Deletion For Large Tables
> "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 -- 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, NY 11375 ---(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-support] [GENERAL] Fast Deletion For Large Tables
> "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, NY 11375 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] [ADMIN] Fast Deletion For Large Tables
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 < ('now'::timestamp - '6
> days'::interval);
> .
> DELETE FROM table_n WHERE column_time < ('now'::timestamp - '6
> days'::interval);
> COMMIT;
>
>
> Everything is running fine, except take long time to finish.
> Because some tables stored values from 50,000 to 100,000 rows
> Some deletion need to deleted up to 45,000 rows.
>
> So I am thinking just delete the rows by their row number or row ID,
> like
>
> DELETE FROM a_table WHERE row_id < 45000;
>
> I know there is row_id in Oracle.
> Is there row_id for a table in Postgres?
Not really of that sort IIRC Oracle's row_id definition, although you
could probably fake something with a sequence.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
