can you share the PostgreSQL version you are using
PG8.3.1
maybe you are facing some sort of corruption?
I do not know. All other works fine except that.
- Original Message -
From: "Hans-Juergen Schoenig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 26, 200
select ats.id, ap.value from akh_test_suit ats
LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
where ats.ID = 472
id | value
472 | 472
ID -- integer
value -- text
select * from akh_test_suit ats
LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
where ats.ID = 472 and ap.v
Is there guide to compile PG?
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Pavel Stehule" <[EMAIL PROTECTED]>; "Peter Eisentraut"
<[EMAIL PROTECTED]>; ; "Euler Taveira de Oliveira"
<[EMAIL PROTECTED]>
Sent: Sunday, August 24, 2008 8:06
Yes, I am ActivePerl and Win32 Binary PG
Is it scheduled to fix?
- Original Message -
From: "Pavel Stehule" <[EMAIL PROTECTED]>
To: "Peter Eisentraut" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>; "Euler Taveira de
Oliveira" <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2008 12:20 PM
1. Install Perl v5.10
2. Install PG
3. PG does not see that machine has Perl
4. Remove Perl and PG
5. Instll Perl v5.8
6. Install PG
7. PG work fine
Problem is that PG does not recognize Perl v5.10 =(
- Original Message -
From: "Euler Taveira de Oliveira" <[EMAIL PROTECTED]>
To: <[EMAIL
Bug in that, that I install PG on server with perl 5.10 installed, but PG
fails to run any PLPERL code
How to fix?
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To:
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2008 2:55 PM
Subject: Re: [BUGS] Postgresql v8.3.
Is this possible?
_
Eugen
ERROR: syntax error at or near "and" at character 307
Actually error is at character 618
-
/*
DELETE FROM akh_test_suit_detail
WHERE ID in (
select atsd.id as id1
from akh_test_suit_detail atsd
left join akh_test_suit ats on ats.ID =
DECLARE
varUnlocked boolean;
BEGIN
varUnlocked:= pg_try_advisory_lock( 783264760123456 ); -- Try to lock function
IF not varUnlocked THEN return NULL; END IF; -- exit if locking is unsucessfull
WRONG QUERY HERE WHICH INTERRUPT EXECUTION
varUnlocked:= pg_advisory_unlock( 783264760123456 ); -- un
ACTUAL:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf atc
left join akh_test_suit ats on ats.id = atc.test_suit_id) tc1
left join (select atc.id, ats.test_suit_type_id from akh_testing_conf atc left
join akh_test_suit ats on ats.id = atc.test_suit_id) tc2 on
tc2.test_
Is any where guide how to build on Win32, which compiler to use etc?
Or may PostgreSQL team build binaries of PostgreSQL 8.3.1 for Perl 5.10?
Thanks
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 19, 2008 8:50 PM
Subject: Re: [B
a.. 1. Install Active perl 5.8a.. 2. Install PostgreSQL 8.3.1a.. 3. CREATE
plperl FUNCTION a.. 4. Call this FUNCTION TO CHECK that plperl.dll IS loaded
AND FUNCTION executeda.. 5. Deinstall Active perl 5.8a.. 6. Install Active perl
5.10a.. 7. When you call plperl FUNCTION you get next error:a..
Aliases in the select list are not in scope in the having clause.
it will be good if aliases will be in scope of 'having' clause.
Because of dublicating code is cause of bugs when people foget replace code
in second place while changing code in first one =(
- Original Message -
From:
SELECT
MIN(COALESCE(cmp_values(parent_td.value, parent_md.value, parent_cmp.value),0))
as chk_parent,
FROM some_table
having chk_parent > 0
ERROR: column "chk_parent" does not exist at character 2342
There is situation where I check values and if they do not satisfy some
condition I need to set default.
What is the best way to do that?
- Original Message -
From: "Pavel Stehule" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 05, 2008 8:10 PM
Subject: Re: [BUGS] F
So why I can do:
insert into (id) values ( default )
and can not do in my trigger:
new.id = default
Why?
I have just installed Postgres 8.3.1.
And /usr/local/etc/rc.d/postgresql and /contrib/start-scripts/freebsd
scripts are different
BUG in installator?
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eugen Konkov" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, April 22, 2008 6:1
It's designed that way intentionally to aid in error detection. Parsing
the packet following its internal structure should end up exactly at the
end of the packet according to the length word. Otherwise something's
corrupted.
Why you do not follow this rule for all messages?
70 00 00 00 27 6D
It's part of the protocol, actually (yes, two NUL bytes -- first one
signals the end of the previous string, the second one signals the end
of the packet).
The end of the packet can be obtained by packet length
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: <[EMAI
53 46 41 54 41 4C 00 43 30 38 50 30 31 00 4D 69 SFATAL.C08P01.Mi
6E 76 61 6C 69 64 20 73 74 61 72 74 75 70 20 70 nvalid.startup.p
61 63 6B 65 74 20 6C 61 79 6F 75 74 3A 20 65 78 acket.layout:.ex
70 65 63 74 65 64 20 74 65 72 6D 69 6E 61 74 6F pected.terminato
72 20 61 73 20 6C 61 73 74 20 62 79
server side: writeInt32( length($message)+4 ); writeString( $message );
client side: $length= readInt32(); readString( $length -4 )
that's just odd, needing to add the number of bytes the length field occupies
This is simpler:
server side: writeInt32( length($message)); writeString( $message );
PROBLEM:
How to FULL JOIN groups=1 from table 'a' with groups=2 from table 'b'
and exclude original NULL groups not thouse which FULL JOIN produce?
DESCRIPTION:
I have a schema which is attached at file '123':
while FULL JOIN ing I get:
postgres=# SELECT * FROM a FULL JOIN b ON a.num1 = b.num1;
Yes, It is dangerous. But there is no other way to get arrays for plperl
The doc says that all passed to plperl function are strings ((
Another strange is that that '{1,2,3,4}' looks as hash in perl
It will be more conviniet if arrays passed as '[1,2,3,4]' strings if PG can
not pass them as arra
It seems that function get arrays as strings in plperl.
This is a little workaround who want pass arrays to plperl functions
my( $strarr )= @_;
$strarr =~ s/{/[/g;
$strarr =~ s/}/]/g;
my $arr= eval $strarr;
NOTICE:
you must create you function as plperlu
and add language:
create language plperlu;
DECLARE v_row record;
BEGIN
select 1, row( 1,2) as result into v_row;
return next v_row.result
END;
This code cause "ERROR: RETURN NEXT must specify a record or row variable in
function returning tuple"
BUG? TODO?
DECLARE v_row record;
DECLARE v_result record;
BEGIN
select 1, row( 1,2) as result
DECLARE v_row record;
BEGIN
select 1, row( 1,2) as result into v_scalar, v_row;
return next v_row.result
END;
This code cause "ERROR: RETURN NEXT must specify a record or row variable in
function returning tuple"
BUG? TODO?
DECLARE v_row record;
DECLARE v_result record;
BEGIN
select 1, row( 1,2)
Sorry, docs have confusing me.
I think 'each entry' means each iterations of loop. So maybe it is need to
fix doc. to describe for-in-execute more clearly
thx
- Original Message -
From: "Euler Taveira de Oliveira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 28
Please, can you put this hint to 'F29. tablefunc' chapter:
NOTICE: You need to install contrib module
thx
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 28, 2008 4:48 PM
Subject: Re: [BUGS] BUG: wrong doc or wrong connectby?
PG 8.3.1
http://www.postgresql.org/docs/8.3/interactive/tablefunc.html
I have used copy/past,
examples about does not work (
CREATE TABLE connectby_tree(keyid text, parent_keyid text, pos int);
INSERT INTO connectby_tree VALUES('row1',NULL, 0);
INSERT INTO connectby_tree VALUES('row2','row1', 0
ID |name | parent_ID
-
1a NULL
2b 1
CREATE or REPLACE FUNCTION "public"."get_relation"(
IN "par_fields" text,
IN "par_table" text,
IN "par_id" int4)
RETURNS SETOF "pg_catalog"."record" AS
$BODY$
DECLARE v_parent_ID integer;
DECLARE v_row
http://wwwmaster.postgresql.org/commentdoc
Internal Server Error
Error communicating with database: ERROR: invalid input syntax for type
numeric: ""
Privacy Policy | Project hosted by our server sponsors. | Designed by tinysofa
Copyright © 1996 - 2008 PostgreSQL Global Development Group
The pa
PG v8.3.1
CREATE or REPLACE FUNCTION "public"."aaa"()
RETURNS SETOF "pg_catalog"."record" AS
$BODY$
DECLARE r record;
BEGIN
select 1 as num into r; -- here PG know that first field is integer and has
name 'num'
return next r;
return;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
select * from aaa
Yes, I am running Windows
but why you replace CRLF with \n\n
instead of replace CRLF with only one \n ?
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, March 27, 2008 6:07 PM
Subject: Re: [BUGS] Extra empty lines PGv8.3.1
When I saw log file:
2008-03-27 16:42:47 EET COMMAND: CREATE or REPLACE FUNCTION "public"."test"(
OUT result varchar)
AS
$BODY$
DECLARE varTasksCount integer;
BEGIN
SELECT
count( at2.completion_code_ID )
but command actually was:
CREATE or REPLACE FUNCTION "public"."test"(
OUT
Ok. thx for answer.
When upgrading from 8.0 to 8.3
(http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html)
if those error messages are normal?
C:\Program Files\PostgreSQL\8.3\bin>psql -d postgres -U root -W -f
../../pg_dump
new 2>&1 > c:/restore.log
Password for user root:
Pa
The standard question: when was the last time you did a vacuum analyze
on this table?
Now I done:
1. vacuum full
2. analyze
3. analyze akh_testing_result
4. reindex table akh_testing_result
5. explain select count(*) from akh_testing_result
Aggregate (cost=206372.95..206372.95 rows=1 width=0)
The standard question: when was the last time you did a vacuum analyze
on this table?
Never did.
Fortunately, The Auto-Vacuum Daemon monitors table activity and performs
VACUUMs when necessary. This eliminates the need for administrators to worry
about disk space recovery in all but the most
C:\Program Files\PostgreSQL\8.0\bin>postgres --version
postgres (PostgreSQL) 8.0.3
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, March 25, 2008 1:55 PM
Subject: Re: [BUGS] BUG: PG do not use index
[EMAIL PROTECTED] wrote:
Why PG do not use index?
select max(id) from akh_testing_result
For MySQL this query take 2-3ms, but Postgres take 132 000ms to execute query.
select max(id) from akh_testing_result
Query executed in 2,12 minutes, 1 Record(s) Returned
--
if standard cause head acheing ignore standard
You do so with UPPERCASE, so now you use all lowercased.
This is good when you do thing simpler.
But why you ignore asking of thousands people about case preserving?
create table test ( "Id" integer );
SELECT "Id" as "ID" FROM test
This cause BIG h
if standard cause head acheing ignore standard
You do so with UPPERCASE, so now you use all lowercased.
This is good when you do thing simpler.
But why you ignore asking of thousands people about case preserving?
create table test ( "Id" integer );
SELECT "Id" as "ID" FROM test
This cause BIG h
SELECT "Id" AS ID
and this will return 'id' instead of 'ID'
may be is there server configurations variable to be case sensitive?
or return case preserved field names?
or may be I compile manually PostgreSQL to do that?
Because typing SELECT "Id" AS "ID" instead of SELECT ID is boring
else more y
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
It is have no any matter to me if it is upshifted or lowershifted on server
sidethe standard does not specify that output of queries MUST be
lowershifted/upshifted.why you do this?
http://archives.postgresql.org/pgsql-hackers/2006-10/msg01527.php
- Original Message -
From: "John R Pi
It is have no any matter to me if it is upshifted or lowershifted on server
sidethe standard does not specify that output of queries MUST be
lowershifted/upshifted.why you do this?- Original Message -
From: "John R Pierce" <[EMAIL PROTECTED]>
To: "Eugen Konkov" <[EMAIL PROTECTED]>
Cc:
45 matches
Mail list logo
