[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:       Rolf Schmidt <rolf.frogs () t-online ! de>
Date:       2009-01-24 9:13:24
Message-ID: 200901241013.28091.rolf.frogs () t-online ! de
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


Hello Randy.

> STATIC PUBLIC FUNCTION CreateGLTables()
>
>   DIM hTable AS Table
>
>   hTable = Global.$hConn.Tables.Add("glcoa")
>   WITH hTable
>     .Fields.Add("company", db.String, 3)
>     .Fields.Add("account", db.String, 12)
>     .Fields.Add("description", gb.String, 32)
>     .Fields.Add("gltype", gb.String, 1)
>     .Fields.Add("glsort", gb.Integer)
>     .Fields.Add("status", gb.String, 1)
>     .PrimaryKey = ["account"]
>     .Indexes.Add("glcoa_account", "account", TRUE)
>     .Indexes.Add("glcoa_sort", "glsort", TRUE)
>     .Update
>    END WITH
>
> CATCH
>
>   Message.Error("CreateGLTables Function: " & DConv(Error.Text))
> END
>
>
> The error is "Cannot create index. relation glcoa does not exist." Why?
> Can not find any information on the internet about this error.

First of all, what is the output of the commands, when DB.debug is set. With 
this flag you get the sql-statments send to the database written in a console 
window. Then you can copy the output to the command line tool, psql or mysql 
and see, what error messages you get.

Second, you try to make an index on your primary key field, which always has 
an index, because it is the primary key.

HTH
Rolf

["signature.asc" (application/pgp-signature)]

------------------------------------------------------------------------------
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]