Re: [Phpwebsite-developers] postgresql errors

[Matthew M. <ma...@tu...>]

On Tue, 2003-08-19 at 04:03, Richard Sumilang wrote:
> With postgre, index's are not created within the "create table" syntax  
> and since it's not the SQL standard then it probably wont work with  
> Oracle and other databases (I think). With using a primary key you  
> don't need to index since primary keys are always indexed and I think  
> mod_title and id are never exactly the same correct?

Primary keys are unique and not needed for cache. It needs to index the
mod_title and id because those are the columns searched under.

So then, if we need an index, I am guessing we will need to leave its
creation out of the table creation and instead make a CREATE INDEX line.
Is that Postgres compatible and will it work cross platform?


> I would like to have pws working on postgre since I am porting most of  
> my applications to it so if you guys want me to do any tests of setting  
> up pws and using some of the mods let me know.

What we mainly need are posts like this. We need to know which formats
are MySQL specific. I would like 0.9.4 to be truly compliant.


Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
http://phpwebsite.appstate.edu
http://ess.appstate.edu