Title: Please help - libpq API
Hi all,
I have already posted my query regarding libpq functions and wide character support. Pls somebody help me. I am using libpq API functions in my C code to do operations on the database. But the problem I m facing is API functions like PQexec() etcac
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
>> Is it too late to add a function that returns last reset time as well?
>> That would cover all bases and force some less confusing naming.
> This would be one more vote in favour of initdb
Hi,
I am new to pgsql.
At present i ma having Oracle database and using pgsql for my new application.
I would like to access data exists in Oracle database from new pgsql database.
Is there a way to link Oracle database from pgsql?
If not, is there any other ways to achieve it?
Regards,
Chandra.
On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
> On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote:
> > PG 8.1 will have a function to return postmaster start time, but not
> > database reset time. I wonder if this is misdefined --- if you are
> > trying to measure database u
adey wrote:
> Please let me know if there is a way to determine when the Postmaster
> was last restarted?
If you have configured your server log to contain timestamps, that is
your best bet to look. In any case, the server log will tell when the
last shutdown was, so you can at least narrow dow
I wrote
> Adam Witney <[EMAIL PROTECTED]> writes:
>> I think I have found the offending row in measured_bioassay_base... The
>> entry in its toast table looks like this
>> bugasbase2=# select chunk_id, chunk_seq, length(chunk_data) from
>> pg_toast.pg_toast_134401982 where chunk_id = 144391872;
>>
Adam Witney <[EMAIL PROTECTED]> writes:
> I think I have found the offending row in measured_bioassay_base... The
> entry in its toast table looks like this
> bugasbase2=# select chunk_id, chunk_seq, length(chunk_data) from
> pg_toast.pg_toast_134401982 where chunk_id = 144391872;
> chunk_id | c
Adam Witney <[EMAIL PROTECTED]> writes:
> Got that now Sorry but I am being dim... But where do I find the file to
> dump.. You want the index on pg_toast_134401982 right?
Right (if that's the toast table you identified for the problem table).
It's probably named pg_toast_134401982_index. Loo
Adam Witney <[EMAIL PROTECTED]> writes:
>> I would be interested to see "pg_filedump -i -f" output for the toast
>> table's index before you blow it away, if you have time for that.
> Yep I can run this Can't seem to locate pg_filedump though... Its not in
> contrib... Anyone know where it is
On 7/9/05 4:28 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>>> I would be interested to see "pg_filedump -i -f" output for the toast
>>> table's index before you blow it away, if you have time for that.
>
>> Yep I can run this Can't seem to locate pg_fi
> I would be interested to see "pg_filedump -i -f" output for the toast
> table's index before you blow it away, if you have time for that.
Yep I can run this Can't seem to locate pg_filedump though... Its not in
contrib... Anyone know where it is these days?
--
This message has been scann
On 7/9/05 10:50 am, "Adam Witney" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I just ran into an error from pg_dump:
>
> /usr/local/pgsql/bin/pg_dump -F p my_db
>
> pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
> 144391872
> pg_dump: SQL command to dump the contents of
On Wed, Sep 07, 2005 at 10:50:44AM +0100, Adam Witney wrote:
> pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
> 144391872
> pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
You might have a corrupted TOAST table. Have you had any hardware
pro
Adam Witney <[EMAIL PROTECTED]> writes:
> pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
> 144391872
> pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
> failed: PQendcopy() failed.
> Any ideas whats happened here?
If you're lucky, it's just
Hi,
I just ran into an error from pg_dump:
/usr/local/pgsql/bin/pg_dump -F p my_db
pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
144391872
pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
failed: PQendcopy() failed.
pg_dump: Error message
15 matches
Mail list logo
