Hi,
I use a lot of views in my DB, many of whom depend on each other (ie
views of views). When I alter one of the subviews, all the views that
depend on it fail. Postgres complains that the view with the old OID no
longer exists. The fix is to drop and create all views that depend on
the a
I have found that !~ and !~* do not match the null string even when one
would expect them to. I am not sure if this is how it is supposed to
work or if this is an error. If this is how it works, I can't figure
out where it is states in the documentation.
Let me give an example. Suppose we h
nks,
David
Reinhard Max wrote:
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 hasto be 255.255.255.255 instead of 0.0.0.0. A mask of 0.0.0.0 caus
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
