[BUGS] Bug #485: strange behavior when creting rules with serial id

2001-10-16 Thread pgsql-bugs
Tony Tomov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description strange behavior when creting rules with serial id Long Description I do not know if this is a bug, but for me this is a strange behavior. I will describe the followin

[BUGS] Bug #484: TIMESTAMP arithmetic insconsistencies

2001-10-16 Thread pgsql-bugs
Rick Mason ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description TIMESTAMP arithmetic insconsistencies Long Description I have found some inconsistencies relating to TIMESTAMP arithmetic. I am not sure if this is a bug, but perhaps

Re: [BUGS] psql core dump

2001-10-16 Thread Tom Lane
Kris Houghton <[EMAIL PROTECTED]> writes: > When I attempt psql demodb I get a core dump .. ( NOT GOOD ) > I'm using solaris 8 update 5 There's some magic you need to do to get the readline library linked correctly on Solaris. Please search our mailing list archives to find the details; I don

Re: [BUGS] Bug #482: psql (7.1.3) doesn't like sysid=0

2001-10-16 Thread Peter Eisentraut
> Sherwin Daganato ([EMAIL PROTECTED]) reports a bug with a severity of 3 > I have migrated a production database from 7.0.3 > to 7.1.3 successfully. Then I was trying to load this > database (7.1.3) to a development machine with > another 7.1.3 when I encounter the error. It is not > clear in th

Re: [BUGS] SQLCODE==-209

2001-10-16 Thread John Summerfield
On Thu, 11 Oct 2001, Bruce Momjian wrote: > > I have added documentation for code 209. Looks like there are other > undocumented ones. Should we document them all? If you're asking me, I'm all in favour of documenting them;-) I'm not a fan of "Read the source," though I do it if I'm desperat

[BUGS] psql core dump

2001-10-16 Thread Kris Houghton
Postgres Support, I have been trying to start psql demodb database that I created and every time I get a core dump.. initdb and createdb worked just fine. When I attempt psql demodb I get a core dump .. ( NOT GOOD ) Please review output below. I have also included a core dump using gdb.

[BUGS] Hi

2001-10-16 Thread prinson
After successful installation of Postgressql, when i type the command psql i am getting this error. "Connection to database 'prinson' failed. connectDB() -- connect() failed: Connection refused Is the postmaster running at 'localhost' and accepting connections on Unix socket '5432'? " pl

[BUGS] Dumps/Reloads

2001-10-16 Thread Eric
Not sure how to classify this... Here is the scenario: create database pozicom; create table employees(); create table emppayrate(); create function getemprate(...); If I pg_dump pozicom > /tmp/pozicom.dump then log in and \i /tmp/pozicom.dump everything works fine until. Now I nee

[BUGS] unknown object exception in postgresql-7.1.3 jdbc driver

2001-10-16 Thread Lora Goldston
example query: select '12345' as total from table or select first_name as "name" from table In either case, the quoted strings cause an unknown object exeption in the postgresql-7.1.3 jdbc driver. Adding this line of code to the ResultSet.java seems to work, although I don't believe it is

Re: [BUGS] Bug #478: Integer overflow in pg_dump

2001-10-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Would someone comment on this? AFAIK this is fixed in current sources. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] Bug #478: Integer overflow in pg_dump

2001-10-16 Thread Bruce Momjian
Would someone comment on this? --- > Premysl Maly ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > Integer overflow in pg_dump > > Long Descript