On 2010-01-04, Ben Woosley ben.woos...@gmail.com wrote:
The following bug has been logged online:
Bug reference: 5258
Logged by: Ben Woosley
Email address: ben.woos...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Mac OS 10.6
Description:Unique and
The following bug has been logged online:
Bug reference: 5260
Logged by: Toni Helenius
Email address: toni.helen...@syncrontech.com
PostgreSQL version: 8.3.9
Operating system: Windows 2008 Server Enterprise
Description:Postgre crashed unexpectedly
Details:
Postgre
On mån, 2010-01-04 at 03:48 +, Ben Woosley wrote:
However, unique and foreign key constraints added using the alter
table add
constraint syntax fail on the column name. At this point the
statement has
enough information (the host table name) to properly identify the
column
despite the
On 4/01/2010 6:18 PM, Goodomens wrote:
Craig Ringer
I come from Shanghai of China,my english is not well,sorry.
Is this the output of psql's `\dp' command? If so, where are the actual
privelege rows - did you delete them, or is the output you pasted
actually EXACTLY what came out of psql?
yes
The following bug has been logged online:
Bug reference: 5261
Logged by: Takesver Kumar Thakur
Email address: takesver.tha...@mobilefundas.com
PostgreSQL version: postgresql-8.1
Operating system: centos 5
Description:Invalide page header
Details:
Hi ,
I received
2010/1/2 Tomas Studva tstu...@gmail.com:
Hi all gurus,
I've encountered on my computer this bug. I will try to describe all what I
have discovered till now.
1, this bug happened a few times before and wasn't resolved:
bug 5130 -
On Mon, Jan 4, 2010 at 5:29 AM, Toni Helenius
toni.helen...@syncrontech.com wrote:
The following bug has been logged online:
Bug reference: 5260
Logged by: Toni Helenius
Email address: toni.helen...@syncrontech.com
PostgreSQL version: 8.3.9
Operating system: Windows
Craig Ringer cr...@postnewspapers.com.au writes:
On 4/01/2010 2:26 PM, David wrote:
the table name double,why?
How about some information?
A reasonable bet is that the pg_namespace row for public has gotten
duplicated (either in reality, or there's an extra index entry for it).
Which would
On Sun, Jan 3, 2010 at 10:48 PM, Ben Woosley ben.woos...@gmail.com wrote:
Check constraints successfully accept columns named with reserved words when
they are qualified by table using the . syntax, e.g. check (mod(table.as,
2) = 0)
However, unique and foreign key constraints added using the
These work:
alter table books add constraint books_from_within check (books.from = 5
and books.from11);
alter table books add constraint books_as_whitelist check (books.as in
('whitelisted1','whitelisted2','whitelisted3'));
These don't:
alter table books add constraint books_from_reference
Ben Woosley ben.woos...@gmail.com writes:
These work:
alter table books add constraint books_from_within check (books.from = 5
and books.from11);
alter table books add constraint books_as_whitelist check (books.as in
('whitelisted1','whitelisted2','whitelisted3'));
These don't:
alter
Thanks Tom,
I hadn't tried double-quoting, which worked fine. I'm only so well
acquainted with SQL and had only tried single quotes and backticks.
So, there is a way, and I'm satisfied with it. Bug retracted - thanks!
-Ben
On Mon, Jan 4, 2010 at 1:30 PM, Tom Lane t...@sss.pgh.pa.us wrote:
On Mon, Jan 4, 2010 at 8:44 AM, Takesver Kumar Thakur
takesver.tha...@mobilefundas.com wrote:
The following bug has been logged online:
Bug reference: 5261
Logged by: Takesver Kumar Thakur
Email address: takesver.tha...@mobilefundas.com
PostgreSQL version: postgresql-8.1
The following bug has been logged online:
Bug reference: 5263
Logged by: Jozsef Szalay
Email address: jsza...@storediq.com
PostgreSQL version: 8.4.2
Operating system: Windows, Linux (Fedora/CentOS)
Description:Query execution fails with ERROR: FULL JOIN is only
14 matches
Mail list logo