[Gambas-user] Problem with Postgresql

[Patrick Jacquot]

rolf wrote:

>Hi Ron
>
>  
>
>>>- CODE:  
>>>  query1 = "alter table _" & TextBox.Text & " add column id serial not
>>>null"   res1 = hDB.Exec(quer<1)
>>>
>>>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)
>>>      
>>>
>>What are those underscores?
>>    
>>
>
>They are used, because the tablename is a number (of a bank account). If I use 
>pure numbered tablenames they always must be double quoted with mouch more 
>trouble.
>
>  
>
>>In example on postgres site: 'ALTER TABLE table_name ADD'
>>    
>>
>
>All the comands work in the psql-shell without any error! I printed out the 
>commands in a file and passed this file as input to psql and again all 
>commands will execute as expected without any error.
>
>  
>
>>Leave those underscore away or do you have really a table starting with '_'
>>?
>>
>>" ADD CONSTRAINT X" & TextBox.Text & "_pkey PRIMARY KEY (id)"
>>This looks as 'CONSTRAINT Xmyname_pkey PRIMARY' are you sure this correct?
>>
>>Maybe also case sensitive can be a problem.
>>    
>>
>
>Postgres is case sensitive in table, column and database names, not in sql 
>commands.
>
>I found a discussion on the postgres mailing list about this problem - with 
>version 8.1.1 - I use 8.1.4 - but in spanish, which I don't understand.
>
>Because all the trouble making sql commands work in the psql-shell I am not 
>shure, if gambas is linked against the right libraries or uses the right 
>function calls. I recompiled gambas (using 1.9.31 because the documentation 
>is still usable) and will test it.
>
>Many thanks for your help.
>Rolf
>
>
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easier
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Gambas-user mailing list
>Gambas-user at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>  
>
Wouldn't it be better to use one and only one table
for all the bank accounts,
and add the account number to the identifiant of that table?

Cordialement
-- 
Patrick