On Thu, Apr 3, 2014 at 12:58:37PM +0900, nuko yokohama wrote:
> Hi,
>
> PostgreSQL 9.3 document in "Table 8-9" of "8.5. Date / Time Types", storage
> size of the interval data type has 12 bytes.
> However, the definition of "datatype/timestamp.h", size of the interval data
> type was 16 bytes.
Robert Haas wrote:
> On Tue, Apr 8, 2014 at 4:41 PM, Tom Lane wrote:
> > I just created sections in the SGML manual chapters about GIST, GIN, and
> > SP-GIST to hold documentation about the standard opclasses provided for
> > them:
> >
> > http://www.postgresql.org/docs/devel/static/gist-builtin-o
Alvaro Herrera writes:
> Robert Haas wrote:
>> On Tue, Apr 8, 2014 at 4:41 PM, Tom Lane wrote:
>>> http://www.postgresql.org/docs/devel/static/gist-builtin-opclasses.html
>>> http://www.postgresql.org/docs/devel/static/gin-builtin-opclasses.html
>>> http://www.postgresql.org/docs/devel/static/spg
Hi,
Currently there is a warning against the following in manual:
BEGIN;
SELECT * FROM mytable WHERE key = 1 FOR UPDATE;
SAVEPOINT s;
UPDATE mytable SET ... WHERE key = 1;
ROLLBACK TO s;
here: http://www.postgresql.org/docs/9.2/static/sql-select.html
IIUC, it says if the lock-upgrading sub-tran
Hi,
would it be good idea to add new paragraph 5.3.7 to chapter 5.3
(Constraints) with at least information that there is something like
partial unique index and link to chapter 11.8 (Partial Indexes)?
Partial index can be used to enforce uniqueness in a way other constraints
cannot provide. Curr
