David Johnston yahoo.com> writes:
>
> Trigve Siver wrote
> > I want to iterate all records with cursor from beginning to end. This
> > sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> > I'm interested with solution which throws er
>
> From: Giuseppe Broccolo
>To: pgsql-general@postgresql.org
>Sent: Wednesday, September 4, 2013 6:26 PM
>Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
>error
>
>
>
>Hi Trigve,
>
>Il 04
> From: Tom Lane
> To: Trigve Siver
> Cc: "pgsql-general@postgresql.org"
> Sent: Wednesday, September 4, 2013 7:04 PM
> Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
> error
>
>T rigve Siver writes:
>> yes I
option to enable backward scan.
I want to iterate all records with cursor from beginning to end. This sample
could be rewritten using FETCH FORWARD 1 ... without using MOVE but I'm
interested with solution which throws error.
Thank you
Trigve
--
Sent via pgsql-general mailing
On 6. Okt, 08:48 h., Trigve wrote:
> Hi,
> I'm trying to make a custom composite type and use it as a PK and FK.
> When adding FK to table I've got trhis error: operator is not unique:
> "BigintRef" pg_catalog.= "BigintRef" (see below). Here is my type
&
best candidate operator. You might need to
add explicit type casts.
QUERY: SELECT fk."id" FROM ONLY "pg_temp_6"."t_b" fk LEFT OUTER JOIN
ONLY "pg_temp_6"."t_a" pk ON ( pk."id"::pg_catalog.record
OPERATOR(pg_catalog.=) fk."id"::pg_catalog.record) WHERE pk."id" IS
NULL AND (fk."id" IS NOT NULL)
Anyone know what is wrong? I'm using PostgreSQL 9.0
Thanks
Trigve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi, Thank you, for the link... was helpfull. Trigve Qingqing Zhou <[EMAIL PROTECTED]> wrote: "Trigve Siver" <[EMAIL PROTECTED]>wrote>> Thank you for reply. No there isn't any panic message. Log contain only> messages I have posted.>Check out th
Note: forwarded message attached.
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.--- Begin Message ---
Hi, Thank you for reply. No there isn't any panic message. Log contain only messages I have posted. TrigveQingqing Zhou <[EMAIL PROTECTED]> wrot
all server processes terminated; reinitializing2006-06-19 12:00:43 LOG: background writer process (PID 133080) exited with exit ... thanks Trigve
Yahoo! Sports Fantasy Football 06 - Go with the leader.
Start your league today!
