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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo