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
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
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?
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.
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
-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
Branch, and
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
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 code
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
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 weekend ...
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
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
found in it,
-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 mind it's
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
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?
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,
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
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
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
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
is NOT
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:
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
22 matches
Mail list logo