Skip Menu |

This queue is for tickets about the Rose-DB CPAN distribution.

Report information
The Basics
Id: 64331
Status: resolved
Priority: 0/
Queue: Rose-DB
People
Owner: Nobody in particular
Requestors: afanasjev.av [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 0.763

History Show all quoted text
  Thu Dec 30 06:49:20 2010 afanasjev.av [...] gmail.com - Ticket created
Subject: PostgreSQL. Insert error.
Date: Thu, 30 Dec 2010 14:49:09 +0300
To: bug-Rose-DB [...] rt.cpan.org
From: Alexander Afanasjev <afanasjev.av [...] gmail.com>
Hello. I use following software: perl5 (revision 5 version 10 subversion 1) Rose-DB-Object-0.793 Rose-DB-0.762 DBD-Pg-2.17.1 Linux localhost 2.6.35-23-generic #41-Ubuntu SMP Wed Nov 24 11:55:36 UTC 2010 x86_64 GNU/Linux PostgreSQL 8.4.5 I get an error when I try to insert default NULL value in varchar field wich is either foreign key or might be the NULL. Default value for this field is 'NULL::character varying' (it's generated by Rose::DB::Object::Loader). It's happens, because DBD::Pg receive string 'NULL::character varying' and, of course, it's violates foreign key constraint. Of course, I can to change default value to undef in module wich generated by Rose::DB::Object::Loader, but it's not desirable for my application. Is it possible to solve this problem?
  Thu Dec 30 13:17:55 2010 siracusa [...] gmail.com - Status changed from 'new' to 'open'
  Thu Dec 30 13:55:14 2010 siracusa [...] gmail.com - Correspondence added
On Thu Dec 30 06:49:20 2010, afanasjev.av@gmail.com wrote: Show quoted text
> I get an error when I try to insert default NULL value in varchar field wich > is either foreign key or might be the NULL. Default value for this field is > 'NULL::character varying' (it's generated by Rose::DB::Object::Loader).
Can you provide the table definition?
  Thu Dec 30 14:40:33 2010 siracusa [...] gmail.com - Correspondence added
Never mind, it should be fixed in SVN now, and Rose::DB 0.763 and Rose::DB::Object 0.794 both on their way to CPAN now.
  Thu Dec 30 14:40:33 2010 siracusa [...] gmail.com - Correspondence added
Never mind, it should be fixed in SVN now, and Rose::DB 0.763 and Rose::DB::Object 0.794 both on their way to CPAN now.
  Fri Dec 31 11:14:32 2010 siracusa [...] gmail.com - Status changed from 'open' to 'resolved'
  Fri Dec 31 11:14:32 2010 siracusa [...] gmail.com - Fixed in 0.763 added