[BUGS] BUG #2512: pg_dump produces unrestorable output when table and serial sequence are not in the same schema

2006-07-04 Thread Phil Frost
The following bug has been logged online: Bug reference: 2512 Logged by: Phil Frost Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Mac OS 10.4.7 Description:pg_dump produces unrestorable output when table and serial sequence are not in

[BUGS] server stopped running abnormally

2006-07-27 Thread Phil Frost
Things were crusing along just fine as I can tell, and then all the postgresql processes terminated. This is all I see in the logs: LOG: autovacuum: processing database "dew" LOG: autovacuum: processing database "postgres" LOG: autovacuum: processing database "template1" LOG: autovacuum: proce

[BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-14 Thread Phil Frost
I have been attempting to migrate my application from 8.1 to 8.2.3. In doing so, I found some queries would always cause the postgres backend to die with a segfault. I was advised to rebuild with -- enable-debug --enable-cassert, and so I did. The same query would now cause an assertion fail

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-15 Thread Phil Frost
o it couldn't be blamed. I'll explore the problem more today and see if I can get a backtrace with a debug version and debug_assertions off. On Feb 14, 2007, at 5:49 PM, Tom Lane wrote: Phil Frost <[EMAIL PROTECTED]> writes: I have been attempting to migrate my application from 8.

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-15 Thread Phil Frost
Yeah, maybe I am the only one doing this to the planner. The optimizations which caused this error will be greatly appreciated when I stop getting segfaults, however :) I rebuilt my pg with the attached patch and it did indeed resolve the assertion failure the previous test produced. I tink

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-16 Thread Phil Frost
Great, this seems to solve the problem. Thanks for the prompt attention. On Feb 15, 2007, at 10:52 PM, Tom Lane wrote: Phil Frost <[EMAIL PROTECTED]> writes: I rebuilt my pg with the attached patch and it did indeed resolve the assertion failure the previous test produced. I tinkere

Re: [BUGS] BUG #3059: psql to 'postgres' shortcut

2007-02-27 Thread Phil Frost
Hrm...I haven't used windows for a while now, but isn't there an option on all shortcuts to command-line programs to make the shell pause on exit? It is something like, right click on shortcut, select 'properties', uncheck 'close shell on exit'. It would seem this would solve the problem of

Re: [BUGS] BUG #3297: psql won't open

2007-05-22 Thread Phil Frost
On May 22, 2007, at 14:57 , ;John D. Tiedeman wrote: The following bug has been logged online: Bug reference: 3297 Logged by: ;John D. Tiedeman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.4 Operating system: Linux (Kubuntu 7.4) Description:psql won't ope