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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-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 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


pgsql-hackers by date

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

pgsql-patches by date

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

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