Re: New Patch file for MS SQL autonumbers

Thanks, committed.

Regards, Dave.

> -----Original Message-----
> From: John McCawley [mailto:jmccawley@worleyco.com] 
> Sent: 18 June 2002 00:14
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] New Patch file for MS SQL autonumbers
> 
> 
> A bug was introduced into pgMigration when I added the sequence drop 
> code.  If you were importing a table that had an autonumber, 
> but there 
> was no conflicting sequence on import, the CREATE SEQUENCE line would 
> end up with an invalid query.  (The variable would have junk 
> in it from 
> an earlier query)
> 
> The patch is attached, it is simply setting the query to an 
> empty string 
> before it is used.
> 
> John
> 
>