Hi Tom!
On 2004-06-23 11:09 -0400, Tom Lane wrote:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> > Recently we got the following bug report about VACUUM FULL. Can
> > anybody comment on this?
>
> This was reported to the PG lists already. We asked for a test case
> but didn't get one ...
Then may
Hi PostgreSQL developers!
Recently we got the bug report below. It seems that there is a special
treatment of columns named "version". Normally fields of primary key
indices are printed out unquoted, however, if the column is named
"version", the name is printed out in quotes.
This behaviour see
On Thu, 8 Jul 2004, Martin Pitt wrote:
> Hi PostgreSQL developers!
>
> Recently we got the bug report below. It seems that there is a special
> treatment of columns named "version". Normally fields of primary key
> indices are printed out unquoted, however, if the column is named
> "version", the
Hi Stephan!
On 2004-07-08 7:10 -0700, Stephan Szabo wrote:
> It doesn't appear to be necessary to quote the identifier, however version
> and "version" refer to the same identifier in this case so I wouldn't call
> it an error, either. My guess as to the reason comes from this comment
> fragment
Hello
i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL
exists but does not working. Example:
My table:
create table1(
id SERIAL,
name VARCHAR(100)
);
insert into table1 (name) values('name1');
ERROR: duplicate key violates unique constraint "table1_pkey"
Why ? I want to have autoincre
On Fri, 2004-07-02 at 11:24, vertigo wrote:
> Hello
> i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL
> exists but does not working. Example:
> My table:
> create table1(
> id SERIAL,
> name VARCHAR(100)
> );
>
> insert into table1 (name) values('name1');
> ERROR: duplicate key viol
Thank you for the confirmation.
Best,
Ted
-Original Message-
From: Michael Meskes [mailto:[EMAIL PROTECTED]
Sent: Monday, July 05, 2004 11:55 AM
To: Tom Lane
Cc: Neil Conway; Ted Kremenek; [EMAIL PROTECTED]; Michael Meskes
Subject: Re: [BUGS] [CHECKER] 4 memory leaks in Postgresql 7.4.2
