On Tue, 16 Sep 2003, John Allgood wrote:
> Hello
>
> I am looking for information on what operating systems and
> filesystems people are running postgresql on. I have read so much on this I
> decided to get some input from other people. I at first was leaning toward
> FreeBSD and using its
Hi, there,
I installed postgresql 7.3.4 by RPMs, and created a database. Now I found I need
multibytes language support. How can I change the database setting? I don't want to
re-create the database.
I installed JDBC and when some columns have multibytes chars. JDBC throws error.
Please help m
Quoth Markus Espenhain <[EMAIL PROTECTED]>:
> SELECT * FROM Hauptantrag WHERE (select datenfeldname from
> datenexport) > (select datum_von from datenexport) AND (select
> datenfeldname from datenexport) < (select datenexport.datum_bis from
> datenexport) limit 10;
If I understand you right, you w
Title: File Sytems Types and Os Recomendations
Hello
I am looking for information on what operating systems and filesystems people are running postgresql on. I have read so much on this I decided to get some input from other people. I at first was leaning toward FreeBSD and using i
"Mauricio de Castro" <[EMAIL PROTECTED]> wrote:
> Report Generator in PHP-GTK that work with Pear-db. It's very easy for
> users...
I was thinking to generate the report with the psql, not with an external
program, somethink like this:
Welcome to psql 7.X, the PostgreSQL interactive terminal.
T
On 16 Sep 2003, Jose Vicente Nunez Z wrote:
> Tom,
>
>
> On Tue, 2003-09-16 at 10:44, Tom Lane wrote:
> > Jose Vicente Nunez Z <[EMAIL PROTECTED]> writes:
> > > For that i'm using the PostgreSQL copy tool, but the problem is that is
> > > taking almost 9 hours to load the data:
> >
> > Hmm, 889
Jose Vicente Nunez Z <[EMAIL PROTECTED]> writes:
> create table mytable
> (
>a varchar(20) not null,
>b varchar(20) not null,
>c varchar(20) not null,
>d char(6),
>f int null,
>g float not null,
>
Tom,
On Tue, 2003-09-16 at 10:44, Tom Lane wrote:
> Jose Vicente Nunez Z <[EMAIL PROTECTED]> writes:
> > For that i'm using the PostgreSQL copy tool, but the problem is that is
> > taking almost 9 hours to load the data:
>
> Hmm, 889 rows/second doesn't sound that bad, considering that you've
>
Jose Vicente Nunez Z <[EMAIL PROTECTED]> writes:
> For that i'm using the PostgreSQL copy tool, but the problem is that is
> taking almost 9 hours to load the data:
Hmm, 889 rows/second doesn't sound that bad, considering that you've
given us no data about the hardware you're running on. In parti
By default they should be in /usr/local/pgsql/include
[EMAIL PROTECTED] wrote:
> Does anyone know where i can get the postgresql headers from or where
> they might be located on my redhat machine.
begin:vcard
n:Missimilly;Thierry
tel;fax:+33 (0)4 76 29 78 78
tel;work:+33 (0)4 76 29 74 54
x-mo
Read the administrator docs again, and look for the line:
This option can only be set at server start.
At the end of a lot of the entries. This is one of them.
I.e. reload won't do, only restart.
On 16 Sep 2003, Frédéric Burlet wrote:
>
> Hi,
>
> When I'm using pg_ctl to reload the config
You should find it by issuing :
rpm -ql postgresql-devel
on a command line
HTH
Flupke
--
<< There's no place like ~! >>
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 4:12 PM
To: [EMAIL PROTECTED]
Subject: [ADMIN] postgresql
> SELECT * FROM Hauptantrag WHERE (select datenfeldname from datenexport)
> > (select datum_von from datenexport) AND (select datenfeldname from
> datenexport) < (select datenexport.datum_bis from datenexport) limit 10;
It is not correct. You have not defined the condition between hauptantrag
&
Greetings,
I'm trying to use PostgreSQL to manage big amounts of data; One of the
first things i'm testing is how fast PostgreSQL can load some big CSV
text files.
For that i'm using the PostgreSQL copy tool, but the problem is that is
taking almost 9 hours to load the data:
copy nb_cmo_deal_po
Does anyone know where i can get the postgresql headers from or where they
might be located on my redhat machine.
Report Generator in PHP-GTK that work with Pear-db. It's very easy for
users...
http://agata.codigolivre.org.br
Creator: Pablo ([EMAIL PROTECTED])
[]s
Mauricio
On Monday 15 September 2003 18:25, kaolin fire wrote:
> On Monday, September 15, 2003, at 02:06 PM, Gaetano Mendola wrote:
> > ""Mat
It's possible to use dbArtisan for administrate PostgreSQL databases?
Eliecer Osorio Verdugo
Ivestigación y Desarrollo
Sisdef Ltda.
Fono: 56 32 810777
Fax : 56 32 811190
e-mail: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to inc
Hello all,
I have the problem that I must create an Querry witch looks like:
--snip--
SELECT * FROM Hauptantrag WHERE (select datenfeldname from datenexport) > (select
datum_von from datenexport) AND (select datenfeldname from datenexport) < (select
datenexport.datum_bis from datenexport) li
Hi,
When I'm using pg_ctl to reload the config of postgres and nothing
happens. I mean that the new configuration seems to not be reloaded
(even if the logs say that a SIGHUP has been sent to postmaster).
The command line I'm using is the following:
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl
19 matches
Mail list logo
