[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade
From: |
alex |
Subject: |
Re: [Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade |
Date: |
Tue, 24 Jan 2006 10:41:08 -0600 |
User-agent: |
Thunderbird 1.5 (X11/20051201) |
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
>