[Reply-To set to pgsql-general]
On Fri, Mar 25, 2005 at 11:11:19PM -0800, chamil wijenayake wrote:
> i want to find the last update time of a tuple(row) in the postgresql data
> base
You can set up a trigger to maintain a timestamp for the row. See
the example in the "Trigger Procedures" secti
Daniel Schuchardt <[EMAIL PROTECTED]> writes:
> there seem to be a bug in the 8.0 Rule System if I update a view and
> does not give a column an value.
You can't seriously expect that example to work. The DELETE removes the
row that lang_abzu() needs to have in order to yield a non-null result,
hi
i want to find the last update time of a tuple(row) in the postgresql data base
please be knid enough to reply me a solution if u know
thanking you in advance
chamil
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
Hi List,
there seem to be a bug in the 8.0 Rule System if I update a view and
does not give a column an value.
example
TEST=# \d abzu_ruletest
View "public.abzu_ruletest"
Column | Type| Modifiers
+---+---
abz_txt| character varyi
"Srinivasa Perumal" <[EMAIL PROTECTED]> writes
>
> hi, is there is way undelete or recover the deleted row in a table in
postgres.iam layman, can anyone help me.
>
Here is one way but I am not sure it is a good one. The precondition is that
you didn't schedule any vacuum on your database.
Since P
--On lördag, mars 26, 2005 17.40.01 -0800 Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Sun, 27 Mar 2005, Palle Girgensohn wrote:
--On lördag, mars 26, 2005 08.16.01 -0800 Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Sat, 26 Mar 2005, Palle Girgensohn wrote:
>> I've noticed a couple of things ab
On Sun, 27 Mar 2005, Palle Girgensohn wrote:
>
>
> --On lördag, mars 26, 2005 08.16.01 -0800 Stephan Szabo
> <[EMAIL PROTECTED]> wrote:
>
> > On Sat, 26 Mar 2005, Palle Girgensohn wrote:
> >> I've noticed a couple of things about using the ICU patch vs. pristine
> >> pg-8.0.1:
> >>
> >> - ORDER B
--On lördag, mars 26, 2005 13.59.19 +1100 John Hansen <[EMAIL PROTECTED]>
wrote:
- ORDER BY is case insensitive when using ICU. This might
break the SQL standard (?), but sure is nice :)
This would mean that indexes are also case insensitive right?
Which makes it a Bad Thing(tm).
Well, no, not r
--On lördag, mars 26, 2005 08.16.01 -0800 Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Sat, 26 Mar 2005, Palle Girgensohn wrote:
I've noticed a couple of things about using the ICU patch vs. pristine
pg-8.0.1:
- ORDER BY is case insensitive when using ICU. This might break the SQL
standard (?), b
Alvaro,
> On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:
> > SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min';
> > 2600 min
>
> Hmm, what if you wanted more than one literal string? Say "1 mon 3
> days" ... your concatenation idea wouldn't work. ISTM the format stri
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> ... ISTM the format string
> should allow unconverted literals, so you would use
> SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI min' );
... which to_char can do already, IIRC. The rewrite should define a new
set of format substitution codes, b
On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:
> SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min';
> 2600 min
Hmm, what if you wanted more than one literal string? Say "1 mon 3
days" ... your concatenation idea wouldn't work. ISTM the format string
should allow unc
This has my vote
Lorne
In <[EMAIL PROTECTED]>, on 03/26/05
at 02:04 PM, Josh Berkus said:
>Karel,
>> > Yeah. áKarel Zak, who wrote that code, is convinced we should remove it,
>> > but I don't think anyone else is ...
>>
>> áI think I was Peter and Josh Berkus who convinced me that t
Karel,
> > Yeah. ÂKarel Zak, who wrote that code, is convinced we should remove it,
> > but I don't think anyone else is ...
>
> ÂI think I was Peter and Josh Berkus who convinced me that the code is
> bed. "we should remove..." is opinion only...
I certainly didn't recommend removing it before w
On Sat, 26 Mar 2005, Tom Lane wrote:
Oleg Bartunov writes:
I'm looking for blocks *actually* read from disk, since IO is the most
important factor.
Well, you won't find that out from Postgres, since it has no idea
whether a read() request was satisfied from kernel disk cache or had
to actually go
Oleg Bartunov writes:
> I'm looking for blocks *actually* read from disk, since IO is the most
> important factor.
Well, you won't find that out from Postgres, since it has no idea
whether a read() request was satisfied from kernel disk cache or had
to actually go to disk.
You could turn on log
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Well, it seems at least to be running. When I fire up postmaster there
> are 4 processes running and no indication of failure that I could see on
> the log. (There is a complaint about failing to dup(0) after 3195
> successes - I assume that has nothi
Euler Taveira de Oliveira wrote:
> Hi Bruce,
>
> > Function and comments are just _strings_ to PostgreSQL, so we have no
> > good way of cleaning the output up, unless we hack pg_dump to somehow
> > change line endings when outputting such information, though
> > currently we
> > don't. The would
Jim,
that is just execllent! Thank you so much! I assume you mean XP-Pro - I
gather that user permissions get in the way on XP-HE.
We can make the one machine do double duty for Windows and Cygwin.
You will need installed:
. cygwin, including whatever it takes to build cygwin postgres
. native
On Sat, 26 Mar 2005, Palle Girgensohn wrote:
> I've noticed a couple of things about using the ICU patch vs. pristine
> pg-8.0.1:
>
> - ORDER BY is case insensitive when using ICU. This might break the SQL
> standard (?), but sure is nice :)
Err, I think if your system implements strcoll correctly
Andrew,
I can set one up a dedicated windows XP system on monday. I also have some w2k
systems that can be used.Are there
directions anywhere?
Jim
-- Original Message ---
From: Andrew Dunstan <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
Cc: PostgreSQL-development
Sen
Tom Lane wrote:
Dunno about the stats failure. It looks like the stats collector just
isn't working on Cygwin, but AFAIR no one has touched that code lately.
Well, it seems at least to be running. When I fire up postmaster there
are 4 processes running and no indication of failure that I coul
Hi there,
I'm investigating one performance issue with tsearch2 index and trying to
interperet io statiscs from pg_statio_user_tables, pg_stat_user_tables.
But from documentation it's not clear what numbers I shoud take into
account and I'm a bit confused :)
I'm looking for blocks *actually* read
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 25 Mar 2005, Tom Lane wrote:
Does "\d pg_trigger" show that the tgargs column is of type bytea?
Umm no:
tgnargs| smallint | not null
tgargs, not tgnargs.
Ooops, sorry. Ok, tgargs is of type bytea.
Also, get the OID for this pg_tr
24 matches
Mail list logo
