Re: [Phpwebsite-developers] Postgres Support (making progress...)

[David M. <dma...@so...>]

On Wed, 2003-11-05 at 14:30, Richard Sumilang wrote:
> You forgot the cache_idx. You must name an index in order to create it.
> 
> - Richard Sumilang

I finally figured out that the error was occurring from where I had been
trying to replace line 769 in core/Database.php with a postgres
compatible version.  What finally seemed to work is replace the function
with

foreach ($columns as $item){  $sql = "CREATE INDEX idx on "
$this->tbl_prefix . "$table_name ($item)";
  if ($this->query($sql)) return TRUE;
  else return FALSE;
}

Now I get a error from line 484 where it performs a "show index" query.



> 
> On Nov 4, 2003, at 6:01 PM, David Macbanay wrote:
> 
> >>> biggest problem I've been having is in the "setup/install.sql" file. 
> >>>  I
> >>> do not know the equivalent syntax for lines such as
> >>> "index(mod_title,id)".  Someone has mentioned about removing these 
> >>> line
> >>
> >> I used:
> >>
> >> create index cache_idx on cache (mod_title, id);
> >>
> > Here is the error that I get when I use that statement
> >
> > DB Error: syntax error
> > CREATE INDEX on cache (mod_title) [nativecode=ERROR: parser: parse 
> > error
> > at or near "on" at character 14 ]
> >
> > David
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Phpwebsite-developers mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> >
> >
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers