Opened 5 years ago

Closed 4 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 5 years ago by isavoy@…

Should probably mention that this is on 0.11.7dev.

comment:2 Changed 5 years ago by techtonik

  • Owner changed from pedro to techtonik

Probably. Does it relate somehow to NoAnonymousPlugin ?

comment:3 Changed 4 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 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.