On Thu, 2002-11-28 at 21:21, yudha wrote:
> Dear Milist;
> Please give me some advices and help. How can i do
> "select" the TABLE_1 on other database DB_2,
> but currently i'm connecting to on DB_1.
>
> ORACLE :
> Current_DB_1 #> Select * From DB_2.TABLE_1;
>
> MS-SQL :
> Current_DB_1 #> Se
Dear Milist;
Please give me some advices and help.
How can i do
"select" the TABLE_1 on other
database DB_2,
but currently i'm connecting to on
DB_1.
ORACLE :
Current_DB_1 #> Select * From
DB_2.TABLE_1;
MS-SQL :
Current_DB_1 #> Select * From DB_2..TABLE_2;
PostGre :
Current_DB_1 #
On Wed, 2002-11-27 at 17:03, Hugh Esco wrote:
> I'm resending this, sans attachments, and to the list this time for others
> edification, to correct some typos by my attempt to recreate the shell
> dialogue. Those first two lines are cat'ing diversions, not diversions.txt.
>
> It seemed simpler
If I have to take a guess, it is that you have a language defined in
template1 (and hence in the new db) or in the database you are loading
into and that is conflicting with the load of the dump.
---
Nick Fankhauser wrote:
>
Mr. Elphick:
I'm resending this, sans attachments, and to the list this time for others
edification, to correct some typos by my attempt to recreate the shell
dialogue. Those first two lines are cat'ing diversions, not diversions.txt.
It seemed simpler than a continuous exchange of questions t
On Wed, 27 Nov 2002, fred wrote:
> Ok,
> Thank you for your quick answer,
> I'm affraid I made a mistake on my mail.
> I really wanted to automaticly delete line in the 'fact' table when I delete
> a line in the 'fact' table.
> But when I suppress a line in the 'coop' table I still have the relat
Ok,
Thank you for your quick answer,
I'm affraid I made a mistake on my mail.
I really wanted to automaticly delete line in the 'fact' table when I delete
a line in the 'fact' table.
But when I suppress a line in the 'coop' table I still have the related line
in the 'fact' table.
Do you think ther
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> We've never touched template1, but just to make sure, I tried using
> template0 to ensure an empty DB with the same results:
> nickf@morgai:~$ createdb -D PG_ALPHA -T template0 test
> CREATE DATABASE
> nickf@morgai:~$ pg_restore -dalpha test.dump.ta
On Wed, 27 Nov 2002, fred wrote:
> Hello,
> I use postgreSQL 7.2.3 and I have trouble on deleting.
> I would like to automaticly delete line in the 'coop' table when I dlete the
> line in the 'fact' table but it is not ok.
> Where is my mistake ?
On delete cascade goes the other direction. What
Hello,
I use postgreSQL 7.2.3 and I have trouble on deleting.
I would like to automaticly delete line in the 'coop' table when I dlete the
line in the 'fact' table but it is not ok.
Where is my mistake ?
This is my database:
create table coop (
id_coop serial not null,
nom_coop varchar(50) not nu
On Wed, 2002-11-27 at 14:28, Nick Fankhauser wrote:
> Oliver-
>
> Thanks for the idea. Unfortunately, it still won't go.
>
> We've never touched template1, but just to make sure, I tried using
> template0 to ensure an empty DB with the same results:
Does the same happen with a plain text dump (r
Its a very funny installation that ur GRASS has done.
if primary group of posgres is www then data folder
shud not be own by group staff.
i would suggestt that u install pgsql your self from
its install doc and preferebly the 7.3rc2 version.
that would be much simplier & quicker
and digging th
Oliver-
Thanks for the idea. Unfortunately, it still won't go.
We've never touched template1, but just to make sure, I tried using
template0 to ensure an empty DB with the same results:
nickf@morgai:~$ createdb -D PG_ALPHA -T template0 test
CREATE DATABASE
nickf@morgai:~$ pg_restore -dalpha tes
On Wed, 2002-11-27 at 13:16, Nick Fankhauser wrote:
> Hi-
>
> I'm trying to do a dump & restore of a complete database using tar archive
> format. I've previously used the text dump approach, so I'm very new to this
> method.
>
> I created the dump using:
>
> pg_dump -Ft alpha > alpha.dump.tar
>
Hi-
I'm trying to do a dump & restore of a complete database using tar archive
format. I've previously used the text dump approach, so I'm very new to this
method.
I created the dump using:
pg_dump -Ft alpha > alpha.dump.tar
I'm trying to restore into an empty db using:
pg_restore -d alpha2
hi there,
i want to change the datatype within one colum for example column 'text'
which is 'varchar' to 'int(4)' i didnt find anything about that in the
manuals.
i tried something like that:
ALTER table io ALTER COLUMN wort RENAME TO wort int(4);
but it didnt work! i hope you can help me!
t
16 matches
Mail list logo