it is at connect-time, so there is nothing done with set session authorization.
I just want to connect, and read data from a table to which the group the
user is in has read-access.
I have tried if it would differ when I try to connect with a user created like:
CREATE USER 20020003 WITH ENCRYPTED
Hi all,
I'm experiencing a strange problem in the usage of indexes for query
optimization.
I'm runnig a "forum" application that uses a PostgreSQL DB.
The version on the DB is 7.2.3 but I've also tested it under 7.3.1 but I
had no luck :( The problem is always the same.
Linux distro is Slackware
Michiel Lange <[EMAIL PROTECTED]> writes:
> it is pretty strange... might it be a bug?
I'm quite sure it's a bug in your code. Try turning on query logging so
you can see what queries are being issued; maybe that will help solve
the problem.
regards, tom lane
---
Luca Fabbro <[EMAIL PROTECTED]> writes:
> It seems that the problem is in the Backward scan of the index :(
It looks like a pretty reasonable plan to me. Could we see the output
of EXPLAIN ANALYZE, not just EXPLAIN?
regards, tom lane
---(end of br
At 09.39 27/01/2003 -0500, you wrote:
Luca Fabbro <[EMAIL PROTECTED]> writes:
> It seems that the problem is in the Backward scan of the index :(
It looks like a pretty reasonable plan to me. Could we see the output
of EXPLAIN ANALYZE, not just EXPLAIN?
Thanks Tom for your interest.
It looks
Luca Fabbro <[EMAIL PROTECTED]> writes:
> Limit (cost=0.00..1003.36 rows=1 width=454) (actual time=806.78..2097.61
> rows=1 loops=1)
> -> Nested Loop (cost=0.00..392651.18 rows=391 width=454) (actual
> time=806.77..2097.59 rows=2 loops=1)
> -> Index Scan Backward using forum_p
Hi,
My name is Oscar, and i am working with
Postgres.
I want to know if: "can i change of lenguage
error's menssages of Postgres?"
I need spanish menssages no english menssages.
Can you help me, please.
---(end of broadcast)---
TIP 6: Have y
I know this is extremely remedial and trival for most of you - but I am a
very new user, and need to know what I have to do to get my database instance
created? Anyone that has a cheatsheet or something they can send me would
also be greatly appreciated.
I am a 10+ year veteran of Oracle 6.0 t
but, but it is even with the psql command...
it will differ if I put a -U parameter with postgres or 20020003
postgres, michiel or most other names will connect fine, however the user
20020003 will not...
I get that FATAL error... all users should be able to connect to the
database, according
We have both test and production databases, about 10 GB total in each.
Recently, I learned about "max_fsm_pages" and "max_fsm_relations". To get
a feel for what changing these settings would do to our production
database, I set the following values in the "test" database:
max_fsm_relations = 100
m
"Andrew Sullivan" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> We are currently using eRServer for the .info registry, and starting
> next week it will also underpin the .org registry. Dunno if that's
> good enough performance for you. It works for us.
t
Also, it only really works well for lengthening columns. If you shorten
them, the old values will remain their original longer length.
---
Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > There is a "gamblers
Michael,
This is a good place to start:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/tutorial-
start.html
If you're still having trouble after reading all the docs, please feel
free to post a question to the list.
--Jeremy
On Monday, January 27, 2003, at 08:44 AM, Michael Cup
I assume this is 7.2.X. I know this is fixed in 7.3.1 but I am not sure
what release we fixed it in. The HISTORY file doesn't have a specific
mention of the fix. It is not something to be worried about, as I
remember.
---
Michiel Lange <[EMAIL PROTECTED]> writes:
> but, but it is even with the psql command...
Hmm. You didn't by any chance put a SET for session_authorization into
the per-user settings for 20020003, did you? Or the per-database
settings for whichever database he's trying to connect to? Look at
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I assume this is 7.2.X. I know this is fixed in 7.3.1 but I am not sure
> what release we fixed it in. The HISTORY file doesn't have a specific
> mention of the fix. It is not something to be worried about, as I
> remember.
Mmm, I'm not sure. The kno
On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
>
> the eRServer is for free or not ?
"Not", as far as I know. Its baby cousin is in contrib/rserv in the
source tree. I haven't tested it with 7.3, so I don't know whether
it works.
A
--
Andrew Sullivan
Hmm i do the below daily to this table. And this is pgsql 7.3
~~~
BEGIN WORK;
INSERT INTO archives.site_search SELECT * from public.site_search;
COMMIT;
TRUNCATE TABLE public.site_search;
~~
and then it is VACUMMED within 24 hrs.
The table public.site_sea
The Python DB-API (2.0) specifies that on creation a connection object
is to start a transaction if the database supports them. The pgdb
implementation of the DB-API does this:
>>> Begin Listing 1
class pgdbCnx:
def __init__(self, cnx):
self.__cnx = cnx
I have installed running pg 7.2, and it apparently would like to have
an identd server to help it establish who is who.
I installed pidentd from the red hat 8.0 distribution and started it
up but, but looking over the conf files, there is apparently no way to
restrict identd to listening/binding o
I know this is extremely remedial and trival for most of you - but I am a
very new user, and need to know what I have to do to get my database instance
created? Anyone that has a cheatsheet or something they can send me would
also be greatly appreciated.
I am a 10+ year veteran of Oracle 6.0 t
<[EMAIL PROTECTED]> writes:
> Hmm i do the below daily to this table. And this is pgsql 7.3
> TRUNCATE TABLE public.site_search;
Drat. Now that I look at it, 7.3 TRUNCATE doesn't send any kind of
relcache inval message, so it's got the same kind of problem that the
nailed-in-cache catalogs do: ot
On Mon, 27 Jan 2003, Andrew Sullivan wrote:
> On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
> >
> > the eRServer is for free or not ?
>
> "Not", as far as I know. Its baby cousin is in contrib/rserv in the
> source tree. I haven't tested it with 7.3, so I don't know whether
>
I would give /contrib/dbmirror a try.
---
Marc G. Fournier wrote:
> On Mon, 27 Jan 2003, Andrew Sullivan wrote:
>
> > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote:
> > >
> > > the eRServer is for free or
24 matches
Mail list logo
