[BUGS] alter table rename missing numeric type

Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description alter table rename missing numeric type Long Description I start with table n1 which contains only a numeric type 4,2. Inserting a value larger than 99.99 causes

Re: [BUGS] alter table rename missing numeric type

> template1=> insert into n2 values(154.23); > INSERT 360703 1 > template1=> alter table n1 rename to oldn1; > RENAME > template1=> alter table n2 rename to n1; > RENAME > template1=> insert into n1 values(154.23); > ERROR: overflow on numeric ABS(value) >= 10^2 for field with precision 4 scale 2

[BUGS] SQLException: java.sql.SQLException: ERROR: WaitOnLock: error on wakeup - Aborting this transaction

From: [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED], [EMAIL PROTECTED] John Evans ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description SQLException: java.sql.SQLException: ERROR: WaitOnLock: error on wakeup - Aborting this transac

[BUGS] Solaris 8 / still waiting

Sorry If I'm annoying you, but I'm trying to install PostgreSQL onto Solaris 8 and I'm not able to perform the second install process, that is, could you take a look at these two files that I'm seending to you? sincerely, Zenon Farias Braga F. P.S.: ./configure --prefix=/opt/pgsql >

[BUGS] Postgres 7 pgdump problems with views

Hi, here's a bug report. Below is a reply to a message I posted on pgsql-admin. I'm quoting it to demonstrate that others have also seen this bug. Below it is my original message regarding the bug. --Rainer -Original Message- From: Paul Breen [mailto:[EMAIL PROTECTED]] Sent: Mon

[BUGS]

Hi, Warwick Johnston here, and thanks in advance for any assistance you can provide. I'm trying to run postgresql, and am having trouble with the embedded c compiler. First the facts: I'm running PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66, as stated by the version inf

[BUGS] bug with postgresql

Hello, After a successful installation of postgresql (7.0.3), when i want to start using it, i have a problemes: in the directory /usr/local/pgsql/bin i type ./psql , and i have this result: welcome to psql, the postgresql interactive terminal. Type \h for help \? ..

[BUGS] empty result on SELECT with LIKE on '...Z%'

I have a table with name of people. In this table there is 'MENDEZ PATRICIA' If I try SELECT * FROM people WHERE nom LIKE 'MEND%' result => MENDEZ PATRICIA If I try SELECT * FROM people WHERE nom LIKE 'MENDEZ%' result => empty (here is the problem) If I try SELECT * FROM people WHERE nom LIKE 'ME

[BUGS] iofflush: psql 7.0.3 coredump on RH 6.1

Couldn't find an archive for this list, so here you go. Seemed to build OK, and I managed to create a test database under the user 'postgres'. When I run the psql tool to connect to it, the client dumps core. Sorry for the spam; I searched a bit before posting, and saw others who had the problem

[BUGS] a probleme with postgresql

hello, I have a probleme when i want start using postgresql (linux : corel linux 1.1), after a successful installation, when i go to /usr/local/pgsql/bin i type ./psql and i have like result: welcome to psql the postgresq interactive Type \copyright . // .. // .. seg

[BUGS] Solaris 8 / still waiting

Sorry If I'm annoying you, but I'm trying to install PostgreSQL onto Solaris 8 and I'm not able to perform the second install process, that is, could you take a look at these two files that I'm seending to you? sincerely, Zenon Farias Braga F. P.S.: ./configure --prefix=/opt/pgsql >

[BUGS] Re: [NOVICE] RE: iofflush psql 7.0.3 coredump on RH 6.1

On Fri, Dec 01, 2000 at 10:26:07AM -0500, Tom Lane wrote: > Rasputin <[EMAIL PROTECTED]> writes: > > In this case, disabling readline starts up the client OK. > > > I'll try upgrading readline on this system ,and see what happens. > > I was just going to suggest that. Did you compile Postgres f

[BUGS] PostgreSQL 7.0.2 doesn't install

I sent an e-mail yesterday and I don't have any response by now, even an automatic response. I tryed to install PostgreSQL 7.0.2 onto Solaris 8 Intel Platform but it fails, whem I executed "./configure" I got the contents in "stage1.out", an attachment file that I'm sending to y

[BUGS] UNSUBSCRIBE

Does anyone know how I get off this "Bugs" list? On Tue, 28 Nov 2000 13:49:49 -0500 Tom Lane <[EMAIL PROTECTED]> writes: > Karla Peralta <[EMAIL PROTECTED]> writes: > >> Show us a sequence of queries that causes these messages, and > we'll > >> fix it ... > > > The messages show ups in two q

[BUGS] I'm not able to install PostgreSQL

Please, help me. I'm trying to install PostgreSQL on Solaris 8 Intel platform, and whem I execute: 1 - ./configure --prefix=/opt/pgsql --with-CXX=g++ I get the output that is in the file stage1.out And whem I execute: 2 - gmake