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

[Benoit Hamet]

(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.

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
\.

signature.asc
Description: OpenPGP digital signature