- Original Message -
From: <[EMAIL PROTECTED]>
> Hello
>
> It is probably something quite silly but I have installed all the binaries
> from the RH6.2 installation disk and browsed through the manual. These
> are:
>
> postgresql-6.5.3-6.i386.rpmpostgresql-python-6.5.3-6.i386.rpm
Ould wrote:
The size of any file is limitted (for exemple in linux 2.2.x to 2GO). If
database (tablespace) is considered as file how we can atteign 60 GO?
> Ould wrote:
>
> > Hello,
> >
> > I have 2 questions:
> > 1) What is th max size of database we can create in Postegrsql?
> > 2) Suppose I
PostgreSQL splits the table files into several files transparently, so
you don't have to worry about that.
I think Linux 2.4.x will have this limit removed.
But when you dump at 60GB table to disk on linux 2.2.x, you can use the
utilities "split" and "gzip" to avoid running into the 2GB barrier.
Hi,
I have been having a few problems with strings (varchar)s.
How can I insert a quote ' character in a string?
The following, needless to say does not work:
INSERT INTO table (string) VALUES ('colin's');
Also, are there any other characters that need special attention in order to
put t
Tom Lane wrote:
> > CREATE TABLE pfam (swiss_id varchar(16) NOT NULL, pfam_family
> > varchar(32), comment varchar(80), sequence_data varchar(-5));
>
> Hrm. varchar(-5) is pretty obviously broken :-(. I don't want to
> guess what sort of aberration prompted that output from pg_dump
> --- 6.3.2
I have a customer that works on a MDB database.
There is a simple way to port data in the PGSQL database in his site (i use
php) ?
Hello:
After creating the tables tb_bombas and tb_abastecimentos
as follows
\connect f
drop table tb_bombas;
CREATE TABLE "tb_bombas" (
"id_bomba" int2 PRIMARY KEY,
"tipo_bomba" char,
"estado_bomba" int2,
"data_atualizacao" datetime);
CREATE TABLE "tb_abastecimen
After cursing over this for I don't know how long, its was recently
brought to my attention that the C search.cgi that comes with UDMsearch
just might not be up to snuff, compared to some of the other interfaces
...
After some investigation, we've installed a mod_perl front-end to the
database t
Hi,
I've been able to use pg_trigger.tgargs to get relationships between foreign
keys. Now I want to get the update, delete etc. rules. Any idea how?
If possible could you tell me what each of the columns in pg_trigger are for,
because I have no idea, and I can't find it in the docs.
Thankyou f
> Available at:
> ftp://ftp.postgresql.org/pub/binary/v7.0.3/RPMS
> or on your favorite PostgreSQL mirror.
> PPC RPM's should be available soon, as should Mandrake 7.1 RPM's.
I've just posted the RPMs for Mandrake. They built without any changes
to the spec file (thanks Lamar!) except of course f
Please, help me.
I configure/compile perl with option ( other options stay default ):
./Configure -Dprefix=/usr/local/perl -Duseshrplib
make
make install
I add string '/usr/local/perl/lib/5.6.0/i686-linux/CORE'
in file /etc/ld.so.conf and call program 'ldconfig'.
Environment:
Has anyone ever implemented a matrix data type that they would be willing
to share? All I want is basic addition & subtraction (don't even need
multipication), but an avg & sum implementation would be nice...
Philip Warner
Hello community,
I want to compile postgresql 7.0.3 on my WinNT at work, but I don't
know how! Am I supposed to compile it with VisualC++, as I read in
the docs I hope not, cause I am only a poor system admin!! :)
I have cygwin-tools on my machine so I hoped that's all I need!
Can anybody
I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED ,
NOT A INTEGER INDEX FROM I TO
CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW
NUMBER IN POSTGRESQL!!
I have an old Postgres server (v6.3) running on a machine which I do not
control and cannot update.
I have a new machine which came with Postgres 7.0.2, which I do control.
I need to be able to talk to the v6.3 server from the new machine.
Can this be done? When I try I get:
newMachine$ psql
Hi all.
I would like to use pgaccess with a developpement server.
I red the page "http://www.postgresql.org/docs/admin/x377.htm" but
didn't understand if I have to include the both "--with-tcl" and
"--with-x" on the server in the compilation. (The server is a BSD-i386)
Thus, I have no X-serve
Subject says it all I guess. What is the relationship between 7.1 and
the new features added by www.erserver.com (ie. adding replication
functionality to Postgresql which will be open source)?
Dirk
Anyone out there used PostgreSQL on Redhat's High Availability Server?
We are trying to determine if a RedHat/PostgreSQL combo could be used in
a dual-redundant manner, such as a Active/Inactive cluster
configuration. Anyone out there do this? Any problems, gripes, or
success stories? Please re
Hi:
Wonder if any of you know how to setup a postgreSQL server as a windows 2000 service
or have a URL or document on how to do it.
Thank you
---
Luis Magaña
Gnovus Networks & Software
www.gnovus.com
Tel. +52 (7) 4422425
[EMAIL PROTECTED]
many users have asked for this feature (ie load balancing,clustering, of 1
postgresql database)
but no answer from mailing-list, and no planning for this important feature,
i don't understand why.
Why not set-up a site to found this project with donations... on
postgresql.org?
valter mazzola
On Thu, Nov 23, 2000 at 01:21:14PM +0100, Enrico Comini wrote:
> I have a customer that works on a MDB database.
>
> There is a simple way to port data in the PGSQL database in his site (i use
> php) ?
>
there is a odbc-driver for postgreSQL for win-applications, that you
can use for copy/paste
Hi
I was playing with a snapshot and doing some regression tests just in
case when i discovered that if i use a locale (fr_FR for instance), some
tests fails because the output doesn't not look like the default one
(without locales).
I believe the failure of these tests are not really bad as it's
Hello .. on the same machine i have several DBs.. i owuld like to do a query
that joins results from different ones .. is ther eany way to do it in
postgres? i would expect something list
select foo1 from database1.mytable,database2.mytable etc.. ec.
but i have found no way..
i woudl be very
[EMAIL PROTECTED] writes:
> I need to be able to talk to the v6.3 server from the new machine.
You'll have to install a 6.3.x libpq and psql for that, I'm afraid.
regards, tom lane
On Thu, 16 Nov 2000, Lisa Reilman wrote:
> This program is suppose to have averagefunc that accepts 5 floating
> point numbers as arguments and return the average to two decimal places.
>
> I keep getting syntax errors on lines 6 & 26 and on line 29 is says
> unspecified a,b,c,d,e.
Not sure what
> I don't care how but I need to emulate ENUM type, just to convert
> MySQL dumps to PostgreSQL. E.g. ENUM values
> stored in MySQL dump should be restorable in Postgres without any
> conversion.
In MySQL, ENUM is like this:
create table blah (
sex ENUM ('M', 'F')
);
This can be emul
My guess is that the problem is a very difficult one to solve well. The
backends have to reliably communicate between each other in order to stop
two processes writing to the one record. The communication times between 2
processes on the one machine and on two different machines would be at least
On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
At first, don't use all caps.
--
Igor' Robul', Unix System Administrator & Programmer @
On Fri, Nov 24, 2000 at 08:35:34AM +0300, some SMTP stream spewed forth:
> On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> > CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
> At first
On Fri, Nov 24, 2000 at 08:35:34AM +0300, Igor' Robul' wrote:
> On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> > CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
> At first, don't use
On Fri, Nov 24, 2000 at 01:32:38AM +0100, Giovanni Tummarello wrote:
> Hello .. on the same machine i have several DBs.. i owuld like to do a query
> that joins results from different ones .. is ther eany way to do it in
> postgres?
It is in the TODO list. Take a look ;)
Greets.
Hello all.
It's like this. ;-)
I have a table with a column that has a default nextval('sequence').
The sequence is a standard increment 1 cycle sequence.
What happens when
the sequence wraps after inserting the
2-million-and-whatever-th row
some of the earlier
Floyd Shackelford writes:
> i created a user using createuser named "user1" with password "password1"
> my pg_hba.conf file has the following entry:
> host all 192.168.1.0 255.255.255.0 password pg_passwd
> i try the following:
> psql -h 192.168.1.200 -d a_database -U user1 -W
> and i enter
Steffen Schmidt writes:
> I'am running several postmaster on different machines, accessing the
> same database in parallel. Is this a good idea?
Not at all. In fact, version 7.0 and later won't even let you do this any
more. Earlier versions where not so careful.
--
Peter Eisentraut [EM
Steffen Schmidt writes:
> > > I'am running several postmaster on different machines, accessing the
> > > same database in parallel. Is this a good idea?
> >
> > Not at all. In fact, version 7.0 and later won't even let you do this any
> > more. Earlier versions where not so careful.
>
> Well,
Olivier Cherrier writes:
> I would like to use pgaccess with a developpement server.
> I red the page "http://www.postgresql.org/docs/admin/x377.htm" but
> didn't understand if I have to include the both "--with-tcl" and
> "--with-x" on the server in the compilation. (The server is a BSD-i386)
Guys, hello.
Here is a problem.
--
-- Creating 2 new functions and new type
--
BEGIN;
CREATE FUNCTION enum_week_in (opaque)
RETURNS int2
AS '
DECLARE
invalue ALIAS for $1;
BEGIN
IF invalue= OR invalue=''0'' THEN RETURN 0; END IF;
37 matches
Mail list logo
