Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> On this page:
> http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html
> It has this sequence:
> root# mkdir /usr/local/pgsql/data
> root# chown postgres /usr/local/pgsql/data
> root# su postgres
> postgres$ initdb -D /usr/local/
Useful if it's going to support earlier releases of ICU
Not all os's come with ICU3.2, debian for example, currently has 2.1 in
testing, and 2.6 in unstable.
... John
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Palle Girgensohn
> Sent:
On Fri, Mar 25, 2005 at 12:30:46PM +0800, Christopher Kings-Lynne wrote:
> root# mkdir /usr/local/pgsql/data
> root# chown postgres /usr/local/pgsql/data
> root# su postgres
> postgres$ initdb -D /usr/local/pgsql/data
>
> However, initdb will fail in this case, since the /usr/local/pgsql dir
> i
Sorry, on further investigation this seems to work for everyone except
that guy - weird.
Chris
Christopher Kings-Lynne wrote:
On this page:
http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html
It has this sequence:
root# mkdir /usr/local/pgsql/data
root# chown postgres /usr/local/
On this page:
http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html
It has this sequence:
root# mkdir /usr/local/pgsql/data
root# chown postgres /usr/local/pgsql/data
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data
However, initdb will fail in this case, since the /usr/lo
Hello there,
I have a View with a Delete rule and I would like the Delete rule to call a
function (and pass-in a few of the the underlying View's/Table's column
values). How do you do this?
When I do it, I keep getting the following error:
ERROR: function expression in FROM may not refer to ot
On Thu, 24 Mar 2005, Dave Page wrote:
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
Sent: 24 March 2005 18:37
To: Dave Page
Cc: Marc G. Fournier; pgsql-hackers@postgresql.org
Subject: RE: [HACKERS] Upcoming 8.0.2 Release
On Thu, 24 Mar 2005, Dave Page wrote:
Not me, b
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> I have three pending kerberos patches, two of which are plain bugfixes
> and one which I'd argue is a bugfix around a can't-compile issue, that
> I'd very much like to see in 8.0.2.
Working on these. Don't you have the test backwards here?
Hi!
I've put together a patch for using IBM's ICU package for collation.
If your OS does not have full support for collation ur uppercase/lowercase
in multibyte locales, this might be useful. If you are using a multibyte
character encoding in your database and want collation, i.e. order by, and
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]
> Sent: 24 March 2005 18:37
> To: Dave Page
> Cc: Marc G. Fournier; pgsql-hackers@postgresql.org
> Subject: RE: [HACKERS] Upcoming 8.0.2 Release
>
> On Thu, 24 Mar 2005, Dave Page wrote:
>
> > Not me, but bear in
Magnus Hagander wrote:
> > Now that Tom has gotten the ARC->2Q changes into the 8.0.x Branch, and
>
> >Josh has had some time to do some preliminary performance
> >testing on it,
> >we need to put out 8.0.2 ...
> >
> >Core's hope is to wrap a beta up on Friday (tomorrow), and
> >baring any bugs
> Now that Tom has gotten the ARC->2Q changes into the 8.0.x Branch, and
>Josh has had some time to do some preliminary performance
>testing on it,
>we need to put out 8.0.2 ...
>
>Core's hope is to wrap a beta up on Friday (tomorrow), and
>baring any bugs
>found in it, do a full release next
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Thu, 24 Mar 2005, Dave Page wrote:
>> Not me, but bear in mind it's the Easter holidays, so I for one cannot
>> guarantee I'll be able to package a windows installer for at least a few
>> days.
> That's okay, we're only packaging a beta this we
On Thu, 24 Mar 2005, Dave Page wrote:
Not me, but bear in mind it's the Easter holidays, so I for one cannot
guarantee I'll be able to package a windows installer for at least a few
days.
That's okay, we're only packaging a beta this weekend ...
Marc G. Fournier Hub.Org Networking
Michael Fuhr wrote:
> On Thu, Mar 24, 2005 at 12:35:14PM -0400, Marc G. Fournier wrote:
> >
> > Is anyone sitting on anything that they feel needs/should get into 8.0.2?
>
> Has anybody had a chance to review the PL/Python patch I submitted?
> I did the diff against HEAD but I think its PL/Python
On Thu, Mar 24, 2005 at 12:35:14PM -0400, Marc G. Fournier wrote:
>
> Is anyone sitting on anything that they feel needs/should get into 8.0.2?
Has anybody had a chance to review the PL/Python patch I submitted?
I did the diff against HEAD but I think its PL/Python code is
identical to REL8_0_STA
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marc
> G. Fournier
> Sent: 24 March 2005 16:35
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Upcoming 8.0.2 Release
>
>
> Now that Tom has gotten the ARC->2Q changes into the 8.0.x
> Br
Hello there,
What's the preferred and most efficient way to obtain PGCrypto encrypted
data from a plpgsql function?
1. Imagine the following simple table:
CREATE TABLE crypto (
pid SERIAL PRIMARY KEY,
title VARCHAR(50),
crypted_content BYTEA
);
2. Now insert the following 3
Now that Tom has gotten the ARC->2Q changes into the 8.0.x Branch, and
Josh has had some time to do some preliminary performance testing on it,
we need to put out 8.0.2 ...
Core's hope is to wrap a beta up on Friday (tomorrow), and baring any bugs
found in it, do a full release next Thursday.
Title: RE: [HACKERS] RFC: built-in historical query time profiling
> I see your point. The ugliness of log-parsing beckons.
>
Maybe it would make sense to use a separate log server machine, where they could be written to a database without impacting production?
Oleg Bartunov wrote:
oh, no. I need 2 numbers only :) What's \timing in psql does ?
Or it's just a wrapper to system 'time' ?
It computes wall-clock time via gettimeofday(), and is entirely
implemented on the client-side.
-Neil
---(end of broadcast)
hi, is there is way undelete or recover the deleted row in a table in
postgres.iam layman, can anyone help me.
with regards
csperumal
__
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.ne
22 matches
Mail list logo
