From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] interesting observatation regarding views and V7.0 |
Date: | 2000-02-29 06:43:03 |
Message-ID: | 38BB6A77.53DEDA9D@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> When you finish catching up on your mail, you'll find lztext is already
> back in ;-). At this point, whether you change the representation is
> pretty much irrelevant for rule size, I think. However, I am still
> concerned by the hack I had to put into ruleutils.c to get pg_dump
> to produce valid output for cases like
> create view foo as select * from int8_tbl;
> See the note and code at about line 1000 of utils/adt/ruleutils.c.
> Ideally we want to be able to tell from the parsetree whether the user
> wrote any column aliases or not (and if possible, distinguish the ones
> he wrote from any that got added by the system). So that may force
> a representation change anyway.
Well, if I add another field/list to the RangeTblEntry structure to
hold my working aliases, and if I keep the ref structure as a pristine
copy of the parameters specified by the user, then everything will go
back to working as expected. There may be other places in the code
which really want one or the other of the fields, but as a first cut
I'll isolate the changes to just the parser directory, more or less.
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-02-29 06:48:06 | Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh |
Previous Message | The Hermit Hacker | 2000-02-29 06:32:15 | RE: [HACKERS] Re: ALTER TABLE DROP COLUMN |