On 2010-01-04, Ben Woosley 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 foreign key cons
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 d
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
> desp
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?
y
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 w
2010/1/2 Tomas Studva :
> 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 -
> http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg24810.html
>
On Mon, Jan 4, 2010 at 5:29 AM, Toni Helenius
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 2008 Server Enterprise
>
Craig Ringer 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 cause the join in psql's
On Sun, Jan 3, 2010 at 10:48 PM, Ben Woosley 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 "alter table ad
These work:
alter table books add constraint books_from_within check (books.from >= 5
and books.from < 11);
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 f
Ben Woosley writes:
> These work:
> alter table books add constraint books_from_within check (books.from >= 5
> and books.from < 11);
> alter table books add constraint books_as_whitelist check (books.as in
> ('whitelisted1','whitelisted2','whitelisted3'));
> These don't:
> alter table books ad
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 wrote:
> Ben Woosley writ
On Mon, Jan 4, 2010 at 8:44 AM, Takesver Kumar Thakur
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
> Operating system: cent
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
supp
14 matches
Mail list logo
