Re: Error Importing CSV File - Mailing list pgsql-general

From Scott Ribe
Subject Re: Error Importing CSV File
Date
Msg-id 821F2E36-8AFC-4313-AA14-8503AC3674DF@elevated-dev.com
Whole thread Raw
In response to Re: Error Importing CSV File  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Jul 15, 2011, at 11:44 AM, Tom Lane wrote:

> Never heard of rake before, but I'm betting that it's doing stuff
> behind your back, like including an "id" column in the table definition.
> Try looking at the table in psql (\d geo_data), or enabling query
> logging on the server so you can see what the actual CREATE TABLE
> command sent to the server looks like.

That's it. Rake is part of Ruby on Rails, and RoR wants every table to start with an integer synthetic key column.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Error Importing CSV File
Next
From: Bryan Nelson
Date:
Subject: Re: Error Importing CSV File