The following bug has been logged on the website:
Bug reference: 7501
Logged by: Matt Kusnierz
Email address: matthew.p.kusni...@jpmorgan.com
PostgreSQL version: 9.0.4
Operating system: Windows XP
Description:
Multi-column unique indexes allow duplicate rows to be ins
the bug #7499 is not more a bug, but my missunderstanding (RESOLVED INVALID)
My arguments are:
> create table tbl_test
> (id int not null primary key,
> str_last_name text not null,
> misc text);
> insert into tbl_test values
> (1, 'Kolesnik'),
> (83, 'GX'),
> (111, 'Kolesnik'),
>
The following bug has been logged on the website:
Bug reference: 7502
Logged by: Tigran Mkrtchyan
Email address: tigran.mkrtch...@desy.de
PostgreSQL version: 9.1.1
Operating system: Linux
Description:
Hi,
we have notice that
ALTER TABLE a_table ALTER COLUMN a_colum
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Excerpts from tigran.mkrtchyan's message of jue ago 23 10:37:02 -0400 2012:
> The following bug has been logged on the website:
>
> Bug reference: 7502
> Logged by: Tigran Mkrtchyan
> Email address: tigran.mkrtch...@desy.de
> PostgreSQL version: 9.1.1
> Operating system: Linux
On Thu, 2012-08-23 at 09:38 +, matthew.p.kusni...@jpmorgan.com
wrote:
> Multi-column unique indexes allow duplicate rows to be inserted if any of
> the indexed columns are inserted with a null.
That is mandated in the SQL spec, and is documented here:
"For the purpose of a unique constraint,
Alvaro Herrera writes:
> So the ALTER TABLE trick is not needed in 9.0, but is useful in previous
> releases. There are optimizations to avoid the table rewrite in certain
> cases in 9.2:
> http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#Reduce_ALTER_TABLE_rewrites
> According to th
d...@uvic.ca writes:
> I am trying to understand how postgresql implements REVOKE GRANT ...
> CASCADE
> [ example snipped ]
> What I am surprised is that m keeps the proviledge (via b) but x and y have
> lost it. See below). is that the way it is supposed to be?
It is not. There is actually cod
Hi;
I figured I would report this as well, primarily because people
getting into table inheritance may try to use this to solve the set
exclusion problem (i.e. partly required to prevent duplicate key
values in an inheritance tree). I see this as minor because I don't
see a lot of people using th
The following bug has been logged on the website:
Bug reference: 7504
Logged by: shenqw
Email address: she...@163.net
PostgreSQL version: 9.1.5
Operating system: FreeBSD 9.1 P4
Description:
Aug 23 11:12:11 www postgres[32088]: [2-1] WARNING: corrupted statistics
file
Chris Travers writes:
> My guess is that tableoid is not known when the check constraint is
> checked.
None of the system columns are set at the time check constraints are
checked.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To mak
11 matches
Mail list logo
