| Lists: | pgsql-general |
|---|
| From: | "Bob T" <rjtalbo(at)attglobal(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | template Database |
| Date: | 2002-02-24 21:31:42 |
| Message-ID: | 003901c1bd7a$a8254880$8700a8c0@BOBSVAIO |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dump sequence START incorrect? |
| Date: | 2002-02-24 21:46:13 |
| Message-ID: | 20020224214613.21849.qmail@web13008.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump sequence START incorrect? |
| Date: | 2002-02-24 22:22:35 |
| Message-ID: | 12820.1014589355@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
"Brent R. Matzelle" <bmatzelle(at)yahoo(dot)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
| From: | Brent Wood <baw(at)frc(dot)niwa(dot)cri(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | polygon info |
| Date: | 2002-02-25 02:02:37 |
| Message-ID: | Pine.OSF.4.21.0202251342330.375691-100000@neptune.niwa.cri.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(dot)wood(at)niwa(dot)cri(dot)nz Ph: +64(4)386-0300
'o \/ NIWA, Box 14901,
> ) /\ Kilbirnie, Wellington, New Zealand
`-===-' #include <std_disclaimer>