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