[Devel] [ openser-Bugs-1645475 ] presence module use reserved
postgres term
SourceForge.net
noreply at sourceforge.net
Fri Jan 26 18:20:30 CET 2007
Bugs item #1645475, was opened at 2007-01-26 18:20
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1645475&group_id=139143
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Klaus Darilion (klaus_darilion)
Assigned to: Nobody/Anonymous (nobody)
Summary: presence module use reserved postgres term
Initial Comment:
Hi!
Take a look at the xcap_xml table.
CREATE TABLE `xcap_xml` (
`id` int(10) NOT NULL auto_increment,
`user` varchar(66) NOT NULL,
`domain` varchar(128) NOT NULL,
`xcap` text NOT NULL,
`doc_type` varchar(64) NOT NULL,
UNIQUE KEY udd_xcap (`user`,`domain`,`doc_type`),
PRIMARY KEY (id)
)
'user' can't be used in postgresql as it is a reserved word. Further, to be consistent with other modules the term "username" should be used.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1645475&group_id=139143
More information about the Devel
mailing list