Re: [HACKERS] when does CREATE VIEW not create a view?

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)hub(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] when does CREATE VIEW not create a view?
Date: 2000-08-23 17:55:18
Message-ID: 20000823125518.A4635@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Wed, Aug 23, 2000 at 10:02:02AM +0900, Tatsuo Ishii wrote:
> > See my other reply about what gets added: the problem is the rewrite
> > rule name, as you guessed.
> >
> > Here's a patch that silently truncates the generated rule name. Unlike
> > tablename or generated sequence name truncation, there's no need in
> > normal operation for the DBA to know the name of this rule, so I didn't
> > put in a NOTICE about the truncation.
> >
> > I found every accurance of _RET in the source that refered to a view rule,
> > and patched them to do the right thing.
>
> Oh, the patch strikes me since it is not "multibyte aware." Are you
> going to put it into the CVS? If so, please let me know after you do
> it so that I could add the multibyte awareness to that.

Well, I meant it to go into CVS, if noone objected. I consider your raising
the multibyte issue sufficent objection to have it held off. No point
patching and repatching.

The problem is that I just chop it off at NAMEDATALEN, which might be
in the middle of a multibyte character, correct?

Ah, I see code in parser/scan.l that does the multibyte aware version
of the chop. Should I just rewrite my patch with that code as a model?

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tiago Antão 2000-08-23 20:13:55 statistics
Previous Message Tiago Antão 2000-08-23 17:22:40 Re: analyze.c

Browse pgsql-patches by date

  From Date Subject
Next Message Malcontent 2000-08-24 06:30:00 Re: when does CREATE VIEW not create a view?
Previous Message Tatsuo Ishii 2000-08-23 01:02:02 Re: [HACKERS] when does CREATE VIEW not create a view?