Hi, I have updated wiki with the process to tag the queries. The below link would be used to track changes:
https://fedorahosted.org/spacewalk/wiki/PgportQueries And the following link has examples for query tagging: https://fedorahosted.org/spacewalk/wiki/QueryTaggingExamples Regards, Vikram Rai EnterpriseDB On Thu, Feb 26, 2009 at 4:12 AM, Bruce Momjian <br...@momjian.us> wrote: > > 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 > > Spacewalk-devel@redhat.com > > https://www.redhat.com/mailman/listinfo/spacewalk-devel > -- > Bruce Momjian <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + If your life is a hard drive, Christ can be your backup. + > > _______________________________________________ > Spacewalk-devel mailing list > Spacewalk-devel@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-devel >
_______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel