Dear Magnus,
Thanks for your reply.
On 24/09/13 18:31, Magnus Hagander wrote:
The following bug has been logged on the website:
Bug reference: 8467
The documentation for pgcrypto:
http://www.postgresql.org/docs/current/static/pgcrypto.html
(and indeed all versions from 8.3-9.3)
contains
Note that doing anything more than RAISE NOTICE or equivalent would
imply a significant protocol change. You can't just shove a table out
to the client, because it'll think that that's the response to the outer
SELECT (or whatever) command that called your function. So while it'd
be kind of co
Sure it does. You can pass the tuple to RAISE NOTICE easily enough.
It won't have all the same bells and whistles psql would supply, but
it prints out well enough for debugging. Or at least it's never
bothered me.
Sorry if I'm being dense, but I can't see how you can pass a tuple; I
think r
Dear Pavel,
Thanks for your help.
Do you not think it would be really amazingly useful? After all, in C, the
single most useful debugging tool is "fprintf(stderr,...)", and yet
postgresql doesn't have an equivalent that can operate on the most common
data format. [I'm stretching the analogy a b
The following bug has been logged online:
Bug reference: 5867
Logged by: Richard Neill
Email address: postgre...@richardneill.org
PostgreSQL version: 9.03
Operating system: Linux
Description:wish: plpgsql print table for debug
Details:
When debugging a plpgsql
The following bug has been logged online:
Bug reference: 5867
Logged by: Richard Neill
Email address: postgre...@richardneill.org
PostgreSQL version: 9.03
Operating system: Linux
Description:wish: plpgsql print table for debug
Details:
When debugging a plpgsql
Kevin Grittner wrote:
"Richard Neill" wrote:
date_trunc('day', timestamp '2010-01-20 10:16:55')
What happens with a "timestamp with time zone" literal?
-Kevin
Good call!
This query is fast:
SELECT count(1) FROM tbl_tracker WHERE ((srep_t
The following bug has been logged online:
Bug reference: 5293
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.4.2
Operating system: Linux
Description:constant function (date_trunc) is repeatedly evaluated
inside loop
Details:
SUMMARY
Tom Lane wrote:
"Richard Neill" writes:
If subdirectories of base/ are actually symlinks, then postgresql deletes
just the symlink, not the directory.
Doing that is completely unsupported, and we cannot be expected to cope
with random manual modifications to the structure of th
The following bug has been logged online:
Bug reference: 5174
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.4.1
Operating system: Linux
Description:[minor] directories symlinked into base/ are not
recursively removed
Details:
This is
Dear Tom,
Thanks for this, and sorry for not replying earlier. We finally obtained
a window to deploy this patch on the real (rather busy!) production
system as of last Saturday evening.
The good news is that the patch has now been in place for 5 days, and,
despite some very high loading, it
Dear All,
I've just upgraded from 8.4.0 to 8.4.1 because of a segfault in 8.4, and
we've found that this is still happening repeatedly in 8.4.1. We're in a
bit of a bind, as this is a production system, and we get segfaults
every few hours.
[It's a testament to how good the postgres crash r
Dear Peter and Tom,
Thanks for your help. Sorry for posting an incorrect bug report. I hope
there are still a few useful parts...
Tom Lane wrote:
"Richard Neill" writes:
* Convert a timestamp into a number of seconds since
the epoch. This can be done in an ugly way using EXT
The following bug has been logged online:
Bug reference: 4972
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.3.7
Operating system: Linux
Description:RFE: convert timestamps to fractional seconds
Details:
Postgresql has a huge range of
10, 2009 at 11:37:46PM +, Richard Neill wrote:
In addition to the existing aggregate functions (avg, stddev etc), it would
be nice if postgres could return further information. For example, the
quartiles, percentiles, and median.
[mode would also be useful, as an explicit function, thoug
The following bug has been logged online:
Bug reference: 4916
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.4
Operating system: Linux
Description:wish: more statistical functions (median, percentiles
etc)
Details:
In addition to the
The following bug has been logged online:
Bug reference: 4909
Logged by: Richard Neill
Email address: rn...@cam.ac.uk
PostgreSQL version: 8.4
Operating system: Linux
Description:wish: easier way to configure RAM allocation
Details:
I've been using Postgres for
Dear Tom and Neil,
Thanks very much for your help, and your explanations. This makes a lot
of sense, and I agree - this bug is definitely invalid.
Best wishes
Richard
Tom Lane wrote:
"Richard Neill" <[EMAIL PROTECTED]> writes:
SELECT instrument,priceband,pounds FROM tbl_instru
The following bug has been logged online:
Bug reference: 1540
Logged by: Richard Neill
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.01
Operating system: Linux
Description:Enhancement request: 'ambiguous' column reference in
psql
Details:
Dear
Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
Description:Order by doesn't sort correctly.
It almost certainly is the correct sort order according to the locale
you're using. Use pg_controldata to check the database locale. You'll
probably want to re-initdb in C lo
.org/docs/7.3/static/charset.html#AEN21582
I did realise that the sort would be locale dependent, but failed to
realise it wasn't byte-at-a-time.
Best wishes
Richard
Tom Lane wrote:
Richard Neill <[EMAIL PROTECTED]> writes:
This ordering is perverse!
No kidding.
No matter what th
21 matches
Mail list logo
