Re: [Phpwebsite-developers] postgresql errors

[Richard S. <ri...@ri...>]

Yes, a one liner after creating the table should be compliant... CREATE 
INDEX indexname ON tablename (column, ...);

Let me know when this is done and i'll give the installation another 
shot.

- Richard S.


On Tuesday, August 19, 2003, at 10:53  AM, Matthew McNaney wrote:

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