Hello all.
Is there a way to change the datestyle for a single select statement. I
dont wnat to play around with PGDATESTYLE, for fear of messing with other
program we have using the database, and am not sure if set datestyle sets
the style for every database, or just the current database.
So,
Hello all.
Often times in our database we have web pages built off of the order in
which data is retrieved from the database. For the most part this data is
retreived in the same order in which it was put in.
For Example we put in the following info
song1, title2
song2, title2
song3, title3
E
NoI haven't vacuumed in a whilebut this change in speed happened
almost overnight. Is that possible?
Darren
- Original Message -
From: Lamar Owen <[EMAIL PROTECTED]>
To: Darren Greer <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 10, 19
Hello all. On another maybe related note to my recovery issues, I am
noticing a drastic slow down with my database. A couple of days ago, when
deleting 20,000 rows of data, it would take roughly 5-10 seconds. Now it is
taking about 2-5 minutes for 2,000. Is there anything I can check to see if
Ok.thanks to the help of Oliver Elphick, I know have the correct version
of Postres installed, and my old data is there and working fine (ie I can do
a psql -c "select count(*) yada yada" dbname, with success). My problem now
is that, when I try and go into psql, I get a Segmentation fault.
OkI had mentioned that the PG_VERSION file in my original data directory
says 6.4. Well, I installed postgres version 6.3 and then copied my original
data directory over the new. This is what I get:
gandalf:/# /etc/init.d/postgresql start
The database is in an older format that cannot be re
directory exactly what version I was running?
- Original Message -
From: Jay W. Summet <[EMAIL PROTECTED]>
To: Darren Greer <[EMAIL PROTECTED]>
Sent: Tuesday, August 10, 1999 8:48 AM
Subject: Re: [ADMIN] Urgent - Help Needed (Restoriing Data)
> -BEGIN PGP SIGNED MESSAGE-
Somehow, our version of postgres got upgraded during some system
maintenance. To make a long story short we had to completely re-install
Posgres (6.3-15). Now I have originaly data directory backed up, but have
found no way to import the data. I tried simply replacing the new data
directory wit
/report to the group
for further information.
Darren Greer
QTI - Information Systems
(414)566-7543
[EMAIL PROTECTED]
Hello all.
Ive got a table with a field that is varchar(80). This field has a URL
in it. Unfortunately when the data was entered some of the URL's are
hardcoded with the IP number. For example:
http://207.200.200.2/yada/yada.ra
I need to replace the 207.200.200.2 with the domain name. Ive be
I would like to thank all those that replied with my problem importing and
exporting into a text field. I will be trying it tonight, and feel quite
confident that all will go well. I will let everyone know how it goes.
Once again Thanks,
Darren Greer
QTI - Information Systems
(414)566-7543
has been answered several times, but have been
unable to find any post that actually shows how. I would greatly
appreciate it if someone could tell me the steps to solve my dilema.
Thanks in advance,
Darren Greer
QTI - Information Systems
(414)566-7543
[EMAIL PROTECTED]
12 matches
Mail list logo
