The following bug has been logged online:
Bug reference: 2223
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: linux
Description:Misleading info in docs on volatility level of functions
Details:
Hi, all!
The documentation on how
The following bug has been logged online:
Bug reference: 2224
Logged by: Hervé Hénoch
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux FC4
Description:unlogical syntax error
Details:
I do this request :
select id_caisse as caisse
David Fetter wrote:
+ /* Disallow BADCHARS characters */
+ if (strcspn(cstate->delim, BADCHARS) != 1)
+ ereport(ERROR,
+ (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
+errmsg("COPY delimiter cannot be \"%#02x\"",
+
"Hervé Hénoch" <[EMAIL PROTECTED]> writes:
> CETLOG: statement: PREPARE AS SELECT adm_pat."nip", id_caisse
> caisse FROM adm_pat WHERE nip = '20020523'
> CETERROR: syntax error at or near "caisse" at character 33
"AS" before a column alias is not optional in Postgres.
Hi,
The symptom:
The PostgreSQL backend sometimes does not terminate a query. (Killed after
the backend consumed 1h30 of CPU time.)
That query usually executes in less than 2 seconds, see also the explain
analyze.
Version: 8.0.2
Query:
select cel.objid,
cel.shortname, ser.shortna
Hi,
This is a reposting of my email from win32 hackers list.
Original Issue:
http://archives.postgresql.org/pgsql-hackers-win32/2006-01/msg0.php
Below I have given the exact scenario which I can replicate in three
different systems. Anybody who has faced this kind of issue please let
me kno
Philipp Reisner <[EMAIL PROTECTED]> writes:
> Version: 8.0.2
I don't think so ... neither bitmap scans nor slot_getattr exist in 8.0.
> Is this bug-report of any use so far ?
Not a lot. You need to find out what the difference is between the
cases where the query runs quickly and those where it
On Mon, Jan 30, 2006 at 10:47:10AM +, Herv Hnoch wrote:
> CETLOG: statement: PREPARE AS SELECT adm_pat."nip", id_caisse
> caisse FROM adm_pat WHERE nip = '20020523'
>
> CETERROR: syntax error at or near "caisse" at character 33
Are you writing this query or is JDBC generating it? The AS
On Mon, Jan 30, 2006 at 08:21:34AM -0500, Andrew Dunstan wrote:
>
>
> David Fetter wrote:
>
> >
> >+/* Disallow BADCHARS characters */
> >+if (strcspn(cstate->delim, BADCHARS) != 1)
> >+ereport(ERROR,
> >+(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
>
On Sat, 2006-01-28 at 20:17 +0100, Peter Eisentraut wrote:
> This bug was reported to Debian. Comments?
AFAICS I fixed this a few weeks ago (post-8.1.2):
http://archives.postgresql.org/pgsql-committers/2006-01/msg00209.php
http://archives.postgresql.org/pgsql-patches/2006-01/msg00139.php
I get
This was recently discussed on -docs and I believe a patch was applied
to at least HEAD.
On Mon, Jan 30, 2006 at 10:33:35AM +, [EMAIL PROTECTED] wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2223
> Logged by:
> Email address: [EMAIL PROTECTED]
>
Neil Conway <[EMAIL PROTECTED]> writes:
> On Sat, 2006-01-28 at 20:17 +0100, Peter Eisentraut wrote:
>> This bug was reported to Debian. Comments?
> AFAICS I fixed this a few weeks ago (post-8.1.2):
You only fixed the bind-parameter case, though, no? The problem is
still rampant in the PLs.
On Mon, 2006-01-30 at 20:45 -0500, Tom Lane wrote:
> You only fixed the bind-parameter case, though, no? The problem is
> still rampant in the PLs.
Right: the bug report was specific to the bind parameter case. Domain
constraints should also be checked before returning values of a domain
type fro
13 matches
Mail list logo
