template Database
Every time I use the server I get this message from postmaster
FATAL 1: Database "template0" is not currently accepting connections
How can I correct this condition??
Bob T
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>