Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.2.3
-
Component/s: Data Fixtures
-
Labels:None
-
Environment:Ubuntu lucid up to date - Symfony 1.4.4 - Postgresql 8.4
Description
If I force id in fixtures (they are autoincremented in model), the sequence is not set correctly in postgresql.
Model :
T_Company:
actAs:
Timestampable: ~
Searchable:
fields: [name]
columns:
company_id:
dn:
{ type: string(255) }name:
{ type: string(127), notnull: true} relations:
RssSettings:
ParentCompany:
{ local: company_id, foreign: parent_company_id, foreignAlias: ChildCompany, refClass: J_Company_Company, class: T_Company }ParentLinkType:
{ local: company_id, foreign: parent_company_id, refClass: J_Company_Company, class: S_CompanyLinkType }Fixtures :
T_Company:
A:
company_id: 1
name: A
dn: A
B:
company_id: 2
name: B
dn: B
C:
company_id: 3
name: C
dn: C
Postgresql :
sl3dev=# select * from t__company;
company_id | dn | name | created_at | updated_at
-------------------------------------------------------------------------------------------------------------------------------------------------------
1 | A | A | 2010-05-18 16:55:12 | 2010-05-18 16:55:12
2 | B | B | 2010-05-18 16:55:12 | 2010-05-18 16:55:12
3 | C | C | 2010-05-18 16:55:12 | 2010-05-18 16:55:12
sl3dev=# select nextval('t__company_company_id_seq'::regclass);
nextval
---------
1
(1 ligne)
1 instead of 4 naturally.
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | No sequence_id increment after fixtures loaded forcing their ids | No sequence_id increment after fixtures loaded, while setting their ids |
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Fix Version/s | 1.2.3 [ 10051 ] |
- Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DC-691, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)