> > ---------- Messaggio inoltrato ---------- > > From: "Benoît Minisini" <gam...@users.sourceforge.net> > > To: mailing list for gambas users <gambas-user@lists.sourceforge.net> > > Date: Thu, 9 Sep 2010 03:10:27 +0200 > > Subject: Re: [Gambas-user] gb3 and postgresql indexes > > > >> Hi to all > >> creating a table onto a postgresql db fails when adding the index, this > >> is my code: > >> > >> Public Function CreaDbUtenti() As Boolean > >> Dim hConn As New Connection > >> Dim hTable As Table > >> With hConn > >> .Host = "localhost" > >> .Type = "postgresql" > >> .Port = "6532" > >> .Login = "postgres" > >> .Password = "<postgrespwd>" > >> .Open() > >> End With > >> If (Not hConn.Databases.Exist("gbputenti")) Then > >> hConn.Databases.Add("gbputenti") > >> hConn.Close() > >> hConn.Name = "gbputenti" > >> hConn.Open() > >> hTable = hConn.Tables.Add("utenti") > >> With hTable > >> .Fields.Add("id", db.Serial) > >> .Fields.Add("unome", db.String, 30) > >> .Fields.Add("ucognome", db.String, 30) > >> .Fields.Add("ulogin", db.String, 30) > >> .Fields.Add("upassword", db.String, 50) > >> .Fields.Add("ureparto", db.String, 30) > >> .Fields.Add("uaziende", db.String, 100) > >> .Fields.Add("utipo", db.Integer, 1, 1) > >> .Fields.Add("ulastmodify", db.Date) > >> .PrimaryKey = ["id"] > >> .Update() > >> .Indexes.Add("login", ["ulogin"], True) > >> End With > >> gbPneus.gbpLog.logWrite(("Creato DB Utenti.")) > >> Else > >> gbPneus.gbpLog.logWrite(("Il DB utenti esiste.")) > >> Endif > >> hConn.Close() > >> Return True > >> > >> Catch > >> gbPneus.gbpLog.logWrite(Subst$(("Errore durante la creazione del DB > >> utenti: &1"), Error.Text)) > >> Return False > >> End > >> > >> The server logs: > >> ERROR column "utenti" does not exist > >> STATEMENT CREATE UNIQUE INDEX "login" ON "utenti" ( "utenti" ) > >> > >> The same function works fine with mysql. > >> > >> gambas3 rev. 3195 > >> SO Ubuntu 10.04 > >> Psql ver. 8.4.4-0 installed from binaries > >> > >> Any help will be appreciated, > >> Emanuele > > > > Please can you run the same code by setting DB.Debug = True before, and > > send the debugging messages? > > > > Thanks in advance. > > > > Regards, > > > > -- > > Benoît Minisini > > Thanks Benoît, > pls teach me how can I do it... > > Emanuele >
Put "DB.Debug = TRUE" before your code and run it again. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user