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 _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
