The rule question before, request official documentation on the problem

From: Chris Travers <chris(at)metatrontech(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: The rule question before, request official documentation on the problem
Date: 2007-04-11 06:24:50
Message-ID: 461C7F32.6010404@metatrontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all;

Sorry to follow up so soon on my own post. I did find that there was
some discussion about this problem back in 2003. However, the big issue
is that sequences are wrapped by serial data types and so this is likely
to be a common issue (using an insert rule on a serial, causing the
sequence to be incremented for the target table too). In the
application I am working on, this was reviewed by a number of people who
are pretty strong PostgreSQL experts and nobody spotted this as an issue.

My request at this point is to officially and clearly document this as a
substantial limitation of rules. It is not obvious that this is how
rules are supposed to behave in this case, and even assuming that the
current behavior is desired, it would be nice to let us know this :-)
Sometimes the easiest way to fix a bug is to document it as a feature....

Best Wishes,
Chris Travers

Attachment Content-Type Size
chris.vcf text/x-vcard 171 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Cooper 2007-04-11 06:41:06 Re: The rule question before, request official documentation on the problem
Previous Message A. Kretschmer 2007-04-11 06:18:17 Re: Is this a bug? Sequences and rules