[Gambas-user] Problem with Postgresql

[rolf]

 Hi,

> I need to add a column to a postgres table (which name starts with an
> underscore) and and have to modify a few constraints. With this actions the
> following problems araise:
> - Postgresql 8.1 always crashes when a "serial" datatyp is requested. The
> log file says something like "bad UTF-8" code. The server crashes with a
> message like "ERROR-STACK EXCEED"
>
> - CODE:
>   query1 = "alter table _" & TextBox.Text & " add column id serial not
> null" res1 = hDB.Exec(query1)
>
> - The same happens, if a primary key should be set with a code like:
>     query1 = "ALTER TABLE ONLY _" & TextBox.Text &
>                      " ADD CONSTRAINT X" & TextBox.Text &
>                      "_pkey PRIMARY KEY (id)"
>    res1 = hDB.Exec(query1)
>
> Of couse I checked the output of the "direct window" with the
> setting:  "DB.Debug = true"
>
> A copy of the output line into the psql-Client works without any problem!
>
> At least I don't know, if it is a gambas or a postgresql problem.

I use GAMBA 1.9.31 and PostgreSQL 8.1.4

It seems to be a problem of postgresql and no real solution.

Bye
Rolf