Re: [BUGS] bug in create table with serial

2002-10-16 Thread Kris Jurka
On Wed, 16 Oct 2002, Tom Lane wrote: > =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <[EMAIL PROTECTED]> writes: > > In PostgreSQL 7.3b2, if I create a table like so: > > create table customers (id serial primary key); > > > The id field will be created of type 32 bit integer, yet the upper limit

Re: [BUGS] bug in create table with serial

2002-10-16 Thread Tom Lane
=?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <[EMAIL PROTECTED]> writes: > In PostgreSQL 7.3b2, if I create a table like so: > create table customers (id serial primary key); > The id field will be created of type 32 bit integer, yet the upper limit > for the sequence will be relative to a 64 bit i

Re: [BUGS] multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)

2002-10-16 Thread ir. F.T.M. van Vugt bc.
> > May I ask why you don't want to go with something like: > > #define DESCR(x) typedef int postgresql_foo_bar > > Because it doesn't work. > $ cat z.c > typedef int postgresql_foo_bar; > typedef int postgresql_foo_bar; > $ gcc -c z.c > z.c:2: redefinition of `postgresql_foo_bar' > z.c:1: `postgr

[BUGS] bug in create table with serial

2002-10-16 Thread Cristóvão Dalla Costa
In PostgreSQL 7.3b2, if I create a table like so: create table customers (id serial primary key); The id field will be created of type 32 bit integer, yet the upper limit for the sequence will be relative to a 64 bit integer. \d customers Table "public.customer

[BUGS] Bug #798: Data in table causes server to terminate with signal 11

2002-10-16 Thread pgsql-bugs
Dan Wilder ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Data in table causes server to terminate with signal 11 Long Description I have a table which brings about the error message (from syslog) server process (pid 21503)

Re: [BUGS] multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)

2002-10-16 Thread Tom Lane
"ir. F.T.M. van Vugt bc." <[EMAIL PROTECTED]> writes: > May I ask why you don't want to go with something like: > #define DESCR(x) typedef int postgresql_foo_bar Because it doesn't work. $ cat z.c typedef int postgresql_foo_bar; typedef int postgresql_foo_bar; typedef int postgresql_foo_bar; $

Re: [BUGS] multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)

2002-10-16 Thread ir. F.T.M. van Vugt bc.
Tom Lane writes: > That's hard to believe; I think it's Qt that's doing something strange > here. As a newbie on the list, I'm sorry I have to disagree with you, Tom... ;) The fact that PostgreSQL dissolves stuff into something like: #include extern int errno; extern int errno; was more of a