Ok, I let the server run for a few days (usually long enough to get into
this situation) and then did a shutdown. No hang. Could be fixed.
Thanks!
L.
On Mon, 17 Feb 2003, Tom Lane wrote:
> I said:
> > Oh, duh! You don't need to be using NOTIFY explicitly --- you just have
> > to sit idle long
"Michael A. Schulte" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Offhand I think this is only used to implement waits associated with
>> SELECT FOR UPDATE row locking --- all other locks are on tables or
>> table-like objects.
> What about two processes updating the same row?
Right, that cas
Hi all, I have a problem that I am chasing and getting nowhere with.
Can anyone help?
I have postgresql-7.2.1-5 running as the server on a redhat7.3 box.
I am connecting from a redhat8.0 box with postgresql-7.2.2-1 using both
psql and pgaccess.
My pg_hba.conf looks like this:
local all ident
Bob Smith <[EMAIL PROTECTED]> writes:
> I have a question about transaction isolation that I can't find an
> answer to in the docs. I'm working with a database that has some data
> split over two tables. One table is the ultimate destination for all
> the data, the other is a "pending" table w
Hi,
I'm currently porting gentoo on parsic aka hppa stations and I can't run
postgresql. It seems to be a common error but common workaround are not
working. (Log is at the bottom)
I've tryied what is described in
http://developer.postgresql.org/docs/postgres/kernel-resources.html with no
res
On Fri, Feb 28, 2003 at 12:37:53 +0200,
Nathalie Boulos <[EMAIL PROTECTED]> wrote:
> Hi,
>
> is there a way to grant or revoke rights on specific fields of a table for
> specific users?
>
> if yes how is it possibly done and in which versions of postgres?
You need to use views or rules to do
On Fri, 2003-02-28 at 16:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented
This could be because cross-database references are not implemented (yet
:-) ...
Andreas Schmitz <[EMAIL PROTECTED]> writes:
> the vacuum seems to be ok. I discovered that the "cluster" kills the
> data for some reason.
Hmm. I'm not sure whether clustering on a GIST index is really useful
(seeing that there's no linear ordering associated with GIST). But it
shouldn't lose da
How can i list the users of a group?
Thanks.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Use your postgresql.conf file to enable logged connections:
log_connections = on
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perr
how can i use no wrap text in psql
console
:-) Sidar Lopez Cruz- Cero Riesgo,
S.A.
When i try to do something like
templae1=# select * from
mydatabase.public.mytale;
this message appear: Cross-database references are
not implemented
:-) Sidar Lopez Cruz- Cero Riesgo,
S.A.
Hi ,
I don't know if you can grant field but i think it's more interesting to
create view and grant users this view.
later please see documentation before request.
Fouad
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Nathalie Boulos
Envoyé : vendredi 28
On Fri, Feb 28, 2003 at 12:37:53PM +0200, Nathalie Boulos wrote:
> Hi,
>
> is there a way to grant or revoke rights on specific fields of a table for
> specific users?
>
> if yes how is it possibly done and in which versions of postgres?
This is not possible in PostgreSQL. It's in TODO, but I
Hi,
is there a way to grant or revoke rights on specific fields of a table for
specific users?
if yes how is it possibly done and in which versions of postgres?
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://j
Hello all,
I was wondering if there is a log file where are logged connection to a
postgresql database per user and per date.
Or do i have to specify a table and insert rows in it each time a user logs
in and out?
Regards
Nathalie
___
Hi ,
Within a transaction in thru psql if we cancel
a given query with ^C then the transaction is
not commited.
what is disturbing is the COMMIT does not even gives
an warning or error.
the transaction is silently rollbacked.
regd
mallah.
tradein_clients=# begin work;UPDATE eyp_listing set
> Ultimately, we need a way to reproduce the problem for debugging.
> If it is a Postgres bug, it should be possible to reproduce it.
>
> regards, tom lane
Hello,
the vacuum seems to be ok. I discovered that the "cluster" kills the data for
some reason. I could reproduce
18 matches
Mail list logo
