Paul Lambert wrote:
> Taking your example of file permissions - although it is not default
> behavior, it is possible to recursively apply a priviledge change to a
> directory onto files/subdirectories within it. Certainly it can be done on
> OpenVMS and Windows that I work with primarily and I
A.Burbello a écrit :
Hi people,
I have a case and I got a doubt what should be the
best ways.
One table has more than 150 million of rows, and I
thought that could divided by state.
For each row has person ID, state and other
informations, but the search would be done only by
person ID (number
Hi,
I am trying to use postgres odbc driver on windows Japanese machine, to
test connection to a remote postgres database. The database has latin1
encoding.
Connection tests to databases with latin1 encoding fail with this error
message:
fatal: conversion between SJIS and LATIN1 is n
Hi list;
We're seeing this error whern trying to restore a pg_dump file:
-
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0x9f CONTEXT:
COPY log_customer_api, line 4551 pg_res
On Dec 13, 2007 7:15 AM, olivier boissard <[EMAIL PROTECTED]> wrote:
> A.Burbello a écrit :
> > Hi people,
> >
> > I have a case and I got a doubt what should be the
> > best ways.
> >
> > One table has more than 150 million of rows, and I
> > thought that could divided by state.
> > For each row h
Am Donnerstag, 13. Dezember 2007 14.40:22 schrieb Sofer, Yuval:
> Hi,
>
>
>
> I am trying to use postgres odbc driver on windows Japanese machine, to
> test connection to a remote postgres database. The database has latin1
> encoding.
>
>
>
> Connection tests to databases with latin1 encoding fail
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 13 Dec 2007 14:55:53 +0900
Paul Lambert <[EMAIL PROTECTED]> wrote:
> > The analogy to think about is that usage privilege on a schema is
> > comparable to read access on a directory. That doesn't necessarily
> > give you access to any single f
Hi everybody,
As I look at output from pg_stat_activity view,
I see often under query column and on the
same row waiting column is always f. I gather
that this is someone sitting at prompt of psql.
My question: What does it mean when a query column
lists a sql statment and waiting column f? Wo
I am trying to create a tablespace logged in as postgres. I just
installed postgresql 8.2.5 on a Redhat linux server.
I am receiving the following error.
ERROR: could not set permissions on directory "/data/pgsql/pgdata":
Permission denied
The SQL command I am using is as follows.
CREATE
On Dec 13, 2007 1:33 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi everybody,
>
> As I look at output from pg_stat_activity view,
> I see often under query column and on the
> same row waiting column is always f. I gather
> that this is someone sitting at prompt of psql.
>
> My question:
Am Donnerstag, 13. Dezember 2007 18.06:23 schrieb Kevin Kempter:
> Hi list;
>
> We're seeing this error whern trying to restore a pg_dump file:
>
> ---
>-- pg_restore: ERROR: invalid byte sequence f
Hi,
In Earlier versions of PostgreSQL (installed in FreeBSD) we could cancel
process from Server Status of pgAdmin III (in MS Windows). Now we have PG 8.2
and we can't do it anymore.
¿What must we change to be able to cancel process from pgAdmin III?
Thanks
Sebastián
Sebastián Baioni
h
"Ferry, Craig" <[EMAIL PROTECTED]> writes:
> I am trying to create a tablespace logged in as postgres. I just
> installed postgresql 8.2.5 on a Redhat linux server.
> I am receiving the following error.
> ERROR: could not set permissions on directory "/data/pgsql/pgdata":
> Permission denie
Hi Scott,
Thank you for an enlightening example! I see
it and I believe it.
My next question:
What would be a good way to tell if some
query is hung?
Regards,
Tena
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thu 12/13/2007 11:47 AM
To: Tena Sakai
Cc: pgsql-
On Wed, Dec 12, 2007 at 06:01:52PM +0100, Listaccount wrote:
> BTW : How can one find out the application doing unused allocations?
> What value of "ps" output to watch for?
As far as I know, the only way to learn that is to use a debugger. If the
OS knew this, it'd be able to shoot the misbeh
On Dec 13, 2007 3:43 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> My next question:
> What would be a good way to tell if some
> query is hung?
That would really depend on what you mean by hung. Just running a
really long time, or waiting for a lock that some other session is not
will to comm
Hi Scott,
Thanks for the sql statement with pg_stat_activity.
> You can set the value for statement_timeout and any statement
> that takes over that amount of time will generate a timeout and you
> then log it in the logs.
I like this idea, but according to what I read, it looks
like the query w
Hi,
Is it possible to create synonym in postgresql?
I am getting error while creating synonym.
ERROR: syntax error at or near "synonym" at character 8
Thanks & Regards,
Suresh
PostgreSQL does not support SYNOSYM or ALIAS. Synonym is a non SQL 2003
feature implemented by Microsoft SQL 2005 (I think). While it does provide
an interesting abstraction, but due to lack of relational integrity, it can
be considered a risk.
That is, you can create a synonym, advertise it to yo
19 matches
Mail list logo