Re: [Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade

[alex]

Benoit Hamet wrote:
> (Sorry for posting the user discussion from users to devs, but I think
> that's more relevant here)
>
> Hi all,
>
> After some discussion with this guy, I remember some discussion about
> setting null instead of '' in pgsql. He is using pg 7.2 and perhaps this
> explain why the attempt of Chris fails, since perhaps this version of pg
> consider '' as null.
>
>   
Make shure about this. No distro carries 7.2 anymore. Its all 7.4 and
up. If such is the case id say the solution is...upgrade!

> I attach a partial dump of the phpgw_vfs table with first entry ...
> looks strange for me.
>
> Regards,
>
> Caeies.
>
> Chris Weiss wrote:
>   
>> a guy on IRC (who can't join the mailing list for some reason, but
>> that's for another email) is getting this sql error on Step1 when
>> upgrading from .14 to .16.
>> #
>> Database error: Invalid SQL: INSERT INTO phpgw_vfs
>> (file_id,owner_id,createdby_id,modifiedby_id,created,modified,size,mime_type,deleteable,comment,app,directory,name,link_directory,link_name,version,content)
>> VALUES 
>> (1,0,0,0,'1970-01-01',null,null,'Directory','Y',null,null,'/',null,null,null,'0.0.0.0',null)
>> #
>> PostgreSQL Error: 1 (ERROR: ExecAppend: Fail to add null value in not
>> null attribute name )
>>
>>
>> In my install, "name" is '' and not NULL, so I have him set the name
>> ='' and try again and it gave the same message.
>>
>> any idea's?  I don't have pgsql to test with.
>>
>>
>> _______________________________________________
>> Phpgroupware-users mailing list
>> address@hidden
>> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
>>
>>     
>
>   
> ------------------------------------------------------------------------
>
> --
> -- Selected TOC Entries:
> --
> \connect - diverse
>
> --
> -- TOC Entry ID 2 (OID 105982)
> --
> -- Name: phpgw_vfs Type: TABLE Owner: diverse
> --
>
> CREATE TABLE "phpgw_vfs" (
>       "file_id" integer DEFAULT nextval('seq_phpgw_vfs'::text) NOT NULL,
>       "owner_id" integer NOT NULL,
>       "createdby_id" integer,
>       "modifiedby_id" integer,
>       "created" date DEFAULT '1970-01-01' NOT NULL,
>       "modified" date,
>       "size" integer,
>       "mime_type" character varying(150),
>       "deleteable" character(1) DEFAULT 'Y',
>       "comment" character varying(252),
>       "app" character varying(25),
>       "directory" character varying(508),
>       "name" character varying(252) NOT NULL,
>       "link_directory" character varying(508),
>       "link_name" character varying(252),
>       "version" character varying(30) DEFAULT '0.0.0.0' NOT NULL,
>       Constraint "phpgw_vfs_pkey" Primary Key ("file_id")
> );
>
> --
> -- Data for TOC Entry ID 3 (OID 105982)
> --
> -- Name: phpgw_vfs Type: TABLE DATA Owner: diverse
> --
>
>
> COPY "phpgw_vfs" FROM stdin;
> 1     0       0       0       1970-01-01      \N      \N      Directory       
> Y       \N      \N      /               \N      \N      0.0.0.0
> 2     0       0       0       1970-01-01      \N      \N      Directory       
> Y       \N      \N      /       home    \N      \N      0.0.0.0
> 3     6       6       \N      2003-03-25      \N      4096    Directory       
> Y       \N      infolog /infolog        1       \N      \N      0.0.0.0
> 4     5       5       \N      2003-03-25      \N      4096    Directory       
> Y       \N      infolog /infolog        4       \N      \N      0.0.0.0
> 5     3       3       \N      2003-03-26      \N      4096    Directory       
> Y       \N      infolog /infolog        10      \N      \N      0.0.0.0
> 8     3       3       \N      2003-03-26      \N      4096    journal-deleted 
> Y       Deleted infolog /infolog        17      \N      \N      0.0.0.0
> 9     3       3       \N      2003-03-26      \N      4096    journal-deleted 
> Y       Deleted infolog /infolog        14      \N      \N      0.0.0.0
> 11    3       3       \N      2003-03-26      \N      0       journal Y       
> Created infolog /infolog/1      20020816.prn.txt        \N      \N      
> 0.0.0.0
> 10    6       3       \N      2003-03-26      \N      10695   text/plain      
> Y               infolog /infolog/1      20020816.prn.txt        \N      \N    
>   0.0.0.1
> \.
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
>