[BUGS] Re: Feature request: include script file into function body (better syntax)

2011-02-03 Thread Jasen Betts
On 2011-02-01, Steve White wrote: > Hi Tom, > > I already agreed to Kevin's proposed syntax, and it is better than > my suggestion, but mine isn't quite as crazy as you make out. > > On 1.02.11, Tom Lane wrote: >> Steve White writes: >> > Try this instead: >> >> > ==

Re: [BUGS] Feature request: include script file into function body

2011-02-03 Thread Jasen Betts
On 2011-02-02, Steve White wrote: > Hi, Robert, > > I made a file 'yadda_yadda.py' containing only the line: > print 'hello world' > > > d=# \set yadda `cat yadda_yadda.py` > d=# \echo :yadda > print 'hello world' >==

Re: [BUGS] Feature request: include script file into function body

2011-02-03 Thread Jasen Betts
On 2011-02-01, Steve White wrote: > Hi > > I asked on pgsql-general 31 Jan 2011 if there were a way to do this, and got > no response, so let's make it a feature request. > > It would be really nice to have a way to load script (especially Python > and Perl) from a separate file into a function bo

[BUGS] Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-11 Thread Jasen Betts
On 2010-06-10, Stefan Kaltenbrunner wrote: > Tom Lane wrote: >> Heikki Linnakangas writes: >>> On 10/06/10 16:21, Robert Haas wrote: I do agree that the human readability of pg_dump is an asset in many situations - I have often dumped out the DDL for particular objects just to look

[BUGS] Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-11 Thread Jasen Betts
On 2010-06-10, Robert Haas wrote: > On Thu, Jun 10, 2010 at 9:02 AM, Stefan Kaltenbrunner > wrote: >> I for myself would be rather annoyed if we started quoting all column names >> in our dumps. This is seriously hampering readability and while it is >> already annoying that pg_dump output is slig

Re: [BUGS] BUG #5476: sequence corruption

2010-05-28 Thread Jasen Betts
On 2010-05-27, Piergiorgio Buongiovanni wrote: > > The following bug has been logged online: > > Bug reference: 5476 > Logged by: Piergiorgio Buongiovanni > Email address: p.buongiova...@net-international.com > PostgreSQL version: 8.3.4 > Operating system: CentOS (Redhat 5.4)

[BUGS] Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation

2010-05-27 Thread Jasen Betts
On 2010-05-26, Daniele Varrazzo wrote: > [regexp_matches:] Return all groups of captured substrings resulting > from matching a POSIX regular expression against the string. Warning: > in case of no match, tested record is dropped. See Section 9.7.3 for > more information. possibly like this inst

[BUGS] Re: BUG #5457: dblink_connect now restricts non-superusers to password

2010-05-11 Thread Jasen Betts
On 2010-05-11, Chana Slutzkin wrote: > > The following bug has been logged online: > > Bug reference: 5457 > Logged by: Chana Slutzkin > Email address: ch...@cs.huji.ac.il > PostgreSQL version: 8.4 > Operating system: FreeBSD 7.2 > Description:dblink_connect now restri

[BUGS] Re: BUG #5448: psql \set does not terminate if variable is referenced recursively

2010-05-09 Thread Jasen Betts
On 2010-05-05, Tom Lane wrote: > The problem is there's no real support inside psql for "throwing an > error" --- we have to unwind all the state manually. In particular, > what this problem requires is backing out the stack of flex buffers > representing pending variable expansions. So I think

Re: [BUGS] Bug with Tsearch and tsvector

2010-05-01 Thread Jasen Betts
On 2010-04-29, Tom Lane wrote: > Jasen Betts writes: >> \ is popular in URIs on some platfroms, or is URI a different beast > > I hope not, because \ is explicitly disallowed by both the older and > newer versions of that RFC. I should have known better than to assume that Mic

Re: [BUGS] Bug with Tsearch and tsvector

2010-04-29 Thread Jasen Betts
On 2010-04-26, Kevin Grittner wrote: > Tom Lane wrote: > > From the RFC: > >| control = >| space = >| delims = "<" | ">" | "#" | "%" | <"> >| unwise = "{" | "}" | "|" | "\" | "^" | "[" | "]" | "`" > > Except, of course, that since % is the escape character, it is OK. >

Re: [BUGS] bugs that have not been replied-to on list

2010-04-11 Thread Jasen Betts
On 2010-04-10, Stefan Kaltenbrunner wrote: > Craig Ringer wrote: >> Dave Page wrote: >> >>> This basically indicates that we need an issue tracker. There, look - >>> now see what you made me do :-( >> >> Please?!? >> >> I wonder, if EDB just went ahead and set one up, would people start >> usin

Re: [BUGS] dividing money by money

2010-03-30 Thread Jasen Betts
On 2010-03-30, Kevin Grittner wrote: > Andy Balholm wrote: > >> The ability to divide money by money would be useful for finding >> what percent one money value is of another. > > That certainly sounds useful and natural to me. I don't think it > rises to the level of a *bug*, but it's a rea

Re: [BUGS] whole-row functional index?

2010-02-02 Thread Jasen Betts
On 2010-02-02, Tom Lane wrote: > Jasen Betts writes: >> jasen=# update member set id=id where id=441; >> UPDATE 1 >> jasen=# create index member_search on member using gin ( >> (get_search_text_internal(member)) ); >> CREATE INDEX >> jasen=# update member s

[BUGS] whole-row functional index?

2010-02-02 Thread Jasen Betts
jasen=# update member set id=id where id=441; UPDATE 1 jasen=# create index member_search on member using gin ( (get_search_text_internal(member)) ); CREATE INDEX jasen=# update member set id=id where id=441; ERROR: table row type and query-specified row type do not match DETAIL: Physical storag

[BUGS] Re: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints

2010-01-04 Thread Jasen Betts
On 2010-01-04, Ben Woosley wrote: > > The following bug has been logged online: > > Bug reference: 5258 > Logged by: Ben Woosley > Email address: ben.woos...@gmail.com > PostgreSQL version: 8.4.2 > Operating system: Mac OS 10.6 > Description:Unique and foreign key cons

[BUGS] BUG #4964: return value does not agree with documentation

2009-08-05 Thread jasen Betts
The following bug has been logged online: Bug reference: 4964 Logged by: jasen Betts Email address: ja...@xnet.co.nz PostgreSQL version: 8.3 Operating system: linux Description:return value does not agree with documentation Details: PQsendQuery() seems to return 0

[BUGS] Re: BUG #4916: wish: more statistical functions (median, percentiles etc)

2009-07-11 Thread Jasen Betts
On 2009-07-10, Richard Neill wrote: > > 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 (med

Re: [BUGS] BUG #4901: Column name "window" breaks pg_dump/pg_restore

2009-07-06 Thread Jasen Betts
On 2009-07-05, Steve Purcell wrote: > Thanks for the quick reply, Tom. That makes sense, and yes, that does > appear to be the problem. > > I thought that I *was* using the newer pg_dump, but I'm doing this on > Debian: > > # su - postgres -c "env PGCLUSTER=8.3/main pg_dump openx|env > PGCLU

[BUGS] Re: BUG #4791: NULL value in function causes reproducible segmentation fault

2009-05-05 Thread Jasen Betts
On 2009-05-05, Sikkerhed.org ApS wrote: > > The following bug has been logged online: > > Bug reference: 4791 > Logged by: Sikkerhed.org ApS > Email address: supp...@sikkerhed.org > PostgreSQL version: 8.3.7-0lenny1 > Operating system: Debian GNU/Linux 5.0.1 stable (fully upda

Re: [BUGS] Problème password

2009-04-29 Thread Jasen Betts
On 2009-04-28, Bertrand Yohan Breyton Sanial wrote: > --_81b99346-804a-46a1-86b8-0b19e1d6c356_ > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > Bonjour=2C lorsque je souhaite lancer le logiciel poker tracker une fen=EAt= > re s'affiche et me dema

[BUGS] BUG #4602: child processes inherit database socket

2009-01-06 Thread Jasen Betts
The following bug has been logged online: Bug reference: 4602 Logged by: Jasen Betts Email address: ja...@treshna.com PostgreSQL version: 8.3 Operating system: linux Description:child processes inherit database socket Details: libpq creates sockets to the server

[BUGS] BUG #4011: spelling mistake in comments

2008-03-05 Thread Jasen Betts
The following bug has been logged online: Bug reference: 4011 Logged by: Jasen Betts Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: WINDOWS xp Description:spelling mistake in comments Details: bin/psql.bat 11 s/exist/exits/ -- Sent via

[BUGS] BUG #4010: psql does not honour -c after database name

2008-03-05 Thread Jasen Betts
The following bug has been logged online: Bug reference: 4010 Logged by: Jasen Betts Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 (win32) Operating system: XP pro Description:psql does not honour -c after database name Details: I notice psql is now

[BUGS] BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

2007-06-22 Thread Jasen Betts
The following bug has been logged online: Bug reference: 3403 Logged by: Jasen Betts Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: window XP (vmware) Description:ver 8.2 can't add serial column to temp table,but 8.1 can De