Thanks
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 1:38 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Error when dropping table
Tom Lane <[EMAIL PROTECTED]> writes:
> "Chris White (cjwhite)" <[EMAIL PROTECTED]> writes
ERROR: XX000: relation "vm_message" has rel_triggers = 0
LOCATION: RemoveTriggerById, commands/trigger.c:581
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, June 23, 2004 1:32 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subj
Tom Lane <[EMAIL PROTECTED]> writes:
> "Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
>> On 7.4.2, I am trying to drop a table using the command
>> drop table vm_message cascade;
>> and I get the error message
>> relation "vm_message" has rel_triggers = 0
> I can't find any such error messag
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> On 7.4.2, I am trying to drop a table using the command
> drop table vm_message cascade;
> and I get the error message
> relation "vm_message" has rel_triggers = 0
I can't find any such error message in the 7.4 sources. Could we see
the exact
Title: Message
On 7.4.2, I am
trying to drop a table using the command
drop table
vm_message cascade;
and I get the error
message
relation
"vm_message" has rel_triggers = 0
and the table is not
dropped. What does this message mean and how can I drop the
table?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 23 Jun 2004, Hemapriya wrote:
> Does anyone know how to write queries to tables in
> other database intances in postgres? For examlpe if I
> have two DB instances set up, called "test1" and
> "test2" I may want to run an SQL in "test1" t
Hi,
Does anyone know how to write queries to tables in
other database intances in postgres? For examlpe if I
have two DB instances set up, called "test1" and
"test2" I may want to run an SQL in "test1" that
selects data from a table in "test2".
It is unclear whether it is supported or not.
Thank
Try re-installing PostgreSQL, dumping it, then re-installing the new
version.
Kevin
- Original Message -
From: "Jón Ragnarsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 12:29 PM
Subject: [ADMIN] Stupid mistake: Forgot to dump when upgrading. (7.3 ->
7.4.
I upgraded Postgres on my computer and forgot to dump the data. (Yes,
very stupid) And now 7.4.2 refuses to read the datafiles. Is there
anything that I can do?
Maybe I should ask people over at redhat/fedora if I could downgrade
Postgres?
J.
---(end of broadcast)---
BTW for those interested Oracle 9i also uses the LEFT, RIGHT, and OUTER join syntax as
well.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: [EMAIL
I am trying to restore tables and associated large objects under 7.4.2.
I created a backup using
pg_dump -U admin -Ft -b aesop > db.tar
When I try to restore it using the following command:
pg_restore -c -d aesop -U admin < db.tar
I get the following message:
pg_restore: [archiver (db)] could
On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
> Hello Everybody?...
>
>
>
>Hey, i have a question about of the uses the joins
> in PostgreSQL.
>
> In SQL Server the joins i can use with the simbol(*),
> Example:. the right join is "field1=*field2"
>
> In Oracle the joins are w
Hello Everybody?...
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is "field1=*field2"
In Oracle the joins are with the simbol (+),
Example:. the left join is "field1(+)=field2"
What is the si
[EMAIL PROTECTED] writes:
> Here is the solution to the problem:
> First: We have to restore (only) the structure (schema) of the database
> pg_restore -Ft -v -s db.tar -d database_name -U postgres -S postgres
> --disable-triggers
> Second: Restore the datas
> pg_restore -Ft -v -a db.tar -d databa
Werner Bohl <[EMAIL PROTECTED]> writes:
> pg_restore: [archiver (db)] could not execute query: ERROR: user "100"
> does not exist
I'd suggest doing a plain text schema-only dump (pg_dump -s) and looking
through it for references to userid 100. You have presumably got some
objects in the database
=?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= <[EMAIL PROTECTED]> writes:
> Hi every body, my best regards for every one who reads
> this message. I'm writing this message in order to get
> some help with a problem I'm having with the
> connection I make to a remote Database using
> PostgreSQ
I'm using Postgresql 7.4.2 on RedHat 9. We backup a database weekly with
the following command:
pg_dump --clean --create --verbose --format=c \
--compress 9 -U admin $DBSID \
| dbdumpsplit $DBSID.dump
where $DBSID is the database name. The database is very large, so we
split the dump in 1
Dear Eduardo ,
What is the most recommended way to backup a
PostgreSQL database?
pg_dump --disable-triggers -U -a -d -b -D -Fc -Z 9 -f
+
A file system backup could be done but for this you will have to
shutdown PostgreSQL server
before filesystem backup is done
And to restore it?
pg_re
Thanks you very much Tom,
Here is the solution to the problem:
First: We have to restore (only) the structure (schema) of the database
pg_restore -Ft -v -s db.tar -d database_name -U postgres -S postgres --disable-triggers
Second: Restore the datas
pg_restore -Ft -v -a db.tar -d database_name -U
What is the most recommended way to backup a
PostgreSQL database?
And to restore it?
I would like to get ALL the data and properties
possible, because if I have a problem, and I lost my
current database, I can just restore it, and will be
all exactly like was before.
What is the best way? pg_du
>> I do this, from Saturn:
>> pg_dump -Ft -b -U dbuser -h saturn dbsample > db.tar
>> Then, I create the user and database in Saturno, and perform this:
>> pg_restore -Ft -v db.tar -d dbsample -U dbuser
>> But, pg_restore stops, showing this message:
>
>> pg_restore: fixing large object cross-refer
...and on Wed, Jun 23, 2004 at 08:53:01AM +0200, Grega Bremec used the keyboard:
>
> Recap - patch /etc/rc.d/rc.sysvinit with the attached patch, create
>
> $ mkdir /etc/rc.d/{init,rc{0,1,2,3,4,5,6}}.d
Eeek, seems there's been a mismatch in the original source file
I used to create the patch
Hi every body, my best regards for every one who reads
this message. I'm writing this message in order to get
some help with a problem I'm having with the
connection I make to a remote Database using
PostgreSQL on a Linux Operating System. The matter is
that when I make my connection every query I
Janio:
My experience of various Linux distributions is not very wide. But I'd be
surprised if slackware didn't have some variant of the su -c command, which
is what I generally use to start postgres from rc.* scripts.
A line like
su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsq
...and on Wed, Jun 23, 2004 at 01:38:44AM -0300, Janio Rosa da Silva used the keyboard:
>
> I am looking for a way to start PostgreSQL when the computer is turned
> on. Any ideas?
>
> I am using Slackware 9.1 and PostgreSQL 7.4.2;
>
> I was made a rc.postgresql script file. And I called for it f
25 matches
Mail list logo