Try pgsendmail.
ftp://ftp.trurl.anything3d.com/pub/Linux/our/pgsendmail-1.1.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/pgsendmail-1.1.tar.gz
Joseph Showalter
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tulio Oliveira
> Sent: Monday, F
Title: RE: [GENERAL] postgresql-tcl-7.03 requires libtcl8.0.so
Mandrake 7.2 includes tcl-8.3.2-4mdk. Make sure this is installed then, as long as thats the only remaining dependency, install postgresql-tcl-7.0.3-2mdk with --nodeps and all seems to work ;-)
Regards
Ben
> -Original Mes
Moin,
is there any way to get the last x records of an query
result?
I can use "... order by x DESC LIMIT n" but I need ASC not
DESC, the last records in the correct order.
Many thanks
Matthias
--
Matthias Teege -- [EMAIL PROTECTED] -- http://emugs.de
make world not war
PGP-Key auf Anfrage
Hi,
My triggers performs a lot of verifications over the data before insert
or update.
So I need make all checks, and at the end, RAISE EXCEPTION msgsErrors;
and the variable msgsErrors containing all Error Messages reported by
hole trigger.
But the RAISE EXCEPTION don't accept variables, on
I have an idea that might help
I found ODBC to be very slow for importing data
So I wrote a program in C that reads in dump files of SQL text on the Linux
server itself
E.G. first line is a create table, next lines are all the insert's
This is very fast, 80mb of data in about 15 minutes
Only prob
On Tue, Feb 27, 2001 at 08:40:27AM -0300, Tulio Oliveira wrote:
> But the RAISE EXCEPTION don't accept variables, only a CONTANT STRING.
>
> Nor strigs concatenation are supported
You can add variables to the string, like this:
RAISE EXCEPTION "Record % has same name as record %", new.
From: "Matthias Teege" <[EMAIL PROTECTED]>
> Moin,
>
> is there any way to get the last x records of an query
> result?
>
> I can use "... order by x DESC LIMIT n" but I need ASC not
> DESC, the last records in the correct order.
If you know how many records there are you could use "LIMIT n OFFS
Does pg_dump work with BLOBs yet ?
terry
> --
> From: Rob Arnold[SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 20, 2001 9:31 PM
> To: Robert Kernell; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: copying tables
>
> use pg_dump with
Hi people,
I'm wondering if postgres could be capable of acting as a
mail storage. This would imply storing messages, from
1KB to > 100MB in size. The expected volume is 4000
messages a day, and the database may store up to,
lets say, 50 messages.
Could postgres cope with this? (How is th
Stephen Livesey wrote:
>
> I am very new to PostgreSQL and have installed v7.03 on a Red Hat Linux
> Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC.
>
> I have created a small file as follows:
> CREATE TABLE expafh (
> postcode CHAR(8) NOT NULL,
> postcode_record_no IN
Jose Manuel Lorenzo Lopez wrote:
> Hi folks,
>
> I noticed a strange behavior of my DB. Let me explain:
>
> I created a table bdf_users as admin user 'postgres' and granted insert
> access for this table to public.
>
> Now I want to insert a line as user 'jose' (That's me!) and got the
> foll
> I'm wondering if postgres could be capable of acting as a
> mail storage. This would imply storing messages, from
> 1KB to > 100MB in size. The expected volume is 4000
> messages a day, and the database may store up to,
> lets say, 50 messages.
>
> Could postgres cope with this? (How is t
I am very new to PostgreSQL and have installed v7.03 on a Red Hat Linux
Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC.
I have created a small file as follows:
CREATE TABLE expafh (
postcode CHAR(8) NOT NULL,
postcode_record_no INT,
street_name CHAR(30),
town CHAR(31),
On Tue, Feb 27, 2001 at 03:49:25PM +0100, Morten W. Petersen wrote:
> Hi people,
>
> I'm wondering if postgres could be capable of acting as a
> mail storage. This would imply storing messages, from
> 1KB to > 100MB in size. The expected volume is 4000
> messages a day, and the database may sto
"Morten W. Petersen" <[EMAIL PROTECTED]> writes:
> I'm wondering if postgres could be capable of acting as a
> mail storage. This would imply storing messages, from
> 1KB to > 100MB in size. The expected volume is 4000
> messages a day, and the database may store up to,
> lets say, 50 messa
We're looking at porting GNU Mailman to use Postgres as a backend,
breaking off the mail handling functionality into free-standing Python
scripts, and allowing for a separate presentation layer as well... looks
promising so far. We'll be doing the development on our greatbridge.org
website -
I want to partial index every table in a inherited tree.
Please let me know how to override the fields along inheritance?
===8<=
CREATE SEQUENCE "a_id_seq" increment 1 minvalue 01 maxvalue
01 start 010001 cache 1;
CREATE TABLE "a" (
"id" int4 DEFAULT
On Tue, 27 Feb 2001, Morten W. Petersen wrote:
> I'm wondering if postgres could be capable of acting as a
> mail storage. This would imply storing messages, from
> 1KB to > 100MB in size. The expected volume is 4000
> messages a day, and the database may store up to,
> lets say, 50 message
Frank Joerdens <[EMAIL PROTECTED]> writes:
> I don't see why it shouldn't work, since 7.1 supports an unlimited row
> width. The question is: Why would you want to do that? A filesystem is
> always faster than a database, which is usually a very important
> consideration with a mailserver (or wer
> It works quite well (designing a web-based system on it right now),
but
> because of a DDB::Pg limit, I can only get 8k into a 'text' field.
So if
> your app is web-based, you might want to not use perl...
Umm... I'm not sure what you're talking about here. I think you are
referring to the 8KB
> > I am very new to PostgreSQL and have installed v7.03 on a Red Hat
Linux
> > Server (v6.2), I am accessing the files using JDBC from a Windows
2000 PC.
> >
> > I have created a small file as follows:
> > CREATE TABLE expafh (
> > postcode CHAR(8) NOT NULL,
> > postcode_record_no INT,
> > street
43 hours? Ouch, that is quite a long time! I'm no expert by any means, but
here are a few tips that I've picked up on this list that might help out:
1. The COPY command is blazing fast for importing, if you are certain your
input is clean, this is the way to go. Read more about that here:
http://
> Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC.
I don't use Microsoft software, nor Java, but a few general suggestions
for you:
- you may want to create the INDEX at the end (using CREATE INDEX)
in one operation
- you may want to run your requests in trans
"Richard Huxton" <[EMAIL PROTECTED]> writes:
> From: "Matthias Teege" <[EMAIL PROTECTED]>
>> is there any way to get the last x records of an query
>> result?
> Otherwise, the only thing that I can think of is to set up a view that does
> the LIMIT n on a DESC then sort ASC when selecting on that
On Tue, 27 Feb 2001, Bruce Richardson wrote:
> Discovering that text fields in Postgres are case sensitive - so "Text"
> <> "text" and both can go into the same UNIQUE column - threw me a bit,
> as this is different from other databases I've worked with.
>
> Is there a toggle to turn off case se
johnchildress writes:
> I tried to look for the answer before posting, but I couldn't find anything.
> I am attempting to install Postgres on Redhat 7 (or 6.2) and after I run
> "./configure", then "gmake" the install enters an "infinate loop".
What PostgreSQL version? What gmake version? If y
Peter,
I am sorry for wasting your time. My problem had nothing to do with
PostgreSQL. My system time was incorrect, it had a year of 1980. When I
corrected this the install went great.
Thanks,
John
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "johnchildress"
Bruce Richardson wrote:
>Discovering that text fields in Postgres are case sensitive - so "Text"
><> "text" and both can go into the same UNIQUE column - threw me a bit,
>as this is different from other databases I've worked with.
Well, they are different, aren't they?
>Is there a togg
-Mensaje original-
De: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: martes 27 de febrero de 2001 14:06
Asunto: Re: [GENERAL] Migrate from MS SQL 6.5 to postgres??
>
>I have an idea that might help
>I found ODBC to be very slow for importing da
Nico wrote:
>I want to partial index every table in a inherited tree.
>Please let me know how to override the fields along inheritance?
There is currently no facility that I know of for doing this.
It would be nice to be able to attach a column to an existing index.
--
Oliver Elphick
I am wondering if a very useful feature of some DB's is available in
postgres
For example in DB2 you can execute SQL from the command line (via terminal
emulator)
It will perform it entirely then display the results, but only one page at
a time
You can then page down and page up within the result
On Tue, 27 Feb 2001 [EMAIL PROTECTED] wrote:
> I notice that PSQL doesn't do this which makes large tables difficult to
> maintain
This is already implemented in psql - you have to make sure your PAGER
environment variable is set correctly - there might be some other
requirements that I'm not fa
On Wed, Feb 28, 2001 at 01:12:47PM +1100, Andrew Snow wrote:
> Plus it might be a good idea if people teamed up and co-authored a book! I
> personally would be interested in writing something about functions and
> PL/PGSQL and so on, as it seems to me there needs to be somewhere with more
> examp
when upgrading from version X to version Y of postgres, the
install appears to dump the data and schema, and then suck it
back in with the new binaries.
[i just tried going from 6.5.3 to 7.0.3potato but the plpgsql.so
module wasn't installed and data types were conflicting, so the
new schema is a
Hi,
Is there some kind of command or internal PostgreSql
column to find out when a table was last changed (INSERT, UPDATE
or DELETE) on a 7.0.2 Server ?
thanks,
Markus
--
Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/
EMail: [EMAIL PROTECTED]
PGP Public Ke
Currently there is no way to acces more than one db at a time.. But i
heard that there will be implementation of schema pretty soon..
Anand
On Tue, Feb 27, 2001 at 06:09:03PM -0600, will trillich wrote:
>how can i join separate DATABASES?
>
> select
> a.fld1,b.fld2
> f
At 02:25 PM 27-02-2001 -0500, Tom Lane wrote:
>
>> Is this sort of degradation normal using a PostgreSQL database?
>
>No, it's not. Do you have any triggers or rules on this table that
I find slowdowns with inserts with rollbacks and updates with commits ( no
triggers or rules) :(.
But no not
No u need to maintain this information in another column such as
last_update_date which your application should update everyt time u
perform any operation on it..
Hope this helps
Anand
On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
>Hi,
> Is there some kind of command or i
Oliver Elphick wrote:
>
> will trillich wrote:
> >aha. i found /var/lib/postgresql/data/automatic_update.log
> >containing, among other things:
> >
> >[snip]
> >You are now connected to database template1 as user will.
> >CREATE DATABASE
> >You are now connected to database puz as u
Aah! Life is so good when things are working.
Thanks very much.
Regards,
Bill
--- "Trewern, Ben" <[EMAIL PROTECTED]> wrote:
> Mandrake 7.2 includes tcl-8.3.2-4mdk. Make sure
> this is installed then, as
> long as thats the only remaining dependency, install
> postgresql-tcl-7.0.3-2mdk with
I'm wandering what is the best way to get all user fields from a table using
SQL.
With following SQL, I get extra field names that is not defined by user.
(cmax,
cmin, etc)
select a.attname from pg_class as c, pg_attribute as a where c.oid =
a.attrelid and c.relname = 'table_name';
It seems pg_a
"Yasuo Ohgaki" <[EMAIL PROTECTED]> writes:
> It seems pg_attribute does not have flag to distinguish user defined fields.
attnum > 0 indicates a user field.
regards, tom lane
Hi, After listening to others it seems best to run 7.0 and so rather than
carry on I decided to remove all traces of 6.5 and install 7.0 once I have
downloaded it. (have not had chance yet, hope to tonight)
At the same time while removing 6.5 I did notice a running of postmaster at
the end of my
Oliver Elphick wrote:
> will trillich wrote:
> >-rw---1 postgres postgres4 Feb 27 12:24 PG_VERSION
> >-rw---1 postgres postgres0 Oct 13 21:05 active
> >-rw---1 postgres postgres 8192 Feb 27 04:00 cust
> >-rw---1 postgres postgres16384
will trillich wrote:
>> >-rw---1 postgres postgres 8192 Feb 27 04:00 range
>> >-rw---1 postgres postgres16384 Feb 11 07:39 range_pkey
>> >actually, i think the 'range' table is the main one i need to
>> >resurrect... everything else is gravy.
>>
>> Wha
On Wed, Feb 28, 2001 at 06:52:01AM +, Oliver Elphick wrote:
> A pity the dump file got clobbered.
indeed!
> I suspect the dump from 6.5 was
> in a form that 7.0 rejected - you had those two failed creates in the
> log.
the problem was apparently
DEFAULT TEXT 'CURRENT_DATE'
in the da
46 matches
Mail list logo
