Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-23 Thread Andrew Sullivan
On Fri, Oct 20, 2006 at 09:01:15PM -0700, Richard Broersma Jr wrote: > actually I am get duplicate emails like this one across the various PG lists. > Perhaps someone > else is resending these email? More likely, this happened: 1. person sent mail to list, got bounced because not subscribed. 2

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Richard Broersma Jr
> This could be fixed if someone wanted to improve the moderation software > to auto-approve pending messages from someone who's just subscribed, but > perhaps that's a lot of work. I haven't looked at that code, so I'm not > volunteering ... Thats not a problem. I was surprised to see your name

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Tom Lane
Richard Broersma Jr <[EMAIL PROTECTED]> writes: > actually I am get duplicate emails like this one across the various PG lists. > Perhaps someone > else is resending these email? The usual mechanism is * newbie sends question * newbie gets response indicating that message is being held for mo

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Richard Broersma Jr
> It seems that you've already asked for this question last Sunday, and > because your question is somewhat deterministic, the answers are more likely > to be the same. Check your previous e-mails. actually I am get duplicate emails like this one across the various PG lists. Perhaps someone els

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Daniel CAUNE
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de Kenneth Gonsalves > Envoyé : 15 octobre 2006 08:31 > À : pgsql-sql@postgresql.org > Objet : [SQL] conversion of numeric field from MSSQL to postgres > > hi, > > am migrating a database from MSSQL to po

[SQL] conversion of numeric field from MSSQL to postgres

2006-10-20 Thread Kenneth Gonsalves
hi, am migrating a database from MSSQL to postgres. How would i migrate this: [Id] [numeric](18, 0) IDENTITY (1, 1) -- regards Kenneth Gonsalves Associate, NRC-FOSS [EMAIL PROTECTED] http://nrcfosshelpline.in/web/ ---(end of broadcast)---