[Dbix-class] For a reliable update_or_create we need to make create( { primary_key => undef, ... } ) work in Pg

[Matt S Trout]

On Tue, Jan 22, 2008 at 12:43:12PM +0100, Zbigniew Lukasiak wrote:
> Is it ever possible that it works 100%?  I mean - the Relationship POD
> says that "The condition needs to be an SQL::Abstract-style
> representation of the join between the tables" and from follows there,
> it looks that it really can be nearly any SQL::Abstract structure.  Is
> it ever feasible that we parse the SQL::Abstract query and determine
> if it chooses a unique row?  And if not then where you suppose to
> stop?

Of course you can't always determine. But if you don't know, then you default
to "no it doesn't produce a unique row" and provide some way for the user to
say "actually I know it does and I accept you can't help me if I'm wrong" :)

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/