Koen Bok wrote:
Hello, I have two questions concerning sequences.
Whenever an INSERT fails and a ROLLBACK occurs, the sequence is skipped
by one. What is the best way to prevent this? I could do a SELECT
max(id) FROM table and reset the sequence with it by making a trigger on
the table. But
Hi,
is there a possibility to detach/reattache an object from/to the objectstore?
Here is a small samle:
objectstore.begin
load an object o
objectstore.flush
# some time later
change property of o
objectstore.begin
reattach o
objectstore.flush
thanks,
ALex.
I think this patch got lost.
it fixes Firebird so that Date columns are not treated like DateTime columns.
--
Brad Clements,[EMAIL PROTECTED](315)268-1000
http://www.murkworks.com
AOL-IM or SKYPE: BKClements
The following section of this message
hello all -
with an mssql database, i'm walking through this tutorial:
http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html
when using a connect url that does not include the port, freetds
apparently tries to connect to port 4000 by default - i get an error
that includes this line:
Last I heard, SA was requiring only Python 2.3, so in-library support for Decimal would be ruled out. RickOn 5/30/06, Yuan HOng
[EMAIL PROTECTED] wrote:I got the schema reflected from a PostgreSQL table, where some fields
are defined as numeric type. In sqlalchemy the column type is shown
Sounds like you have FreeTDS misconfigued. Port 4000 is the default port
for TDS version 5, which is used to connect to Sybase servers.
You can override that with an environment variable -- see http://www.freetds.org/userguide/envvar.htm
for the details.
There are also date translation issues
Also on this subject, can anyone out there report on their experiences with mxODBC vs. Sql Server?
It would be nice to have a stable and well supported Unix-based mssql
DBAPI module for SA; I've always been a bit nervous about using FreeTDS
in a production environment.
Rick
Does that mean Python2.4 is not officially supported by SA, in things
such like Decimal support?
On 6/2/06, Rick Morrison [EMAIL PROTECTED] wrote:
Last I heard, SA was requiring only Python 2.3, so in-library support for
Decimal would be ruled out.
Rick
--
Hong Yuan
大管家网上建材超市
装修装潢建材一站式购物
the float type coming from Numeric etc. is straight from the DBAPI,
in this case psycopg2. If youd like to make your own Decimal type
which translates this value back and forth from whatever float value
psycopg2 is giving you, simply subclass TypeDecorator, specify
Numeric as the 'impl',
9 matches
Mail list logo