On Fri, 7 Sep 2001, Mike Rogers wrote:
> So this issue was raised quite some time ago by many many people and
> seems to contantly be asked by new PostgreSQL users. I never seem to find
> any real answers for it.
>
> I am running a multi-user system and wish to have 10 user accounts with
"Mike Rogers" <[EMAIL PROTECTED]> writes:
> I have tried chaning pg_hba.conf to add the database field to the user,
> but that doesn't seem to help at all.
Make the database field "sameuser", and then the line only allows
connection to one's own database. You will need an escape hatch to
all
Greets all;
So this issue was raised quite some time ago by many many people and
seems to contantly be asked by new PostgreSQL users. I never seem to find
any real answers for it.
I am running a multi-user system and wish to have 10 user accounts with
10 different corresponding databases
[EMAIL PROTECTED] wrote in message
> connectDB() -- connect() failed: No such file or directory
> Is the postmaster running at 'localhost' and accepting connections on Unix
> socket '5432'?
>
> I figured that, although through Windows clients everything works fine,
> maybe from the command line
Paul Green <[EMAIL PROTECTED]> writes:
> I didn't actually compile it at all - I used the default RPMs provided by
> Redhat. I'm unsure whether they have compiled in support or not,
They do...
> but I know
> I always start/stop postgres using the init.d scripts, which always start
> the database
On 2001.09.07 15:53 Tom Lane wrote:
> Paul Green <[EMAIL PROTECTED]> writes:
> >> Hmm. What PG version is this, on what platform?
>
> > Redhat 7.1, (Linux 2.4.2-2) on a K6-2 300 with 128 mb ram running PG
> 7.0
>
> > What *is* wierd is that if I do, say, "select *
> > from player where name='b
Paul Green <[EMAIL PROTECTED]> writes:
>> Hmm. What PG version is this, on what platform?
> Redhat 7.1, (Linux 2.4.2-2) on a K6-2 300 with 128 mb ram running PG 7.0
> What *is* wierd is that if I do, say, "select *
> from player where name='bob'" I get one result where as if I do a "select *
>
On 2001.09.07 15:10 Tom Lane wrote:
> Paul Green <[EMAIL PROTECTED]> writes:
> > I am having a problem with duplicates appearing in a unique index and I
> > have no idea why.
>
> Hmm. What PG version is this, on what platform?
Redhat 7.1, (Linux 2.4.2-2) on a K6-2 300 with 128 mb ram running P
Paul Green <[EMAIL PROTECTED]> writes:
> I am having a problem with duplicates appearing in a unique index and I
> have no idea why.
Hmm. What PG version is this, on what platform?
Have you tried dropping and recreating the index?
> I can't say how often these duplicates slip through, but it s
Dong B Calmada writes:
> "ERROR: ORDER BY and DISTINCT on views are not implemented."
Upgrade to 7.1.3.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 5: Have you checked our extensive F
Hi,
I am having a problem with duplicates appearing in a unique index and I
have no idea why. The database in question has a high number of inserts and
updates to a table (around 5000-1 per hour) and occasionally duplicates
slip through. To provide some background, I have listed the propertie
What is the postgres database running on? Can't you just go to that machine
and pg_dump?
If not then you could try installing cygwin (www.cygwin.com). This
will give you a unix like api and bash shell in windows. The default install
also has a binary version of postgresql including tools s
12 matches
Mail list logo
