Here is where the query type numbers are defined:
https://fedorahosted.org/spacewalk/wiki/PostgresTechnicalApproach
---------------------------------------------------------------------------
Vikram Rai wrote:
> Hi,
>
> We have started looking at the queries that need to be tagged.
> In the initial stages of going through these queries we found a couple
> of things and some ways we can tag them.
>
> Keeping in mind the diversity and complexity of the some of the queries
> we have divided them into four categories:
>
> 1. Queries that need to have minor changes to make them work in postgres.
>
> For eg: It could be like adding an "as" clause for alias names etc.
> We had a suggestion to tag them with the following comment where ever
> the changes are necessary:
>
> pgsql_c:xxx --> which is postgresql_comment:line number.
>
> 2. Queries that need to be rewritten. We had gone through a couple of
> them as we went along the list and found some queries that had to be
> rewritten to give an exact result. For eg: queries on system catalogs in
> oracle do not work in postgres.
>
> we would be tagging such queries with the following comment:
>
> pgsql_q:xxx --> which is postgresql_query:line number.
>
> 3. Incase there are any db changes to accommodate a query using Orafce,
> such queries would be tagged as:
>
> pgsql_orafce:xxx --> which is postgresql_database_change:line number.
>
> 4. No changes required to the existing query. Works both on postgres and
> oracle.
>
> pgsql_ora:xxx --> which is works on both postgres and oracle:line
> number.
>
> These are just some initial thoughts and I am sure we will have some
> additions to it down the road as we unfold some more of them. Do let me
> know what you think.
>
> Regards,
>
> Vikram Rai
> EnterpriseDB
> _______________________________________________
> Spacewalk-devel mailing list
> [email protected]
> https://www.redhat.com/mailman/listinfo/spacewalk-devel
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
