Обсуждение: template Database

Hello,

When I perform a pg_dump of any database (PG 7.1.3) the CREATE
SEQUENCE calls are incorrect.  They all use 'start 1', thus resetting
the sequence at the beginning.  Is this the desired functionality?  I
would think that it should set the sequence at the max value of the
column +1.  Am I missing something?

Brent

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

"Brent R. Matzelle" <bmatzelle@yahoo.com> writes:
> When I perform a pg_dump of any database (PG 7.1.3) the CREATE
> SEQUENCE calls are incorrect.  They all use 'start 1', thus resetting
> the sequence at the beginning.  Is this the desired functionality?  I
> would think that it should set the sequence at the max value of the
> column +1.  Am I missing something?

Yes, the setval() commands executed later on ...

            regards, tom lane

I have a table created with an attribute of polygon datatype.

7.2 seems to have overcome a tuple size limit in 7.1.x which is nice.

The doc's don't go into much detail about geometric operators & functions.

Can PG return the area of a polygon? The docs suggest it can (at least
for box data), but this suggests it can't.

>geotest=# select area(list)from test1;
>ERROR:  Function 'area(polygon)' does not exist
>        Unable to identify a function that satisfies the given argument
>types
>        You may need to add explicit typecasts

Boxing the polygon to return the area won't quite do what I want :-)

Also, is there any further info available on indexing & performance
tweaking for geometric datatypes?

Thanks....

=============================================================================

       _-''-_    <Brent Wood> b.wood@niwa.cri.nz  Ph: +64(4)386-0300
      'o     \/  NIWA, Box 14901,
      > )    /\  Kilbirnie, Wellington, New Zealand
      `-===-'    #include <std_disclaimer>