Re: Error with ALTER TABLE %s

On 04/05/2010 13:54, [email protected] wrote:
> Hi, when I do
> SQL = "ALTER TABLE films ADD COLUMN (%s) text;"
> data = ("test3", )
> cur.execute(SQL,data)
> 
> I get this error,
> 
> LINE 1: ALTER TABLE films ADD COLUMN (E'test3') text;

You can't use bound variables with column (or table, or functions, etc.)
names.

federico

-- 
Federico Di Gregorio                                       fog-NGVKUo/i/[email protected]
 When people say things are a lot more complicated than that, they
  means they're getting worried that they won't like the truth.
                                                    -- Granny Weatherwax

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkvgDYQACgkQvcCgrgZGjeuq/QCcC4mSIm+6uLCyvSNcW/CpCTHw
qxsAoJXfP8LQKEDNECs0DemOjnXzJc5j
=k1+f
-----END PGP SIGNATURE-----