[Gambas-user] Issue 567 in gambas: Recent changes for db collation cause postgresql crash

[gambas at ...2524...]

Status: New
Owner: ----
Labels: Version Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any  
Desktop-Any GUI-Any

New issue 567 by adamn... at ...626...: Recent changes for db collation cause  
postgresql crash
https://code.google.com/p/gambas/issues/detail?id=567

1) Describe the problem.
After the recent gb.db changes to support table level charset and collation  
settings the iteration:
  For Each hField In hTable.Fields
causes the following error
ERR: Unable to get field info: ERROR:  relation "pg_collation" does not  
exist
LINE 1: ...pg_attrdef.adnum = pg_attribute.attnum) left join pg_collati...

At posgres 9.0.17 that relation definitely does not exist. Per column  
collation support was only added at version 9.1

2) Give information about your system. Use the 'System information' menu in
the Gambas IDE, and paste the result there.
[System]
Gambas=3.6.0
OperatingSystem=Linux
Kernel=3.12.18-pclos2
Architecture=x86
Distribution=PCLinuxOS
Desktop=LXDE
Theme=QWindows
Language=en_AU.UTF-8
Memory=1008M
[Libraries]
Cairo=libcairo.so.2.11200.16
Curl=libcurl.so.3.0.0
Curl=libcurl.so.4.3.0
DBus=libdbus-1.so.3.7.8
GStreamer=libgstreamer-0.10.so.0.30.0
GStreamer=libgstreamer-1.0.so.0.402.0
GTK+3=libgtk-3.so.0.1200.2
GTK+=libgtk-x11-2.0.so.0.2400.22
OpenGL=libGL.so.1.2.0
OpenGL=libGL.so.173.14.39
OpenGL=libGL.so.96.43.23
Poppler=libpoppler.so.13.0.0
Poppler=libpoppler.so.19.0.0
Qt4=libQtCore.so.4.8.5
SDL=libSDL-1.2.so.0.11.4

3) Provide a little project that reproduces the bug or the crash.
na

4) If your project needs a database, try to provide it, or part of it.
na

5) Explain clearly how to reproduce the bug or the crash.
see above

6) By doing that carefully, you have done 50% of the bug fix job!

IMPORTANT NOTE: If you encounter several different problems or bugs, (for
example, a bug in your project, and an interpreter crash while debugging
it), please create distinct issues!

ANOTHER NOTE: Don't create an issue if you have a compilation problem on
the development version. Send a mail to the mailing-list instead, thanks.


-- 
You received this message because this project is configured to send all  
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings