On Wed, Feb 27, 2008 at 3:44 AM, Tim Uckun [EMAIL PROTECTED] wrote:
Where can I get uuid-ossp for windows? Also where can I get citext for
windows.
These two are missing from the windows installer.
uuid-ossp is missing because until a few days ago the underlying
uuid-ossp wasn't ported to
On Wed, Feb 27, 2008 at 11:11:52AM +1300, Tim Uckun wrote:
I just downloaded postgres 8.3 for windows and noticed that citext is
not an option for columns.
The web site has the source code but no binaries for windows.
That is something you need to talk to the citext creators about. Ideally,
On Tue, Feb 26, 2008 at 11:51:34PM -, Joris Dobbelsteen wrote:
AFAIK stopping the server, zipping data dir, and restarting
the server
creates a zip file which is not easily portable to other
computers due
to some ntfs file system permission problems.
IIRC you have to re-assign
Bruno Baguette wrote:
Hello !
I have a week number (ISO 8601) and a year, based on theses values, I
would like to get the first and the last dates of that week.
Broken down step-by-step. End of week left as an exercise
SELECT
doy,
EXTRACT(dow FROM doy) AS offset,
(doy - EXTRACT(dow
On Tue, Feb 26, 2008 at 10:30:02PM +0100, Gevik Babakhani wrote:
AFAIK stopping the server, zipping data dir, and restarting
the server creates a zip file which is not easily portable to
other computers due to some ntfs file system permission problems.
IIRC you have to re-assign owner
On Feb 27, 2008, at 2:32 AM, Bruno Baguette wrote:
Hello !
I have a week number (ISO 8601) and a year, based on theses values,
I would like to get the first and the last dates of that week.
How I can do that ?
The only solution is doing a big generate_series to build a subset
that
I just got aware of the difficulties of restoring db from different
locales (money data type).
Even if I was aware money was deprecated it was used just for a
temp table that I forgot to drop before dump.
I do have to move stuff from boxes with different locale. Should I be
aware of other
I just ANALYZEd the database and times are back to normal. Sorry for the noise.
Regards, Clodoaldo Pinto Neto
2008/2/27, Clodoaldo [EMAIL PROTECTED]:
Postgresql 8.2.6, Fedora 8, 2 GB memory.
A query that used to perform in a few seconds is now taking 64 seconds
with 100% cpu:
fahstats=
On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote:
Norman Peelman [EMAIL PROTECTED] writes:
My options are, as far as I can tell,
1) replace the Database PDO extending class with something else that
provides query results caching in PHP, or
2) get Postgres itself to cache the
Postgresql 8.2.6, Fedora 8, 2 GB memory.
A query that used to perform in a few seconds is now taking 64 seconds
with 100% cpu:
fahstats= explain analyze
fahstats- select
fahstats- donor::smallInt as new_members,
fahstats- active_members,
fahstats- d.data::date as day,
fahstats-
Suppose I have two tables, A and B, with k(A) and k(B) columns respectively,
and let's assume to begin with that they have the same number of rows r(A) =
r(B) = r.
What's the simplest way to produce a table C having r rows and k(A) + k(B)
columns, and whose i-th row consists of the k(A) columns of
On Wed, Feb 27, 2008 at 7:39 AM, Kynn Jones [EMAIL PROTECTED] wrote:
Suppose I have two tables, A and B, with k(A) and k(B) columns
respectively, and let's assume to begin with that they have the same number
of rows r(A) = r(B) = r.
What's the simplest way to produce a table C having r rows
Stuart Brooks wrote:
Are you measuring index as well as table size? VACUUM FULL is no good
at compacting indexes.
I am measuring pg_total_relation_size which I believe includes indexes.
How does one go about compacting indexes if a VACUUM doesn't do the
trick? I see that a
Dear Sirs.
I have a problem with installing PostgreSQL 8.3 on my computer
with Windows XP Home edition and AVG FREE antivirus 7.5.
The installation-program asks for a installing-language and to save
the installation-process in a logfile. When I choose English and press
the
Are you measuring index as well as table size? VACUUM FULL is no good
at compacting indexes.
I am measuring pg_total_relation_size which I believe includes indexes.
How does one go about compacting indexes if a VACUUM doesn't do the
trick? I see that a recommendation is to drop
On Wed, Feb 27, 2008 at 02:41:09PM +, Richard Huxton wrote:
Jan Christensen wrote:
Dear Sirs.
I have a problem with installing PostgreSQL 8.3 on my computer
with Windows XP Home edition and AVG FREE antivirus 7.5.
The installation-program asks for a installing-language and
On Wed, Feb 27, 2008 at 03:59:24PM +0100, [EMAIL PROTECTED] wrote:
On 22:37 Tue 26 Feb , Magnus Hagander wrote:
[EMAIL PROTECTED] wrote:
AFAIK stopping the server, zipping data dir, and restarting the server
creates a zip file which is not easily portable to other computers due
to
This has come up a few times over the last few months, and I'm not
too keen on the solutions we've been using.
There seems to be a lack of useful functions for converting intervals
to useful representations. For example, I want to display an interval
in hours and fractions of hours only, not
Jan Christensen wrote:
Dear Sirs.
I have a problem with installing PostgreSQL 8.3 on my computer
with Windows XP Home edition and AVG FREE antivirus 7.5.
The installation-program asks for a installing-language and to save
the installation-process in a logfile. When I choose
On Wed, Feb 27, 2008 at 02:58:22PM +, Richard Huxton wrote:
Magnus Hagander wrote:
On Wed, Feb 27, 2008 at 02:41:09PM +, Richard Huxton wrote:
I'm guessing that you're missing some of the locale (language) files for
your machine. Have you got anything unusual selected in your
Magnus Hagander wrote:
On Wed, Feb 27, 2008 at 02:41:09PM +, Richard Huxton wrote:
I'm guessing that you're missing some of the locale (language) files for
your machine. Have you got anything unusual selected in your language
settings?
That's not actually the error. That happens
Bill Moran [EMAIL PROTECTED] writes:
There seems to be a lack of useful functions for converting intervals
to useful representations. For example, I want to display an interval
in hours and fractions of hours only, not hours and minutes.
Perhaps EXTRACT(EPOCH ...) to get total seconds and
Gordon wrote:
On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote:
Norman Peelman [EMAIL PROTECTED] writes:
My options are, as far as I can tell,
1) replace the Database PDO extending class with something else that
provides query results caching in PHP, or
2) get
On Feb 27, 10:37 am, Gordon [EMAIL PROTECTED] wrote:
On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote:
Norman Peelman [EMAIL PROTECTED] writes:
My options are, as far as I can tell,
1) replace the Database PDO extending class with something else that
provides query
In response to Tom Lane [EMAIL PROTECTED]:
Bill Moran [EMAIL PROTECTED] writes:
There seems to be a lack of useful functions for converting intervals
to useful representations. For example, I want to display an interval
in hours and fractions of hours only, not hours and minutes.
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and see
the data inside.
i am working on windows xp and have installed the software successfully.
please help i am my wits end.
--
akshay uday bhat.
t.y.c.e.
department of chemical
Bill Moran wrote:
It just seemed like this would be something so common that there'd
be something in existence already. I guess I was wrong.
Yeah, I have wished for the same thing myself.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company -
Tom Lane wrote:
There never was a 7.1.4 release, so I suspect the OP meant 7.4.1
not that that speaks very much better for his software maintenance
habits. Even with the more charitable interpretation, it's a version
that was obsoleted four years ago next week.
In my experience at
On 27/02/2008, Olmec Sinclair [EMAIL PROTECTED] wrote:
Hi Olmec,
I have encountered a similar situation that came about when I
upgraded to postgres 8.3. Now it won't start stating that:
The server must be started under the locale : which does not
exist any more
(it looks like the locale
Lew wrote:
Tom Lane wrote:
There never was a 7.1.4 release, so I suspect the OP meant 7.4.1
not that that speaks very much better for his software maintenance
habits. Even with the more charitable interpretation, it's a version
that was obsoleted four years ago next week.
In my
(Sorry for the repost but I thought this would be appropriate to both
groups. I did tell Google to delete my first post but odds are some
guys got that copy already anyway)
After a lot of hairpulling, I finally found a mechanism in PHP for
doing what I wanted. I just had to know 2 things:
1)
Lew [EMAIL PROTECTED] writes:
Tom Lane wrote:
There never was a 7.1.4 release, so I suspect the OP meant 7.4.1
not that that speaks very much better for his software maintenance
habits. Even with the more charitable interpretation, it's a version
that was obsoleted four years ago next
On Wed, 27 Feb 2008, Lew wrote:
One has only to look at how many organizations still use Oracle 8, or
Java 1.3, for example, to see how conservative many shops are with
respect to upgrades. I'm not saying they should be that conservative,
but many organizations are and we must be ready to
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
$ cat /etc/issue
Red Hat Enterprise Linux AS release 3 (Taroon Update 9)
Kernel \r on an \m
$ rpm -qa | grep ssl
docbook-style-dsssl-1.76-8
mod_ssl-2.0.46-70.ent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 27 Feb 2008 11:28:32 -0500
Lew [EMAIL PROTECTED] wrote:
In my experience at various big-iron shops (government agencies,
large health-care organizations and the like), four years is not a
long time for enterprise software - a version often
On 28/02/2008, Olmec Sinclair [EMAIL PROTECTED] wrote:
Hello again!
And please remember to hit reply-to-all so everyone on the
list sees what you're saying. Also please note that top-posting
is frowned upon here. :)
I am running postgres on Ubuntu 7.10 (recent convert from windows) and I
Greg Smith [EMAIL PROTECTED] writes:
If some big-iron shop who is so blind to security issues that they want to
keep 7.4 on life support, they certainly can find someone to deliver such
a support agreement on a contract basis. But they shouldn't expect the
public project to keep them
Ray Stell [EMAIL PROTECTED] writes:
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
Weird. Did you look into config.log to see exactly why the probes
for ssl.h are failing?
regards, tom lane
Greg Smith wrote:
If some big-iron shop who is so blind to security issues that they want
to keep 7.4 on life support, they certainly can find someone to deliver
such a support agreement on a contract basis. But they shouldn't expect
the public project to keep them afloat for free, and saying
Andrej,
Thanks for the tips (should I post this in a different way?)
Anyway, I uninstalled and installed using the ubuntu package manager. I
tried again this morning - removing 8.2 and then reinstalling 8.2
again... still won't start.
I'm sure I can work through this (I seem to remember
Hallo,
I have Postgres installed as a service on Windows xp pro. It has been working
fine but suddenly i couldn't start it anymore. I looked in different forums for
a similar problem but didn't find any solution sofar. So any help is very
appreciated. one more thing to say is that i am a
On Wed, Feb 27, 2008 at 03:22:57PM -0500, Tom Lane wrote:
Ray Stell [EMAIL PROTECTED] writes:
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
Weird. Did you look into config.log to see exactly why the probes
for ssl.h
On Feb 27, 2008, at 7:22 AM, Kynn Jones wrote:
On Wed, Feb 27, 2008 at 7:39 AM, Kynn Jones [EMAIL PROTECTED] wrote:
Suppose I have two tables, A and B, with k(A) and k(B) columns
respectively, and let's assume to begin with that they have the
same number of rows r(A) = r(B) = r.
What's
On 28/02/2008, Olmec Sinclair [EMAIL PROTECTED] wrote:
Anyway, I uninstalled and installed using the ubuntu package manager. I
tried again this morning - removing 8.2 and then reinstalling 8.2 again...
still won't start.
Are you seeing any error messages? W/o more detail it's impossible
to
citext is not part of core PostgreSQL or something we have any
intention to include in the Windows distribution at this time.
Is there an alternative for people wanting a case insensitive collation?
---(end of broadcast)---
TIP 4: Have you
On Wed, 27 Feb 2008, Ray Stell wrote:
/usr/include/openssl/kssl.h:72:18: krb5.h: No such file or directory
Ah, the RHEL3 Kerberos mess. If you have further problems compiling
there's a heap of other paths you can pass through to sort around this
issue; the end of
(Sorry for asking so many questions!)
What techniques can one use to monitor the progress of a stored procedure?
Specifically, how can I get the procedure to print a progress indicator
message to the screen every once in a while?
I have a stored procedure that has been running for a very long
On Feb 27, 2008, at 5:25 PM, Kynn Jones wrote:
(Sorry for asking so many questions!)
What techniques can one use to monitor the progress of a stored
procedure?
Specifically, how can I get the procedure to print a progress
indicator message to the screen every once in a while?
I have a
Kynn Jones wrote:
I have a stored procedure that has been running for a very long time.
Before doing the current real run, I tested the procedure on a toy
case and confirmed that it produced the right result. So I know that
when it finishes it will be OK, but I can't tell whether it will
Just a reminder to everybody to come along to the PostgreSQL UK 2008
Conference in Birmingham, UK on April 2nd.
I've just had confirmation that the Early Bird Rate has been extended
until March 10th. There are some concessionary places available for
students also, so we want *everyone* there.
Hi,
On Wed, 2008-02-27 at 16:16 -0500, Ray Stell wrote:
/usr/include/openssl/kssl.h:72:18: krb5.h: No such file or directory
Add
--with-includes=/usr/kerberos/include --with-libraries=/usr/kerberos/lib
to your configure parameters. This is what we do while building
PostgreSQL RPMs on RHEL 3.
Kynn Jones wrote:
(Sorry for asking so many questions!)
What techniques can one use to monitor the progress of a stored
procedure?
Specifically, how can I get the procedure to print a progress
indicator message to the screen every once in a while?
[...](In case it matters, the procedure
IIRC, you cannot state runservice runservice -N . from commandline.
just try pg_ctl -D
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Younan
Sent: Wednesday, February 27, 2008 10:08 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Can't start
akshay bhat wrote:
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and
see the data inside.
Drag it into your text editor.
--
Postgresql php tutorials
http://www.designmagick.com/
---(end of
Hi,
This may seem like a very simple question...it is...but I can't find
documentation on it to help. I've seen some posts about lat/long but
none that give simple solutions on how to insert lat/long in tables.
I'm a new user to postgis...I've been using mysql for a while but
needed the spatial
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and see
the data inside.
i am working on windows xp and have installed the software successfully.
please help i am my wits end.
it is huge file 800mb
and is supposed to contain a
Gordon wrote:
(Sorry for the repost but I thought this would be appropriate to both
groups. I did tell Google to delete my first post but odds are some
guys got that copy already anyway)
After a lot of hairpulling, I finally found a mechanism in PHP for
doing what I wanted. I just had to know
On the postgres command prompt you can use /i filename ... try if it
works
Cheers
On Thu, Feb 28, 2008 at 9:07 AM, akshay bhat [EMAIL PROTECTED] wrote:
hello i am new to psql or any database stuff.
i have downloaded an .psql file from internet and wish to open it and see
the data
58 matches
Mail list logo