The following bug has been logged on the website:
Bug reference: 8080
Logged by: Victor Reinhart
Email address: vic...@maintstar.com
PostgreSQL version: 9.2.4
Operating system: Windows XP
Description:
When using PowerBuilder to connect to Postgres using the latest 32
There is a work around for this. Uninstall Postgres, and remove the pgsql user
account(if it was created), as well as any postgres directories(after
uninstall). Login as the local, that is “built in” Administrator, run as
Administrator.
From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-b
Hello, my name is Viktor, I am from Ukraine.
I work under ArchLinux.
I have installed Postgresql 8.4.4 and I can't run it.
Report log:
Oct 12 17:53:25 localhost postgres[26997]: [1748-1] LOG: database
system was shut down at 2010-10-12 17:43:07 EEST
Oct 12 17:53:25 localhost postgres[26997]:
The following bug has been logged online:
Bug reference: 5391
Logged by: Victor Vargas
Email address: kamu...@gmail.com
PostgreSQL version: 8.4
Operating system: Ubuntu Lucid
Description:coding issues displaying server messages
Details:
This report was originally
to wide-char strings or do a per-character (unlike
per-octet) processing?
--
WBR, Victor V. Snezhko
E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
here is non-multibyte-safe
(octet-wise) case conversion somewhere, at best (with fully working
locale) it will cause case conversion to do nothing instead of actual
conversion.
> They have no business mangling high-bit-set bytes in a multibyte
> encoding.
--
WBR, Victor V. Snezhko
E-mail: [EMA
Victor Snezhko <[EMAIL PROTECTED]> writes:
> So, we either don't support utf-8 on BSDs
Hmm, tolower'ing octets of a multibyte string is a bug not only on
BSDs but on other architectures as well. But on BSDs it additionally
causes corruption of utf-8 data.
--
WBR, Victo
his needs to be
checked on less popular BSD flavors) for now, or we need to fix this
somehow. E.g., by calling only wide-character checks, which will
complicate things...
--
WBR, Victor V. Snezhko
E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Victor Snezhko <[EMAIL PROTECTED]> writes:
> However, in system catalogs (SELECT * FROM pg_tables WHERE
> schemaname='public') there appears to be empty strings instead
> of table names.
>
> This is on patched 8.1.4 (with ILIKE and ctype.h fixes), I'm upgrad
on patched 8.1.4 (with ILIKE and ctype.h fixes), I'm upgrading
to HEAD now to see if anything improved.
--
WBR, Victor V. Snezhko
E-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
acter 0x%x is a digit\n", i);
}
return 0;
}
My FreeBSD lists a whole heck of characters:
character 0x85 is a space
character 0xa0 is a space
character 0xaa is alphabetical
character 0xb5 is alphabetical
character 0xba is alphabetical
character 0xc0 is alphabetical
... 0xc1-0xfe is alph
Victor Snezhko <[EMAIL PROTECTED]> writes:
> LOG: plpgsql_convert_ident: ident=х, isspace array=f, isspace(0)=f
> LOG: plpgsql_convert_ident: ident=test_table, isspace array=ff,
> isspace(0)=f
Hmm, there was something wrong in my utf-8 cluster setup, I
re-attached it a
Tom Lane <[EMAIL PROTECTED]> writes:
> Victor Snezhko <[EMAIL PROTECTED]> writes:
>> 2) When I try to create a stored procedure to create table (e.g., for
>>creating table only if it doesn't already exist), it fails to
>>compile if i use cyrillic
time.
But... maybe I misunderstand something fundamental, but should isspace
work when we pass one byte of multibyte character?
I'm digging this procedure (plpgsql_convert_ident()) and will report
if I find something wrong inside it and not inside isspace.
--
WBR, Vi
Victor Snezhko <[EMAIL PROTECTED]> writes:
> ERROR: expected dot between identifiers: х
> CONTEXT: compile of PL/pgSQL function "createoraltertable" near line 2
>
> the following query fails:
>
> CREATE OR REPLACE FUNCTION TestFunction()
> RETURNS
Victor Snezhko <[EMAIL PROTECTED]> writes:
> 2) When I try to create a stored procedure to create table (e.g., for
>creating table only if it doesn't already exist), it fails to
>compile if i use cyrillic letter "х" (unicode id: 0x0445, utf-8
>
$$ LANGUAGE plpgsql;
(the only multibyte symbol is that 0x0445 letter, and it's between
select and from).
Simple create table and select, outside of function, works (except the
first issue).
What can I do to help to debug this?
Should I try the sources from CVS HEAD?
--
WBR, Victor V. Sne
n
proposed at oledb-devel@, but not accepted due to the following:
1) to implement bytea support, we need to avoid the bug in ATL
2) I have implemented date/time uploading as text for now, and all
the other data types are passed in binary.
3) The fix is OK, but wasn't committed y
s and data dir, when russian message incorectly
refers to PG_CONTROL_VERSION.
The simple fix doesn't require russian language understanding, patch
is attached.
--
WBR, Victor V. Snezhko
E-mail: [EMAIL PROTECTED]
--- src/backend/po/ru-orig.po 2005-01-18 02:27:44.0 +0600
+++ src/backen
if you modify
this to:
1000::float/500/7.
In this case 1000/500/7::float or 1000::float/500/7 will return
the same result, but 1000::float/501/7 and 1000/501/7::float will not
because the first operation will be between variables of an integer
type.
--
Tarhon-Onu Victor
Area Tec
itly.
pg_dump always generates a "CREATE SEQUENCE" clause for explicit
sequences.
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi,
I have a (big) problem with postgresql when making lots of
inserts per second. I have a tool that is generating an output of ~2500
lines per seconds. I write a script in PERL that opens a pipe to that
tool, reads every line and inserts data.
I tryed both commited an
and LC_COLLATE categories are needed.
BTW, version of postgresql in Debian woody is 7.2.1
So it is strange, that you have earilier one. Have you installed it from
Debian package or build by hand? If later, it is better to revert to
Debian version.
--
Victor Wagner
t there is no backslash-command to change
working direcory. But there is such command - \cd, at least in 7.2.1
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http://www.comm
uld make
postgresql behavoir closer to standard SQL.
In my (user) point of view, it is obvoisly bugfix, rather than added
feature, so it has right to appear in 7.2.x release.
> because of concern about lack of testing, but seeing that we've gotten
> several complaint
>Victor Wagner <[EMAIL PROTECTED]> writes:
>> As far as I understand, following three queries are exactly equivalent:
>Same results, but the second two constrain the planner's choice of join
>order. See
>http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/
tion definition
would improve maintainability, compared with invoking createlang
as separate command.
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46
n ascii characters only.
PostgreSQL version 7.2.0.
BTW, if I use item left outer join author, execution plan is simular
with second one and execution time is about 4 seconds. I feel that
it is possible to use execution plan simular with first one,
and make outer join queries fly (as it happen
Is it a known bug if optimizer, that Postgres can't
use indexes created on a int8 (bigint) ?
This problem exists in 7.1.3 and even in
7.2.
test=# CREATE TABLE parent_child
(test(# parent_id int8 NOT
NULL,test(# parent_type int4
NOT NULL,test(# child_id
int8 NOT
execution
It would be be very nice feature if upon CREATE FUNCTION statement
these checks would be performed.
--
Victor Wagner [EMAIL PROTECTED]
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http
I cannot insert into key field of some table russian words
for this (ETO) and what(CHTO).
Problem doesn't occur on Linux with ru_RU.CP1251 locale
Locale itself is correctly written
perl script
---
use locale;
print (("\375\362\356" eq "\367\362\356")?1:0,"\n")
used in either subquery or view
definition, return
value_fld | flag
---+--
a | true
b | true
c | true
d | true
In Oracle these queries, (rewirtten according to Oracle outer join syntax)
return same result.
--
Victor Wagner
32 matches
Mail list logo
