Modify ↓

Opened 15 years ago

Closed 14 years ago

#6439 closed defect (invalid)

psql error on table creation

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

Description

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 15 years ago by isavoy@…

Should probably mention that this is on 0.11.7dev.

comment:2 Changed 15 years ago by anatoly techtonik

Owner: changed from Pedro Paixao to anatoly techtonik

Probably. Does it relate somehow to NoAnonymousPlugin ?

comment:3 Changed 14 years ago by anatoly techtonik

Resolution: → invalid
Status: new → closed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain anatoly techtonik.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.