| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Strange problem with create table as select * from table; |
| Date: | 2011-11-03 20:17:25 |
| Message-ID: | 201111031317.25481.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thursday, November 03, 2011 1:03:12 pm hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:
>
> So, did some tests:
>
> as you can see counts of rows in created table are more or less
> sensible, but whatever method I used - create table as, insert into,
> using sychronized_scans (initially) or not (later) - copy of the table,
> as long as it's in database, has 40 those "-1" rows.
At least it is consistent:)
Characteristics of those forty rows.
1) creation_tsz clustered?
2) magic_id in a range?
3) Non -1 xobject_id in a range?
4) Any other field show a similarity?
>
> one note - maybe it wasn't clear from my original mail - when I did
> pg_dump of the xobjects table, it didn't have -1 rows.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cin123 | 2011-11-03 21:01:47 | Linker error VS2008 c++ |
| Previous Message | Tony Capobianco | 2011-11-03 20:13:05 | Re: pg_dump schma while excluding specific table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2011-11-03 20:31:18 | Re: GiST for range types (was Re: Range Types - typo + NULL string constructor) |
| Previous Message | hubert depesz lubaczewski | 2011-11-03 20:03:12 | Re: Strange problem with create table as select * from table; |