ve strange data (ARRAY from all
columns), that I don't expect.
Could you tell me if this is a bug or some feature I haven't heard of.
Best regards,
Kaloyan Iliev
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi
I am looking for a way to convert a text field from a table into
punycode (IDN).
Are there any buildin functions in Postgres ot in plpgsql.
Best regards,
Kaloyan Iliev
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Sorry for the noise.
The problem is solved with the restart of the postgresql server.
Have a nice day.
Kaloyan Iliev
Kaloyan Iliev wrote:
Hi All,
I try to migrate a database from WIN1251 to UTF8 but
I have a problem dumping from WIN1251 to UTF8.
pg_dump -C -E 'UTF8' a > a_utf
Hi All,
I try to migrate a database from WIN1251 to UTF8 but
I have a problem dumping from WIN1251 to UTF8.
pg_dump -C -E 'UTF8' a > a_utf8.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not load library
"/usr/local/lib/postgresql/utf8_and_cyrillic.so": dlopen
nd of profiling/personalisation, and would appreciate
any pointers readers of this newsgroup might be able to offer.
Hi,
And what about RT (Request Tracker - http://bestpractical.com/rt/)
.
AFAIK it is free and open-source, uses Postgres and is easy to setup.
Regards,
Kaloyan Iliev
Please reply
x27;::regclass)
Indexes:
"test_pkey" PRIMARY KEY, btree (id)
r=# ALTER TABLE test ADD COLUMN not_null int NOT NULL;
ERROR: column "not_null" contains null values
My question is why didn't PG create the sequence and fill the values in
the first example.
And why create
execute
it.
INSERT INTO $table_name (key1, key2, key3) VALUES (value1, value2,
value3);
So I suggest you write such function and solve most of your problems:-)
Regards,
Kaloyan Iliev
Clodoaldo wrote:
2008/2/29, Martijn van Oosterhout <[EMAIL PROTECTED]>:
On Fri, Feb 29, 2
Hi,
Why not generate a random number in your application and then:
SELECT *
FROM table_x
WHERE condition = true
OFFSET generated_random_number
LIMIT xx
Kaloyan Iliev
Alban Hertroys wrote:
Hello,
I've recently been busy improving a query that yields a fixed number of
random records mat
accepted as error? I try to
"set client_min_messages TO log" during runtime but this didn't help.
I know this is more Perl problem but if someone could help because I
didn't find anyting in the net.
Thanks in advance.
Kaloyan Iliev
[EMAIL PROTECTED] perl
use CLIB:
And what about using cursors and move. Which is faster - OFFSET/LIMIT OR
CURSOR/MOVE.
Best Regards,
Kaloyan Iliev
Tom Lane wrote:
"Jan Bilek" <[EMAIL PROTECTED]> writes:
I'm using PGDB with JDBC. In my app i need to select only portion of all =
available rows. I
n on
raizpaises) and the index scan on libros.
I suggest you to create index on table isbns_a_descubrir over
column isbn. This will hurry the query.
And use join instead of IN for table raizpaises. This should also save
some time.
Regards,
Kaloyan Iliev
ave this query:
SELECT DISTINCT isbn, CU
raizpaises) and the index scan on libros.
I suggest you to create index on table isbns_a_descubrir over
column isbn. This will hurry the query.
And use join instead of IN for table raizpaises. This should also save
some time.
Regards,
Kaloyan Iliev
ave this query:
SELECT DISTINCT isbn, CURRE
n on
raizpaises) and the index scan on libros.
I suggest you to create index on table isbns_a_descubrir over
column isbn. This will hurry the query.
And use join instead of IN for table raizpaises. This should also save
some time.
Regards,
Kaloyan Iliev
ave this query:
SELEC
Hi All,
I just want to ask shouldn't substraction from infinity returns infinity
in float just like in timestamp?
This is for float:
a=# SELECT version();
version
---
Hi,
What about cast to numeric?
select 6.1::numeric-6::numeric ;
?column?
--
0.1
(1 row)
Regards,
Kaloyan Iliev
Hengki Suhartoyo wrote:
Hi all,
I got problem in postgrsql 8.0 when subtraction in float8, this is my
query :
select 6.1::float8-6::float8
Result
version
PostgreSQL 8.1.4 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
3.4.4 [FreeBSD] 20050518
Kaloyan Iliev
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
that:
I transform the jpeg to Base64 text and then store it into normal text
field.
It takes aproximately 25-30% more disk space but is much easier for me
to operate with it.
When I read the object from the database I decode it and I have the file
in the original format.
Regards,
Kaloyan Iliev
blank columns
really makes me trouble.
Thanks for the answers in advance.
Kaloyan Iliev
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Configure
./configure
5. Run make
make
5.1. Make SU and become root
6. Run
make install
This is the usual procedure, but for best result always read the README
file or INSTALL file first.
Regards,
Kaloyan Iliev
[EMAIL PROTECTED] wrote:
Hi,
I'm interested in
HTML documentation the comments are there. That's it.
I am sorry if this doesn't help you much.
Have a nice day,
Kaloyan Iliev
Ottavio Campana wrote:
Kaloyan Iliev wrote:
Hi,
I'm using postgresql_autodoc. It is perfect for me. And if you have
comments in the database the
have many sequences (one for each table PK) every insert
in a different table will use different sequence and this will improve
performance.
Kaloyan Iliev
Janning Vygen wrote:
Hi,
if you define a SERIAL column postgresql's default is to generate a sequence
for each SERIAL c
Hi Hugo,
Yes, it is possible. Just write an outer perl script(in example), which
to call this stored procedure. Then put in the cron to call whis perl
script. As Far As I Know there isn't other way.
Kaloyan Iliev
Hugo wrote:
hi,
is it possible to schedule the execution of an sql s
Hi Madison,
When you migrate from PG7.2 to PG7.4 didn't you change the Perl too.
When we migrate the PG, we also change the OS verison and the Perl and
etc. So this may be Perl migration error. We have some in our own
scripts (from the same type you posted). As Ian says, you should check
the Pe
es.
Thank in advance:)
Kaloyan
John DeSoi wrote:
On Dec 27, 2004, at 6:42 AM, Kaloyan Iliev Iliev wrote:
CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS'
select CASE WHEN $1 THEN 1
ELSE 0
END
'LANGUAGE 'sql';
The problem is that you have quoted the function name a
form where I dumped) everithing was OK:)
Kaloyan
Kaloyan Iliev Iliev wrote:
Hi
I have the following function:
CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS'
select CASE WHEN $1 THEN 1
ELSE 0
END
'LANGUAGE 'sql';
When I try to use it:
select int(&#x
10x John,
You are right.The problem is that the function was dumped with quotes
from pg_dump but I suppose the one who created it used quotes and that's
why it dumps in this way.
I will fix this in the dump.
Thanks again.
Kaloyan
John DeSoi wrote:
On Dec 27, 2004, at 6:42 AM, Kaloyan
Hi
I have the following function:
CREATE OR REPLACE FUNCTION "int" (boolean) RETURNS integer AS'
select CASE WHEN $1 THEN 1
ELSE 0
END
'LANGUAGE 'sql';
When I try to use it:
select int('t'::bool);
ERROR: syntax error at or near "(" at character 11
I am using PG8.0b1
Thank you.
Kaloyan
-
hanks.
Kaloyan
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
But as I say the file with copy commands contains
[EMAIL PROTECTED]@[EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@COPY &qu
cking_base* add deleted bool;
Kaloyan
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
You are right. I coleage of mine has added the delete column after the
schema was created and it ptobably was on the bottom of the table and
dumped there. But now when I restore the schema t
file
on hand. To remove the column from the tracking_base table, and to add
it manuly on the bottem of each table that inherits it. This should
work. Thanks again.
Kaloyan
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
[ details omitted ]
The easiest way around
Hi ,
I have the following problem.
DBVersion: PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
I have a dump of a database on two parts.
Here are the dump commands:
pg_dump -s -S postgres "db_name" |gzip > "db_name.shema.sql"
pg_dump -S postgres -a -Fc "db_name" > "db_name.data.dump
Hi,
I have the same problem and I solved it. This question then was asked
and I answer it. Try looking at the google and you will find it.
In general - Open the package manager and searche for keyword "redline".
The neccessary library will apper and you just will have to install it.
Regards,
K
sequence
So I understand that you can't adapt it to all languages and alphabets
but in case this is an error and can be fixed I report it.
Kaloyan
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
libvar=# select '\\a\\à\\à\\.' ~ '\\a\\à\\à\\.';
E
Thank you
Kaloyan
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
libvar=# select '\\a\\à\\à\\.' ~ '\\a\\à\\à\\.';
ERROR: invalid regular expression: invalid escape \ sequence
7.4 and later are stricter about the use of \ than
Dear friends,
I have the following problem.
libvar=# select version();
version
PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
(1 row)
libvar=# select '\\a\\à\\à\\
Hi,
What about
mydb=# \dv
??
Doesn't it works fine. I don't see any pg views.
Regards,
Kaloyan
Olivier Guilyardi wrote:
Hi,
I'm trying to list views, eliminating internal ones from the output.
Using 7.2, I found this simple statement :
SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
It
36 matches
Mail list logo
