Opened 8 years ago

Closed 7 years ago

#1320311 closed Bugs (Fixed)

a bunch of postgresql related bugs

Reported by: rstml Owned by: roundcube
Priority: 5 Milestone:
Component: Database Version: 0.1-alpha
Severity: Keywords:
Cc:

Description

just seen pgsql suport and decided to test, however
looks like no one use it:

- 'ip' column missing in 'session' table
- postgres do not support LIMIT #,# syntax, use LIMIT
and OFFSET clauses
- there's no NOW() function, use now() instead
- change ORDER BY `default` to ORDER BY "default"

And sort of feature request:
- add prefix to table names. it's useful to have
"rc_sessions" table instead of "sessions" when you've
limited number of databases.
- add dynamically configurable sequence names

Change History (3)

comment:1 Changed 8 years ago by nobody

Logged In: NO 

Postgres does not support UNIX_TIMESTAMP()

use:

EXTRACT(EPOCH FROM current)

comment:2 Changed 7 years ago by nobody

Logged In: NO 

another minor postgresql mistake in INSTALL (might be freebsd specific) :

roundcubemail =# ALTER USER roundcube WITH PASSWORD 
'the_new_password';   

should be changed to 

roundcubemail =# ALTER USER roundcubemail  WITH PASSWORD 
'the_new_password';   

or the user should be called roundcube everywhere and not roundcubemail


comment:3 Changed 7 years ago by roundcube

  • Status changed from assigned to closed
Note: See TracTickets for help on using tickets.