Ticket #631 (closed bug: fixed)

Opened 2 months ago

Last modified 2 months ago

Fichier SQL d'installation de jAcl2

Reported by: nuks Assigned to: nuks
Priority: normal Milestone: Jelix 1.1 beta 1
Component: jelix:acl Version: trunk
Severity: normal Keywords: jAcl2 SQL PostGreSQL PgSQL
Cc: Php version:
Review: review+ Hosting Provider:
Documentation needed: 0 Blocking:

Description

Le fichier lib/jelix/core-modules/jelix/install/sql/install_jacl2.data.*.sql inclus deux enregistrement de groupes "admin" et "users" dans jacl2_group. Les id de ces enregistrements (id_aclgrp) sont spécifiés explicitement car réutilisés dans les enregistrements dans jacl2_rights. Le problème est que le fait de spécifié ces ids ne modifie pas la séquence sur postgresql. Ainsi, lors du prochain enregistrement dans jacl2_group sans spécifié explicitement l'id, la séquence va renvoyer l'id 1. La requête va alors être annulé car contradictoire avec la contrainte d'unicité de la colonne jacl2_group.

Attachments

patch.diff (0.9 kB) - added by nuks on 07/02/08 14:39:40.
SELECT setval('table_row_seq', 2, true); or SELECT setval('table_row_seq', 3, false); ;)

Change History

07/02/08 14:08:49 changed by bballizlife

I don't know about postgresql so i can't fix this issue. do you know more and so can you make a proposal in order to have an install file working for postgresql ?

07/02/08 14:39:40 changed by nuks

  • attachment patch.diff added.

SELECT setval('table_row_seq', 2, true); or SELECT setval('table_row_seq', 3, false); ;)

07/02/08 14:42:53 changed by nuks

  • owner set to nuks.

07/02/08 15:13:55 changed by bballizlife

  • review set to review?.

Thanks for the patch, i'll let someone knowing pgsql reviewing it.

07/07/08 11:41:03 changed by laurentj

  • review changed from review? to review+.
  • version changed from 1.0.4 to trunk.
  • milestone set to Jelix 1.1 beta 1.

It's ok for me.

07/11/08 23:45:32 changed by bastnic

  • status changed from new to closed.
  • resolution set to fixed.

commited

Download in other formats: Comma-delimited Text Tab-delimited Text RSS Feed