The following bug has been logged online:
Bug reference: 5647
Logged by: David Sahagian
Email address: david.sahag...@gmail.com
PostgreSQL version: 9.0 beta4
Operating system: win XP
Description:COPY TO does not respect the
[standard_conforming_strings] setting
documentation indicated that the path to the shared library had to be
declared because I don't remember any example showing $library.
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: Tuesday, September 07, 2010 10:30 PM
To: Tom Lane
Cc: David Platt; pgsql
.
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: Tuesday, September 07, 2010 9:54 PM
To: David Platt
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries
for language handlers
David Platt wrote:
>
> The following b
with 140,000,000 rows.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, September 07, 2010 11:17 PM
To: David Platt
Cc: 'Bruce Momjian'; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries
for language handlers
d.
> >
> Thanks, I will do that. However, I cannot call myself a hacker, I
> am but a mere beginner with Postgres.
You're a hacker when you start hacking :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfet
The following bug has been logged online:
Bug reference: 5673
Logged by: David Schmitt
Email address: da...@dasz.at
PostgreSQL version: 8.4.4
Operating system: Windows 7
Description:Optimizer creates strange execution plan leading to
wrong results
Details
On 9/23/2010 5:33 PM, Tom Lane wrote:
"David Schmitt" writes:
Description:Optimizer creates strange execution plan leading to
wrong results
Please supply a self-contained example demonstrating the incorrect results.
The information you've provided is completely
On 9/23/2010 9:53 PM, Tom Lane wrote:
David Schmitt writes:
Executing the attached example.sql on a fresh database demonstrates the
problem I'm seeing:
Found it. If you need a patch right away, it's a one-liner:
diff --git a/src/backend/optimizer/path/allpaths.c
b/src/backend
6.32-24-generic #43-Ubuntu SMP Thu Sep 16 14:58:24 UTC
2010 x86_64 GNU/Linux
Two cores
This appears to be a regression; it doesn't occur with ecpg (PostgreSQL
8.3.8) 4.4.1
Regards,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On 14/10/10 12:14, Itagaki Takahiro wrote:
Which solution is better? Or, another idea?
This does seem to be an new bug in previously working code. While any
solution that fixes the problem is good, it might pay to look the code
that worked before. As reported, it worked for ecpg (Postgr
ress
Date: Thu, 14 Oct 2010 10:44:50 +0900
From: Itagaki Takahiro
To: David Newall, PostgreSQL Hackers
CC: pgsql-bugs@postgresql.org
On Mon, Oct 11, 2010 at 7:42 AM, David Newall
wrote:
Trivial program to demonstrate problem:
main() {
ECPGdebug(1,stderr);
exec sql
The following bug has been logged online:
Bug reference: 5754
Logged by: David Fetter
Email address: da...@fetter.org
PostgreSQL version: 8.4+
Operating system: All
Description:CTE optimization fails to account for side effects
Details:
Here's how to repr
On Mon, Nov 15, 2010 at 06:55:47PM -0500, Tom Lane wrote:
> "David Fetter" writes:
> > CREATE SEQUENCE my_seq;
> > WITH t AS (SELECT nextval('my_seq')) VALUES(1);
> > SELECT currval('my_seq');
>
> > ERROR: currval of sequence &
The following bug has been logged online:
Bug reference: 5836
Logged by: David Pinheiro
Email address: davidsantospinhe...@gmail.com
PostgreSQL version: 8.4
Operating system: Centos
Description:Enum Support Functions don't work on empty tables
Details:
some kind of plans to build major version
upgrades into your development process, as end-of-life is a fact of
life in this as in every other software or system.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
The following bug has been logged online:
Bug reference: 5869
Logged by: David Schmitt
Email address: da...@dasz.at
PostgreSQL version: 8.4.5
Operating system: Windows 7
Description:postgresql corrupts unquoted non-ascii chars in column
aliases
Details:
Example
On 03.03.2011 16:08, Robert Haas wrote:
On Tue, Feb 8, 2011 at 2:19 AM, David Schmitt wrote:
Example query:
SELECT column as zurück FROM table;
results in corruption of the "ü" (umlaut u). This causes Npgsql to fail to
match up the columns in the result set (see
http://pgf
at :)
> but the second case seems seriously annoying, since there's no way
> for someone to write a CTE-containing rule action without risking a
> conflict. Ideas anybody?
Is there some way to throw "not implemented" there, too? It seems to
me that making accommodations for
The following bug has been logged online:
Bug reference: 6067
Logged by: David Fetter
Email address: dfet...@vmware.com
PostgreSQL version: 9.0.4
Operating system: Linux
Description:In PL/pgsql, EXISTS(SELECT ... INTO...) fails
Details:
Here's some example
Hola,
estoy desesperado, no consigo levantar postgresql en Opensuse, me sale el
siguiente error al intentar levantar el servicio:
psql: no se pudo conectar con el servidor: No exite el fichero o el
directorio ¿Está el servidor en ejecución localmente y aceptando conexiones
en el socket de dominio
o much for copying from a separate file.
>
> The attached patch seems like an appropriate fix. However, I'm
> unsure whether to apply it to released branches ... does anyone
> think this might break somebody's application?
No.
Cheers,
David.
--
David Fetter http://fe
The following bug has been logged online:
Bug reference: 6094
Logged by: David Hartveld
Email address: david.hartv...@mendix.com
PostgreSQL version: 9.1-beta2
Operating system: Debian GNU/Linux 6.0.2 "Squeeze"
Description:Streaming replication does not cat
The following bug has been logged online:
Bug reference: 6131
Logged by: David Johnston
Email address: pol...@yahoo.com
PostgreSQL version: 9.0.4
Operating system: Windows 7 64-bit
Description:Query Returning Incorrect Results
Details:
The embedded script exhibits
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, July 26, 2011 7:42 PM
To: David Johnston
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6131: Query Returning Incorrect Results
"David Johnston" writes:
> The embedded script exhibits
ke
precedence
configure: WARNING: ## ##
configure: WARNING: ## Report this to pgsql-bugs@postgresql.org ##
configure: WARNING: ## ##
checking for ossp/uuid.h... yes
checking whether byte ordering is bigendian... u
The following bug has been logged online:
Bug reference: 6292
Logged by: David Pinheiro
Email address: davidsantospinhe...@gmail.com
PostgreSQL version: 8.4
Operating system: Linux
Description:java.sql.PreparedStatement.setNull() throws
PSQLException
Details:
I&#
h, so please to report bugs in that
language, enlisting help wherever you need to in order to do so.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/i
me up sooner is because most Windows users either use the
'official' binaries rather than compiling from source, or link against the
dynamic runtime.
Is this something I could expect to be fixed in the near future, or is it
enough of an edge case that I should come up with some solutio
Upgrade to 9.1.3 and let us know whether that fixes the problem.
Cheers,
David.
On Wed, May 02, 2012 at 09:58:16PM -0700, leo xu wrote:
> pg version is 9.1.2
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/select-table-indicate-missing-chunk-num
Thanks guys for your prompt support!
I'm going to update Olson library on the concerned computer using the latest
files.
Thanks again.
David Chuet
Odotech inc.
-Original Message-
From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com]
Sent: May-14-12 11:51 AM
To:
On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote:
> On Mon, Jun 11, 2012 at 5:14 PM, wrote:
> > The following bug has been logged on the website:
> >
> > Bug reference: 6687
> > Logged by: David Fetter
> > Email address: da...@
On Mon, Jun 11, 2012 at 06:04:22PM +0200, Magnus Hagander wrote:
> On Mon, Jun 11, 2012 at 6:01 PM, David Fetter wrote:
> > On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote:
> >> On Mon, Jun 11, 2012 at 5:14 PM, wrote:
> >> > The following bug
On Mon, Jun 11, 2012 at 06:21:43PM +0200, Magnus Hagander wrote:
> On Mon, Jun 11, 2012 at 6:14 PM, David Fetter wrote:
> > On Mon, Jun 11, 2012 at 06:04:22PM +0200, Magnus Hagander wrote:
> >> On Mon, Jun 11, 2012 at 6:01 PM, David Fetter wrote:
> >> > On Mon, Ju
The following bug has been logged on the website:
Bug reference: 7596
Logged by: David PEYRIERES
Email address: david.peyrie...@meteo.fr
PostgreSQL version: 9.1.4
Operating system: Red Hat
Description:
Hello.
I found a little bug in /etc/init.d/postgresql-9.x file
? That would seem to be the area of greatest
concern - particularly around the usage of truncate/delete/drop.
Thought: would there be some way to flag a table like this to always require
the use of a schema prefix to be accessed (since right now truncated names only
have to be schema unique) in
;
Not A Bug.
When you add an "Order By" the resultant window FRAME is from the first record
(of the partition) up-to-and-including the current record (of the partition);
no "future" records (in the partition) are part of the window FRAME. Thus for
"last_va
only the
offending code and whatever is minimally necessary to make it execute.
Unless the example provided is self-contained simply putting out the entire
code without any commentary makes it more difficult for people to provide
help.
David J.
--
View this message in context:
http://
*uint16* idsubst)
+matchIdSubst(LexemeInfo *stored, *uint32* idsubst)
{
bool res = true;
Kind regards.
David
On Mon, Jan 7, 2013 at 1:41 AM, Tom Lane wrote:
> dav...@gmail.com writes:
> > [ thesaurus dictionary fails for more than 64K entries ]
>
> I see a whole bunch of uses of &q
The following bug has been logged on the website:
Bug reference: 7885
Logged by: David Thomas
Email address: david.tho...@enterprisedb.com
PostgreSQL version: 9.2.3
Operating system: CentOS 6.3
Description:
It seems that if the postmaster encounters a PANIC condition
postmaster will still shut down normally and thus release the
> shmem segment.)
>
Yup, if I attempt to start the cluster normally, it cleans up after
itself, so this is specific to --single mode.
--
David Thomas
System Engineer
EnterpriseDB - The Enterprise PostgreSQL Company
--
Sent via
d and basically the index is only acting as a table surrogate as
opposed to an index. If you really want to anchor the start you should
index and search on the reverse of the string so you can write it as a
postfix wildcard. The other option to index words via the full-text search
capabilities
/why they can be omitted in the examples as well as
in the text - is an idea worth considering.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8211-Syntax-error-when-creating-index-on-expression-tp5758030p5758040.html
Sent from the PostgreSQL - bug
many use-cases only the single-match mode is desired.
Are there any other functions that have this same risk profile that would
increase the applicability of such a patch?
David J.
e of PostgreSQL
than the one you start manually.
I am not that strong a linux user but it does seem you need to provide
considerably more detail as to your install/configuration if you expect help
resolving your issue. Specifically, HOW did you install PostgreSQL and what
configuration steps have you p
f what you need to have
done. Recursion (iteration) allows you to more easily handle/walk
hierarchical data but said hierarchy remains static for the duration of the
query.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/with-recursive-ignores-side-e
having the correct
> updated values.
> We are using default isolation level (Read Committed)
PostgreSQL 8.1 has been unsupported since 2010. Once you've upgraded
to a supported version, if the problem persists, we may be able to
help.
Cheers,
David.
--
David Fetter http://fetter.org/
A much more simple example courtesy of Chris Travers from the original
-general thread that I suggested be moved to -bugs.
> Here is a minimal query that demonstrates the problem. In 9.1 it works:
>
> chris=# select * FROM current_user u join (current_user u cross join
> current_user v) x on tr
Tom Lane-2 wrote
> David Johnston <
> polobo@
> > writes:
>>> Here is a minimal query that demonstrates the problem. In 9.1 it works:
>>>
>>> chris=# select * FROM current_user u join (current_user u cross join
>>> current_user v) x on true;
David Fetter fetter.org> writes:
>
> Upgrade to 9.1.3 and let us know whether that fixes the problem.
I've run into this issue as well on postgres 8.4.14. Aside from upgrading to a
newer release is there any manual fixup that can be done ?
Thanks,
David
--
Sent via pgsq
es, containing 4633 live
rows and 0 dead rows; 4633 rows in sample, 4633 estimated total rows
INFO: analyzing "information_schema.sql_features"
INFO: "sql_features": scanned 7 of 7 pages, containing 649 live rows
and 0 dead rows; 649 rows in sample, 649 estimated total rows
ERRO
On Thu, Sep 26, 2013 at 4:19 PM, David Rennalls wrote:
> On Thu, Sep 26, 2013 at 3:40 PM, Kim Applegate wrote:
>> I have seen this issue on a slave although it was in version 9.2. I ran
>
> oh ok. Looks like the issue was fixed in 8.2.23 according to these
>
hese cases it is the current value of a column that is needed.
So "SELECT" is read as being a top-level (as are UPDATE and DELETE) - and as
Stephen said because WHERE can be part of UPDATE and DELETE the additional
comment is made that WHERE in those contexts require "SELECT-like&quo
The following bug has been logged on the website:
Bug reference: 8518
Logged by: david
Email address: david.ku...@vsoftcorp.com
PostgreSQL version: 9.3.1
Operating system: Windows 7
Description:
Hi All,
I had tried using FreeBSD disk encryption but unable to find
ot actually been defined, you'd get an error such as:
ERROR: operator not defined: name[] <> name[]
Thanks,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
at. Is it something that could be backported, or is it not worth it?
Thanks,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ust need Apple's uuid.h. This is a known issue for OSSP UUID:
http://cvs.ossp.org/tktview?tn=164
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Apr 17, 2009, at 7:08 AM, Tom Lane wrote:
"David E. Wheeler" writes:
I'm building 8.4beta1 on Mac OS X 10.5.6. I have ossp-uuid installed
with its includes in /usr/local/include/ossp-uuid.
Well, then you would need --with-includes=/usr/local/include/ossp-uuid
(don&#
On Apr 17, 2009, at 10:21 AM, David E. Wheeler wrote:
On Apr 17, 2009, at 9:22 AM, David E. Wheeler wrote:
So does it not know to look in /usr/local/include/ossp-uuid when
it's looking for uuid.h?
Tried a few more things. No matter where I put uuid.h, configure
doesn't seem to
On Apr 17, 2009, at 10:47 AM, David E. Wheeler wrote:
On Apr 17, 2009, at 10:21 AM, David E. Wheeler wrote:
On Apr 17, 2009, at 9:22 AM, David E. Wheeler wrote:
So does it not know to look in /usr/local/include/ossp-uuid when
it's looking for uuid.h?
Tried a few more things. No m
On Apr 17, 2009, at 11:08 AM, Tom Lane wrote:
"David E. Wheeler" writes:
I take that back. It can find it in the ossp subdirectiry, as
RhodiumToad said, but it can't compile it:
checking ossp/uuid.h usability... no
checking ossp/uuid.h presence... yes
configure: WARNI
was here
Oh, that old canard. So it's just http://cvs.ossp.org/tktview?tn=164
again.
Thanks,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Found in 8.4.2, replicated in HEAD. Steps:
1. Create PL/Perl function.
2. Run it.
3. Create same function with PL/PerlU
4. Run it.
5. Create same function again with PL/Perl
6. Boom.
Example on HEAD built today (ignore the error from the plperl version, that's
the issue I'm trying to fix locally
the short run, you can downgrade to Safe.pm 2.19 and the problem will go
away. Or just use PL/Perlu, which doesn't rely on Safe.pm.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
able way to fix Safe such that PostgreSQL would work without
> changes.
Hrm. I don't have this bug with Safe 3.19, FWIW.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
time the C code looks up the utf8::SWASHNEW method without a problem.
Oh, so 2.19 is less secure in that regard, yes?
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
7;s the understatement of the month. What you're saying, IIUC, is
> that if function A calls function B via a SPI command, and B wasn't
> executed previously in the current session, it would fail? Seems
> entirely unacceptable.
Exactly what I was thinking. This "fix" is
you said :) ). Ill see if I can figure something out via straight
> Safe tonight.
I think Tom meant, what sorts of changes to PostgreSQL do you think might solve
the problem?
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
okay tradeoff to get recursive calls working again,
but I certainly hope that Safe can be updated in the near future to give us
both.
There seem to be no good answers here.
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
cant speed boost.
That solves the problem with recursion or with $a and $b or both?
I'm happy to rebuild Perl without threads, since I'm not going to use Padre
after all. But that won't help the millions who rely on package-supplied Perls,
which are nearly always threaded AFAICT.
y adding the extra security when *not* under threads as well?
I find this all very confusing, frankly.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
okay tradeoff to get recursive calls working again,
but I certainly hope that Safe can be updated in the near future to give us
both.
There seem to be no good answers here.
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
#x27; and statecode = 'FL';
>
> However this does work
>
> Select citystateinfoid from iss.citystateinfo where cityname =
> 'Jacksonville' and statecode = 'FL'
>
> The second query is how the data is actually stored. I've already forwarded
> our
an actually doing what Michael would like.
Yes, I suspect that he can solve his problem by adding the iss schema to
search_path.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
27;s more consistent
about the use of reserved words.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
POSTGRESQL BUG REPORT TEMPLATE
Your name : David Jack Olrik
Your email address : [EMAIL PROTECTED
Postgres version: 8.0.6
Operating system: Ubuntu GNU/Linux
I executed the following query while trying to build some date-conversion
functions for data that was represented as milliseconds since the Unix epoch:
davidl=# SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J MS');
to_ch
e DOS PATH
doesn't include "C:\Program Files\Java\jdk1.6.0_02\jre\bin\client" or
similar.
I've got the 1.3.0 pljava code into NetBeans IDE and will see if I can find
where these messages arise.
Regards
David
-Original Message-
From: Dave Page [mailto:[EMAIL PRO
It doesn't seem to have been installed:
david=# select uuid_generate_v1();
ERROR: function uuid_generate_v1() does not exist
LINE 1: select uuid_generate_v1();
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.
david=#
On Jan 28, 2008, at 10:08, Tom Lane wrote:
david=# select uuid_generate_v1();
ERROR: function uuid_generate_v1() does not exist
Did you run the module's SQL script?
It was not put into /usr/local/pgsql/share/contrib. Neither of these
had any output:
trigger% ll /usr/local/pgsql/
ostgres
trigger% psql
Welcome to psql 8.3RC2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
david=# select uuid_generate_v1()
uce that the MSVCR80.dll needs to be distributed in the
PostreSQL distribution for Windows.
As part of my investigation I wrote a small Java program that a potential
plJava user can run if they hit problems. It will give them some clues as
to what to look for ! See attached.
Regards
David Gra
ation file:
hostall192.168.1.2255.255.255.128password
host all 127.0.0.1 0.0.0.0identsameuser
Now the connection worked without problems. In the first case, it seems
to be trying to use IDENT authentification, even though that should only
apply to localho
seems strange to me that it works this way. Basically, if
mask is something other than 255.255.255.255, you might as well put 0's in
your id address. This doesnt seem to be how subnet masks normally work and
it seems redundant to me.
Is there something I don't understand?
Tha
~* should just be the inverse of ~*, but this does
not seem to be the case.
David
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
This would
solve the problem, but it would be nice to update the OIDs somehow.
3) Upon creating a view with a certain name, make all views that depend
on it point to it with the correct OID.
David Kaplan
---(end of broadcast)---
TIP 4: Don&#x
is at
http://www.roaringpenguin.com/segfault.tar.bz2
Unfortunately, I was not able to come up with a short bit of code
which duplicates the problem, hence the tarball. Sorry!
Regards,
David.
Roaring Penguin Software Inc. | http://www.roaringpenguin.com
GPG fingerprint: C523 771C 3710 0F54 B2D2
Hello,
My apologies if this is not a bug or has already been resolved. I have
searched fairly extensively for this particular problem and haven't
found anything yet.
I have been having problems with psql under linux lately and this problem has followed me from
7.4.4 - 7.4.6, but it started some
The following bug has been logged online:
Bug reference: 2115
Logged by: David S. Edwards
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Red Hat Enterprise Linux AS release 4 Kernel 2.6.9-22
Description:If we CLOSE a Closed Cursor
(I don't think it's practical to get the HINT to
> read "Put the ORDER BY at the end" ;-)) but at least it should
> get people pointed in the right direction when they do this.
It confuses the shit out of me. It says "string_agg(text)" doesn't exist when
> What function name do you believe was called?
The message says:
string_agg(f1 order by f1, ',')
That looks like string_agg(text, text) or string_agg(anyelement, text).
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
> Well, maybe we need to expend some more sweat on the error message then.
> But this patch was still a prerequisite thing, because without it there
> is no error that we can complain about.
Yeah, understood.
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Aug 5, 2010, at 12:16 PM, Tom Lane wrote:
> HINT: No aggregate function matches the given name and argument
> types. Perhaps you misplaced ORDER BY; ORDER BY must appear after all
> regular arguments of the aggregate.
+1
David
--
Sent via pgsql-bugs mailing list (p
The following bug has been logged online:
Bug reference: 5616
Logged by: David E. Wheeler
Email address: da...@kineticode.com
PostgreSQL version: 8.4
Operating system: Mac OS X 10.6.4
Description:psql Doesn't Change Log files on \c
Details:
I have this
|19 |
readline_echoing_p
[866] |22165210|0010|OBJT |GLOB |0|19 |
rl_readline_name
On Aug 27, 2010, at 9:38 PM, Tom Lane wrote:
"David Kensiski" writes:
The psql binary (64-bit from binary install) dumps core when I
attempt to
edit the input line after a few
The following bug has been logged online:
Bug reference: 5775
Logged by: David Quinn-Jacobs
Email address: d...@ecornell.com
PostgreSQL version: 9.0.1
Operating system: Cent OS 5
Description:DBLINK Connection String Truncation
Details:
Causes connection failure
The following bug has been logged online:
Bug reference: 5846
Logged by: David E. Wheeler
Email address: da...@kineticode.com
PostgreSQL version: 9.0.1
Operating system: Mac OS X 10.6.6
Description:Segfault Postgresql Built with --lib-libedit-preferred
Details
st noticed it quite some time
ago. Anyone got a test case that doesn't involve building PostgreSQL?
Thanks,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following bug has been logged online:
Bug reference: 6003
Logged by: David carlos Manuelda
Email address: stormb...@gmail.com
PostgreSQL version: 9.0.3
Operating system: Gentoo Linux
Description:Cannot have a constraint foreign key on master class
with
The following bug has been logged online:
Bug reference: 6113
Logged by: David Carlos Manuelda
Email address: stormb...@gmail.com
PostgreSQL version: 9.0.4
Operating system: Gentoo Linux
Description:SET DATESTYLE='European' does not set datestyle output
The following bug has been logged on the website:
Bug reference: 8228
Logged by: David Johnston
Email address: david.g.johns...@gmail.com
PostgreSQL version: 9.0.13
Operating system: Ubuntu Linux 10.04
Description:
The following query results in "SQL Error:
201 - 300 of 303 matches
Mail list logo
