X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B06443A40BB for ; Wed, 10 Nov 2004 06:22:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16660-10 for ; Wed, 10 Nov 2004 06:21:58 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id 910183A40A0 for ; Wed, 10 Nov 2004 06:21:59 +0000 (GMT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I6Y00I019NHX3@asu.edu> for pgsql-admin@postgresql.org; Tue, 09 Nov 2004 23:21:17 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0I6Y00I959NG1F@asu.edu> for pgsql-admin@postgresql.org; Tue, 09 Nov 2004 23:21:17 -0700 (MST) Received: from moroni.pp.asu.edu (moroni.pp.asu.edu [129.219.69.200]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id iAA6LHMC029524 for ; Tue, 09 Nov 2004 23:21:17 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 0C07DE2E; Tue, 09 Nov 2004 23:21:17 -0700 (MST) Date: Tue, 09 Nov 2004 23:21:17 -0700 From: David Bear Subject: import limited to 1000 tuples To: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20041110062116.GA486@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/83 X-Sequence-Number: 15468 I am migrating data from msaccess. Using msaccess own export function I was able to export to an odbc data source -- I chose the postgres odbc source. The export went fine except it only save 1000 tupples from the access data source. These are not real big tables, but they do have almost 2000 tupples in them. Is there a limit to the number of tupples that can be exported/created through the odbc driver? -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"