The following bug has been logged online:
Bug reference: 4275
Logged by: Carl-Daniel Hailfinger
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.9
Operating system: openSUSE Linux 10.3, x86
Description:Multicolumn subquery expression not allowed on both
sides
yep.. mea culpa.. I forgot the CC - reply to all would've been a better
choice :-)
If anyone happens to run into this, or have a fix (even if its some godawful
windows hack.. ) please... I'm in a need to know position here. I don't
see any mention of this bug on the todo or faq, so I assume it
The following bug has been logged online:
Bug reference: 4276
Logged by: x
Email address: [EMAIL PROTECTED]
PostgreSQL version: n/a
Operating system: n/a
Description:Feature request aggregate indexes
Details:
# CREATE INDEX count_star ON fscrbank (COUNT(*));
ERROR:
"Carl-Daniel Hailfinger" <[EMAIL PROTECTED]> writes:
> This works:
> # SELECT ROW(true,true)=(SELECT true,true);
> This doesn't:
> # SELECT (SELECT true,true)=(SELECT true,true);
> Error: 42601: subquery must return only one column
This is not a bug, since we do not claim support for feature F64
The following bug has been logged online:
Bug reference: 4277
Logged by: x
Email address: [EMAIL PROTECTED]
PostgreSQL version: n/a
Operating system: n/a
Description:Feature request inet type cast numeric values
Details:
SELECT inet 2130706433;
Should return:
?colu
x wrote:
Description:Feature request inet type cast numeric values
Details:
SELECT inet 2130706433;
Should return:
?column?
127.0.0.1
This would emulate the functionality:
CREATE OR REPLACE FUNCTION inet_ntoa(bigint) RETURNS text AS '
SELECT (($1>>24) & 255::int8) || ''.'' |
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
>> Description:Feature request inet type cast numeric values
> You can create the cast yourself if you want to, see CREATE CAST.
The proposed cast seems rather inappropriate in an IPv6 world anyway.
If you want IPv4-only functionality, I th
Hi
I just tried it, slightly better but not a runner
Here is a sample of the results I get when running my test script, note
result vary but lack of duplicates does not.
Why do you not use the CreateUUID function in windows??
Regards
Eric
result --
Tengo un scrip que hago manualmente que es asi
#!bin/sh
#iniciando Programa
echo "Iniciando backup de aloradius.highway.com.py"
pg_dump -Ft -b radius > $(date +%Y%m%d)_aloradius_radius.tar
echo " Finalizo el Backup"
echo "Iniciando compresion de Backup"
gzip -9 $(date +%Y%m%d)_aloradius_radius.t
On Tue, 01 Jul 2008 19:44:28 +0200, Avilio Alarcón
<[EMAIL PROTECTED]> wrote:
pg_dump: not found
I have no idea what you just said, but I think I understand the problem.
Cron's PATH is reset to quite simple value in each cron script, so,
instead of:
pg_dump -Ft -b radius > $(date +%Y%m%d)_al
Hi.
Umm...
The test of my box is comfortable.
--
-- ossp-uuid test
--
CREATE OR REPLACE FUNCTION test_uuid(gen INTEGER)
RETURNS VOID AS $$
BEGIN
FOR i IN 1..$1 LOOP
RAISE INFO 'uuid = %', uuid_generate_v4();
END LOOP;
END;
$$
LANGUAGE 'plpgsql';
postgres=# CREATE OR REPLACE FUNCTION test_uu
11 matches
Mail list logo
