Re: [BUGS] PL/R Median Busts Commit (Postgres 9.1.6 + plr 8.3.0.13 on Ubuntu 12.10 64 bit)

2013-01-28 Thread Joe Conway
> Making use of this seems to fix the original bug - and possibly the > SIGINT stealing too. > > Patch attached to set the variable (R_SignalHandlers = 0), and remove > the SIGINT workaround. Cool -- thanks. Maybe that got added in a release since last I looked. Joe -- Joe

[BUGS] Spaces before newlines in view definitions in 9.3

2013-09-10 Thread Joe Abbate
t (breaking each column on a separate line) was done to improve readability but it has the side effect of making the text unreadable if processed via a YAML utility such as Pyrseas dbtoyaml (since YAML then quotes the entire string and even breaks it down further with extra backslashes). Regards,

Re: [BUGS] tablefunc extension

2013-09-22 Thread Joe Conway
the documentation: http://www.postgresql.org/docs/9.2/interactive/tablefunc.html If you still have a problem please provide SQL that can be cut and pasted which: 1) create your table 2) insert sample rows Then show us what out put you are trying to acheive as output from that data. Joe - --

Re: [BUGS] tablefunc extension

2013-09-22 Thread Joe Conway
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/22/2013 04:17 PM, Joe Conway wrote: > If you still have a problem please provide SQL that can be cut and > pasted which: 1) create your table 2) insert sample rows Then show > us what out put you are trying to acheive as output from th

[BUGS] Feature request - Information Schema enhancement

2013-10-11 Thread Joe Love
I know the Information Schema is a SQL standard, but it's somewhat lacking. I was trying to write a web page that showed a db table,it's columns and foreign keys. All went well and I was able to get this tool working great using the information_schema, problem is that some of the information_sche

[BUGS] BUG #5179: Installation fails

2009-11-11 Thread Joe Marshal Mathew
The following bug has been logged online: Bug reference: 5179 Logged by: Joe Marshal Mathew Email address: joemarshalmat...@gmail.com PostgreSQL version: 8.3 Operating system: Windows vista ultimate 64 bit Description:Installation fails Details: The installation

[BUGS] Fwd: plpgsql plan caching allowing invalid data to enter table?

2013-07-09 Thread Joe Van Dyk
It's looking like I can use a plpgsql function to insert data into a table that violates a domain constraint. Is this a known problem? Session 1: create domain my_domain text check (length(value) > 2); create table my_table (name my_domain); create function f(text) returns void as $$ declare my_

<    1   2