(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
-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
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
unbsubscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
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
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]#
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
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
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
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
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
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
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 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
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
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
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
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
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
19 matches
Mail list logo
