Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift

On Aug 30, 2015, at 11:59 AM, Christopher Brooks <brooksch@umich.edu> wrote:
>  [SQL: 'INSERT INTO qualtrics_dim (k, v) VALUES (%(k)s, %(v)s)'] [parameters: {'v': ['aa', 'bb'], 'k': ['a', 'b']}]

The values you've written there are two arrays of TEXT values, but the columns aren't declared as TEXT or VARCHAR
arrays,but as single VARCHAR values.  Are you trying to insert two rows of the form 'aa', 'a' and 'bb', 'b'? 

--
-- Christophe Pettus
   xof@thebuild.com