Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Richard Huxton
Emilie Laffray wrote: > Hello, > > well Icouldn't turn off my antivirus since it is controlled by our IT > management team. However, since I rebuilt the indexes, the query has > been running fine. I don't understand what happpened. Before asking for > help, I made sure I could repeat the problem o

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Emilie Laffray
Hello, well Icouldn't turn off my antivirus since it is controlled by our IT management team. However, since I rebuilt the indexes, the query has been running fine. I don't understand what happpened. Before asking for help, I made sure I could repeat the problem over several reboots. Emilie

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Richard Huxton
Emilie Laffray wrote: > 3) I have an antivirus running, but again this antivirus has been > running for months and I have worked on postgresql also for months. > There has been an update yesterday to that antivirus, but I don't think > it had an impact. > I tried also in the meantime to run a vacu

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Emilie Laffray
Hello, 1) I can perform a query on the rows that I am trying to update. I have also successfully updated rows before in the same table and also after. 2) I have no reason to believe that the filesystem got corrupted. I have started a scan before you asked the question wondering if it could be

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Grzegorz Jaśkiewicz
what about free disc space ? aren't you running out of ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Richard Huxton
Emilie Laffray wrote: > Hello, > > I am sending this email since I am hitting a snag with postgresql. I > am currently running the following version of postgresql: > Postgresql 8.3.5 on Windows XP Pro 32bits > > I am getting a crash whenever I try to perform an update on some rows. > More precise

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Richard Huxton
Andrew Gould wrote: > On Wed, Feb 4, 2009 at 6:18 AM, Emilie Laffray > wrote: >> UPDATE gtable AS g >> SET code = '00' -- 04 >> WHERE g.code = '04' >> AND g.cc = 'TW'; > What does '--' do? It's a comment delimeter -- Richard Huxton Archonet Ltd -- Sent via

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Tommy Gildseth
Andrew Gould wrote: What does '--' do? -- Is an SQL comment -- Tommy Gildseth DBA, Gruppe for databasedrift Universitetet i Oslo, USIT m: +47 45 86 38 50 t: +47 22 85 29 39 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

Re: [GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Andrew Gould
On Wed, Feb 4, 2009 at 6:18 AM, Emilie Laffray wrote: > Hello, > > I am sending this email since I am hitting a snag with postgresql. I > am currently running the following version of postgresql: > Postgresql 8.3.5 on Windows XP Pro 32bits > > I am getting a crash whenever I try to perform an upda

[GENERAL] Crash of Postgresql on Windows

2009-02-04 Thread Emilie Laffray
Hello, I am sending this email since I am hitting a snag with postgresql. I am currently running the following version of postgresql: Postgresql 8.3.5 on Windows XP Pro 32bits I am getting a crash whenever I try to perform an update on some rows. More precisely, I have recently imported a dataset