[rt-devel] fixing up RT for Postgres 7.3

Vivek Khera khera at kcilink.com
Fri Jan 10 15:06:37 EST 2003

I was starting to poke around DBIx::SearchBuilder for any fixes that
might be needed for Postgres 7.3.  I'm not seeing how SearchBuilder
really knows which DB it is using when, for example, generating the
LIMIT clause.  The one there never should have worked considering that
PG implemented LIMIT X,Y backwards from MySQL (the offset/count order
was reversed).  This is why the preferred LIMIT X OFFSET Y format was
kept in favor of the other format.

So, how does it tell which DB it is using when generating these
things?  Do I just override the method in SearchBuilder's Pg module?

Once that's fixed, it is on to track down all the implicit '' => 0
casts that need to be found and fixed...

Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

More information about the Rt-devel mailing list