Hello all,
I have created users for which I have restricted access to SELECT
from a set of tables, this works :)
But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
The user can still create tables...I've also issued this command for the
SCHEMA and still no go.
Is this a known p
Hi,
I am facing a serious problem now...
I am using wxWidgets 2.5.1 and Dev-C++ in Windows XP. I have no problem
trying to acccess the database. But I have a problem trying to decipher the
data in Postgresql.
For example, If I want to do a query... and get the results back, I can
count the numb
Christian Fowler wrote:
I'm running a large database ( data dir is ~9gigs ) on Fedora Core 2
with 7.4.5-PGDG rpm's
When using the -Fc dump method + pg_restore, I get:
-bash-2.05b$ pg_restore -Fc -d foo -L backup.list
/tmp/02\:43-postgresql_database-foo-backup
pg_restore: ERROR: invalid input sy
On Wed, 2004-10-20 at 08:17, Joe Maldonado wrote:
> Hello all,
> I have created users for which I have restricted access to SELECT
> from a set of tables, this works :)
> But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
> The user can still create tables...I've also issued th
Joshua -
well, i ran a --inserts dump as you suggested, and it died upteen millions
(and many hours) in at:
INSERT 59235383 1
invalid command \033',
cannot allocate memory for output buffer
Weiping,
db=# \encoding
UNICODE
the last four columns in the table are:
full_name_nd | character varying
I am running 7.4.2
and I am seeing a strange error. I am using jdbc to update a table with the
following statement:
update vm_message
set usecount=4 where messsage id='1234567';
this statements
generates a PSQLException with the following message:
ERROR: duplicate key
violates unique
ERROR: duplicate key violates unique constraint "vm_message_pkey"
I don't understand why I am getting this message because the primary key
for table vm_message is messageid and this is not being changed
Any body have any ideas?
7.4.2 is know to have index issues. Try reindexing the primary key
I need some help understanding what the difference is between the
following debug_print parameters. I have tried them all and they all
seem to give me the same output (looks like an explain verbose).
Anyway, I am really wanted to just have the db print a simple explain to
the log for each que
That doesn't help me because this is running in an embedded system that
should have little or no db admin. Anybody suggest what version I should be
running?
Chris
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 12:42 PM
To: [EMAIL PROT
Chris White (cjwhite) wrote:
That doesn't help me because this is running in an embedded system that
should have little or no db admin. Anybody suggest what version I should be
running?
7.4.5.
Sincerely,
Joshua D. Drake
Chris
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTE
On Wed, 2004-10-20 at 12:57, Chris White (cjwhite) wrote:
> I am running 7.4.2 and I am seeing a strange error. I am using jdbc to
> update a table with the following statement:
>
> update vm_message set usecount=4 where messsage id='1234567';
Is that really your query, cut and pasted? Is that
It was a mistype, it was not a cut and paste, as I do not have email on the
system that has access to the system running the DB. There is meant to be no
space in messageid
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 2:53 PM
To: [EMA
I am running 7.4.2,
when I try to drop a table it comes back with the message:
relation
"vm-message" has reltriggers = 0
and doesn't drop the
table. What does this mean and how can I really drop the
table?
Chris
White
Christian Fowler wrote:
db=# \encoding
UNICODE
the last four columns in the table are:
full_name_nd | character varying(200) |
mod_date | timestamp without time zone |
pc_char | character varying(4)|
dim_char | character varying(16) |
[EMAIL PROTECTED] root]#
Joe Maldonado <[EMAIL PROTECTED]> writes:
> But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
> The user can still create tables...
CREATE privilege on a database concerns the right to create schemas
within the database. Whether you can create tables within a schema
is a differen
unbsubscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
hi friends
pls help me
i have a Linux redhat 9 machine
and i have installed the POstgres 7.4.5 using the
sources
the problem heppens when i want the postgres to start
automatically when my server is booted
i have written a shell script in rc.local for doing
this which looks as shown below
my ap
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 20 Oct 2004, Jagdish rao wrote:
i have a Linux redhat 9 machine
and i have installed the POstgres 7.4.5 using the
sources
RPMs for Red Hat 9 are also available from any PostgreSQL FTP mirrors; you
could install the RPMs also: www.postgresql
(B
(B
(BHi,
(B
(BI thought I read something about this in
(Brelation to v8, but I can't find any reference to it now... is it (or will it
(Bbe) possible to do master-slave style database replication by transmitting log
(Bfiles to the standby server and having it process them?
(B
(BA
19 matches
Mail list logo
