Skip site navigation (1) Skip section navigation (2)

Re: Inconsistent Errors on Row Comparisons

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Inconsistent Errors on Row Comparisons
Date: 2009-06-30 18:36:41
Message-ID: 291009CA-CBBB-4E4F-9871-B2A7AB6137A6@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Jun 30, 2009, at 11:27 AM, David E. Wheeler wrote:

>    # Failed test 148
>    #     Number of columns differs between queries
>    #         have: 4 columns
>    #         want: 3 columns
>
>    # Failed test 149
>    #     Column types differ between queries
>    #         have: (integer,text)
>    #         want: (inet,text)
>
> This gives the tester a lot of information to help diagnose the test  
> failure. I don't know that I can gather that kind of information,  
> though.

Actually, I can for `set_eq()`, since it creates a temporary table, I  
can just get the list of types from the system catalog. Is there a way  
to get a RECORD object to tell me what data types it contains? Then I  
could use the same error for both situations, since the difference in  
the number of columns is implicit in the list of data types:

    # Failed test 148
    #     Column types differ between queries
    #         have: (integer,text,integer)
    #         want: (inet,text)

    # Failed test 149
    #     Column types differ between queries
    #         have: (integer,text)
    #         want: (inet,text)

Thanks,

David

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2009-06-30 18:41:46
Subject: Re: 8.5 development schedule
Previous:From: Alvaro HerreraDate: 2009-06-30 18:31:39
Subject: Re: 8.5 development schedule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group