Re: [HACKERS] [BUGS] BUG #3811: Getting multiple values from a sequence generator

2007-12-10 Thread NikhilS
Hi, Right, I want to use it with a bulk operation, say importing a million records with COPY. Calling nextval one million times looks to me like an enormous waste of resources. Suppose, you are on an ADSL line: it will cost one million times the ping time of the ADSL line (say 10

Re: [HACKERS] [BUGS] BUG #3811: Getting multiple values from a sequence generator

2007-12-10 Thread Gregory Stark
NikhilS [EMAIL PROTECTED] writes: Coincidently, I very briefly discussed (offline) about supporting expressions while doing loads using COPY FROM with Heikki a while back. From the above mail exchanges, it does appear that adding this kind of functionality will be useful while doing bulk