On Wed, 29 May 2002, Gareth Kirwan wrote:
> Hello all,
> Let's dive straight in, eh?
>
> 1.
> Table: current_sessions
> Fields: Server (int Foreign Key servers.id)
> Client (int Foreign Key clients.id)
> status (vc(10))
>
> 2.
> Table: clients
> Fields:
On Wed, 29 May 2002 10:54:50 -0300
"Denilson Guedes Duarte" <[EMAIL PROTECTED]> wrote:
Probably this runs, I guess. As for username table, however, I have another
question: why denilson is first. What rule there would be ?
select c1.cod_cliente,
c1.controle, c1.dt_vencimento,
c1
Nick Fankhauser wrote:
> Try:
>
> ls -al /tmp
>
> make sure the permissions on /tmp are: drwxrwxrwt
>
> >please answer in chinese
>
> That's a skill I don't have- I hope you can work with this...
I think there is the document in Chinese. Please check the home site of
postgres.
>
>
> -Nick
Hello all,
Let's dive straight in, eh?
1.
Table: current_sessions
Fields: Server (int Foreign Key servers.id)
Client (int Foreign Key clients.id)
status (vc(10))
2.
Table: clients
Fields: id (serial Pkey)
username (UNIQUE)
3.
Try:
ls -al /tmp
make sure the permissions on /tmp are: drwxrwxrwt
>please answer in chinese
That's a skill I don't have- I hope you can work with this...
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.9
On Sat, 25 May 2002 09:53:39 -0300
"Denilson Guedes Duarte" <[EMAIL PROTECTED]> wrote:
> and runs ok, but the problem is that the table username (alias u) hane N records and
>I want to get only one record. I try to use a subqyuery:
> select
> (select u.username from ctareceber c left join
Hi,
How can we mirror an ENTIRE DATABASE? I have came across pgreplicator
and it seems that it will mirror ONLY TABLES. Then how about views,
functions, triggers, sequences, etc.(somebody correct me if wrong)
So am i unable to mirror a ENTIRE DATABASE in postgres? Else shall i
do this way on per