Re: [sqlalchemy] Searching from jsonb list

2016-01-04 Thread Jon Rosebaugh
The @> operator (contains) is defined only for JSONB; your original message said you were using JSONB. However, this error says your column is just JSON. These two types are not the same thing; you should use JSONB if you have a choice. On Thu, Dec 31, 2015, at 03:43 PM, Sami Pietilä wrote: > Perh

RE: [sqlalchemy] how to pick up constraint violation errors in Alchemy

2016-01-04 Thread Gombas, Gabor
If you're using psycopg2, then you may want to use the Diagnostics extension - check the documentation of psycopg2. Gabor > -Original Message- > From: sqlalchemy@googlegroups.com > [mailto:sqlalchemy@googlegroups.com] On Behalf Of Krishnakant > Sent: 03 January 2016 08:16 > To: sqlalchem