Bug #6258

createtable.php not fully working

Details

Submitted	2005-12-16 05:15 UTC
From	bwragg at westnet dot com dot au
Status	Bogus
Package	DB_DataObject
PHP Version	4.3.4
OS	linux
Roadmaps	(Not assigned)

Comments

[2005-12-16 05:15 UTC] bwragg at westnet dot com dot au

Description:
------------
I'm using postgresql 7.4.6 with formbuilder and I'm having trouble running the createTable.php script.

When i run it, it creates all the files required and everything seems correct except in the db schema ini file it misses information. For example this table:

CREATE TABLE item(
id serial NOT NULL,
title varchar NOT NULL,
CONSTRAINT item_pkey PRIMARY KEY (id)
)

Gets definied as the following in the ini file as:

[public.item]
id = 1
title = 2

[public.item__keys]

Notice how the id field should be a not null and the id field should be in the keys section. Same thing happens on tables with int4 fields as the primary keys.

Also the class files that get created are saved like Public_item.php and the class name is DataObjects_Public_item. I know this isn't really a bug, but is ther a way around?

[2005-12-16 05:18 UTC] bwragg at tpg dot com dot au

Forgot to mention that it works fine if I use proxy=full in the ini file.

I can't use proxy though as I need to customise my objects.

[2006-01-24 06:52 UTC] bwragg at westnet dot com dot au

the above comment by alan_k at php dot net fixed the problem