Re: [BUGS] TOAST tables bug restoring to PostgreSQL 9.0.4

2011-07-25 Thread Tom Lane
ZIV - Beratung writes: > If I dump (pg_dump 8.3) any 8.3 PostgreSQL-Database and then > restore (pg_restore 9.0.4) to a PostgreSQL 9.0.4 Database, > the relpages information concerning restored TOAST-tables in pg_class is > wrong. > The relpages entries are all 0 (or 1(TOAST-Index-relations))! T

[BUGS] TOAST tables bug restoring to PostgreSQL 9.0.4

2011-07-25 Thread ZIV - Beratung
Hello PostgreSQL-Team, i have got a problem with PostgreSQL 9.0.4. I want to migrate. If I dump (pg_dump 8.3) any 8.3 PostgreSQL-Database and then restore (pg_restore 9.0.4) to a PostgreSQL 9.0.4 Database, the relpages information concerning restored TOAST-tables in pg_class is wrong. The relpag

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Stefan Kaltenbrunner
On 07/25/2011 05:57 PM, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of lun jul 25 11:20:55 -0400 2011: >> On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote: Any idea what query triggered this? >>> >>> Only up to which stored procedure (which itself contains multiple >>> statemen

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Alvaro Herrera
Excerpts from Robert Haas's message of lun jul 25 11:20:55 -0400 2011: > On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote: > >> Any idea what query triggered this? > > > > Only up to which stored procedure (which itself contains multiple > > statements). > > If you provide a reproducible test case

Re: [BUGS] BUG #5953: pgadmin sql-query text pad doesn't work

2011-07-25 Thread p.de.waal
Hello, Is there already a fix for this, I just installed pgadmin version 1.12.3 on windows 7. And I also have a problem with the SQL window. I can open it, but can't type any query. On my XP system it worked fine. Regards, Peter -- View this message in context: http://postgresql.1045698.n5.nab

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Robert Haas
On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote: >> Any idea what query triggered this? > > Only up to which stored procedure (which itself contains multiple > statements). If you provide a reproducible test case, we can probably get this fixed. Otherwise, we probably can't. -- Robert Haas Ent