Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB - work around

2008-01-07 Thread Rolf Schaufelberger
Hi, On Sunday 06 January 2008 11:13:21 Patrick Weemeeuw wrote: Analyzing the problem a bit more, I found out that, in generic terms, find_or_new({ pk_col = undef }) creates an internal row, and that the successive insert fails to substitute the pk_col with a value from the sequence,

Re: [Dbix-class] Bug with relationships on new objects.

2008-01-07 Thread Jess Robinson
On Mon, 7 Jan 2008, brett gardner wrote: The offending line is on line 793 of ResultSource.pm $ret{$k} = $for-get_column($v) if $for-has_column_loaded($v); That's because has_column_loaded returns true if the data is in/was loaded from the database, you're calling new(), which doesnt

Re: [Dbix-class] Re: utf8 / pg double encoding problem

2008-01-07 Thread Daniel McBrearty
well, the moral is probably never work on your code when recovering from flu. It was pretty much a self-induced problem. I have a system where the user submits a value, and the value is copied back to them. If there is a network problem with corruption of the data, they will see it, as the

[Dbix-class] RFC: InflateColumn::File proposed changes

2008-01-07 Thread Marc Mims
Last week, I attempted to use InflateColumn::File to discover that the latest version on CPAN is broken. I have created a branch to resurrect it, since it appeared to require more than a simple bug fix. http://dev.catalyst.perl.org/repos/bast/DBIx-Class/0.08/branches/file_column I have committed

Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB

2008-01-07 Thread Patrick Weemeeuw
On Monday 07 January 2008 10:43:49 Jess Robinson wrote: On Sun, 6 Jan 2008, Patrick Weemeeuw wrote: | create table article ( | artId integerNOT NULL DEFAULT | nextval('article_artid_seq'), day char(8)NOT NULL, | seqnr integerNOT

Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB

2008-01-07 Thread Jess Robinson
On Mon, 7 Jan 2008, Patrick Weemeeuw wrote: So, I don't know whether the find_or_new method should create an embryonic row that satisfies the conditions of the where clause, or not. In the first case the where-clause values are copied to the row, in the other case they are not. And I am

Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB

2008-01-07 Thread Erik Colson
Erik Colson wrote: does this mean it is possible to do such a thing : $newrecord = $rs-new({id=DEFAULT}) ; and then $newrecord-insert ; would autoincrement id if id is defined as a primary key autoincrement ? Hate replying to myself ... but this seems to work with sqlite3

Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB

2008-01-07 Thread Erik Colson
Jess Robinson wrote: There may be a DB where submitting NULL to a NOT NULL field which is auto-inc does the required thing, but it's not sane, IMO. Most prefer either don't supply it or want DEFAULT instead which is saner and iirc standard. does this mean it is possible to do such a