perl.dbi.users...Re: Detecting auto-incrementing primary keys by C.J. Adams-Collier- June 30, 2008 I expect he was looking for an abstraction around the concept ofauto-increment primary key sequence, etc.Dan,As Greg mentioned, since 1.38, DBI has specified a C<last_insert_id>method. The docs recommend caution when using this method, however,since its operation may or may not be defined depending on which DBDdriver used.http:search.cpan.orgtimbDBI-1.605DBI.pmlast_insert_idWhich driver(s) do you intend to useCheers,C.J.On Mon, 2008-06-30 at 13:42 +0000, Greg Sabino Mullane wrote:>...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33027.html rt.cpan.org 36696 DBI AutoCommit perldebug eval $ problem by Tim_Bunce via RT- June 30, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36696 >Doesn&39;t the fact this only happens in the debugger point to a problem with the debuggerhttp://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33026.html Re: Detecting auto-incrementing primary keys by Greg Sabino Mullane- June 30, 2008 -----BEGIN PGP SIGNED MESSAGE-----Hash: RIPEMD160> I&39;m looking for a portable way to detect auto-incrementing primary> keys. Is there oneNo - because there is no universal concept of an "auto-incrementing"primary key. MySQL and SQLite have a specific column modifiercalled AUTOINCREMENT. Postgres uses sequences and a default value.Oracle uses sequences and a trigger. And so on. Perhaps if you explainwhat exactly you are trying to do, another solution (such...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33025.html Detecting auto-incrementing primary keys by Daniel Kasak- June 30, 2008 Hi all.I&39;m looking for a portable way to detect auto-incrementing primarykeys. Is there oneI&39;m using $dbh->primary_key_info to fetch details about column(s) thatare participating in primary keys, but this doesn&39;t mention whetherthey&39;re auto-incrementing or not, and I must also know this.I realise I can do $dbh->column_info to fetch info on columns, but:a) Not all servers support this ( SQLite, which I have to support,doesn&39;t )b) It&39;s not very portable - each server seems.http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33024.html DBD-ODBC 1.15 "freezes" by Kristian Oye- June 26, 2008 I just upgraded from DBD-ODBC 1.13 to 1.15 using the ActiveStaterepository (e.g. ppm install DBD-ODBC) and am now experiencing a new"behavior" where re-executing the same prepared statement 3 timeslocks up the current process.My info: I am running DBD-ODBC 1.15 on Windows XP (and 2003 Server inour production facility) with ActiveState Perl 5.8.7 (build 815). Iexperience the same issue when connecting to both MSSQL 2000 and 2005(Microsoft SQL Server 2000 - 8.00.760 (Intel X86) and...http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33023.html Re: rt.cpan.org 37092 Bogus RT e-mail updates by Jacqui Caren via RT- June 25, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=37092 >adrianhquietstars.com via RT wrote:> Wed Jun 25 12:31:40 2008: Request 37092 was acted upon.> Transaction: Ticket created by adrianhquietstars.com> Queue: DBI> Subject: Bogus RT e-mail updates> Broken in: (no value)> Severity: (no value)> Owner: Nobody> Requestors: adrianhquietstars.com> Status: new> Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=37092.http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33020.html rt.cpan.org 36696 DBI AutoCommit perldebug eval $ problem by Jan Dubois via RT- June 25, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36696 >I think the DESTROY method for the dbh is calling code that in turn useseval(), which will clear out $. The fix should be to localize $ inthe DESTROY function before calling any other code from it.http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33021.html Re: rt.cpan.org 37092 Bogus RT e-mail updates by jhannahomnihotels.com via RT- June 25, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=37092 >On 62508 11:31 AM, "adrianhquietstars.com via RT" <bug-DBIrt.cpan.org>wrote:> I too am getting RT updates on something that (to the best of my> knowledge) I have nothing to do with :-)Me three.jhttp://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33022.html Re: Cannot run INSERT statement over odbc connection to postgres db by Alexander Medina- June 25, 2008 Awesome, this fixed it. There was actually no ReadOnly setting (andtherefore must default to Readyonly=yes, but I added this to the DSN entry:ReadOnly = NoAnd the connection worked.Thanks!Alex-On Wed, Jun 25, 2008 at 12:23 PM, Greg Sabino Mullane <gregturnstep.com>wrote:>> -----BEGIN PGP SIGNED MESSAGE-----> Hash: RIPEMD160>>> > "DBD::ODBC:db prepare failed: unixODBCConnection is readonly, only> select> > statements are allowed....http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33019.html Re: Cannot run INSERT statement over odbc connection to postgres db by Alexander Medina- June 25, 2008 Awesome, this fixed it. There was actually no ReadOnly setting (andtherefore must default to Readyonly=yes, but I added this to the DSN entry:ReadOnly = NoAnd the connection worked.Thanks!Alex-On Wed, Jun 25, 2008 at 12:23 PM, Greg Sabino Mullane <gregturnstep.com>wrote:>> -----BEGIN PGP SIGNED MESSAGE-----> Hash: RIPEMD160>>> > "DBD::ODBC:db prepare failed: unixODBCConnection is readonly, only> select> > statements are allowed....http://www.nntp.perl.org/group/perl.dbi.users/2008/06/msg33018.html |