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

Re: when does CREATE VIEW not create a view?

From: Brook Milligan <brook(at)biology(dot)nmsu(dot)edu>
To: malcontent(at)msgto(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: when does CREATE VIEW not create a view?
Date: 2000-08-28 15:26:13
Message-ID: 200008281526.JAA08126@biology.nmsu.edu (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
   >    Here's a patch that silently truncates the generated rule name.

   What are the consequences of changing the NAMEDATALEN and recompiling?
   Doesn't that seem like a better solution then to truncate the view name? 

All names are truncated.  The bug arises from the fact that view names
were being incorrectly truncated by not taking into account the extra
characters added to enforce the automatic "on select" rule.  The point
is to make the truncation rules internally consistent.

Cheers,
Brook

In response to

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-08-28 15:39:53
Subject: Re: SQL COPY syntax extension (was: Performance on inserts)
Previous:From: Brook MilliganDate: 2000-08-28 15:24:00
Subject: Re: Re: Too many open files (was Re: spinlock problems reported earlier)

pgsql-patches by date

Next:From: Alex KapranoffDate: 2000-08-28 18:19:23
Subject: Re: Unbreak plperl building
Previous:From: Ross J. ReedstromDate: 2000-08-28 15:21:16
Subject: Re: when does CREATE VIEW not create a view?

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