I run an application which connects to my pgsql DB.
How could I see which query is sent to DB when, an example, i push some
application button (such ´find´).
sds
Eric Anderson
CPD Via Net SAO
11-66432800
---(end of broadcast)-
How could I record the ´ \d table ´ command to a file?
sds
Eric Anderson
CPD Via Net SAO
11-66432800
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
how could I fix this problem:
ERROR: unexpected chunk number 8 (expected 0)
for toast value 6935693
It appear to be simple: update chunk_seq from 8 to
0.
how to do it?
in the stand alone postgres, could I copy a entire
table?
how to do it?
tnx
Eric
hello all
When i tried ´pg_dump -v -f dump.dmp dtbtransporte´ I got
the error:
pg_dump: restoring data for table tbdmovimento
pg_dump: dumping out the contents of table tbdmovimento
pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value
6935693
pg_dump: lost synchronization
which index? could you help me again?
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 1
Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 11:55 AM
Subject: Re: [SQL] yet pg_toast reindex
> "Eric Anderson Vianet SAO" <[EMAIL PRO
When I try to reindex a toast table with command ´REINDEX TABLE
pg_toast_16557' I receive following error message:
ERROR: "pg_toast_16557" is a system table. call REINDEX under standalone
postgres with -O -P options
So I restart postmaster standalone (no -i option) and I receive same error.
how
Shoul I thank the guys who help me?
Or to post other message saying ´it worked
well etc´?
or it will flood the lists?
I´m new(bie) on the lists.
tnx
Eric Anderson Martins MirandaNet Admin @ Via
Net SAO
c Anderson Martins Miranda
Net Admin @ Via Net SAO
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 27, 2003 11:20 AM
Subject: Re: [SQL] discover a toast t
