Viacheslav N Tararin <[EMAIL PROTECTED]> writes:
> Why alter table commands not check index existence?
What do you want them to do exactly? Error out if there's an equivalent
index in place already? Absorb the index as the implementation of the
constraint? I don't really like either of those ..
Florian Wunderlich <[EMAIL PROTECTED]> writes:
> So can I be sure that every non-aggregate SELECT on tables joined with
> unique indexes works, independent of the WHERE or ORDER BY?
I would think that backwards scan on a join mostly doesn't work, but
haven't tried it in any detail.
A plan with a
Installing PostgreSQL 7.3.2 on FreeSD 4.7 I found the following discrepancy
between the output from "make check" and "reality":
I ran make check and the output ended thusly:
===
1 of 89 tests failed.
===
The differences that caused some tests to fail can
I can't get through to you because your spam filter blocks my SMTP
relay.
Tom Lane wrote:
>
> > I now have a quite similar problem: while a CURSOR on a SELECT for a
> > normal query works now, I encounter the same behavior for aggregate
> > queries:
>
> As I think I pointed out in the original d
On Mon, Feb 10, 2003 at 02:30:52PM -0500, Tom Lane wrote:
> >> make[4]: Entering directory `/home/anteater/psql/pgsql/src/backend/optimizer/util'
> >> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
>-I../../../../src/include -c -o clauses.o clauses.c
> >> clauses.c:2322:1: directives
Gday All,
I'm surprised I can't find any descriptions of this in the archive
already, since I had imagined it would be a common action, but
apparently not!
Illustration:
As superuser:
create table1 ( test1 integer );
create table2 ( test2 integer );
create user pleb;
grant insert on table1 to
On Tue, Feb 11, 2003 at 00:13:44 +0200,
Elias Athanasopoulos <[EMAIL PROTECTED]> wrote:
>
> And my GNU bison is version 1.28.
>
> I'll maybe have to upgrade. Thanx for your answer.
I think you need to upgrade to at least 1.75.
---(end of broadcast)-
Hi.
--- Next sequence of commans: ---
CREATE TABLE CURRENCY.CURRENCY (
ID integer NOT NULL,
CODE varchar(17) NOT NULL,
DESCRIPTION text,
PRINT_SYMBOL VARCHAR(17) NOT NULL,
VERSION smallint
);
create unique index PK_CURRENC
Tara Piorkowski ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Column Constraint Not Working in ALTER TABLE ADD COLUMN?
Long Description
According to the docs, you should be able to put a column constraint into an ALTER
TABLE
VIacheslav N Tararin ([EMAIL PROTECTED]) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
incorrect error message when duplicate index name
Long Description
ERROR: relation named "pk_exchange_batch_idx" already exists
Why relation when I create ind
10 matches
Mail list logo