Loading...
 
Development

Development


PostgresSQL and quoted identifiers

posts: 2 United Kingdom

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.

posts: 2881 United Kingdom

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


posts: 2 United Kingdom

Thanks,

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

posts: 2881 United Kingdom

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

No problem! Great to know your sorted out


posts: 2881 United Kingdom

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

No problem! Great to know your sorted out


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting