Обсуждение: BUG #4512: PostgreSQL crash on update command

The following bug has been logged online:

Bug reference:      4512
Logged by:          Keven Guindon
Email address:      kevenguindon@msn.com
PostgreSQL version: 8.3.5
Operating system:   Windows XP sp3
Description:        PostgreSQL crash on update command
Details:

SQl Update command:
UPDATE prod.man_insert_line2 SET
         "Feed" = (SELECT "Feed" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND'2008-02-14 13:00:03'::timestamp + ((252000  + 6000)
|| ' second')::interval
         AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
         "GFI7" = (SELECT "GFI7" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000  + 6000)
|| ' second')::interval
         AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
         "GFI9" = (SELECT "GFI9" FROM "Production_Line2" WHERE "Date"
BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) || '
second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
         AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1),
         "Scraper Powder" = (SELECT "Scraper Powder" FROM "Production_Line2"
WHERE "Date" BETWEEN '2008-02-14 13:00:03'::timestamp + ((252000 - 6000) ||
' second')::interval AND '2008-02-14 13:00:03'::timestamp + ((252000 + 6000)
|| ' second')::interval
         AND "AC_TorchTime" BETWEEN 252000 - 1000 AND 252000 LIMIT 1)
WHERE torchtime = 70.0;



Event Type:    Error
Event Source:    Application Error
Event Category:    (100)
Event ID:    1000
Date:        11/5/2008
Time:        10:56:04 AM
User:        N/A
Computer:    SYSTEMDB
Description:
Faulting application postgres.exe, version 8.3.5.8304, faulting module
msvcr80.dll, version 8.0.50727.1433, fault address 0x0001500a.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 70 6f 73   ure  pos
0018: 74 67 72 65 73 2e 65 78   tgres.ex
0020: 65 20 38 2e 33 2e 35 2e   e 8.3.5.
0028: 38 33 30 34 20 69 6e 20   8304 in
0030: 6d 73 76 63 72 38 30 2e   msvcr80.
0038: 64 6c 6c 20 38 2e 30 2e   dll 8.0.
0040: 35 30 37 32 37 2e 31 34   50727.14
0048: 33 33 20 61 74 20 6f 66   33 at of
0050: 66 73 65 74 20 30 30 30   fset 000
0058: 31 35 30 30 61            1500a

"Keven Guindon" <kevenguindon@msn.com> writes:
> Description:        PostgreSQL crash on update command

Please provide sufficient information to let us reproduce the crash
(the query alone is not sufficient).  See
http://www.postgresql.org/docs/8.3/static/bug-reporting.html
if you need advice about how to prepare an adequate bug report.

            regards, tom lane