Re: Text Reports query

On Dec 12, 2003, at 13:02, Vincent Danen wrote:

> Well, this is a little annoying.  I can import everything except the 
> bugdesc table... not sure what's going on there.  I keep getting 
> pg_atoi errors saying it can't parse what is the text field.  Need to 
> dig a little further.

Aaarg.  Found the problem.  mysqldump is doing stuff like:

INSERT INTO bugdesc VALUES (bla)

and the dump is putting the system field after the description text 
field wheras in pgsql the system field comes first (this is from an old 
db).

Can't seem to find a way to make mysqldump explicitly give the table 
info in the insert clause, ie:

INSERT INTO bugdesc (cols) VALUES (bla)

A bit of a nuisance.

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers