Re: [pgadmin-support] Failed to write to history file

[michel boekestein]

Op 27 februari 2012 22:28 schreef Guillaume Lelarge
<guilla...@lelarge.info>het volgende:

> On Mon, 2012-02-27 at 22:07 +0100, Michel Boekestein wrote:
> >
> >
> >
> > Op 27 feb. 2012 om 15:28 heeft Guillaume Lelarge <guilla...@lelarge.info>
> het volgende geschreven:
> >
> > > On Mon, 2012-02-27 at 11:34 +0100, michel boekestein wrote:
> > >> No, there's no accent in the file path. It's here:
> > >>
> > >>
> C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
> > >>
> > >
> > > Please, don't top-post.
> > >
> > > OK, so, if it cannot write in this file, is the file writable? can you
> > > open it, and change a query for example?
> > >
> > >
> > >
> >
> > yes.
>
> If I send you a patch to get more informations, can you apply it and
> compile pgAdmin?
>
>
I'm afraid I can't


> If you cannot compile it, can you send me your history file and the
> query you execute before you get this message?
>

It executes before every query. See attachment for the history file.


>
> Oh, and can you check on 1.14.2, see if it still fails?
>

Yep, it still fails



>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
>

<?xml version="1.0" encoding="UTF-8"?>
<histoqueries>
 <histoquery>select count(*) from wordforms where lemma_id is null</histoquery>
 <histoquery>delete from wordforms where lemma_id is null</histoquery>
 <histoquery>select * from wordforms where oordeel_id is not null</histoquery>
 <histoquery>delete from wordforms where oordeel_id is not null</histoquery>
 <histoquery>SELECT W.wordform, count(*) 
FROM wordforms W 
GROUP BY W.wordform HAVING count(*) &gt; 1 limit 100</histoquery>
 <histoquery>SELECT W.wordform
FROM wordforms AS W
WHERE W.wordform IN (SELECT wordform FROM wordforms AS X WHERE X.lemma_id IS NOT NULL)
AND W.lemma_id IS NULL
</histoquery>
 <histoquery>select distinct W.wordform, W.lemma_id
from wordforms W, wordforms X
where W.wordform = X.wordform
and W.lemma_id &lt;&gt; X.lemma_id;
</histoquery>
 <histoquery>select distinct W.wordform, W.lemma_id
from wordforms W, wordforms X
where W.wordform = X.wordform
and W.lemma_id IS NULL
and X.lemma_id IS NOT NULL;
</histoquery>
 <histoquery>SELECT wordform, lemma_id
FROM wordforms W1
WHERE W1.wordform IN
(
select distinct W2.wordform
from wordforms W2
where W2.lemma_id IS NULL
);
</histoquery>
 <histoquery>SELECT wordform, lemma_id
FROM wordforms W1
WHERE W1.wordform IN
(
select distinct W2.wordform
from wordforms W2
where W2.lemma_id IS NULL
)
ORDER BY W1.wordform;
</histoquery>
</histoqueries>

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support