The following bug has been logged on the website:
Bug reference: 8389
Logged by: Ivan Pliouchtchai
Email address: ivan@solidit.cl
PostgreSQL version: 9.2.4
Operating system: Windows 7
Description:
PRECONDITION:
When having a table with the next columns:
content
" solution?
Helmar, thank you very match.
Regards, Ivan.
**
* *From*: *Helmar Spangenberg mailto:[EMAIL PROTECTED]>>*
* *To*: *pgsql-bugs ( at ) postgresql ( dot ) org
<mailto:[EMAIL PROTECTED]>*
* *Subject*: *Bug concerning regular expressions and UTF-8*
* Date
The following bug has been logged online:
Bug reference: 2726
Logged by: Ivan Volf
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: linux
Description:reindex database failed if number is in database name
Details:
drin=# reindex database
Hello Alvaro,
Thursday, November 3, 2005, 3:28:41 PM, you wrote:
AH> Ivan wrote:
AH> Hi,
>> Perhaps you missed my previous message.
>> pg_dumpall has not -f command line option
>> to specify output file - it always send output
>> to standart output. But there is
d you please add -f option to pg_dumpall,
because it's very inconvenient to replace these
character sequences in hex editor all the time.
Thank you for support!
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of
Hello,
TL> Ivan <[EMAIL PROTECTED]> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).
>> If I create plain backup using pg_dump
>> it
Hello,
Thursday, October 27, 2005, 6:34:36 PM, you wrote:
TL> Ivan <[EMAIL PROTECTED]> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).
>&g
It's very annoy, so please fix if it's not very hard.
Thank you!
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
CT* 1" (cost=0.00..0.02 rows=1 width=0)
-> Result (cost=0.00..0.01 rows=1 width=0)
-> Subquery Scan "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0)
-> Result (cost=0.00..0.01 rows=1 width=0)
select 1 as "Id", &
_type AS
$BODY$
select "Id"::int4, "Data"::test_domain
from (
select 1 as "Id", 'string1' as "Data"
union all
select 2 as "Id", 'string2' as "Data"
) as q1;
$BODY$
LANGUAGE 'sql' VOLATILE;
The following bug has been logged online:
Bug reference: 1520
Logged by: Ivan Chumak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows XP SP2
Description:messages in Russian is made wrong
Details:
The derivation (conclusion) of
The following bug has been logged online:
Bug reference: 1380
Logged by: Ivan Chumak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: windows 2000
Description:dont reading messages in russian languages
Details:
i talking about messages
Hello Nicola,
Monday, November 22, 2004, 9:00:30 PM, you wrote:
NP> I've been experiencing data corruption/loss in Postgresql 7.4.2.
Try to recompile (create or replace) your stored procedure
after you alter the table
Hope this help...
--
Best regard
Title: finger print (minutias)
Hi.
I would like to know if it posible record a minutias code in Postgre SQL, it is a binary data
Ivan E. Rivera Uria
Company: BNC MEXICO
Phone Number: +(52)-55-5241-0670
Fax Number: +(52)-55-5241-0680
Direct Number:+(52)-55-5241-0688
Company Mail
ple1
pg_dump.exe: [archiver (db)] connection to database "example1" failed: FATAL: user
"'postgres'" doe
s not exist
pg_dumpall.EXE: pg_dump failed on database "example1", exiting
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello Tom,
Tuesday, September 21, 2004, 6:17:37 PM, you wrote:
TL> Ivan <[EMAIL PROTECTED]> writes:
>> Suppose we have sql function which returns composite type.
>> When such function's last select statement doesn't return any row
>> error occurs -
>> E
quot; UNIQUE ("name");
----
select * from "test"('second')
will return one row with data
but
select * from "test"('secon')
will raise an ERROR
and
select * from "test2"('secon')
will return empty set.
I think that is more conveniently that when no data is fetched
such function returns instance of composite type with nulls.
In case of function returning record type we also "know" schema of
the last select.
Of course it is possible to use plpgsql function and select into
but sql functions is smaller and don't require handler.
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Pack 2 Build 2600
Thank you.
--
Best regards,
Ivan mailto:[EMAIL PROTECTED]--
-- PostgreSQL database dump
--
SET client_encoding = 'WIN';
SET check_function_bodies = false;
SET SESSION AUTHORIZATION 'root';
--
-- Name: public; Type: SCHEMA; Schema:
Tom you right!!
We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes:
the date format that we use is DD/MM/ but whet we execute a select
command we get this information:
Sounds to me like
docs_requeridos values
(243,5,15,123456,'01/11/2004','ivan',1);
the date format that we use is DD/MM/ but whet we execute a select
command we get this information:
id |status|id2|serie |date_exe
Hi,
I'm not sure if you know this problem.
Create an empty function with 26 parameters:
create function test (INTEGER,TEXT,TEXT,TEXT,CHAR(16),CHAR(11),
BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,
BOOLEAN,BOOLEAN,BOOLEAN,CHAR(2),TEXT,TEXT,TEXT,TEXT,
CHAR(5),TEXT,TEXT,TEXT,TEXT,TEXT )
returns i
|
Index: forum_data_pkey
We can't solve this problem.
Thank you.
Anton Ruhl, Ivan Dolinin (Russia, Tomsk)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Severity: Devastating
Short description:
Simple SELECT query with simple REGEXP comparison with simple
ORDER
and WITHOUT JOINS CRASHES BACKEND (seems to die in an infinite loop that
consumes CPU and uses the hard disk).
Long description:
The query:
SELECT t.* FROM t
I use a DIGITAL ALPHA DEC2000 AXP500 with 128MB of RAM, architecture EV4
150MHz processor. I installed a Debian potato (2.2) and got problems
during installation, postmaster not starting.
After a mail exchange with postgres Debian mantainer, got sources of
postgresql version 7.0.3 (debian patched)
24 matches
Mail list logo
