Now it works, thanks. *Jorge Riquelme Santana* *IT Consultant and Software Architect*, Larix <http://www.larix.cl/> mobile: (+56 9) 66594454 <%28%2B56%209%29%2062481315> web: www.larix.cl
On Mon, Dec 12, 2016 at 2:08 PM, mike bayer <[email protected]> wrote: > > the documentation is incorrect, please use this form: > > from sqlalchemy import FetchedValue > > class User(Base): > __tablename__ = 'user' > > id = Column(Integer, primary_key=True) > name = Column(String(50), nullable=False) > xmin = Column("xmin", Integer, system=True, > server_default=FetchedValue()) > > __mapper_args__ = { > 'version_id_col': xmin, > 'version_id_generator': False > } > > > should be up on the site in 30 minutes. > > > > On 12/12/2016 11:48 AM, Jorge Riquelme wrote: > >> Hi, >> >> I'm trying to use the xmin column as described >> in http://docs.sqlalchemy.org/en/latest/orm/versioning.html#ser >> ver-side-version-counters, >> but when I perform an insert I get the following error: >> >> sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column >> "xmin" of relation "organizations" does not exist >> LINE 1: ...INTO organizations (name, created_at, updated_at, xmin) VALU... >> >> It seems that the xmin column should exists, even though it's declared >> as a system column (I was expecting the opposite). >> >> The example below reproduces my problem: >> >> https://gist.github.com/jriquelme/985bbf624919dd69591a2b4efe4f0ab4 >> >> About my environment: >> - Python 3.5.2 >> - SQLAlchemy 1.1.4 >> - psycopg2 2.6.2 >> - Postgres 9.5 >> >> Any guidance will be appreciated :) >> >> Best regards >> >> Jorge Riquelme >> >> -- >> SQLAlchemy - >> The Python SQL Toolkit and Object Relational Mapper >> >> http://www.sqlalchemy.org/ >> >> To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> --- >> You received this message because you are subscribed to the Google >> Groups "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send >> an email to [email protected] >> <mailto:[email protected]>. >> To post to this group, send email to [email protected] >> <mailto:[email protected]>. >> Visit this group at https://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
