~~~
There was no data loss.
~~~
This message was posted during the disturbance
period in our mailing lists. hence could not
update on this .
In fact i was under the impression that it would
have never reached the lists.
My false assertion was based on d
Title: Timestamp of insertion of the row.
Hi,
Is there any way to know data & time when the row is inserted into a table?
Help appreciated.
Thx,
Anagha
Anagha Joshi wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?
A timestamp column with a default value of 'now' ???
This will only work for inserts and not updates.
Peter
---(end of broadcast)---
TIP 5: H
"Anagha Joshi" <[EMAIL PROTECTED]> wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?
You should define a supplementary field with default value "now()"
this field will contain the transaction start time, if you want have the
real time (if you insert a mi
Hello,
I have a tar.gz of several PostgreSQL 6.5.2 databases files (theses are
the binary files, NOT the sql dump) that I would like to recover in a
PostgreSQL 7.3.3 database.
How can I do that kind of recover ? Where can I find step by step
explanations for that kind of operation ?
Or do you th
"Bruno BAGUETTE" <[EMAIL PROTECTED]> wrote:
> If Yes, where can I find the 6.5 PostgreSQL tar.gz ?
ftp://ftp.fr.postgresql.org/source/v6.5/
Regards
Gaetano
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropri
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?
Add a timestamp field and set the default value as now(). If you wish to
maintain similar value during update, a before trigger could help.
regards,
bhuvaneswaran
---(end of broadcast)-
how can i link 2 servers and share db info between
both
the servers are on separated
machines...
:-) Sidar Lopez Cruz- Cero Riesgo,
S.A.
which are the best tool for migrating data from
mssql to postgresql
:-) Sidar Lopez Cruz- Cero Riesgo,
S.A.
I think you'd benefit from a two-stage Rsync (this was discussed on this
list in the past few months):
1. Rsync the $PGDATA cluster from the "hot" server to the "standby" server,
with the postmaster running
2. Stop the postmaster and perform the same rsync again (this will take only
a few seconds
Sidar Lopez Cruz wrote:
how can i link 2 servers and share db info between both
the servers are on separated machines...
See contrib/dblink
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
We have installed Postgres 7.1 on a SUN Solaris 6 server. This works well.
We have also transferred the same binary/libraries to a server running
Solaris 8. This also works well. However we have noticed that 2 postmaster
processes are created when the postmaster is run. The second of which is a
hi sir
i am using postgres on linux 7.2.
i am trying to get backup of databases from postgtres throuhg shell script.
i installed the postgres as default installation. and login as
> su postgres
psql mails
so now problem is that when i am writing a shell script, that script must
postgres user to r
Hi there.
First things first. I just want to say I've moved from Mysql to Postgres
for alot of reasons. :-)
My questions:
=
* What is the limit my PostgresDB can grow to? 4gigs, 8gigs?
* What sort of system I'am a looking at running postgres on?
Now here's a really confusing o
Dear Sir
I am a swiss student in the University of Applied Sciences of Geneva. For a
report on the different implantation of metadata in PostgreSQL 7.3, Oracle
and SQL3, I would like you to know if it is possible to answer me some
questions :
1) is the system catalog the only one way to have meta
Hi all, i'm new in postgres and this question may be very easy, but i need
to do this so here it goes.
I have one user in my database, and i need to create 10 more users to
connect to de database but they must use the tables defined in the first
user but i can not use user.table. how can i do th
Hello,
Currently I am focused basically on the same issues:
1). I hope yes, I see no reason to change it.
2). You may want to take a look at:
http://developer.postgresql.org/docs/postgres/features.html
SQL1999 is just another name for SQL3.
Anyway it's not trivail task to compare SQL3 and PostgreS
On Tue, Jun 10, 2003 at 10:53:50 -0300,
Julian <[EMAIL PROTECTED]> wrote:
> Hi all, i'm new in postgres and this question may be very easy, but i need
> to do this so here it goes.
> I have one user in my database, and i need to create 10 more users to
> connect to de database but they must use
UNSUBSCRIBE
credit.com
690 Fifth Street
San Francisco
Ca 94107
(415) 901 1559
Hello!!!
I 'm new in Postgres 7.2 my question is, exists some way to backup only a table and no the all database with pg_dump or another utility, too I used COPY but my problem is logged like postgres user the message that send me is:
bash-2.05a$ psql gheo -Upostgres
Password:
psql: FATAL
Hi,
Le Mercredi 11 Juin 2003 20:25, vous avez écrit :
> Hello!!!
> I 'm new in Postgres 7.2 my question is, exists some way to backup only
> a table and no the all database with pg_dump or another utility, too
pg_dump allows you to do this using the -t switch.
Try something like
pg_dump -t my
Thank you Guillaume !!
It works!!
Miriam
El mié, 11 de 06 de 2003 a las 18:19, Guillaume LELARGE escribió:
Hi,
Le Mercredi 11 Juin 2003 20:25, vous avez écrit :
> Hello!!!
> I 'm new in Postgres 7.2 my question is, exists some way to backup only
> a table and no the all database with
22 matches
Mail list logo
