Loading...
 
Skip to main content

Development


PostgresSQL and quoted identifiers

Hi,

I tried to setup TikiWiki 1.8RC3 as I need to use the system with PostgreSQL as opposed to MySQL.

I've run into a problem in that using ` for quoted identifiers doesn't seem to work in Pgsql.

I'm using PostgreSQL 7.4.1 and the error I'm getting is:

Warning: error: ERROR: syntax error at or near "`" at character 29 in query:
select `name` ,`value` from `tiki_preferences`

According to the PostgreSQL manual, only doube quotes (") are supported for quoted identifiers.

Is there an easy way round this?

Thanks.

Hi There neilb

RC3 is quite old and I think the progress support was fixed after that release. So your probably best grabbing the CVS code before changing anything. I know we have users with ProgreSql running now.

Damian


Thanks,

It is working in the latest cvs! Sorry .. should've checked that first.

> neilb:
> Thanks,
>
> It is working in the latest cvs! Sorry .. should've checked that first.

No problem! Great to know your sorted out


> neilb:
> Thanks,
>
> It is working in the latest cvs! Sorry .. should've checked that first.

No problem! Great to know your sorted out