Re: Error Importing CSV File

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bryan Nelson <shrek(at)shreks-place(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Error Importing CSV File
Date: 2011-07-15 17:54:24
Message-ID: 821F2E36-8AFC-4313-AA14-8503AC3674DF@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Nelson 2011-07-15 17:57:03 Re: Error Importing CSV File
Previous Message Steve Crawford 2011-07-15 17:44:17 Re: Error Importing CSV File