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

[Randy]

Hello.

New to Gambas and having problems with following code:

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.

Help :-(
Randy

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6)
AntiSpam:  SpamAssassin 3.2.3
AntiVirus: ClamAV 0.91.2/8885 - Wed Jan 21 12:48:08 2009
by Markus Madlener @ http://www.copfilter.org