Opened 7 years ago

Closed 7 years ago

#6439 closed defect (invalid)

psql error on table creation

Reported by: isavoy@… Owned by: techtonik
Priority: normal Component: NoAnonymousPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


dev=> CREATE TABLE milestone_teams (milestone text, username text, role integer, notify integer, UNIQUE (milestone, username), FOREIGN KEY (milestone) REFERENCES milestone(name), FOREIGN KEY (username) REFERENCES session(sid)); NOTICE: CREATE TABLE / UNIQUE will create implicit index "milestone_teams_milestone_key" for table "milestone_teams" ERROR: there is no unique constraint matching given keys for referenced table "session"

Attachments (0)

Change History (3)

comment:1 Changed 7 years ago by isavoy@…

Should probably mention that this is on 0.11.7dev.

comment:2 Changed 7 years ago by techtonik

  • Owner changed from pedro to techtonik

Probably. Does it relate somehow to NoAnonymousPlugin ?

comment:3 Changed 7 years ago by techtonik

  • Resolution set to invalid
  • Status changed from new to closed

Closing as invalid, because NoAnonymousPlugin definitely could not be the reason for psql failure.

Add Comment

Modify Ticket

as closed The owner will remain techtonik.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.