brian ally wrote:
Thanks, Nis. Here's my revised list, using those (errors of letter-case
entirely my own, owing to my hazy understanding of capitilisation for
hyphenated french nouns):
With the risk of getting horribly off topic, you may want to be
consistent between the languages in whethe
As far as I know the conversion table was not changed. Are you saying
that Win-1251 0xb9 is converted to a non-space-char in the previous
version?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Previous version converted such characters all right. And there wasn't any
> bogus ASCII spaces. But I looked at
Hi all,
Ragnar and Tino many thanks for you feedback.
Using this type of approach probably i will try first with pl-j or pl/java
because i am more comfortable with the java language.
It would be nice if i can use, inside postgresql, something like "select * from
[EMAIL PROTECTED]" ... Probably
Glauco Mancini schrieb:
Hi all,
Ragnar and Tino many thanks for you feedback.
Using this type of approach probably i will try first with pl-j or pl/java
because i am more comfortable with the java language.
It would be nice if i can use, inside postgresql, something like "select * from
[EMAI
Hello
We had a strange problem yesterday in one of our servers using PITR
(postgresql 8.1.4).
The script used by archive_command is designed to refuse to overwrite
any pre-existing archive file. Yesterday this situation happened and it
refused to overwrite a file, filling the log file with this
Roman Neuhauser wrote:
# [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
som
Patch applied to CVS HEAD and 8.1.X. Thanks.
---
Marko Kreen wrote:
> On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
> > On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
> > > The fact that Fedora pgcrypto is linked wi
I've setup a database using tsearch2, configured with support for compound
words according to the excellent guide found here:
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words
This works fine. There is however one drawback that I'd like to know
whether can be remedied. Le
It seems not.
$ cat koi8.sh
printf "SELECT '==\xb9=='"|PGCLIENTENCODING=WIN1251 psql -p 5435 koi8
$ psql -p 5435 -c 'select version()' koi8
version
--
On Tue, 30 May 2006, Lars Haugseth wrote:
I've setup a database using tsearch2, configured with support for compound
words according to the excellent guide found here:
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words
This works fine. There is however one drawback that
I have a client that only supports Latin-1 and needs to connect to a
UTF-8 database to retrieve some data. Some columns may contain
characters that have no Latin-1 equivalent. I would like to convert
these to a blank or perhaps some hex value. Is there any way to do
this in PostgreSQL witho
You are right. I was in a harry when wrote my last message.I solved my problem by changing some source files. But It is not very good because I have to do it every time when I need to update my database. And I can't check all fields in all tables because it take a few days.
2006/5/30, Tatsuo Ishii
Did you try escaping the data:
my $rc=$sth->bind_param(1, escape_bytea($imgdata), { pg_type =>
DBD::Pg::PG_BYTEA });
Susan
Rafa
Chris writes:
SELECT * from pg_locks ;
And this is per DB right?
No, this is per system.
On a DB doing no/little work I always see two records returned. One has a
value in the 'database' column. How can I find what database it is?
Looking for it in pg_database did not yield any databases
Francisco Reyes <[EMAIL PROTECTED]> writes:
> The two records I always see are:
>locktype|| mode | granted
> ---++-+-
> transactionid || ExclusiveLock | t
> relation || AccessShareLock | t
That would be your own transa
Hi,
I have to install PGSQL 7.4.13 under RH Linux Entreprise Server 4, and I can
apparently use either the rpm "postgresql--7.4.13-1PGDG.i686.rpm" from
the Postgresql Development Group, or use the rpm
"postgresql--7.4.13-2.RHEL4.1.i386" from Redhat itself.
What is the best to do?
Thanks,
On Tuesday 30 May 2006 09:39, "Philippe Lang" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I have to install PGSQL 7.4.13 under RH Linux Entreprise Server 4, and I
> can apparently use either the rpm "postgresql--7.4.13-1PGDG.i686.rpm"
> from the Postgresql Development Group, or use the rpm
> "postgre
On Tue, 2006-05-30 at 09:05 -0700, [EMAIL PROTECTED] wrote:
> Did you try escaping the data:
> my $rc=$sth->bind_param(1, escape_bytea($imgdata), { pg_type =>
> DBD::Pg::PG_BYTEA });
No. But:
$ ./test
Undefined subroutine &main::escape_bytea called at ./test line 34.
Where can I find on
Moving to -general, where this belongs.
On Sat, May 27, 2006 at 11:13:58PM -0500, Chris Broussard wrote:
> Hello Hackers,
>
> I have the following questions, after reading this FAQ (http://
> www.postgresql.org/docs/faqs.FAQ.html#item4.4) are there statistics
> around the max number of schemas
Sorry, forgot:
sub escape_bytea {
my ($instring)[EMAIL PROTECTED];
my $returnstring=join ('',map {
my $tmp=ord($_);
($tmp >= 32 and $tmp <= 126 and $tmp != 92) ? $_ :
sprintf('\%03o',$tmp);} split (//,$instring));
return $returnstring;
} # end sub escape_bytea
Rafal Pietrak wrote:
> 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. Be
testdb=# select to_tsquery('default_norwegian', 'fritekst');
to_tsquery
--
'fritekst' | 'fri' & 'tekst'
(1 row)
Now, this will indeed match those records, but it will also match any
records containing both of the words 'fri' and 'tekst', without regard
to wh
On May 30, 2006, at 5:48 AM, Eci Souji wrote:
Hmmm that works too. So I guess my next question is which is a
better designed system; one large table with bools and views or six
small tables with stored procs to move data between tables?
That depends entirely on your access patterns and how
On Tue, 2006-05-30 at 20:12 +0200, Daniel Verite wrote:
> Rafal Pietrak wrote:
> > Hmmm, despite initial euphoria, this doesn't actually work.
>
> Just an idea: make sure DBD::Pg::PG_BYTEA is defined.
> If not, you're just lacking a "use DBD::Pg;" and the result
:) This time it's a hit. The
postgresql_autodoc and dia.
On 28 May 2006 05:19:04 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
What open source tool do people here like for creating ER diagrams?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
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, including all the files of the
original Postgres installatio
In PostgreSql 8.1 i've tried to use Out parameter but when I've changed
function (added Out parameter)
CREATE OR REPLACE FUNCTION reffunc3(FROM_ID in integer,COUNT_ROW OUT
integer) RETURNS SETOF Person AS '
DECLARE
rec RECORD;
BEGIN
SELECT count(*) INTO
Well, I did try that, but PostgreSQL service refused to start. :(
Berislav
---(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
ma
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
---(end of broadcast)---
The latest version (V8.1.4) breaks the setup process of our
application's installation wizard. We used to call "createdb.exe" and
piped the password for the postgres user (which has been entered by the
user in our setup wizard's dialogs) into it.
With version V8.1.4 this is not possible anymore, t
On Tue, May 30, 2006 at 10:26:31PM +0200, Rafal Pietrak wrote:
> Now, this is probably not exactly the furum to discuss that, but:
> 1. I did quite a few scripts with DBI, not only for Postgesql in fact -
> scripts worked flowlessly between Oracle/Sybase and the old DBASE files,
> too. And I have
On Sun, May 28, 2006 at 07:24:56 -0700,
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
> fu
[EMAIL PROTECTED] wrote on 29.05.2006 13:06:
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
This is not
Hi guys, I have to update a Linux box with PostgreSQL on it, essentially for data warehousing purposes. I had set it up about 3 years ago and at that time the best solution I had been recommended was to use SCSI disks with hardware RAID controllers.
Is this still the way to go or things have r
On Tue, 2006-05-30 at 16:28, Riccardo Inverni wrote:
> Hi guys,
>
>I have to update a Linux box with PostgreSQL on it, essentially for
> data warehousing purposes. I had set it up about 3 years ago and at
> that time the best solution I had been recommended was to use SCSI
> disks with hardwar
SAS and SATA will give you the best throughput for your array total. U320 is limited to 320MB/channel.AlexOn 5/30/06, Scott Marlowe <
[EMAIL PROTECTED]> wrote:On Tue, 2006-05-30 at 16:28, Riccardo Inverni wrote:
> Hi guys,>>I have to update a Linux box with PostgreSQL on it, essentially for> d
How much money do you want to spend? If you don't care, SAN is probably the way
to go.
How much data do you have to store? If you can afford to fit it onto scsi, scsi
probably is still the way to go.
Otherwise, sata arrays have come a long way in 3 years, and they are by FAR the
cheapest sol
Scott Marlowe wrote:
On Tue, 2006-05-30 at 16:28, Riccardo Inverni wrote:
Hi guys,
I have to update a Linux box with PostgreSQL on it, essentially for
data warehousing purposes. I had set it up about 3 years ago and at
that time the best solution I had been recommended was to use SCSI
disks
Thanks Jim for the interesting information.
in theory what Is the best method (clustering software, or regular
postgresql configuration ?) to spread/partition schemas between
physical machines within a single database? Is it even possible??
I have been using postgres for many years, and the
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> I have to install PGSQL 7.4.13 under RH Linux Entreprise Server 4, and I can
> apparently use either the rpm "postgresql--7.4.13-1PGDG.i686.rpm" from
> the Postgresql Development Group, or use the rpm
> "postgresql--7.4.13-2.RHEL4.1.i386" from R
Compare these two drives:http://www.storagereview.com/php/benchmark/suite_v4.php?typeID=10&testbedID=4&osID=6&raidconfigID=1&numDrives=1&devID_0=279&devID_1=308&devCnt=2
Prices:http://www.cdw.com/shop/products/default.aspx?EDC=984588 - SAS - ~$950
http://www.cdw.com/shop/products/default.aspx?EDC=9
am 30.05.2006, um 3:21:27 -0700 mailte [EMAIL PROTECTED] folgendes:
> In PostgreSql 8.1 i've tried to use Out parameter but when I've changed
> function (added Out parameter)
> ...
>
> ERROR: function result type must be integer because of OUT parameters
>
>
> Of course when I change
hi all,
At the first, please let me say sorry for my poor english.
I have two postgresql database(A and B) running in different machines(X and
Y). I want to visit tables of B from A as if they are tables of A, could
you tell me how can I do?
For example, table t1 belongs to database A, which
Hi,
I only run RHEL because of the "progress" database, running on this server.
Technical support for progress is only available when servers are running
RHEL, so that's why we are running this OS. But if I had the choice, I would
have installed freebsd there...
Alan, you are right, it's time may
am 31.05.2006, um 5:30:45 + mailte liu long folgendes:
> hi all,
>
> At the first, please let me say sorry for my poor english.
>
> I have two postgresql database(A and B) running in different machines(X and
> Y). I want to visit tables of B from A as if they are tables of A, could
> you
* oleg@sai.msu.su (Oleg Bartunov) wrote:
|
| On Tue, 30 May 2006, Lars Haugseth wrote:
|
| > I've setup a database using tsearch2, configured with support for compound
| > words according to the excellent guide found here:
| >
| > http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound
46 matches
Mail list logo
