[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade
From: |
Benoit Hamet |
Subject: |
[Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade |
Date: |
Tue, 24 Jan 2006 12:15:55 +0100 |
User-agent: |
Debian Thunderbird 1.0.7 (X11/20051017) |
(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
- [Phpgroupware-developers] Re: [Phpgroupware-users] pgsql upgrade,
Benoit Hamet <=