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,
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
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
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
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
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
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
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