Re: [BUGS] pg_hba.conf confusion

2002-06-18 Thread Bruce Momjian
David M. Kaplan wrote: > Hi, > > I recently experienced a weird bug with postgresql. I am running: > > postgresql-7.2.1-8 > postgresql-server-7.2.1-5 > > I was trying to connect to a database on a my machine from another > machine. Initially, my pg_hba.conf looked like: > > host all

Re: [BUGS] pg_hba.conf confusion

2002-06-18 Thread Reinhard Max
On Tue, 18 Jun 2002 at 09:28, David M. Kaplan wrote: > Thanks, that did fix that problem. Now I have another one. The line: > > hostall192.168.1.2255.255.255.128password > > matches all ip addresses of the form 192.168.1.x. If I change the mask > to 255.255.255.255 it no longer

Re: [BUGS] pg_hba.conf confusion

2002-06-18 Thread Reinhard Max
Hi, On Mon, 17 Jun 2002 at 20:47, David M. Kaplan wrote: > host all 127.0.0.1 0.0.0.0identsameuser If you want this entry to match only the loopback device, the mask has to be 255.255.255.255 instead of 0.0.0.0. A mask of 0.0.0.0 causes *all* IP addresses to match this

[BUGS] pg_hba.conf confusion

2002-06-18 Thread David M. Kaplan
Hi, I recently experienced a weird bug with postgresql. I am running: postgresql-7.2.1-8 postgresql-server-7.2.1-5 I was trying to connect to a database on a my machine from another machine. Initially, my pg_hba.conf looked like: host all 127.0.0.1 0.0.0.0identsameu

[BUGS] referential integrity through inherited tables

2002-06-18 Thread Josh Goldberg
This is probably more like an "undesired feature" than a software bug, but it was behaviour that I did not expect. thanks! Your name : Josh Goldberg Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel P

[BUGS] JDBC Metadata Problems

2002-06-18 Thread Aaron Mulder
I'm using the PostgreSQL 7.2.1 server and JDBC drivers distributed with Red Hat 7.3. When I create a series of tables and foreign keys, and then use the JDBC DatabaseMetaData calls getImportedKeys and getExportedKeys, the results are incorrect. In some cases, I get the primary key table

[BUGS] Bug #693: python interface doesn't handle int8 correctly.

2002-06-18 Thread pgsql-bugs
Ragnar Kjørstad ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description python interface doesn't handle int8 correctly. Long Description This applies to postgresql 7.2.1 on linux x86 (32 bit) getresult() and dictresult() return int4 d

[BUGS] ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)

2002-06-18 Thread Lee Kindness
Hi, When creating a table in embedded SQL, a foreign key construct like: FOREIGN KEY(col) REFERENCES table(col) is not accepted by ecpg. Consider the following code fragment (error checking omitted): EXEC SQL CREATE TABLE colscales(id INTEGER NOT NULL, name VARCHAR(6