> On Wed, 29 Jun 2011 22:40:16 +0100, Gavin McCullagh said:
>
> The database was originally made in Ubuntu Hardy which was v2.x as I recall
> now. We then upgraded to v3 (ubuntu packages built using the debian
> package git archive as we needed volume shadow copy support under Win64)
> and si
Hi,
On Wed, 29 Jun 2011, Martin Simmons wrote:
> These duplicates in the File table are probably generated by the batch insert
> code. Since each pair has the same FileIndex, it should be safe to elide them
> them.
Fair enough, thanks.
> > so perhaps this is safe enough. Does anyone know how
> On Mon, 27 Jun 2011 14:03:24 +0100, Gavin McCullagh said:
>
> I've been experimenting with a migration from MySQL to Postgres.
>
> One problem I've come across is that there are a handful of duplicate files
> in the Filename table
> ...
> I could of course prune four duplicate lines from t
Hi,
I've been experimenting with a migration from MySQL to Postgres.
One problem I've come across is that there are a handful of duplicate files
in the Filename table
mysql> select count(*) as filecount, Filename.name from Filename GROUP BY
Filename.Name ORDER BY filecount DESC LIMIT 30;
+---