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 since then
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 the data
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
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;