"Pascal PEYRE" <[EMAIL PROTECTED]> writes:
> I have some big postgreSQL databases (4/5 GB at start) on this server.
> Every night I erase data and I import a lot of new data.
Exactly how do you erase the old data? If you're zapping the entire
contents of tables, TRUNCATE might be a good answer.
On Fri, Feb 21, 2003 at 11:01:31AM +0200, Nathalie Boulos wrote:
> Hi everyone,
Hi!
> I'm using postgresql-7.2.2-1 under RedHat linux 8.0.
>
> I created a unicode DB and trying to insert arabic text through a php
> script on the web. I'm getting the following error:
> Warning: pg_exec()
On Thu, Feb 20, 2003 at 11:07:55PM -0500, Tom Lane wrote:
> Ganesan R <[EMAIL PROTECTED]> writes:
> > I am using 7.3.2. postmaster prints this on starting up:
>
> > LOG: ReadRecord: bad resource manager data checksum in record at 0/E42144
>
> > pg_resetxlog is able to recover from the problem; b
Hi,
I use postgresql 7.2.x on Linux 2.4.18-6mdksmp #1 SMP i686
I have some big postgreSQL databases (4/5 GB at start) on this server.
Every night I erase data and I import a lot of new data.
For optimize my database I operate a vacuum "all" every night.
The problem is that the size of database
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Could somebody tell me the consequences of setting the date forward in time=
> on the server running PostgreSQL and then at a later date, after some tran=
> sactions have been committed, setting the date back in time?
AFAIR, Postgres itself couldn't c
Donald,
It depends on your application and by how much you
change the time.
If you have a database field that is populated with the
system time when you insert records your application
logic may not work as intended.
Not sure why you would want to play with the system
clock in the first place.
Could somebody tell me the consequences
of setting the date forward in time on the server running PostgreSQL
and then at a later date, after some transactions have been
committed, setting the date back in time?
Thanks in advance,
Donald Fraser
On Fri, 21 Feb 2003, Nathalie Boulos wrote:
> I created a unicode DB and trying to insert arabic text through a php
> script on the web. I'm getting the following error: Warning: pg_exec()
> query failed: ERROR: Invalid UNICODE character sequence found (0xe4)
>
> the client is a IE browser on
