[teiid-issues] [JBoss JIRA] (TEIID-5963) Teiid imported all schemas from PG

[Renat Eskenin (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14129723#comment-14129723 ] 

Renat Eskenin edited comment on TEIID-5963 at 6/2/20 4:21 AM:
--------------------------------------------------------------

This SQL get all metadata from DB:

{code}
select
	t.typname,
	t.oid
from
	pg_catalog.pg_type t
join pg_catalog.pg_namespace n on
	(t.typnamespace = n.oid)
where
	n.nspname != 'pg_toast'
	and (t.typrelid = 0
	or (
	select
		c.relkind = 'c'
	from
		pg_catalog.pg_class c
	where
		c.oid = t.typrelid))
{code}

We get all tausents of types from all schemas.


was (Author: i3draven):
This SQL get all metadata from DB:

{code}
select
	t.typname,
	t.oid
from
	pg_catalog.pg_type t
join pg_catalog.pg_namespace n on
	(t.typnamespace = n.oid)
where
	n.nspname != 'pg_toast'
	and (t.typrelid = 0
	or (
	select
		c.relkind = 'c'
	from
		pg_catalog.pg_class c
	where
		c.oid = t.typrelid))
{code}

> Teiid imported all schemas from PG
> ----------------------------------
>
>                 Key: TEIID-5963
>                 URL: https://issues.redhat.com/browse/TEIID-5963
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 14.0
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>
> When we started teiid spring boot app, we have long start time.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)