[Gambas-user] Gambas & PostgreSQL cannot create index. relation XXX does not exist.

[Ron_1st]

On Thursday 22 January 2009, Randy wrote:
>  ---8<---
>    .Fields.Add("account", db.String, 12)
>    .Fields.Add("glsort", gb.Integer)
>  ---8<---
>     .PrimaryKey = ["account"]
>     .Indexes.Add("glcoa_account", "account", TRUE)
>     .Indexes.Add("glcoa_sort", "glsort", TRUE)
>     .Update
> 

> The error is "Cannot create index. relation glcoa does not exist." Why?  
> Can not find any information on the internet about this error.




There is something going wrong with the names 'glcoa_account' and 'glcoa_sort'
Try it with 'glcoaaccount' and 'glcoasort' (without the underscore).




Best regards,

Ron_1st

--