From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: attribute names & typecast/psql default port |
Date: | 2001-09-09 03:09:09 |
Message-ID: | Pine.LNX.4.21.0109091308120.6691-100000@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Correct. (Unless anyone can find if it busts anything which regression
would not find?)
Thanks
Gavin
On Sat, 8 Sep 2001, Bruce Momjian wrote:
>
> So bug #1 patch should be applied, and not bug #2 part?
>
>
> > Hi all,
> >
> > I found a few bugs this afternoon - Patch attached. Patch was generated
> > from current source and tested with the regression tests.
> >
> > ...
> >
> > ============== shutting down postmaster ==============
> >
> > ======================
> > All 77 tests passed.
> > ======================
> >
> > ...
> >
> > ----
> >
> > Bug #1: attribute name when column is type cast:
> >
> > Given the following table:
> >
> > test=# \d f
> > Table "f"
> > Column | Type | Modifiers
> > --------+---------+-----------
> > i | integer |
> > test | text |
> >
> > If I do the following:
> >
> > test=# insert into f values(1,'test');
> > INSERT 139549 1
> > test=# select i::int8,test from f;
> > ?column? | test
> > ----------+------
> > 1 | test
> > (1 row)
> >
> > It doesn't make much sense that the first column should be called
> > '?column?'.
> >
> > The patch results in the output appearing like this:
> >
> > test=# select i::int8,test from f;
> > i | test
> > ---+------
> > 1 | test
> > (1 row)
> >
> > ----------
> >
> > Bug #2
> >
> > Found this while testing the first patch. As it happens I only have one
> > box handy and it was running PG already. I changed the default port to
> > 9999. When I executed bin/psql (the freshly built psql) it connected to my
> > production postmaster on port 5432.
> >
> > The patch sets the configured port to that defined in pg_config.h.
> >
> > Gavin
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-09-09 03:09:12 | Re: UTF-8 patch for PgTcl (was: Patch for pl/tcl ...) |
Previous Message | Bruce Momjian | 2001-09-09 03:08:46 | Re: attribute names & typecast/psql default port |