Opened 9 years ago

Closed 8 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


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

Should probably mention that this is on 0.11.7dev.

comment:2 Changed 9 years ago by anatoly techtonik

Owner: changed from Pedro Paixao to anatoly techtonik

Probably. Does it relate somehow to NoAnonymousPlugin ?

comment:3 Changed 8 years ago by anatoly techtonik

Resolution: invalid
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain anatoly techtonik.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.