Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-1514

prefix for tables but not some constraints?

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
      None
    • Environment:
      Linux
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_13_STABLE

      Description

      When trying to create a second instance of moodle using the same db but a different prefix, the following two sql statements complain:

      CONSTRAINT user_username_uk UNIQUE (username)

      and

      CONSTRAINT config_name_uk UNIQUE (name)

      for the user table & config tables respectively.

      These are the only two I've found thus far, as can't get past the first admin screen.

        Gliffy Diagrams

          Activity

          Hide
          dougiamas Martin Dougiamas added a comment -

          From (penny at catalyst.net.nz) Wednesday, 2 June 2004, 08:50 AM:

          I have attached a new version of postgres7.sql from $CFG->libdir/db/ which fixes the problem.

          From (penny at catalyst.net.nz) Thursday, 15 July 2004, 12:51 PM:

          patch against latest development version from cvs (today) at http://nzvle.eduforge.org/postgres.patch

          From Martin Dougiamas (martin at moodle.com) Thursday, 15 July 2004, 01:59 PM:

          Fixed in CVS (development and stable), thanks.

          You know you could just set up another database, too.

          Show
          dougiamas Martin Dougiamas added a comment - From (penny at catalyst.net.nz) Wednesday, 2 June 2004, 08:50 AM: I have attached a new version of postgres7.sql from $CFG->libdir/db/ which fixes the problem. From (penny at catalyst.net.nz) Thursday, 15 July 2004, 12:51 PM: patch against latest development version from cvs (today) at http://nzvle.eduforge.org/postgres.patch From Martin Dougiamas (martin at moodle.com) Thursday, 15 July 2004, 01:59 PM: Fixed in CVS (development and stable), thanks. You know you could just set up another database, too.
          Hide
          mblake Michael Blake added a comment -

          assign to a valid user

          Show
          mblake Michael Blake added a comment - assign to a valid user

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: