Re: [Core-lan-org-devel] jumbo edits, cvsdiff -u

[Marshall R. <mr...@db...>]

> Hi Marshall,
> 
> You need to upgrade. Coreapm used the value 0 to indictate a filed was not
> set. This was handy at the time I wrote it. Nowadays I use NULL as it offers
> the posilibility do more complex things with the database.
> 
> The point is that the data you now have is full of 0's and the database
> won't allow you to insert them as they refer to non-existant tasks (0 is not
> a possible task, SQL starts couting at 1). So as I've said before we need a
> script to take all the 0's and convert them into NULL's.

right. good point... pgsql isn't my strong-point, but i'll take a look at writing such a script... if someone beats me to it, great!

/mtr