and thus I would hope,
some event would be logged.
Possible? Ill-advised?
> From: Lincoln Yeoh
> Date: Sun, 07 May 2006 17:48:32 +0800
> To: HH <[EMAIL PROTECTED]>
> Cc: PostgreSQL
> Subject: Re: [GENERAL] Can't Figure Out Where Rows Are Going
>
> Are the relev
<[EMAIL PROTECTED]>
> Organization: Hub.Org Networking Services
> Date: Sun, 7 May 2006 21:23:32 +0300
> To:
> Subject: Re: [GENERAL] Can't Figure Out Where Rows Are Going
>
> Turn PITR on
> Restore database to the state immediately after transaction is commited and
> look
de of that transaction, I (incorrectly?)
assumed that meant it was committed.
I will keep looking for other reasons.
Hunter
> From: John Sidney-Woollett <[EMAIL PROTECTED]>
> Date: Sun, 07 May 2006 09:11:10 +0100
> To: HH <[EMAIL PROTECTED]>
> Cc: Tom Lane <[EMAIL P
ing(255) |
product_id| character varying(255) |
line_source | character varying(255) |
Indexes:
"order_lines_pkey" PRIMARY KEY, btree (id)
"order_lines_order_id_index" btree (order_id)
Foreign-key constraints:
"order_lines_order
:43:19 -0400
> To: Rodrigo Gonzalez <[EMAIL PROTECTED]>
> Cc: HH <[EMAIL PROTECTED]>, PostgreSQL
> Subject: Re: [GENERAL] Can't Figure Out Where Rows Are Going
>
> Is there an chance the rows are being inserted in a transaction that
> fails and rolls back? Maybe
>
> Date: Sat, 06 May 2006 20:33:29 -0300
> To: HH <[EMAIL PROTECTED]>
> Cc: PostgreSQL
> Subject: Re: [GENERAL] Can't Figure Out Where Rows Are Going
>
> Just to be sure
>
> Any error msg in log?
>
> Maybe you can run this query in psql and see
Hello,
I am running 8.1.3, built from source, on RHEL4/x64.
I have a Web application that uses this database to sell products. We have
an order table and an order lines table with a one to many relationship
between them.
For the past few months I have had a strange problem where sometimes (about
