After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 670859 - MetaStore update doesn't work
MetaStore update doesn't work
Status: RESOLVED OBSOLETE
Product: libgda
Classification: Other
Component: PostgreSQL provider
unspecified
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2012-02-27 05:03 UTC by Daniel Espinosa
Modified: 2018-09-21 13:46 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Python test case (237 bytes, text/x-python)
2012-09-03 22:03 UTC, Daniel Espinosa 		Details

Description Daniel Espinosa 2012-02-27 05:03:16 UTC 
Update meta store for _schemata and _key_column_usages fails.

Reproduce (using Python):

from gi.repositoy import Gda
c = Gda.Connection.open_from_string ("PostgreSQL", "DB_NAME=test", None, Gda.ConnectionOptions.NONE)
ctx = Gda.MetaContext ()
ctx.set_table ("_schemata")
c.update_meta_store (ctx)
Comment 1 Daniel Espinosa 2012-02-27 05:23:44 UTC 
(In reply to comment #0)
> Update meta store for _schemata and _key_column_usages fails.
> 
> Reproduce (using Python):
> 
> from gi.repositoy import Gda
> c = Gda.Connection.open_from_string ("PostgreSQL", "DB_NAME=test", None,
> Gda.ConnectionOptions.NONE)
> ctx = Gda.MetaContext ()
> ctx.set_table ("_schemata")
> c.update_meta_store (ctx)

The problem is for table _information_schema_catalog_name, the code will fail with it.
Comment 2 Murray Cumming 2012-09-01 15:30:39 UTC 
Is this what you see too: Bug #683162 ?

If not, do you see some other warnings or GError messages?
Comment 3 Daniel Espinosa 2012-09-03 22:00:31 UTC 
I have different warning/errors:

Testing using bug report's Python script I have these errors:

SUGGEST META UPDATE Returned FALSE: Meta update error
SUGGEST META UPDATE Returned FALSE: Meta update error
SUGGEST META UPDATE Returned FALSE: Meta update error
Traceback (most recent call last):

+ Trace 230792

  • File "./bug670859.py", line 6 in <module> 
    c.update_meta_store (ctx)
  • File "/usr/lib/python2.7/dist-packages/gi/types.py", line 43 in function 
    return info.invoke(*args, **kwargs)
gi._glib.GError: Meta update error 
gda_meta_context_update_meta_store () prints these messages and return a 'Meta update error' GError message.

SUGGEST META UPDATE Returned FALSE: Meta update error
SUGGEST META UPDATE Returned FALSE: Meta update error
SUGGEST META UPDATE Returned FALSE: Meta update error
Comment 4 Daniel Espinosa 2012-09-03 22:03:36 UTC 
Created attachment 223380 [details]
Python test case

Just use python TheScript.py to run it.
Comment 5 GNOME Infrastructure Team 2018-09-21 13:46:17 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/libgda/issues/63.