Hi
all,
i'm looking for a
method to connect natively a postgresql db to oracle ( maybe via odbc ? ) with
something similar to the oracle dblink.
I connected
successfully a oracle instance to a postgresql instance using unix-odbc, now i
need to proceed on the other way.
Can you plea
What the hell is Rupees?
On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote:
Hi there,
Help me by taking this survey. We can both get 1000 Rupees! Click here:
http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2
---(end of broadcast)--
On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote:
> i'm looking for a method to connect natively a postgresql db to oracle
> ( maybe via odbc ? ) with something similar to the oracle dblink.
>
> I connected successfully a oracle instance to a postgresql instance
> using unix-odbc, now i
The legal tender in India, I guess.
P.
Joe Kramer wrote:
What the hell is Rupees?
On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote:
Hi there,
Help me by taking this survey. We can both get 1000 Rupees! Click here:
http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p
Joe Kramer schrieb:
What the hell is Rupees?
bart.gif ;) Indian money of course.
Regards
Tino
(PS: looked like spam for me)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail com
Ragnar schrieb:
On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote:
i'm looking for a method to connect natively a postgresql db to oracle
( maybe via odbc ? ) with something similar to the oracle dblink.
I connected successfully a oracle instance to a postgresql instance
using unix-odb
Rafal Pietrak wrote:
On Sat, 2006-05-27 at 14:06 -0400, Bruce Momjian wrote:
Is this a feature, or a bug? And in fact, is there a construct to get
both the count() and its selectors *in*case*, when the count is ZERO?
All the above in postgres 8.1.
It is supposed to work that way. In the first
On Mon, 2006-05-29 at 12:32 +0200, Nis Jorgensen wrote:
> Rafal Pietrak wrote:
> > But is there a way to achieve one row output with both the count() and
> > its selector, when the ocunt is ZERO?
> SELECT dummy.id, count(xxx.id) FROM (SELECT :id as id FROM dual) as
> dummy LEFT JOIN xxx using (id)
Tom Lane wrote:
Michael Ben-Nes <[EMAIL PROTECTED]> writes:
Im got the following error when the query string was one of the Hebrew
chars:
SELECT upper('׳©');
ERROR: invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably incompatible with the
databas
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> Basically we've got several different "states" that an item can be in.
> From what I've seen the way many places seem to deal with them is
> something along the lines of making bool values that act as
> switches...
>
> Ex:
> table items:
> item_id
Hi!
Within a UTF-8 encoded database, I have a table:
CREATE TABLE pics (id serial not null unique, img bytea);
The table is originally initialized with a set of IDs. Then I'm using
perl-script to insert apropriate images by means of UPDATEing rows:
--within my script called 'j
Am Montag, 29. Mai 2006 13:35 schrieb Rafal Pietrak:
> How come the bytearea is *interpreted* as having encoding?
If you pass data in text mode, all data is subject to encoding handling. If
you don't want that, you need to use the binary mode.
> Or to put it the other way around: What column da
On Mon, May 29, 2006 at 01:35:58PM +0200, Rafal Pietrak wrote:
> The table is originally initialized with a set of IDs. Then I'm using
> perl-script to insert apropriate images by means of UPDATEing rows:
> --within my script called 'job'---
> my $db = DBI->connect
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along the lines of making bool values that act as
switches...
Ex:
table ite
Chris wrote:
Eci Souji wrote:
Hi, I was wondering if anyone had any experience with this type of
setup and could share what they've learned.
Basically we've got several different "states" that an item can be in.
From what I've seen the way many places seem to deal with them is
something along
Hello List:
Please observe the following example that reproduces my problem:
CREATE TABLE ptable (code VARCHAR) WITHOUT OIDS;
CREATE TABLE
CREATE TABLE ctable (code VARCHAR, name VARCHAR)
INHERITS (ptable) WITHOUT OIDS;
NOTICE: merging column "code" with inherited definition
CREATE TABL
On 5/29/06, Bjørn T Johansen <[EMAIL PROTECTED]> wrote:
Druid works ok
http://druid.sourceforge.net/index.html
Are there a couple of screenshots available on the net, a flash demo perhaps?
t.n.a.
---(end of broadcast)---
TIP 1: if posting/r
On Mon, 29 May 2006 14:43:19 +0200
"Tomi NA" <[EMAIL PROTECTED]> wrote:
> On 5/29/06, Bjørn T Johansen <[EMAIL PROTECTED]> wrote:
> > Druid works ok
> >
> > http://druid.sourceforge.net/index.html
>
> Are there a couple of screenshots available on the net, a flash demo perhaps?
>
> t.n.a.
D
On Mon, 2006-05-29 at 14:01 +0200, Martijn van Oosterhout wrote:
> >
> > How come the bytearea is *interpreted* as having encoding?
>
> Actually, it's not the bytea type that is being interpreted, it's the
> string you're sending to the server that is. Before you send bytea data
> in a query stri
On Mon, May 29, 2006 at 08:40:43AM -0400, Terry Lee Tucker wrote:
> INSERT INTO ctable (code, name) VALUES ('code_one', 'Code One');
> rnd=# SELECT * FROM ptable;
>code
> --
> code_one
> (1 row)
>
> rnd=# SELECT * FROM ctable;
> code | name
> ---+--
>
We haven't made much progress on this lately, but the good news is that
I don't remember anyone reporting a problem for about a year, so I
figured it was fixed. I think it has to be assumed to be a buggy
terminal program.
--
Michael Ben-Nes <[EMAIL PROTECTED]> writes:
> The character that I sent is:
> [שâ] U+05E9 ש HEBREW LETTER SHIN
Well, that does work out to D7 A9 in UTF8, if I'm doing the arithmetic
correctly.
I can't replicate any problem in either 8.1.4 or HEAD. It's possible
that this is a bug that's b
On Monday 29 May 2006 09:43 am, Michael Fuhr <[EMAIL PROTECTED]> thus
communicated:
--> On Mon, May 29, 2006 at 08:40:43AM -0400, Terry Lee Tucker wrote:
--> > INSERT INTO ctable (code, name) VALUES ('code_one', 'Code One');
--> > rnd=# SELECT * FROM ptable;
--> >code
--> > --
--> > c
"Berislav Lopac" <[EMAIL PROTECTED]> wrote
>I have recently reinstalled my Windows mychine, including the
> PostgreSQL server, but (due to a system crash, unrelated to Postgres)
> I
> wasn't able to dump my databases to import them now. However, I have a
> full copy of the original system, includ
Hello,is there any known way to convert numbers to their text equivalent in English and other languages?like 25 --> Twenty FiveI am interested in Arabic specifically.
Make a table that you can reference. Fill it with Arabic,
English or any language that you wish.
Make it available to the list so those who wish can
particpate and receive a copy of the finished product.
Bob
- Original Message -
From:
Samer
Abukhait
To: pgsql-gene
Not sure that i understand..Fill what exactly in the table?I am seeking for a dynamic way to combine text numbersPlease also note that in Arabic .. text numbers behave differently according to the item you are counting (male or female Items)
On 5/29/06, Bob Pawley <[EMAIL PROTECTED]> wrote:
...and as I learned the last time I returned from India, no bank
outside of India will exchange rupees, because it's technically
illegal to take rupees outside the country. So unless you happen to
be in or going to India, 1000 rupees isn't too useful.
On May 29, 2006, at 2:37 AM, Tino Wilde
Bob Pawley wrote:
Make a table that you can reference. Fill it with Arabic, English or any
language that you wish.
Make it available to the list so those who wish can particpate and receive a
copy of the finished product.
Bob
- Original Message -
From: Samer Abukhait
To: pgsq
And even if you can convert it, as of today 1000 Rupees is 17.16745
Euro, or 21.85553 US Dollar, which, concerning the convertion fee,
would not give a real good meal in Europe or USA.
Harald
-
on different matter:
did you ever dream of visiting CERN? The place where the antimatter
for explodin
Perhaps it was in reference to Hyrule Rupees? :)
http://en.wikipedia.org/wiki/Rupee_(Legend_of_Zelda)
Ben wrote:
...and as I learned the last time I returned from India, no bank
outside of India will exchange rupees, because it's technically illegal
to take rupees outside the country. So u
Em Segunda 29 Maio 2006 12:22, brian ally escreveu:
> I was thinking the same. But Bob's reply has me wondering if there are
> any online resources for this sort of thing. Specifically, i have a
> look-up table, with most (possibly all - i don't know) countries'
> 2-letter ISO codes and english nam
"Samer Abukhait" <[EMAIL PROTECTED]> writes:
> I am seeking for a dynamic way to combine text numbers
There's some code in the "money" datatype for this, but it's hard-wired
for English.
I have a vague feeling that I've seen a Perl module for the task, which
might possibly have international capa
am 29.05.2006, um 17:09:10 +0200 mailte Samer Abukhait folgendes:
> Hello,
>
> is there any known way to convert numbers to their text equivalent in
> English and other languages?
>
> like 25 --> Twenty Five
IIRC i have @work a book about sed and awk, and, iirc, there are a code
for awk or sed
Hi, I have an error after updating my database up to 8.1.4 version."SQL Error: ERROR: character 0xb9 of encoding "WIN1251" has no equivalent in "MULE_INTERNAL"'. "My client program encoding is windows-1251 and database encoding is koi8.
What can I do to rectify the situation?Verba volent, scripta
2006/5/25, Brandon E Hofmann <[EMAIL PROTECTED]>:
(..)I tried defining composite types, but get a runtime error that it isn'tavailable. That is you postgres-- William Leite AraújoEspecialista em Geoprocessamento- UFMG
Bacharel em Ciêncida da Computação - UFMGMSN: [EMAIL PROTECTED]ICQ:2
2006/5/25, Brandon E Hofmann <[EMAIL PROTECTED]>:
(..)I tried defining composite types, but get a runtime error that it isn'tavailable. That is you postgresql version? Why you need return the temporary table type? Why create a temporary table if you use a function return type "setof"?
brian ally wrote:
I was thinking the same. But Bob's reply has me wondering if there are
any online resources for this sort of thing. Specifically, i have a
look-up table, with most (possibly all - i don't know) countries'
2-letter ISO codes and english names. Just this weekend, i've learned
When I try and create a new database I get the following error:
ERROR: checkpoint request failed
HINT: Consult the server log for details.
but the error log (/var/log/postgresql/postgresql-8.1-main.log) just
repeats the same error message.
This is Postgres 8.1, from Debian Unstable debs. Ther
Nis Jorgensen wrote:
brian ally wrote:
I was thinking the same. But Bob's reply has me wondering if there are
any online resources for this sort of thing. Specifically, i have a
look-up table, with most (possibly all - i don't know) countries'
2-letter ISO codes and english names. Just this w
"Stuart Grimshaw" <[EMAIL PROTECTED]> writes:
> When I try and create a new database I get the following error:
> ERROR: checkpoint request failed
> HINT: Consult the server log for details.
> but the error log (/var/log/postgresql/postgresql-8.1-main.log) just
> repeats the same error message.
> Hi, I have an error after updating my database up to 8.1.4 version.
> "SQL Error: ERROR: character 0xb9 of encoding "WIN1251" has no equivalent
> in "MULE_INTERNAL"'. "
> My client program encoding is windows-1251 and database encoding is koi8.
> What can I do to rectify the situation?
It sugge
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> is there any known way to convert numbers to their text
> equivalent in English and other languages?
See:
http://search.cpan.org/~rvasicek/Lingua-Num2Word-0.07/Num2Word.pm
Easy enough to put into a pl/perlu. I've used the English version
success
Tom Lane writes:
CREATE INDEX shouldn't block any concurrent SELECT, regardless of which
index AM is involved.
The problem was that the table needed a "vacuum full". It was a large table
and had done a massive update. It is not that it was blocked, but that it
was just taking a very long tim
Francisco Reyes wrote:
Tom Lane writes:
CREATE INDEX shouldn't block any concurrent SELECT, regardless of which
index AM is involved.
The problem was that the table needed a "vacuum full". It was a large
table and had done a massive update. It is not that it was blocked, but
that it was jus
I have this small web aplication.When i used mysql i used to do somthing like:SELECT * FROM table WHERE name like '%searchstring%' OR description like '%searchstring%';that doesnt really looks eficient... well... actually it works with no problem.
anyway... what's the standard query for a text sear
On May 30, 2006, at 12:46 , Pedro wrote:
SELECT * FROM table WHERE name like '%searchstring%' OR description
like '%searchstring%';
that doesnt really looks eficient... well... actually it works with
no problem.
Depending on your needs, that may work just fine. PostgreSQL includes
rege
Chris writes:
Is there a way to tell what tables have locks on them?
SELECT * from pg_locks ;
(version 7.4 and above at least, don't have an install earlier than that).
And this is per DB right?
Any way to tell locks in all DBs?
In particular if planning to bounce back the DB would be nice
Francisco Reyes wrote:
Chris writes:
Is there a way to tell what tables have locks on them?
SELECT * from pg_locks ;
(version 7.4 and above at least, don't have an install earlier than
that).
And this is per DB right?
No, this is per system.
Not sure how it works with permissions (eg i
I think you are right. But everything was alright before I updated my database.So there are a lot of "incorrect" values in tables. And errors appear when I execute "SELECT * FROM table".
2006/5/30, Tatsuo Ishii <[EMAIL PROTECTED]>:
> Hi, I have an error after updating my database up to 8.1.4 versi
> On Fri, May 26, 2006 at 12:02:44PM +0500, [EMAIL PROTECTED] wrote:
>> I have trigger on updating the table. Sometimes i need to make queries
>> without calling that trigger. How can I solve this?
>
> You need your function to decide whether the "don't do anything"
> conditions apply, and then not
> I think you are right. But everything was alright before I updated my
> database.
Previous version converted such characters to ASCII spaces. So
probably you have lots of bogus spaces anyway. If you think it's ok,
then you could your own CONVERSION which behaves similar to previous
version.
--
T
Previous version converted such characters all right. And there wasn't any bogus ASCII spaces. But I looked at the KOI8 charset table and found out that there is not equivalent symbol (0xb9) in this table.
2006/5/30, Tatsuo Ishii <[EMAIL PROTECTED]>:
> I think you are right. But everything was alri
# [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> >
> >>Basically we've got several different "states" that an item can be in.
> >>From what I've seen the way many places seem to deal with them is
> >>something along the
54 matches
Mail list logo
