[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-user
Subject:    Re: [Gambas-user] Gambas & PostgreSQL cannot create index. relation
From:       "Ron_1st" <ronstk () tiscali ! nl>
Date:       2009-01-24 16:56:10
Message-ID: 200901241756.10351.ronstk () tiscali ! nl
[Download RAW message or body]

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

-- 
 

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

[prev in list] [next in list] [prev in thread] [next in thread]