On 13-9-2005 23:01, Tom Lane wrote:
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
That's all? There's something awfully suspicious about that. You're
sure this is 8.0.3?
When I do "select version();"
PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> These are all the lines there are for Sep 1:
> [ - 2005-09-01 12:36:50 CEST @] LOG: received fast shutdown request
> [ - 2005-09-01 12:36:50 CEST @] LOG: shutting down
> [ - 2005-09-01 12:36:50 CEST @] LOG: database system is shut down
> [ - 2
On 13-9-2005 20:53, Tom Lane wrote:
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
Unless reindexing is part of other commands, I didn't do that. The last
time 'grep' was able to find an reference to something being reindexed
was in June, something (maybe me, but I doubt it, I'd also reinde
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> Unless reindexing is part of other commands, I didn't do that. The last
> time 'grep' was able to find an reference to something being reindexed
> was in June, something (maybe me, but I doubt it, I'd also reindex the
> user-tables, I suppose)
On 13-9-2005 20:04, Tom Lane wrote:
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
On 13-9-2005 16:25, Tom Lane wrote:
Well, its an index, not a table. It was the index:
"pg_class_relname_nsp_index" on pg_class(relname, relnamespace).
Ah. So you've reindexed pg_class at some point. Rein
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> On 13-9-2005 16:25, Tom Lane wrote:
>> The first thing you ought to find out is which table
>> 1663/2013826/9975789 is, and look to see if the corrupted LSN value is
>> already present on disk in that block.
> Well, its an index, not a table. I
On Thursday September 8 2005 4:08 pm, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I see sys/ipc.h already #includes sys/types.h, though.
>
> Possibly there's some magic #define needed to expose the cid_t
> definition?
>
> We have this in src/template/hpux
> CPPFLAGS="-D_XOPEN_SO
"Ed L." <[EMAIL PROTECTED]> writes:
> Here's my 11.23 compile line:
> gcc -O2 -mlp64 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wendif-labels -fno-strict-aliasing -I../../../src/include
> -D_XOPEN_SOURCE_EXTENDED -c -o pg_sema.o pg_sema.c
> I've attached sys/types.h and sys/ipc.h. I'm happ
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> As a matter of fact, I just tested it again. Issuing that same query
> will trigger the issue again when I execute it. I don't know whether the
> query matters, but I know this one will trigger it, so I didn't try others.
It's highly unlikely t
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I just noticed something in PostgreSQL that might be considered
> surprising (although I do see "Add ISO INTERVAL handling" in the
> TODO list):
> test=> select interval '1' month;
>interval
> --
>00:00:00
> (1 row)
> What's the
On Sun, Sep 11, 2005 at 03:03:57AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > What do other DBMSs do?
>
> This is a fair question. Given that the SQL committee hasn't provided
> any useful leadership, what are other groups doing?
I don't have access to an Oracle system
11 matches
Mail list logo
