[BUGS] pg_dump does not reflect changes in column names with primary keys

2000-09-05 Thread pgsql-bugs
Edward Pilipczuk ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump does not reflect changes in column names with primary keys Long Description If a table with primary key is created (CREATE TABLE), that implicitly forces

[BUGS] Access 97 and PSQL ODBC

2000-09-05 Thread pgsql-bugs
Charles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Access 97 and PSQL ODBC Long Description As of now this is not reproducible. Sometimes when entering data into a PSQL table through Microsoft Access, when you leave the

[BUGS] Access 97 and PSQL ODBC Update

2000-09-05 Thread pgsql-bugs
Charles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Access 97 and PSQL ODBC Update Long Description Update: I can reproduce this now. In a text field if a record already has the text "Hello" in it and I type that same tex

[BUGS] bugs

2000-09-05 Thread Alexei E. Korneyev
POSTGRESQL BUG REPORT TEMPLATE Your name : Alexei E. Korneyev Your email address : [EMAIL PROTECTED

Re: [BUGS] PG still fussy to compile on Solaris + GCC, may stillneed Sun ld

2000-09-05 Thread Matt Benjamin
Okay, thanks for the help. Matt Matt Benjamin President/CTO The Linux Box 206 South Fifth Ave. Suite 150 Ann Arbor, MI 48104 tel. 734-761-4689 fax. 734-769-8938 pgr. 734-431-0118 On Sat, 2 Sep 2000, Tom Lane wrote: > Matt Benjamin <[EMAIL PROTECTED]> writes: > > What do you m

[BUGS] Handling from UPDATE, SELECT, ... with now rows affected

2000-09-05 Thread RSchiele
Hello PostgreSQL-Team, sorry that i'm not using the standard bug report, but I think i have not a bug. I'm using the unixODBC with PostgreSQL and I have a little problems discussed with nick the maintainer from unixODBC. And for now we are stuck. So what is the problem. I hope i can get it on t

[BUGS] Possible bug in referential integrity system

2000-09-05 Thread Richard Ellis
The submit button on the form located at http://www.postgresql.org/bugs/bugs.php?1 results in a report of a parsing error, so I'm sending this here as the alternative. Is the following a bug in the referential integrity system? This is for PG 7.0.0. I realize that declaring the "ref" column in

Re: [BUGS] PG still fussy to compile on Solaris + GCC, may stillneed Sun ld

2000-09-05 Thread Matt Benjamin
Hi Tom, What do you mean, "do what it wanted?" The configure script produced a setup that would not build a perl interface, and the error was related to SunWS compiler options. The larger problem was of linking the PG libs. I had a copy of Sun ld around, but, since this (somehow, like the c

[BUGS] Problem

2000-09-05 Thread Ralf Boeckenholt
Hello In the final part of this message you found the help message of the actual pg_dump edition. There is no option to choose "insert proper sql strings" and there is no point on which I can choose a file the program can put in the output. What can I do to put it in later postgress editions ?

[BUGS] RE: [BUG] calling lo_creat()

2000-09-05 Thread Barnes, Sandy (Sandra)
This is not a bug. The problem was that I was not calling lo_unlink() after consecutive lo_creat(), lo_close() calls. I found this out by looking at the file system containing the database and seeing hundreds of xinvOID and xinxOID files. After cleaning up these files I was able to run this pro

[BUGS] /usr/include/pgsql/os.h does not exist

2000-09-05 Thread pgsql-bugs
Charles Choi ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description /usr/include/pgsql/os.h does not exist Long Description I am trying to install Postgresql 7.0.2 using the RPM on RedHat 6.2. In the example code section I have shown

Re: [BUGS] Possible bug in referential integrity system

2000-09-05 Thread Alexei E Korneyev
Hello! Keys phrase 'NOT NULL' simple=# create table t1 (num int4 PRIMARY KEY, name text); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 't1_pkey' for table 't1' CREATE simple=# create table t2 (ref int4 references t1 (num) NOT NULL, val text); NOTICE: CREATE TABLE will create impl

[BUGS] bug in date_part() function in 6.5.2, 7.0.2

2000-09-05 Thread pgsql-bugs
Alex Karpov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description bug in date_part() function in 6.5.2, 7.0.2 Long Description Checked on Postgres version 6.5.2 and 7.0.2: Incorrect DOW and DAY parts of date calculation. See exanple