> 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
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
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
:-) ...
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
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
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])
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 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
"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
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
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
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,
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
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 ,
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
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.
how can i use no wrap text in psql
console
:-) Sidar Lopez Cruz- Cero Riesgo,
S.A.
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
18 matches
Mail list logo
