limit select question

Started by Kevin Heflinabout 27 years ago8 messagesgeneral

kheflin@shreve.net

about 27 years ago

I've been asked if there is a way to LIMIT the number of results displayed
when doing a SELECT with postgresql, by a former user of mysql. Wasn't
sure if there is an easy way to do this or not. I've don't it before, but
in a very round about way... any suggestions.

with mySQL and SELECT queries
you can LIMIT the number of results displayed to the screen. I can't
seem to find any such switch in the SELECT commands in postgres.

Kevin

--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

Michael Davis

michael.davis@prevuenet.com

about 27 years ago

In reply to: Kevin Heflin (#1)

RE: [GENERAL] limit select question

Select * From table_name limit 1;

-----Original Message-----
From: Kevin Heflin [SMTP:kheflin@shreve.net]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject: [GENERAL] limit select question

I've been asked if there is a way to LIMIT the number of results
displayed
when doing a SELECT with postgresql, by a former user of mysql.
Wasn't
sure if there is an easy way to do this or not. I've don't it
before, but
in a very round about way... any suggestions.

with mySQL and SELECT queries
you can LIMIT the number of results displayed to the screen. I

can't

seem to find any such switch in the SELECT commands in postgres.

Kevin

Import Notes

Resolved by subject fallback

Kevin Heflin

kheflin@shreve.net

about 27 years ago

In reply to: Michael Davis (#2)

RE: [GENERAL] limit select question

On Wed, 31 Mar 1999, Michael Davis wrote:

Select * From table_name limit 1;

I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or near "1"

I was told I could gain this feature by adding the 6.4.2 feature patch.
But when I tried installing the patch, anything and everything I tried in
psql failed with an error on 'select'

Kevin

Kevin Heflin

kheflin@shreve.net

about 27 years ago

In reply to: Kevin Heflin (#3)

RE: [GENERAL] limit select question

On Wed, 31 Mar 1999, Michael Davis wrote:

Good point. I am running 6.5. So it has been fixed. I am not sure what
patch is needed to make this work on 6.4.2.

Is version 6.5 to be had some where, or is it only in beta?

I sure could use that feature on a project I'm working on right now...

Kevin

Import Notes

Reply to msg id not found: 93C04F1F5173D211A27900105AA8FCFC145301@lambic.prevuenet.com | Resolved by subject fallback

Michael Davis

michael.davis@prevuenet.com

about 27 years ago

In reply to: Kevin Heflin (#4)

RE: [GENERAL] limit select question

Good point. I am running 6.5. So it has been fixed. I am not sure what
patch is needed to make this work on 6.4.2.

-----Original Message-----
From: Kevin Heflin [SMTP:kheflin@shreve.net]
Sent: Wednesday, March 31, 1999 12:26 AM
To: Michael Davis
Cc: PGSQL-General (E-mail)
Subject: RE: [GENERAL] limit select question

On Wed, 31 Mar 1999, Michael Davis wrote:

Select * From table_name limit 1;

I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or near "1"

I was told I could gain this feature by adding the 6.4.2 feature
patch.
But when I tried installing the patch, anything and everything I
tried in
psql failed with an error on 'select'

Kevin

Import Notes

Resolved by subject fallback

Michael Davis

michael.davis@prevuenet.com

about 27 years ago

In reply to: Michael Davis (#5)

RE: [GENERAL] limit select question

It entered into beta test this week. There are several features that I
really need so am jumping in early. You have to know how/where to get the
source code because it will not even be available for download until next
week.

-----Original Message-----
From: Kevin Heflin [SMTP:kheflin@shreve.net]
Sent: Wednesday, March 31, 1999 12:30 AM
To: Michael Davis
Cc: PGSQL-General (E-mail)
Subject: RE: [GENERAL] limit select question

On Wed, 31 Mar 1999, Michael Davis wrote:

Good point. I am running 6.5. So it has been fixed. I am not

sure what

patch is needed to make this work on 6.4.2.

Is version 6.5 to be had some where, or is it only in beta?

I sure could use that feature on a project I'm working on right
now...

Kevin

Import Notes

Resolved by subject fallback

Rudy Gireyev

rgireyev@cnmnetwork.com

about 27 years ago

In reply to: Michael Davis (#2)

RE: [GENERAL] limit select question

May be I'm missing something, but why not use the cursor?
Do the select once and then fetch as many rows as you need.

Rudy

On 31 Mar 99, at 1:20, Michael Davis wrote:

Show quoted text

Select * From table_name limit 1;

-----Original Message-----
From: Kevin Heflin [SMTP:kheflin@shreve.net]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject: [GENERAL] limit select question

I've been asked if there is a way to LIMIT the number of results
displayed
when doing a SELECT with postgresql, by a former user of mysql.
Wasn't
sure if there is an easy way to do this or not. I've don't it
before, but
in a very round about way... any suggestions.

with mySQL and SELECT queries
you can LIMIT the number of results displayed to the screen. I

can't

seem to find any such switch in the SELECT commands in postgres.

Kevin

--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

Chris Bitmead

chris.bitmead@bigfoot.com

about 26 years ago

In reply to: Kevin Heflin (#1)

Re: [GENERAL] limit select question

Kevin Heflin wrote:

I've been asked if there is a way to LIMIT the number of results displayed
when doing a SELECT with postgresql, by a former user of mysql. Wasn't
sure if there is an easy way to do this or not. I've don't it before, but
in a very round about way... any suggestions.

I'm not an expert, but why not just read X results from the portal, then
close the portal? That is what I'm doing.

From bouncefilter Mon Feb 28 10:51:06 2000
Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA22034
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 10:50:50 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.27.61.251]) by Mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Mon, 28 Feb 2000 09:39:13 -0600
Sender: ed
Message-ID: <38BA99BA.645FA078@austin.rr.com>
Date: Mon, 28 Feb 2000 09:52:26 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Bruce Momjian <pgman@candle.pha.pa.us>
CC: Serge Sozonoff <serge@globalbeach.com>, pgsql-general@postgresql.org
Subject: Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)
References: <200002280931.EAA23527@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bruce Momjian wrote:

If I have 40 tables and each table is made up of 6-7 files including
index's etc then that
means that per process I could be opening up to 200-240 !!

This means that with 64 db connections I could be hitting 12800-15360 open
files
on my system!!! What is the current Linux limit without kernel re-compile?
What is the Linux
limit with kernel re-compile?

Why can't I just tell postgres to close thos files say 2 minutes after he
is done with them
and they have been idle?

Take a look at /pg/backend/storage/file/fd.c::pg_nofile(). If you
change the line:

This actually brings up a good point. We currently cache all
descriptors up to the limit the OS will allow for a process.

Is this too aggressive? Should we limit it to 50% of the maximum?

Seems difficulty to guess correctly on one setting for all. How
difficult would it be to make the limit configurable so that folks
could set it as a hard limit (eg. 100 open files per backend or 1000
per server) or a percentage of OS max? SET would seem most convenient
from a user point of view, but even something for configure would be
very useful in managing resources.

Cheers,
Ed Loehr

From bouncefilter Mon Feb 28 11:00:22 2000
Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu
[128.42.12.154])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA23369
for <pgsql-general@hub.org>; Mon, 28 Feb 2000 10:59:45 -0500 (EST)
(envelope-from reedstrm@wallace.ece.rice.edu)
Received: by wallace.ece.rice.edu via sendmail from stdin
id <m12PSaC-000LEMC@wallace.ece.rice.edu> (Debian Smail3.2.0.102)
for pgsql-general@hub.org; Mon, 28 Feb 2000 09:59:40 -0600 (CST)
Date: Mon, 28 Feb 2000 09:59:40 -0600
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: Henrique Pantarotto <pantarotto@terra.com.br>
Cc: pgsql-general@hub.org
Subject: Re: RES: [GENERAL] Stored procedures returning multiple values... ?
Message-ID: <20000228095940.A6978@rice.edu>
References: <NDBBKPBFKLCBCDCDMPOLKEBECBAA.pantarotto@terra.com.br>
<NDBBKPBFKLCBCDCDMPOLEEDECBAA.pantarotto@terra.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.0i
In-Reply-To: <NDBBKPBFKLCBCDCDMPOLEEDECBAA.pantarotto@terra.com.br>;
from pantarotto@terra.com.br on Mon, Feb 28, 2000 at 08:53:09AM
-0300

Henrique -
No, not stupid, just hard. I find it interesting that I read your
repost of your question immediately following a pair of postings to the
PGSQL-HACKERS list by Karel Zak about his implementation of cached/stored
procedures. ;-)

As it stands, the "stored procedures" in pgsql are really user defined
functions, and can only return values. Changing that is a major amount
of work, and hasn't happened for 7.0 (or 7.1) Karel Zak's work is also
post 7.0, I believe, unless The Powers That Be (the core developers)
decide that his changes are sufficently isolated s othat any bugs are
unlikely to affect other code.

In other words, no not yet, but soon!

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

On Mon, Feb 28, 2000 at 08:53:09AM -0300, Henrique Pantarotto wrote:

Is my question stupid? ;-)

-----Mensagem original-----
De: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]Em nome de Henrique
Pantarotto
Enviada em: Sexta-feira, 25 de Fevereiro de 2000 09:27
Para: pgsql-general@hub.org
Assunto: [GENERAL] Stored procedures returning multiple values... ?

Hello friends,

many months ago I starting messing with stored procedures with PostgreSQL,
and at the time, I found out that I could only return "one" value when I
used a stored procedure.

I was wondering if this has changed or has/will/could be
changed/implemented
with PostgreSQL 7.0?

It would be fun if stored procedured could return multiple
values, wouldn't
it? ;-)

Thanks,
___________________________________________
Henrique Pantarotto
Administrador de Sistemas - SITE S��o Paulo
Terra Networks Brasil S/A
A Internet do Brasil agora �� TERRA
Tel: (11) 5505-5728 r.214/260/238
ICQ: 6934285
pantarotto@terra.com.br
<Hatuna Matata, �� liiiinndo dizer!>

************

************

From bouncefilter Mon Feb 28 11:04:05 2000
Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA23897
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 11:03:49 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.27.61.251]) by Mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Mon, 28 Feb 2000 09:53:16 -0600
Sender: ed
Message-ID: <38BA9D05.19B76487@austin.rr.com>
Date: Mon, 28 Feb 2000 10:06:29 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pg-gen <pgsql-general@postgresql.org>
Subject: [GENERAL] RFC: Experiences with EARP?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Is anyone using EARP? Any testimonials (good/bad)?

Cheers,
Ed Loehr

From bouncefilter Mon Feb 28 11:40:08 2000
Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA37140
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 11:39:16 -0500 (EST)
(envelope-from keithmur@mindspring.com)
Received: from mindspring.com (pool-209-138-139-239-atln.grid.net
[209.138.139.239])
by smtp6.mindspring.com (8.9.3/8.8.5) with ESMTP id LAA21068
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 11:39:11 -0500 (EST)
Message-ID: <38BAA5ED.8C0B130F@mindspring.com>
Date: Mon, 28 Feb 2000 10:44:29 -0600
From: "Keith G. Murphy" <keithmur@mindspring.com>
Reply-To: keithmur@mindspring.com
Organization: A small shoebox in the middle of the road
X-Mailer: Mozilla 4.7 [en] (Win95; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Re: [HACKERS] TRANSACTIONS
References:
<Pine.LNX.4.10.10002251726100.20593-100000@picasso.realtyideas.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

kaiq@realtyideas.com wrote:

On Fri, 25 Feb 2000, Karl DeBisschop wrote:

From: <kaiq@realtyideas.com>
On Fri, 25 Feb 2000, Karl DeBisschop wrote:

To summarize, I stated that the following does not work with
postgresql:

$dbh->{AutoCommit} = 0;
$dbh->do("CREATE TABLE tmp (a int unique,b int)");
$rtv = $dbh->do("INSERT INTO tmp VALUES ($1,$2)");
if ($rtv) {$dbh->do("UPDATE tmp SET b=$2 where a=$1")};
$dbh->commit;
$dbh->disconnect;

The usefulness of the idion is that in a mutli-user environment, this
is a basic way to update data that may or may not already have a key
in the table. You can't do a "SELECT COUNT" because in the time
between when you SELECT and INSERT (assuming the key is not already
there) someone may have done a separate insert. The only other way I
know to do this is to lock the entire table against INSERTs which has
obvious performance effects.

sounds right, but ;-) why you use the transaction in the first place?

Rememeber that this is just an example to illustrate what sort of
behaviour one user would find useful in tranasctions, so it is a
little simplistic. Not overly simplistic, though, I think.

I'd want a transaction because I'm doing a bulk insert into this live
database - say syncing in a bunch of data from a slave server while
the master is still running. If one (or more) insert(s) fail, I want
to revert back to the starting pint so I can fix the cause of the
failed insert and try again with the database in a known state.
(there may, for instance, be relationships beteewn the b field such
that if only part of the bulk insert suceeds, the database is rendered
corrupt).

thanks. I'm on your side now ;-) -- it is a useful senario.
the question are: 1) can nested transaction be typically interpreted
to handle this situation? If is is, then, it should be handled by that
"advanced feature", not plain transaction ;

I guess like this (got rid of AutoCommit, because that looks funny
nested):

$dbh->RaiseError = 1;
$dbh->StartTransaction;
eval {
$dbh->do("CREATE TABLE tmp (a int unique,b int)");
while (blahblahblah) {
$dbh->StartTransaction;
eval {
$dbh->do("INSERT INTO tmp VALUES ($1,$2)");
};
if ($@) {
$dbh->Rollback;
{$dbh->do("UPDATE tmp SET b=$2 where a=$1")};
} else {
$dbh->Commit;
}
}
}
if ($@) {
$dbh->rollback;
} else {
$dbh->commit;
}
$dbh->disconnect;

I.e., try the INSERT within the inner transaction; if it fails, roll it
back and do the UPDATE; if that fails, blow out the whole outer
transaction.

You could do the whole thing checking a return value as in the original
example, but the eval and RaiseError are canonical, according the the
docs.

2) on the other hand, can sql92's (plain) transaction be interpreted
in the way that above behavior is legitimate?

Well, I'm not sure of the necessity of nested transactions in the case
of continuing a transaction after a single-row insert has failed, but
that's implementation details I'm not familiar with... i.e., I'm not
having to code the danged thing!

From bouncefilter Mon Feb 28 12:03:07 2000
Received: from hotmail.com (f172.law4.hotmail.com [216.33.149.172])
by hub.org (8.9.3/8.9.3) with SMTP id MAA40845
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 12:03:00 -0500 (EST)
(envelope-from sheilabel@hotmail.com)
Received: (qmail 42011 invoked by uid 0); 28 Feb 2000 17:02:26 -0000
Message-ID: <20000228170226.42010.qmail@hotmail.com>
Received: from 24.141.58.44 by www.hotmail.com with HTTP;
Mon, 28 Feb 2000 09:02:26 PST
X-Originating-IP: [24.141.58.44]
From: "sheila bel" <sheilabel@hotmail.com>
To: eloehr@austin.rr.com, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] RFC: Experiences with EARP?
Date: Mon, 28 Feb 2000 17:02:26 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

EARP was an interesting experience!
I wanted to use it too, sounded like a useful tool.
BUT when I ftp'd to their site in the directory
where they say you can find their files which is :
'pub/unix/earp'
nothing is in there !!! No files to download.
I emailed them, never got a response so I guess that
concludes my experience. Please let me know if you
have any luck with it, I'd really like to know :)
-Sheila
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Mon Feb 28 03:16:59 2000
Received: from infinet.ch ([207.207.66.115])
by hub.org (8.9.3/8.9.3) with ESMTP id DAA76321
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 03:16:37 -0500 (EST)
(envelope-from serge@globalbeach.com)
Received: from sony [195.15.85.135] by infinet.ch
(SMTPD32-5.05) id AE5A2C1027A; Mon, 28 Feb 2000 00:14:18 -0800
Message-Id: <4.1.20000228091634.00a99d40@mailgate.globalbeach.com>
X-Sender: serge@mailgate.globalbeach.com
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1
Date: Mon, 28 Feb 2000 09:22:06 -0800
To: pgsql-general@postgreSQL.org
From: Serge Sozonoff <serge@globalbeach.com>
Subject: Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)
In-Reply-To: <200002220120.UAA20677@candle.pha.pa.us>
References: <3.0.5.32.20000222090347.00914400@pop.mecomb.po.my>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Hi all,

But doesn't the backend close the files after it's done with em? Or it
doesn't know when it's done with the files?

I've really nothing against native americans, is there a way to throttle or
fix our good ol elephant instead?

Keeps files open in the expectation it may need them again.

Well, is there not a way to tell Postgres to close the files when he is
finished?

If I have 40 tables and each table is made up of 6-7 files including
index's etc then that
means that per process I could be opening up to 200-240 !!

This means that with 64 db connections I could be hitting 12800-15360 open
files
on my system!!! What is the current Linux limit without kernel re-compile?
What is the Linux
limit with kernel re-compile?

Why can't I just tell postgres to close thos files say 2 minutes after he
is done with them
and they have been idle?

Thanks, Serge

From bouncefilter Mon Feb 28 12:31:08 2000
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA44418
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 12:31:05 -0500 (EST)
(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
MAA06706;
Mon, 28 Feb 2000 12:25:05 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200002281725.MAA06706@candle.pha.pa.us>
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <14522.25770.886051.723043@localhost.localnet> from Ulf Mehlig at
"Feb 28, 2000 01:06:02 pm"
To: Ulf Mehlig <umehlig@uni-bremen.de>
Date: Mon, 28 Feb 2000 12:25:05 -0500 (EST)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL72 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

I have tried the postgreSQL 7.0.0 beta, and, so far, the only problem
I encountered that was unknown to me (and the TODO-list) was a core
dump of pgsql when I tried to import the data from a pg_dump'ed SQL
file under the "wrong" user ID (I dumped the data as user "xxx" and
tried to import them as "yyy"):

----------------------------------------------------------------------
yyy@abc yyy]$ /usr/local/pgsql/bin/psql < data.sql
#\connect: FATAL 1: SetUserId: user 'xxx' is not in 'pg_shadow'
Segmentation fault (core dumped)

Are we getting core dumps in this case. I can't seem to reproduce it.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Mon Feb 28 13:17:07 2000
Received: from twakcax1.twa.com ([207.238.241.218])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA49405
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 13:16:32 -0500 (EST) (envelope-from KJJACKS@twa.com)
Received: by twakcax1.twa.com with Internet Mail Service (5.5.2448.0)
id <1H742DJ5>; Mon, 28 Feb 2000 12:15:40 -0600
Message-ID: <9D546E233EDED21180EC0090273C5BAD01D65912@twakcax2.twa.com>
From: "Jackson, Kevin J." <KJJACKS@twa.com>
To: "'pgsql-general@postgresql.org'" <pgsql-general@postgresql.org>
Subject: What is wrong with this query?
Date: Mon, 28 Feb 2000 12:10:34 -0600
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
charset="iso-8859-1"

Here's the query:

CREATE TABLE project_request (submit_date date ,
projectid serial ,
contact varchar not null ,
department varchar not null ,
telephone varchar not null ,
email varchar not null ,
project_name varchar not null ,
projectgoal1 varchar not null ,
projectgoal2 varchar ,
projectgoal3 varchar ,
projectgoal4 varchar ,
projectgoal5 varchar ,
projectgoal6 varchar ,
projectgoal7 varchar ,
PRIMARY KEY (projectid),
INDEX (projectid, project_name, email),
UNIQUE (projectid, project_name));

Here's the error I message I get:

ERROR: parser: parse error at or near "("

Please respond by email, as I am currently unable to get the list here at
work. (Curse those corprate amerver sysadmins!)

TIA!

Kevin J. Jackson
Internet Support/Development Specialist
TWA
kjjacks@twa.com
http://www.twa.com

From bouncefilter Mon Feb 28 13:21:08 2000
Received: from srv9-sao.sao.zaz.com.br (srv9-sao.sao.zaz.com.br
[200.246.248.46]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA49651
for <pgsql-general@hub.org>; Mon, 28 Feb 2000 13:20:28 -0500 (EST)
(envelope-from pantarotto@terra.com.br)
Received: from winlinux (winlinux.sao.zaz.com.br [200.246.248.236])
by srv9-sao.sao.zaz.com.br (8.9.3/8.9.3) with SMTP id PAA28387;
Mon, 28 Feb 2000 15:20:07 -0300
From: "Henrique Pantarotto" <pantarotto@terra.com.br>
To: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
Cc: <pgsql-general@hub.org>
Subject: RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Date: Mon, 28 Feb 2000 15:20:06 -0300
Message-ID: <NDBBKPBFKLCBCDCDMPOLEEDNCBAA.pantarotto@terra.com.br>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
In-Reply-To: <20000228095940.A6978@rice.edu>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

Ross, thank you for your reply!

Pgsql developers has done a great job so far, and I am sure things will keep
like that.

Thanks and regards from Brazil,
___________________________________________
Henrique Pantarotto
Administrador de Sistemas - SITE S��o Paulo
Terra Networks Brasil S/A
A Internet do Brasil agora �� TERRA
Tel: (11) 5505-5728 r.214/260/238
ICQ: 6934285
pantarotto@terra.com.br
<Hatuna Matata, �� liiiinndo dizer!>

-----Original Message-----
From: Ross J. Reedstrom [mailto:reedstrm@wallace.ece.rice.edu]
Sent: Monday, February 28, 2000 1:00 PM
To: Henrique Pantarotto
Cc: pgsql-general@hub.org
Subject: Re: RES: [GENERAL] Stored procedures returning multiple
values... ?

Henrique -
No, not stupid, just hard. I find it interesting that I read your
repost of your question immediately following a pair of postings to the
PGSQL-HACKERS list by Karel Zak about his implementation of cached/stored
procedures. ;-)

As it stands, the "stored procedures" in pgsql are really user defined
functions, and can only return values. Changing that is a major amount
of work, and hasn't happened for 7.0 (or 7.1) Karel Zak's work is also
post 7.0, I believe, unless The Powers That Be (the core developers)
decide that his changes are sufficently isolated s othat any bugs are
unlikely to affect other code.

In other words, no not yet, but soon!

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

On Mon, Feb 28, 2000 at 08:53:09AM -0300, Henrique Pantarotto wrote:

Is my question stupid? ;-)

-----Mensagem original-----
De: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]Em nome de Henrique
Pantarotto
Enviada em: Sexta-feira, 25 de Fevereiro de 2000 09:27
Para: pgsql-general@hub.org
Assunto: [GENERAL] Stored procedures returning multiple values... ?

Hello friends,

many months ago I starting messing with stored procedures

with PostgreSQL,

and at the time, I found out that I could only return "one"

value when I

used a stored procedure.

I was wondering if this has changed or has/will/could be
changed/implemented
with PostgreSQL 7.0?

It would be fun if stored procedured could return multiple
values, wouldn't
it? ;-)

Thanks,
___________________________________________
Henrique Pantarotto
Administrador de Sistemas - SITE S��o Paulo
Terra Networks Brasil S/A
A Internet do Brasil agora �� TERRA
Tel: (11) 5505-5728 r.214/260/238
ICQ: 6934285
pantarotto@terra.com.br
<Hatuna Matata, �� liiiinndo dizer!>

************

************

From bouncefilter Mon Feb 28 14:32:09 2000
Received: from fep10-svc.tin.it (mta10-acc.tin.it [212.216.176.41])
by hub.org (8.9.3/8.9.3) with ESMTP id OAA59973
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 14:31:36 -0500 (EST)
(envelope-from sandro@bluff.ermit.it)
Received: from bluff.ermit.it ([213.45.133.105]) by fep10-svc.tin.it
(InterMail v4.01.01.02 201-229-111-106) with ESMTP
id <20000228193101.ZYIY25682.fep10-svc@bluff.ermit.it>
for <pgsql-general@postgresql.org>; Mon, 28 Feb 2000 20:31:01 +0100
Received: (from sandro@localhost) by bluff.ermit.it (8.9.3/8.8.5) id UAA09349
for pgsql-general@postgresql.org; Mon, 28 Feb 2000 20:21:58 +0100
Message-Id: <200002281921.UAA09349@bluff.ermit.it>
Subject: Keeping 2 db updated each-other
To: pgsql-general@postgresql.org
Date: Mon, 28 Feb 2000 20:21:57 +0100 (CET)
From: Sandro Dentella <sandro.dentella@mi.infn.it>
Reply-To: sandro.dentella@mi.infn.it
X-Mailer: ELM [version 2.5 PL1]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I need to keep updated to databases (little ~ 100.000 record splitted in 15
tables). Is there any general tip?

Since the database is handles via tcl-tk I'm logging all
update/delete/insert so as to pass the whole bunch of 'not yet updated'
statement to the database that needs updating. This requires having all
statements referenced w/ primary key becouse OID are different on different
hosts. This seems to work but is quite tricky.

Is there a better solution?

Thanks in advance
sandro

--
Sandro Dentella *:-)
e-mail: sandro.dentella@mi.infn.it sandro@ermit.it

From bouncefilter Mon Feb 28 18:18:10 2000
Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236])
by hub.org (8.9.3/8.9.3) with ESMTP id SAA78894
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 18:17:27 -0500 (EST)
(envelope-from peter@localhost.its.uu.se)
Received: from regulus.its.uu.se ([130.238.7.19]:63975 "EHLO
regulus.its.uu.se")
by merganser.its.uu.se with ESMTP id <S352273AbQB1XQm>;
Tue, 29 Feb 2000 00:16:42 +0100
Received: from peter (helo=localhost)
by regulus.its.uu.se with local-esmtp (Exim 3.02 #2)
id 12PZS5-0001FC-00; Tue, 29 Feb 2000 00:19:45 +0100
Date: Tue, 29 Feb 2000 00:19:44 +0100 (CET)
From: Peter Eisentraut <peter_e@gmx.net>
To: Ulf Mehlig <umehlig@uni-bremen.de>
cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <14522.25770.886051.723043@localhost.localnet>
Message-ID: <Pine.LNX.4.21.0002290010270.3511-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: 8BIT
Sender: Peter Eisentraut <peter@hub.org>

Ulf Mehlig writes:

yyy@abc yyy]$ /usr/local/pgsql/bin/psql < data.sql
#\connect: FATAL 1: SetUserId: user 'xxx' is not in 'pg_shadow'
Segmentation fault (core dumped)

I can't reproduce that. I need a complete test case, and if you would a
stack backtrace. (Start 'gdb psql core' and enter 'bt'.) Please also check
the authentication you have set up on the database in question.

--
Peter Eisentraut Sernanders v��g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

From bouncefilter Mon Feb 28 19:52:11 2000
Received: from inet03.citec.qld.gov.au (firewall-user@inet03.citec.qld.gov.au
[203.5.10.10]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA91165
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 19:51:51 -0500 (EST)
(envelope-from Geoff.Moss@qr.com.au)
Received: by inet03.citec.qld.gov.au; id KAA03077;
Tue, 29 Feb 2000 10:51:44 +1000 (EST)
Received: from bne104f5.qr.com.au(h147132129002.qr.com.au 147.132.129.2) by
inet03.citec.qld.gov.au via smap (V2.0)
id xma016071; Tue, 29 Feb 00 10:41:48 +1000
Received: from bne104e4.qrail.com.au (unverified) by bne104f5.qr.com.au
(Content Technologies SMTPRS 2.0.15) with ESMTP id
<B0001191832@bne104f5.qr.com.au> for <pgsql-general@postgreSQL.org>;
Tue, 29 Feb 2000 10:39:58 +1000
Received: by bne104e4.qr.com.au with Internet Mail Service (5.5.2448.0)
id <FXB2HM24>; Tue, 29 Feb 2000 10:43:03 +1000
Message-Id: <551D8400D4F2D211B5B300105A606D8201123862@bne104e2.qrail.com.au>
From: "Moss, Geoff" <Geoff.Moss@qr.com.au>
To: "'pgsql-general@postgreSQL.org'" <pgsql-general@postgresql.org>
Subject:
Date: Tue, 29 Feb 2000 10:43:01 +1000
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
charset="ISO-8859-1"

subscribe
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager of Queensland Rail.

This message has been swept by MIMESweeper for the presence of computer
viruses. No warranty is given that this message upon its receipt is
virus free and no liability is accepted by the sender in this respect.

This email is a message only; does not constitute advice and should not
be relied upon as such.
**********************************************************************

From bouncefilter Tue Feb 29 03:45:16 2000
Received: from hotmail.com (law-f47.hotmail.com [209.185.130.35])
by hub.org (8.9.3/8.9.3) with SMTP id DAA70313
for <pgsql-general@postgreSQL.org>;
Tue, 29 Feb 2000 03:44:20 -0500 (EST)
(envelope-from oomoomi@hotmail.com)
Received: (qmail 11718 invoked by uid 0); 29 Feb 2000 08:43:49 -0000
Message-ID: <20000229084349.11717.qmail@hotmail.com>
Received: from 195.200.226.110 by www.hotmail.com with HTTP;
Tue, 29 Feb 2000 00:43:48 PST
X-Originating-IP: [195.200.226.110]
From: "omid omoomi" <oomoomi@hotmail.com>
To: sheilabel@hotmail.com
Cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
Date: Tue, 29 Feb 2000 00:43:48 PST
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

Hi,
Take a look at date_part() function . it is useful to extract any part(
day,dow,month, year, ...) from a datetime variable.you may use now()
function to catch the current system datetime.
Also there is an internal search ingine on postgresql.org site, which may be
used as a useful search tool inside the docs.

regards
omid.

From: "sheila bel" <sheilabel@hotmail.com>
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
Date: Tue, 29 Feb 2000 00:51:46 GMT

Hi all,

I wanted to get some information about date and time
stamps and examples of how to use them. In the User
Manual I got referred to functions called CURRENT_DATE,
CURRENT_TIME. I have been literally searching for
hours to find more about them in all the PostgreSQL
manuals, I've used ALL the search engines and did not
find anything. If there is a reference to them they should
be somewhere in there, right?
I'm sorry but dear developers your manual is not user
friendly at all :(
A lot of time gets wasted on finding the information you
need or not finding them at all.

-Sheila

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

************

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Mon Feb 28 19:53:11 2000
Received: from hotmail.com (f234.law4.hotmail.com [216.33.149.234])
by hub.org (8.9.3/8.9.3) with SMTP id TAA91192
for <pgsql-general@postgresql.org>;
Mon, 28 Feb 2000 19:52:18 -0500 (EST)
(envelope-from sheilabel@hotmail.com)
Received: (qmail 6696 invoked by uid 0); 29 Feb 2000 00:51:46 -0000
Message-ID: <20000229005146.6695.qmail@hotmail.com>
Received: from 24.141.58.44 by www.hotmail.com with HTTP;
Mon, 28 Feb 2000 16:51:46 PST
X-Originating-IP: [24.141.58.44]
From: "sheila bel" <sheilabel@hotmail.com>
To: pgsql-general@postgresql.org
Subject: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
Date: Tue, 29 Feb 2000 00:51:46 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

Hi all,

I wanted to get some information about date and time
stamps and examples of how to use them. In the User
Manual I got referred to functions called CURRENT_DATE,
CURRENT_TIME. I have been literally searching for
hours to find more about them in all the PostgreSQL
manuals, I've used ALL the search engines and did not
find anything. If there is a reference to them they should
be somewhere in there, right?
I'm sorry but dear developers your manual is not user
friendly at all :(
A lot of time gets wasted on finding the information you
need or not finding them at all.

-Sheila

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

From bouncefilter Mon Feb 28 20:11:11 2000
Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2])
by hub.org (8.9.3/8.9.3) with ESMTP id UAA93146
for <pgsql-general@postgreSQL.org>;
Mon, 28 Feb 2000 20:11:07 -0500 (EST)
(envelope-from t-ishii@sra.co.jp)
Received: from sranhk.sra.co.jp (sranhk [133.137.36.134])
by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id KAA09662;
Tue, 29 Feb 2000 10:11:03 +0900 (JST)
Received: from localhost (IDENT:t-ishii@srapc968-yotsuya [133.137.36.133])
by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id KAA06416;
Tue, 29 Feb 2000 10:11:02 +0900
To: lincoln.spiteri@st.com
Cc: pgman@candle.pha.pa.us, serge@globalbeach.com,
pgsql-general@postgreSQL.org
Subject: Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)
In-Reply-To: <00022815404900.32534@voltaire.kir.st.com>
References: <200002280931.EAA23527@candle.pha.pa.us>
<00022815404900.32534@voltaire.kir.st.com>
X-Mailer: Mew version 1.94 on Emacs 19.34 / Mule 2.3 (SUETSUMUHANA)
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-Id: <20000229101731R.t-ishii@sra.co.jp>
Date: Tue, 29 Feb 2000 10:17:31 +0900
From: Tatsuo Ishii <t-ishii@sra.co.jp>
X-Dispatcher: imput version 990905(IM130)
Lines: 18

Even after extending the number of file descriptors on the kernel quite
significantly I still get the occasional crash due to too many open files. I
would say that the current ploicy is too aggressive uder heavy loads.

This actually brings up a good point. We currently cache all
descriptors up to the limit the OS will allow for a process.

Is this too aggressive? Should we limit it to 50% of the maximum?

We could limit the number of open files/per backend by using limit, or
ulimit etc. if all file accesses would go through Vfd. Is there any
reason to use open() directly, for example, in mdblindwrt()?

Also, I have noticed that some files such as pg_internal.init are not
necessary kept open and should be closed after we finish to use it to
save a fd.
--
Tatsuo Ishii

From bouncefilter Tue Feb 29 08:35:21 2000
Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1])
by hub.org (8.9.3/8.9.3) with ESMTP id IAA91060
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 08:34:24 -0500 (EST)
(envelope-from jose@sferacarta.com)
Received: from proxy.sferacarta.com (sfcabop1.nettuno.it [193.207.10.213])
by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 4.1) with ESMTP id OAA24225;
Tue, 29 Feb 2000 14:34:14 +0100 (MET)
Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5]
by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian))
id 12Pnm3-0001D8-00; Tue, 29 Feb 2000 14:37:19 +0000
Message-ID: <38BBCB88.39ECAF85@sferacarta.com>
Date: Tue, 29 Feb 2000 14:37:12 +0100
From: Jose Soares <jose@sferacarta.com>
Organization: Sfera Carta
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: sheila bel <sheilabel@hotmail.com>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
References: <20000229005146.6695.qmail@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

sheila bel wrote:

Hi all,

I wanted to get some information about date and time
stamps and examples of how to use them. In the User
Manual I got referred to functions called CURRENT_DATE,
CURRENT_TIME. I have been literally searching for
hours to find more about them in all the PostgreSQL
manuals, I've used ALL the search engines and did not
find anything. If there is a reference to them they should
be somewhere in there, right?
I'm sorry but dear developers your manual is not user
friendly at all :(
A lot of time gets wasted on finding the information you
need or not finding them at all.

-Sheila

You ca use the niladics datetime functions:

- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP

as a column default value like:

CREATE TABLE mytb (
mydt DATE DEFAULT CURRENT_DATE,
mytm TIME DEFAULT CURRENT_TIME,
myts TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

to insert a value into a column as in:

INSERT INTO mytb (mydt) VALUES(CURRENT_DATE);

to compare two values as in:

SELECT * FROM mytb WHERE mytm BETWEEN '1999-12-31 12:30:00' AND
CURRENT_TIMESTAMP;

etc, etc...

--
Jose' Soares
Bologna, Italy Jose@sferacarta.com

From bouncefilter Tue Feb 29 08:53:23 2000
Received: from rage.hub.org (root@nat194.111.mpoweredpc.net [142.177.194.111])
by hub.org (8.9.3/8.9.3) with ESMTP id IAA99241;
Tue, 29 Feb 2000 08:53:15 -0500 (EST) (envelope-from jeff@pgsql.com)
Received: from localhost (jeff@localhost)
by rage.hub.org (8.9.3/8.9.3) with ESMTP id JAA03171;
Tue, 29 Feb 2000 09:53:22 -0400 (AST) (envelope-from jeff@pgsql.com)
X-Authentication-Warning: rage.hub.org: jeff owned process doing -bs
Date: Tue, 29 Feb 2000 09:53:21 -0400 (AST)
From: Jeff MacDonald <jeff@pgsql.com>
X-Sender: jeff@rage.hub.org
Reply-To: Jeff MacDonald <jeff@pgsql.com>
To: pgsql-announce@postgresql.org
Subject: Another Database Poll
Message-ID: <Pine.BSF.4.10.10002290952290.793-100000@rage.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

www.linux.com mysql is at 53 %,
pgsql at 14 %

Jeff MacDonald
jeff@pgsql.com

From bouncefilter Tue Feb 29 10:11:21 2000
Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA42262
for <pgsql-announce@postgreSQL.org>;
Tue, 29 Feb 2000 10:11:19 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54])
by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id KAA09619
for <pgsql-announce@postgresql.org>;
Tue, 29 Feb 2000 10:06:15 -0500 (EST)
Received: from austin.rr.com ([24.27.61.251]) by mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Tue, 29 Feb 2000 09:06:52 -0600
Sender: ed@clio.trends.ca
Message-ID: <38BBE101.1D53DFF8@austin.rr.com>
Date: Tue, 29 Feb 2000 09:08:49 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Jeff MacDonald <jeff@pgsql.com>
CC: pgsql-announce@postgreSQL.org
Subject: Re: [GENERAL] Another Database Poll
References: <Pine.BSF.4.10.10002290952290.793-100000@rage.hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jeff MacDonald wrote:

www.linux.com mysql is at 53 %,
pgsql at 14 %

Where is the poll?

From bouncefilter Tue Feb 29 10:11:31 2000
Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA42271
for <pgsql-announce@postgreSQL.org>;
Tue, 29 Feb 2000 10:11:20 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54])
by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id KAA09724
for <pgsql-announce@postgresql.org>;
Tue, 29 Feb 2000 10:07:12 -0500 (EST)
Received: from austin.rr.com ([24.27.61.251]) by mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Tue, 29 Feb 2000 09:07:49 -0600
Sender: ed@clio.trends.ca
Message-ID: <38BBE139.91178733@austin.rr.com>
Date: Tue, 29 Feb 2000 09:09:45 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Jeff MacDonald <jeff@pgsql.com>, pgsql-announce@postgreSQL.org
Subject: Re: [GENERAL] Another Database Poll
References: <Pine.BSF.4.10.10002290952290.793-100000@rage.hub.org>
<38BBE101.1D53DFF8@austin.rr.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Ed Loehr wrote:

Jeff MacDonald wrote:

www.linux.com mysql is at 53 %,
pgsql at 14 %

Where is the poll?

D'oh.

From bouncefilter Tue Feb 29 13:47:25 2000
Received: from sakaki.communique.net (sakaki.communique.net [204.27.64.202])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA03302
for <pgsql-general@postgreSQL.org>;
Tue, 29 Feb 2000 13:46:36 -0500 (EST)
(envelope-from davidb@vectormath.com)
From: davidb@vectormath.com
Received: from bullwinkle (adsl-204-0-250-73.indi.se.verio.net [204.0.250.73])
by sakaki.communique.net (8.8.8/8.8.8) with SMTP id MAA01630
for <pgsql-general@postgreSQL.org>;
Tue, 29 Feb 2000 12:46:34 -0600 (CST)
Message-ID: <001301bf82e4$fe512b70$0602010a@bullwinkle.vectormath>
To: <pgsql-general@postgreSQL.org>
Subject: Would like to install on NT Workstation
Date: Tue, 29 Feb 2000 12:44:13 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0010_01BF82B2.AE8E8AB0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01BF82B2.AE8E8AB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I would like to install PostgreSQL on Windows NT Workstation 4.00.1381 =
Service pack 3.
I have tried following the installation instructions under the =
"Microsoft NT" section of
http://www.postgresql.org/doxlist.html. However, I ran up against a =
brick wall when the=20
ReadMe file for the cygwin32 IPC package referred to files and =
directories that were not
in the downloaded tar file.
I would like to correspond with someone who has installed on NT and who =
can help
me understand what I am evidently not understanding.
Also, can I even install on NT Workstation (rather than NT Server)?

Thanks,
David Boerwinkle

------=_NextPart_000_0010_01BF82B2.AE8E8AB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>I would like to install PostgreSQL =
on Windows NT=20
Workstation 4.00.1381 Service pack 3.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>I have tried following the =
installation=20
instructions under the "Microsoft NT" section of</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2><A=20
href=3D"http://www.postgresql.org/doxlist.html">http://www.postgresql.org=
/doxlist.html.</A> =20
However, I ran up against a brick wall when the </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>ReadMe file for the cygwin32 IPC =
package=20
referred to files and directories that were not</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>in the downloaded tar =
file.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>I would like to correspond with =
someone who has=20
installed on NT and who can help</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>me understand what I am evidently =
not=20
understanding.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Also, can I even install on NT =
Workstation=20
(rather than NT Server)?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Thanks,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>David Boerwinkle</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV></BODY></HTML>

------=_NextPart_000_0010_01BF82B2.AE8E8AB0--

From bouncefilter Tue Feb 29 13:57:24 2000
Received: from ife.org.mx (correo.ife.org.mx [200.34.164.2])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA04145
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 13:56:39 -0500 (EST)
(envelope-from adrianp@correo.ife.org.mx)
Received: (from httpd@localhost) by ife.org.mx (8.9.1/8.9.1) id MAA15944;
Tue, 29 Feb 2000 12:56:22 -0600 (CST)
Date: Tue, 29 Feb 2000 12:56:22 -0600 (CST)
From: Adrian Perez Camarena <adrianp@ife.org.mx>
Message-Id: <200002291856.MAA15944@ife.org.mx>
X-Authentication-Warning: correo.ife.org.mx: httpd set sender to
adrianp@correo.ife.org.mx using -f
To: pgsql-general@postgresql.org
Reply-To: adrianp@ife.org.mx
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: IMP/PHP3 Imap webMail Program 2.0.11
Sender: adrianp@ife.org.mx
X-Originating-IP: 10.0.2.24
Subject: order by

Hello friends
I have the next problem :
I need to order by name a table that contains name and other
fields of users.
I'm in Mexico city and the user's name looks like these:

Select name from prueba_insaculacion order by name;

name
--------------
BELTRAN
DIAZ
HAVEZ
LLUNAS
LOPEZ
NA��ES
NU��EZ
PEREZ
PE��A
YA��ES
��RSATE
��AURIBIA
��NAMUNO

as you can see the order by name is wrong,
mi question is the next:

is there a file of postgres that I can change to tell postgres
that the language that I need to order by name correctly is
spanish? (or something like that)

thanks for your help...

Adrian Perez
IFE

From bouncefilter Tue Feb 29 14:20:24 2000
Received: from local.iboats.com (IDENT:qmailr@[209.90.117.130])
by hub.org (8.9.3/8.9.3) with SMTP id OAA06397
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 14:20:10 -0500 (EST)
(envelope-from steve@iboats.com)
Received: (qmail 1429 invoked from network); 29 Feb 2000 19:20:11 -0000
Received: from hibtone.local.iboats.com (HELO hibtone) (209.90.117.133)
by local.iboats.com with SMTP; 29 Feb 2000 19:20:11 -0000
Message-ID: <001701bf82e9$fe1fc8f0$85755ad1@iboats.com>
From: "Steve Wolfe" <steve@iboats.com>
To: <pgsql-general@postgresql.org>
Subject: "LockRelease: locktable lookup failed, no lock"
Date: Tue, 29 Feb 2000 12:20:09 -0700
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

Searching through the archives, I see a few other persons having this
problem, but no solutions, so I'll ask again. : )

I'm getting "LockRelease: locktable lookup failed, no lock" trying to
insert a row into a database. The database is very simple, it contains a
single table with 8 fields. Over the last few weeks, the database has
been corrupted regularly, but a "vacuum analyze" would do the trick. I
decided to see if I couldn't fix the real problem, though, so I destroyed
the database, created it again, and tried to insert data - but I keep
getting "LockRelease: locktable lookup failed, no lock" when trying to
insert records.

If anyone has suggestions on what to do to fix this problem, please let
me know.

steve

From bouncefilter Tue Feb 29 16:53:26 2000
Received: from local.iboats.com (IDENT:qmailr@[209.90.117.130])
by hub.org (8.9.3/8.9.3) with SMTP id QAA29168
for <pgsql-general@postgreSQL.org>;
Tue, 29 Feb 2000 16:52:38 -0500 (EST)
(envelope-from steve@iboats.com)
Received: (qmail 4008 invoked from network); 29 Feb 2000 21:52:38 -0000
Received: from hibtone.local.iboats.com (HELO hibtone) (209.90.117.133)
by local.iboats.com with SMTP; 29 Feb 2000 21:52:38 -0000
Message-ID: <002601bf82ff$49b281d0$85755ad1@iboats.com>
From: "Steve Wolfe" <steve@iboats.com>
To: <pgsql-general@postgreSQL.org>
References: <001701bf82e9$fe1fc8f0$85755ad1@iboats.com>
Subject: Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"
Date: Tue, 29 Feb 2000 14:52:34 -0700
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

I'm getting "LockRelease: locktable lookup failed, no lock" trying to
insert a row into a database.

Well, I think I tracked down the problem - an index on a "text" field.
Once I removed the index, everything works well. The odd thing is that not
*all* inserts would cause the error. I suppose I ought to dig into the
docs when I get a few spare minutes...

steve

From bouncefilter Tue Feb 29 17:56:26 2000
Received: from fep10-svc.tin.it (mta10-acc.tin.it [212.216.176.41])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA48893
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 17:56:04 -0500 (EST)
(envelope-from sandro@bluff.ermit.it)
Received: from bluff.ermit.it ([213.45.133.10]) by fep10-svc.tin.it
(InterMail v4.01.01.02 201-229-111-106) with ESMTP
id <20000229225532.DUPA9526.fep10-svc@bluff.ermit.it>
for <pgsql-general@postgresql.org>; Tue, 29 Feb 2000 23:55:32 +0100
Received: (from sandro@localhost) by bluff.ermit.it (8.9.3/8.8.5) id XAA11967
for pgsql-general@postgresql.org; Tue, 29 Feb 2000 23:55:24 +0100
Message-Id: <200002292255.XAA11967@bluff.ermit.it>
Subject: Re: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
To: pgsql-general@postgresql.org
Date: Tue, 29 Feb 2000 23:55:23 +0100 (CET)
From: Sandro Dentella <sandro.dentella@mi.infn.it>
Reply-To: sandro.dentella@mi.infn.it
X-Mailer: ELM [version 2.5 PL1]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You may be right that sometime is not that easy to fin documentation, but to
see how CURRENT_TIME works, try:

erm=> select CURRENT_DATE;
?column?
----------
29-02-2000
(1 row

I use it (and the others) in default part of create table:
create table aaa (
who text DEFAULT CURRENT_USER,
when date NOT NULL DEFALUT CURRENT_DATE
);

The problem is pg_dump transforms CURRENT_DATE in something w/ "'" that can
not be fed back to "psql db < file"

By
sandro
*:-)

--
Sandro Dentella *:-)
e-mail: sandro.dentella@mi.infn.it sandro@ermit.it

From bouncefilter Tue Feb 29 18:33:27 2000
Received: from mr-tumnus.avalongroup.net (IDENT:root@mr-tumnus.avalongroup.net
[216.99.209.66]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA51718
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 18:32:28 -0500 (EST)
(envelope-from tjg@exceptionalminds.com)
Received: from exceptionalminds.com (tjg@[192.168.10.206])
by mr-tumnus.avalongroup.net (8.8.7/8.8.7) with ESMTP id QAA32127
for <pgsql-general@postgresql.org>; Tue, 29 Feb 2000 16:06:17 -0800
Sender: tjg@avalongroup.net
Message-ID: <38BC5701.89583E32@exceptionalminds.com>
Date: Tue, 29 Feb 2000 15:32:17 -0800
From: Timothy Grant <tjg@avalongroup.net>
Organization: Avalon Technology Group
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12-20 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Real newbie question re documentation for PL/SQL
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I keep seeing references to server side scripting and something called
PL/SQL, I found some mention of extending it in the programmers
reference, but I am unable to find any reference material, is there such
a thing, and if so, where can I find it.

Related topic, are the functions in pg_proc documented anywhere?

Thanks much.

--
Stand Fast,
tjg.

Chief Technology Officer tjg@exceptionalminds.com
Red Hat Certified Engineer www.exceptionalminds.com
Avalon Technology Group, Inc. (503) 246-3630

Linux...Because rebooting isn't normal<<<<<<<<<<<<

From bouncefilter Tue Feb 29 19:20:27 2000
Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54])
by hub.org (8.9.3/8.9.3) with ESMTP id TAA55145
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 19:20:04 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.27.61.251]) by mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Tue, 29 Feb 2000 18:20:42 -0600
Sender: ed
Message-ID: <38BC62CD.8BA98C11@austin.rr.com>
Date: Tue, 29 Feb 2000 18:22:37 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Timothy Grant <tjg@avalongroup.net>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Real newbie question re documentation for PL/SQL
References: <38BC5701.89583E32@exceptionalminds.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Timothy Grant wrote:

Hi,

I keep seeing references to server side scripting and something called
PL/SQL, I found some mention of extending it in the programmers
reference, but I am unable to find any reference material, is there such
a thing, and if so, where can I find it.

Here are a few pl/pgsql references I've found helpful:

Enabling PL/pgSQL: http://www.deja.com/getdoc.xp?AN=548176178

The "manual", AFAIK:
http://www.postgresql.org/docs/postgres/xplang19388.html

Examples: .../postgresql-6.5.*/src/test/regress/sql/plpgsql.sql

Cheers,
Ed Loehr

From bouncefilter Tue Feb 29 19:35:27 2000
Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55])
by hub.org (8.9.3/8.9.3) with ESMTP id TAA56382
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 19:35:07 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.27.61.251]) by Mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Tue, 29 Feb 2000 18:24:30 -0600
Sender: ed
Message-ID: <38BC6655.7B83E6CD@austin.rr.com>
Date: Tue, 29 Feb 2000 18:37:41 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Timothy Grant <tjg@avalongroup.net>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Real newbie question re documentation for PL/SQL
References: <38BC5701.89583E32@exceptionalminds.com>
<38BC62CD.8BA98C11@austin.rr.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Ed Loehr wrote:

Timothy Grant wrote:

Hi,

I keep seeing references to server side scripting and something called
PL/SQL, I found some mention of extending it in the programmers
reference, but I am unable to find any reference material, is there such
a thing, and if so, where can I find it.

Here are a few pl/pgsql references I've found helpful:

Enabling PL/pgSQL: http://www.deja.com/getdoc.xp?AN=548176178

The "manual", AFAIK:
http://www.postgresql.org/docs/postgres/xplang19388.html

And for some reason still unknown to me, when I click on the link
above, I get a 404 error (not found). I noticed the same in the deja
reference above. I figured the pg folks had moved the doc, but not
so. You can find it via the pg website via the following path:

"Info Central"->"Documentation"->"Documentation"->"Integrated
Document" in Section III.43 under "PL/pgSQL".

Cheers,
Ed Loehr

Examples: .../postgresql-6.5.*/src/test/regress/sql/plpgsql.sql

Cheers,
Ed Loehr

From bouncefilter Tue Feb 29 20:32:28 2000
Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2])
by hub.org (8.9.3/8.9.3) with ESMTP id UAA60935
for <pgsql-general@postgresql.org>;
Tue, 29 Feb 2000 20:31:37 -0500 (EST)
(envelope-from t-ishii@sra.co.jp)
Received: from sranhk.sra.co.jp (sranhk [133.137.36.134])
by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id KAA05243;
Wed, 1 Mar 2000 10:31:35 +0900 (JST)
Received: from localhost (IDENT:t-ishii@localhost [127.0.0.1])
by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id KAA20734;
Wed, 1 Mar 2000 10:31:34 +0900
To: steve@iboats.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"
In-Reply-To: Your message of "Tue, 29 Feb 2000 14:52:34 -0700"
<002601bf82ff$49b281d0$85755ad1@iboats.com>
References: <002601bf82ff$49b281d0$85755ad1@iboats.com>
X-Mailer: Mew version 1.93 on Emacs 19.34 / Mule 2.3 (SUETSUMUHANA)
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-Id: <20000301103134Z.t-ishii@sra.co.jp>
Date: Wed, 01 Mar 2000 10:31:34 +0900
From: Tatsuo Ishii <t-ishii@sra.co.jp>
X-Dispatcher: imput version 980905(IM100)
Lines: 12

I'm getting "LockRelease: locktable lookup failed, no lock" trying to
insert a row into a database.

Well, I think I tracked down the problem - an index on a "text" field.
Once I removed the index, everything works well. The odd thing is that not
*all* inserts would cause the error. I suppose I ought to dig into the
docs when I get a few spare minutes...

What is the version of PostgreSQL and what kind of platform are you
using?
--
Tatsuo Ishii

From bouncefilter Tue Feb 29 23:03:30 2000
Received: from thelab.hub.org (nat196.115.mpoweredpc.net [142.177.196.115])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA68315;
Tue, 29 Feb 2000 23:02:44 -0500 (EST) (envelope-from scrappy@hub.org)
Received: from localhost (scrappy@localhost)
by thelab.hub.org (8.9.3/8.9.1) with ESMTP id AAA02342;
Wed, 1 Mar 2000 00:02:44 -0400 (AST) (envelope-from scrappy@hub.org)
X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs
Date: Wed, 1 Mar 2000 00:02:44 -0400 (AST)
From: The Hermit Hacker <scrappy@hub.org>
To: pgsql-hackers@postgresql.org
cc: pgsql-announce@postgresql.org, pgsql-general@postgresql.org
Subject: Poll: Databases for Linux
Message-ID: <Pine.BSF.4.21.0003010000390.434-100000@thelab.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

As Jeff mentioned earlier today, there is a poll going on at
http://www.linux.com that asks:

Several high-quality databases are available for Linux. Which database,
if any, does your company primarily use with its Linux servers?

Right now, PostgreSQL is lagging MySQL 21% to 48% ...

Who hasn't voted? :) Get out there and make yourself heard, eh?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

From bouncefilter Tue Feb 29 23:21:33 2000
Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id XAA71150
for <pgsql-hackers@postgreSQL.org>;
Tue, 29 Feb 2000 23:20:41 -0500 (EST)
(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
XAA14238;
Tue, 29 Feb 2000 23:20:17 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200003010420.XAA14238@candle.pha.pa.us>
Subject: Re: [HACKERS] Poll: Databases for Linux
In-Reply-To: <Pine.BSF.4.21.0003010000390.434-100000@thelab.hub.org> from The
Hermit Hacker at "Mar 1, 2000 00:02:44 am"
To: The Hermit Hacker <scrappy@hub.org>
Date: Tue, 29 Feb 2000 23:20:17 -0500 (EST)
CC: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
X-Mailer: ELM [version 2.4ME+ PL72 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

As Jeff mentioned earlier today, there is a poll going on at
http://www.linux.com that asks:

Several high-quality databases are available for Linux. Which database,
if any, does your company primarily use with its Linux servers?

Right now, PostgreSQL is lagging MySQL 21% to 48% ...

Who hasn't voted? :) Get out there and make yourself heard, eh?

Reading the web page recent comments, MySQL is getting blasted for lack
of features. Glad to see it. I think we have them on the run. They
are not advancing at the same speed as PostgreSQL, so it is only a
matter of time.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Wed Mar 1 04:19:36 2000
Received: from fep132.fep.ru (mail@fep132.fep.ru [195.230.89.88])
by hub.org (8.9.3/8.9.3) with ESMTP id EAA94861
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 04:18:38 -0500 (EST)
(envelope-from phd@phd.russ.ru)
Received: from localhost [127.0.0.1] (phd)
by fep132.fep.ru with esmtp (Exim 2.05 #1 (Debian))
id 12Q5Gt-0002RV-00; Wed, 1 Mar 2000 12:18:19 +0300
Date: Wed, 1 Mar 2000 09:18:19 +0000 (GMT)
From: Oleg Broytmann <phd@phd.russ.ru>
X-Sender: phd@fep132.fep.ru
Reply-To: phd2@earthling.net
To: Adrian Perez Camarena <adrianp@ife.org.mx>
cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] order by
In-Reply-To: <200002291856.MAA15944@ife.org.mx>
Message-ID: <Pine.LNX.4.21.0003010916370.9371-100000@fep132.fep.ru>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 29 Feb 2000, Adrian Perez Camarena wrote:

is there a file of postgres that I can change to tell postgres
that the language that I need to order by name correctly is
spanish? (or something like that)

If I do understand your problem, the solution is here - you should
recompile Postgres with locale support, and run it with correct locale
settings.
Look more docs on locale support in Postgres sourses and documentation.

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.

From bouncefilter Wed Mar 1 04:21:43 2000
Received: from fep132.fep.ru (mail@fep132.fep.ru [195.230.89.88])
by hub.org (8.9.3/8.9.3) with ESMTP id EAA94946;
Wed, 1 Mar 2000 04:20:52 -0500 (EST) (envelope-from phd@phd.russ.ru)
Received: from localhost [127.0.0.1] (phd)
by fep132.fep.ru with esmtp (Exim 2.05 #1 (Debian))
id 12Q5J5-0002Rt-00; Wed, 1 Mar 2000 12:20:35 +0300
Date: Wed, 1 Mar 2000 09:20:35 +0000 (GMT)
From: Oleg Broytmann <phd@phd.russ.ru>
X-Sender: phd@fep132.fep.ru
Reply-To: phd2@earthling.net
To: The Hermit Hacker <scrappy@hub.org>
cc: pgsql-hackers@postgresql.org, pgsql-announce@postgresql.org,
pgsql-general@postgresql.org
Subject: Re: [HACKERS] Poll: Databases for Linux
In-Reply-To: <Pine.BSF.4.21.0003010000390.434-100000@thelab.hub.org>
Message-ID: <Pine.LNX.4.21.0003010918220.9371-100000@fep132.fep.ru>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 1 Mar 2000, The Hermit Hacker wrote:

As Jeff mentioned earlier today, there is a poll going on at
http://www.linux.com that asks:

Several high-quality databases are available for Linux. Which database,
if any, does your company primarily use with its Linux servers?

Right now, PostgreSQL is lagging MySQL 21% to 48% ...

Who hasn't voted? :) Get out there and make yourself heard, eh?

Yesterday I spent a few minutes trying to choose the DB to vote for. I
am using both Postgres and MySQL - different tasks require different
aproaches and solutions - and I am satisfied with both DBs. There are
niches for both of them.
Finally I voted for Postgres - just because MySQL already has its votes :)

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.

From bouncefilter Wed Mar 1 04:27:37 2000
Received: from game.over.net (game.over.net [193.189.189.100])
by hub.org (8.9.3/8.9.3) with ESMTP id EAA95390
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 04:27:26 -0500 (EST)
(envelope-from tomaz.borstnar@over.net)
Received: from [212.30.94.53] ([212.30.94.53]:14887 "EHLO user.over.net")
by mail.over.net with ESMTP id <S95487AbQCAJ1F>;
Wed, 1 Mar 2000 10:27:05 +0100
Message-Id: <4.3.0.20000301101707.04c85f00@193.189.189.100>
X-Sender: tmail@193.189.189.100
X-Mailer: QUALCOMM Windows Eudora Version 4.3
Date: Wed, 01 Mar 2000 10:23:05 -0100
To: pgsql-general@postgreSQL.org
From: Tomaz Borstnar <tomaz.borstnar@over.net>
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <14522.25770.886051.723043@localhost.localnet>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message:

P.S.: Ah, there was another problem, but I wasn able to reproduce it;
after compiling, "make install" did not install "initdb"; after
repeating the install, everything was in place (Redhat 6.1);
another install on RedHat 6.0 worked without problems.

I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried
with stock gcc (2.7.2.1a faik) and gcc 2.95.2:

/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_type.c -o parse_type.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_coerce.c -o parse_coer
ce.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_target.c -o parse_targ
et.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c scan.c -o scan.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c scansup.c -o scansup.o
In file included from scansup.c:20:
../../include/miscadmin.h:229: parse error before `pid'
gmake[2]: *** [scansup.o] Error 1
gmake[2]: Leaving directory `/usr/work/databases/pgsql/src/backend/parser'
gmake[1]: *** [parser.dir] Error 2
gmake[1]: Leaving directory `/usr/work/databases/pgsql/src/backend'
gmake: *** [all] Error 2

The file has this:

#define PIDFNAME "postmaster.pid"

extern void SetPidFname(char *datadir);
extern char *GetPidFname(void);
extern void UnlinkPidFile(void);
extern int SetPidFile(pid_t pid); <-------------- this line is problematic

#endif /* MISCADMIN_H */

Tomaz
----
Tomaz Borstnar <tomaz.borstnar@over.net>
"Love is the answer to the final question you ask" - Unknown

From bouncefilter Wed Mar 1 08:22:40 2000
Received: from pegasus.sssa.com.pl (pegasus.sssa.com.pl [212.160.133.233])
by hub.org (8.9.3/8.9.3) with ESMTP id IAA15317
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 08:21:52 -0500 (EST)
(envelope-from Zaborowski.Marek@sssa.com.pl)
Received: by PEGASUS with Internet Mail Service (5.5.2448.0)
id <F5VQRBK8>; Wed, 1 Mar 2000 14:15:30 +0100
Message-ID: <B78AB32243C7D211B1B8002035B170D780D2D2@PEGASUS>
From: Zaborowski Marek <Zaborowski.Marek@sssa.com.pl>
To: pgsql-general@postgreSQL.org
Subject:
Date: Wed, 1 Mar 2000 14:15:29 +0100
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
charset="iso-8859-2"

subscribe
end

Marek Zaborowski
tel. 091-459-12-33

From bouncefilter Wed Mar 1 09:49:43 2000
Received: from mail1.w-4.de (mail1.w-4.de [195.126.150.12])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA23453
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 09:47:48 -0500 (EST)
(envelope-from eselg@softbridge.de)
Received: from toshibacom (195.126.151.158)
by mail1.w-4.de with MERCUR-SMTP/POP3/IMAP4-Server (v3.10.18
KA-0098304)
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 15:47:46 +0100
From: "Erwin Selg" <eselg@softbridge.de>
To: <pgsql-general@postgreSQL.org>
Subject: Performance on WindowsNT
Date: Wed, 1 Mar 2000 15:49:32 -0000
Message-ID: <NDBBLKAPPNOHAKEHJBALKEGFCAAA.eselg@softbridge.de>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0004_01BF8395.BCA5C710"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01BF8395.BCA5C710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,

right now I'm evaluating the PostgreSQL and it seems to be the big bang for
us.
But also it is quite important to have a good performance on several
platforms
i.e. WindowsNT , Linux etc.

My question now is: Is there a difference in performance? I read on Windows
it is running
using CygWin, are there any experiences of disadvantages because of that?

Also I read it was a Java database, so my question: Is it a Java database or
is it done
in C++?

Thanks for your help
Erwin Selg

------=_NextPart_000_0004_01BF8395.BCA5C710
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>right =
now I'm=20
evaluating the PostgreSQL and it seems to be the big bang for=20
us.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>But =
also it is quite=20
important to have a good performance on several =
platforms</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>i.e. =
WindowsNT ,=20
Linux etc.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>My =
question now is:=20
Is there a difference in performance? I read on Windows it is=20
running</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>using =
CygWin, are=20
there any experiences of disadvantages because of =
that?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>Also I =
read it was a=20
Java database, so my question: Is it a Java database or is it=20
done</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>in=20
C++?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>Thanks =
for your=20
help</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D065414315-01032000>Erwin=20
Selg</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D065414315-01032000></SPAN></FONT> </DIV></BODY></HTML>

------=_NextPart_000_0004_01BF8395.BCA5C710--

From bouncefilter Wed Mar 1 11:29:40 2000
Received: from local.iboats.com (IDENT:qmailr@[209.90.117.130])
by hub.org (8.9.3/8.9.3) with SMTP id LAA43614
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 11:28:54 -0500 (EST)
(envelope-from steve@iboats.com)
Received: (qmail 16542 invoked from network); 1 Mar 2000 16:28:54 -0000
Received: from hibtone.local.iboats.com (HELO hibtone) (209.90.117.133)
by local.iboats.com with SMTP; 1 Mar 2000 16:28:54 -0000
Message-ID: <004801bf839b$3be312d0$85755ad1@iboats.com>
From: "Steve Wolfe" <steve@iboats.com>
To: "Tatsuo Ishii" <t-ishii@sra.co.jp>
Cc: <pgsql-general@postgreSQL.org>
References: <002601bf82ff$49b281d0$85755ad1@iboats.com>
<20000301103134Z.t-ishii@sra.co.jp>
Subject: Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"
Date: Wed, 1 Mar 2000 09:28:53 -0700
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

I'm getting "LockRelease: locktable lookup failed, no lock" trying

insert a row into a database.

Well, I think I tracked down the problem - an index on a "text"

field.

Once I removed the index, everything works well. The odd thing is that

not

*all* inserts would cause the error. I suppose I ought to dig into the
docs when I get a few spare minutes...

What is the version of PostgreSQL and what kind of platform are you
using?

Lemmee see... pgsql 6.5.3 on redhat linux 6.1, kernel 2.2.12-20smp. The
machine currently isn't running multicpu, that will happen soon. At
bootup, linux finds only one chip, and does pseudo-epic. : )

steve

From bouncefilter Wed Mar 1 11:31:38 2000
Received: from thelab.hub.org (nat196.115.mpoweredpc.net [142.177.196.115])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA43983
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 11:31:24 -0500 (EST)
(envelope-from scrappy@hub.org)
Received: from localhost (scrappy@localhost)
by thelab.hub.org (8.9.3/8.9.1) with ESMTP id MAA07262;
Wed, 1 Mar 2000 12:31:13 -0400 (AST) (envelope-from scrappy@hub.org)
X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs
Date: Wed, 1 Mar 2000 12:31:13 -0400 (AST)
From: The Hermit Hacker <scrappy@hub.org>
To: Erwin Selg <eselg@softbridge.de>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Performance on WindowsNT
In-Reply-To: <NDBBLKAPPNOHAKEHJBALKEGFCAAA.eselg@softbridge.de>
Message-ID: <Pine.BSF.4.21.0003011230360.434-100000@thelab.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 1 Mar 2000, Erwin Selg wrote:

Also I read it was a Java database, so my question: Is it a Java
database or is it done in C++?

Where did you read this? The server itself is written completely in C,
while there are JDBC, ODBC, C++, tcl, etc interfaces available ...

From bouncefilter Wed Mar 1 11:34:39 2000
Received: from local.iboats.com (IDENT:qmailr@[209.90.117.130])
by hub.org (8.9.3/8.9.3) with SMTP id LAA44422
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 11:34:24 -0500 (EST)
(envelope-from steve@iboats.com)
Received: (qmail 16674 invoked from network); 1 Mar 2000 16:34:24 -0000
Received: from hibtone.local.iboats.com (HELO hibtone) (209.90.117.133)
by local.iboats.com with SMTP; 1 Mar 2000 16:34:24 -0000
Message-ID: <006201bf839c$00d466c0$85755ad1@iboats.com>
From: "Steve Wolfe" <steve@iboats.com>
To: <pgsql-general@postgreSQL.org>
References: <001701bf82e9$fe1fc8f0$85755ad1@iboats.com>
Subject: Re: "LockRelease: locktable lookup failed, no lock"
Date: Wed, 1 Mar 2000 09:34:24 -0700
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

Grr....

Although I'm no longer getting lock releases on this table, a daily
vaccum analyze still shows:

NOTICE: Rel reef: Uninitialized page 492 - fixing
NOTICE: Rel reef: Uninitialized page 498 - fixing
NOTICE: Rel reef: Uninitialized page 499 - fixing

The database is a fledgling mail archive, when a message comes in, a
program parses the message for the relevant information, inserts it into
the table, and it's done. Since it's in very early development, there are
only very occasional queries on it. Here's the schema that I used to
create the table....

create sequence reef_sequence increment 2;

create table reef(
reef_index int4 default nextval('reef_sequence') primary
key,
subject varchar(256),
author varchar(256),
author_email varchar(256),
message text,
date date,
time time,
is_reply int
);

Now I know that there are problems with that, like "is_reply" should be a
bool, not an int. This is a very old project that I'm just starting up
again... go easy on me. : )

steve

From bouncefilter Wed Mar 1 12:31:39 2000
Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA55139
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 12:31:37 -0500 (EST)
(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
MAA10066;
Wed, 1 Mar 2000 12:17:08 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200003011717.MAA10066@candle.pha.pa.us>
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <4.3.0.20000301101707.04c85f00@193.189.189.100> from Tomaz
Borstnar at "Mar 1, 2000 10:23:05 am"
To: Tomaz Borstnar <tomaz.borstnar@over.net>
Date: Wed, 1 Mar 2000 12:17:08 -0500 (EST)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL72 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Your OS should have pid_t defined in an include file. Findit, and add
the #include to miscadmin.h. Then, tell us so we can add it here.

At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message:

P.S.: Ah, there was another problem, but I wasn able to reproduce it;
after compiling, "make install" did not install "initdb"; after
repeating the install, everything was in place (Redhat 6.1);
another install on RedHat 6.0 worked without problems.

I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried
with stock gcc (2.7.2.1a faik) and gcc 2.95.2:

/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_type.c -o parse_type.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_coerce.c -o parse_coer
ce.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c parse_target.c -o parse_targ
et.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c scan.c -o scan.o
/usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe
-I.. -c scansup.c -o scansup.o
In file included from scansup.c:20:
../../include/miscadmin.h:229: parse error before `pid'
gmake[2]: *** [scansup.o] Error 1
gmake[2]: Leaving directory `/usr/work/databases/pgsql/src/backend/parser'
gmake[1]: *** [parser.dir] Error 2
gmake[1]: Leaving directory `/usr/work/databases/pgsql/src/backend'
gmake: *** [all] Error 2

The file has this:

#define PIDFNAME "postmaster.pid"

extern void SetPidFname(char *datadir);
extern char *GetPidFname(void);
extern void UnlinkPidFile(void);
extern int SetPidFile(pid_t pid); <-------------- this line is problematic

#endif /* MISCADMIN_H */

Tomaz
----
Tomaz Borstnar <tomaz.borstnar@over.net>
"Love is the answer to the final question you ask" - Unknown

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Wed Mar 1 16:55:43 2000
Received: from mr-tumnus.avalongroup.net (IDENT:root@mr-tumnus.avalongroup.net
[216.99.209.66]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA99151
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 16:55:10 -0500 (EST)
(envelope-from tjg@exceptionalminds.com)
Received: from exceptionalminds.com (tjg@[192.168.10.206])
by mr-tumnus.avalongroup.net (8.8.7/8.8.7) with ESMTP id OAA04196
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 14:29:06 -0800
Sender: tjg@avalongroup.net
Message-ID: <38BD91BA.901FB198@exceptionalminds.com>
Date: Wed, 01 Mar 2000 13:55:06 -0800
From: Timothy Grant <tjg@avalongroup.net>
Organization: Avalon Technology Group
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12-20 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: More newbie question: Restructuring a table
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi again,

Is there a quick and dirty way that I am missing for creating a new
database with a slightly different schema than the old db?

For example, I have a table with a DATETIME field that I really need to
change to a DATE field.

I can create a new table with that field defined as a DATE, but if I do
the following:

INSERT INTO newtable SELECT * FROM oldtable;

I get an data type error.

Is there a "Standard", quick method for doing something like that?

Thanks much.

--
Stand Fast,
tjg.

Chief Technology Officer tjg@exceptionalminds.com
Red Hat Certified Engineer www.exceptionalminds.com
Avalon Technology Group, Inc. (503) 246-3630

Linux...Because rebooting isn't normal<<<<<<<<<<<<

From bouncefilter Wed Mar 1 17:10:44 2000
Received: from ara.zf.jcu.cz (zakkr@ara.zf.jcu.cz [160.217.161.4])
by hub.org (8.9.3/8.9.3) with ESMTP id RAA00818
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 17:10:36 -0500 (EST)
(envelope-from zakkr@zf.jcu.cz)
Received: from localhost (zakkr@localhost)
by ara.zf.jcu.cz (8.9.3/8.9.3/Debian/GNU) with SMTP id XAA14879;
Wed, 1 Mar 2000 23:10:30 +0100
Date: Wed, 1 Mar 2000 23:10:30 +0100 (CET)
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Timothy Grant <tjg@avalongroup.net>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] More newbie question: Restructuring a table
In-Reply-To: <38BD91BA.901FB198@exceptionalminds.com>
Message-ID: <Pine.LNX.3.96.1000301230614.14720A-100000@ara.zf.jcu.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 1 Mar 2000, Timothy Grant wrote:

Hi again,

Is there a quick and dirty way that I am missing for creating a new
database with a slightly different schema than the old db?

For example, I have a table with a DATETIME field that I really need to
change to a DATE field.

I can create a new table with that field defined as a DATE, but if I do
the following:

INSERT INTO newtable SELECT * FROM oldtable;

Example:

SELECT column1, column2::date, column3 INTO newtable FROM oldtable;

- where column2 is a column with your not wanted datetime and is changed to
date. You must cast to new type from old type.
Karel

From bouncefilter Wed Mar 1 17:31:43 2000
Received: from mr-tumnus.avalongroup.net (IDENT:root@mr-tumnus.avalongroup.net
[216.99.209.66]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA03163
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 17:31:10 -0500 (EST)
(envelope-from tjg@exceptionalminds.com)
Received: from exceptionalminds.com (tjg@[192.168.10.206])
by mr-tumnus.avalongroup.net (8.8.7/8.8.7) with ESMTP id PAA04356
for <pgsql-general@postgresql.org>; Wed, 1 Mar 2000 15:05:07 -0800
Sender: tjg@avalongroup.net
Message-ID: <38BD9A2C.BCF57E92@exceptionalminds.com>
Date: Wed, 01 Mar 2000 14:31:08 -0800
From: Timothy Grant <tjg@avalongroup.net>
Organization: Avalon Technology Group
X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12-20 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: PostgreSQL ODBC and Crystal Reports
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Yet some more questions.

Does anyone know of any issues regarding the PostreSQL ODBC driver and
Crystal Reports?

I am running report that Groups by a column that may have several words
in it. It appears that Crystal's grouping system is dropping everything
after the first space. I am trying to determine whether this is a
problem with Postgres or with ODBC or with Crystal.

Any insight would be greatly appreciated.

Thanks.

--
Stand Fast,
tjg.

Chief Technology Officer tjg@exceptionalminds.com
Red Hat Certified Engineer www.exceptionalminds.com
Avalon Technology Group, Inc. (503) 246-3630

Linux...Because rebooting isn't normal<<<<<<<<<<<<

From bouncefilter Wed Mar 1 18:24:45 2000
Received: from game.over.net (game.over.net [193.189.189.100])
by hub.org (8.9.3/8.9.3) with ESMTP id SAA07679
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 18:24:18 -0500 (EST)
(envelope-from tomaz.borstnar@over.net)
Received: from [212.30.66.12] ([212.30.66.12]:52519 "EHLO user.over.net")
by mail.over.net with ESMTP id <S95526AbQCAXX7>;
Thu, 2 Mar 2000 00:23:59 +0100
Message-Id: <4.3.0.20000301235037.02c62d30@193.189.189.100>
X-Sender: tmail@193.189.189.100
X-Mailer: QUALCOMM Windows Eudora Version 4.3
Date: Thu, 02 Mar 2000 00:07:31 -0100
To: pgsql-general@postgreSQL.org
From: Tomaz Borstnar <tomaz.borstnar@over.net>
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <200003011717.MAA10066@candle.pha.pa.us>
References: <4.3.0.20000301101707.04c85f00@193.189.189.100>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 04:17 PM 01/03/00, Bruce Momjian wrote the following message:

Your OS should have pid_t defined in an include file. Findit, and add
the #include to miscadmin.h. Then, tell us so we can add it here.

#include <sys/types.h> seemed to help

At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message:

P.S.: Ah, there was another problem, but I wasn able to reproduce it;
after compiling, "make install" did not install "initdb"; after
repeating the install, everything was in place (Redhat 6.1);
another install on RedHat 6.0 worked without problems.

I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried
with stock gcc (2.7.2.1a faik) and gcc 2.95.2:

----
Tomaz Borstnar <tomaz.borstnar@over.net>
"Love is the answer to the final question you ask" - Unknown

From bouncefilter Wed Mar 1 21:02:46 2000
Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67])
by hub.org (8.9.3/8.9.3) with ESMTP id VAA24749
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 21:02:22 -0500 (EST)
(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
VAA25805;
Wed, 1 Mar 2000 21:01:56 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200003020201.VAA25805@candle.pha.pa.us>
Subject: Re: [GENERAL] psql 7.0.0 beta
In-Reply-To: <4.3.0.20000301235037.02c62d30@193.189.189.100> from Tomaz
Borstnar at "Mar 2, 2000 00:07:31 am"
To: Tomaz Borstnar <tomaz.borstnar@over.net>
Date: Wed, 1 Mar 2000 21:01:56 -0500 (EST)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL72 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

At 04:17 PM 01/03/00, Bruce Momjian wrote the following message:

Your OS should have pid_t defined in an include file. Findit, and add
the #include to miscadmin.h. Then, tell us so we can add it here.

#include <sys/types.h> seemed to help

At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message:

P.S.: Ah, there was another problem, but I wasn able to reproduce it;
after compiling, "make install" did not install "initdb"; after
repeating the install, everything was in place (Redhat 6.1);
another install on RedHat 6.0 worked without problems.

I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried
with stock gcc (2.7.2.1a faik) and gcc 2.95.2:

I looked at 7.0 miscadmin.h, and see sys/types.h, so it is already fixed
in the current beta.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

From bouncefilter Thu Mar 2 02:15:52 2000
Received: from mail.jtek.com (lsajca1-ar3-015-067.biz.dsl.gtei.net
[4.3.15.67])
by hub.org (8.9.3/8.9.3) with ESMTP id CAA45812
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 02:15:35 -0500 (EST)
(envelope-from jacobs@jtek.com)
Received: from dev.jtek.com (dev.jtek.com [10.0.1.2])
by mail.jtek.com (8.9.3/8.9.3) with ESMTP id XAA13296
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 23:41:03 -0800
Date: Wed, 1 Mar 2000 23:12:36 -0800 (PST)
From: Stan Jacobs <jacobs@jtek.com>
To: pgsql-general@postgreSQL.org
Subject: Simple problem?
Message-ID: <Pine.LNX.4.10.10003012309200.7831-100000@dev.jtek.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi there,

I must be confusing my syntax somehow, because I'm having trouble doing a
simple update with returned id... As in.... I have two tables: an order
table and an orderitems table. I need to write the order record, then use
the order_id from the order record in the insert to the orderitems record.

1. Can I use a transaction begin/end for the entire transaction if I need
to get the order_id in between the two writes?

2. How do I get the order_id from the record I just wrote?

thanks in advance.

-sj

From bouncefilter Thu Mar 2 02:36:55 2000
Received: from smtp.tangos.nl (IDENT:root@www.tangos.nl [212.206.127.2])
by hub.org (8.9.3/8.9.3) with ESMTP id CAA47802
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 02:35:56 -0500 (EST)
(envelope-from w.aarts@dsdeurne.nl)
Received: from qube.dsdeurne.nl (1Cust60.tnt16.rtm1.nl.uu.net [213.53.6.60])
by smtp.tangos.nl (8.9.3/8.8.7) with ESMTP id IAA28627;
Thu, 2 Mar 2000 08:27:23 +0100
Received: from dsdeurne.nl ([10.254.211.2])
by qube.dsdeurne.nl (8.9.2/8.9.2) with ESMTP id IAA01175;
Thu, 2 Mar 2000 08:31:32 +0100 (CET)
Message-ID: <38BE197D.C6300610@dsdeurne.nl>
Date: Thu, 02 Mar 2000 08:34:21 +0100
From: Wim Aarts <w.aarts@dsdeurne.nl>
Organization: DSD Automatisering
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Steve Wolfe <steve@iboats.com>
CC: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Re: "LockRelease: locktable lookup failed, no lock"
References: <001701bf82e9$fe1fc8f0$85755ad1@iboats.com>
<006201bf839c$00d466c0$85755ad1@iboats.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Steve,

Have you checked for inserts in the message field larger then 8k?

Cheers Wim.

Steve Wolfe wrote:

Grr....

Although I'm no longer getting lock releases on this table, a daily
vaccum analyze still shows:

NOTICE: Rel reef: Uninitialized page 492 - fixing
NOTICE: Rel reef: Uninitialized page 498 - fixing
NOTICE: Rel reef: Uninitialized page 499 - fixing

The database is a fledgling mail archive, when a message comes in, a
program parses the message for the relevant information, inserts it into
the table, and it's done. Since it's in very early development, there are
only very occasional queries on it. Here's the schema that I used to
create the table....

create sequence reef_sequence increment 2;

create table reef(
reef_index int4 default nextval('reef_sequence') primary
key,
subject varchar(256),
author varchar(256),
author_email varchar(256),
message text,
date date,
time time,
is_reply int
);

Now I know that there are problems with that, like "is_reply" should be a
bool, not an int. This is a very old project that I'm just starting up
again... go easy on me. : )

steve

************

From bouncefilter Thu Mar 2 02:51:50 2000
Received: from smtp.bmi.net (smtp.bmi.net [204.57.191.31])
by hub.org (8.9.3/8.9.3) with ESMTP id CAA49103
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 02:51:38 -0500 (EST)
(envelope-from jscott@bmi.net)
Received: from titan350 (dmf-21.bmi.net [206.63.146.84])
by smtp.bmi.net (Pro-8.9.3/Pro-8.9.3) with SMTP id XAA03793
for <pgsql-general@postgreSQL.org>; Wed, 1 Mar 2000 23:51:35 -0800
Message-Id: <200003020751.XAA03793@smtp.bmi.net>
X-Sender: jscott@mail.bmi.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0
Date: Wed, 01 Mar 2000 23:51:14 -0800
To: pgsql-general@postgreSQL.org
From: Jesse Scott <jscott@bmi.net>
Subject: Postgres on MacOS... Is it even a possibility?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Someone recently asked me about PostgreSQL as they were looking into
integrating some of the software they produce with a database system. I'm
not sure the specifics of the planned integration itself, but one of the
requirements they had was support for MacOS.

I was wondering if anyone has thought about MacOS support. Is it even
possible? Is there some great impediment to porting or is it just that
there is not enough need to justify the effort? The person that asked me
is actually one of the main C/C++ programmers at the company, (They are a
local development house that is owned by a very large software
publisher...no not Microsoft.) and he expressed some mild interest in
working on a port if it was feasible, so any input on this subject would be
appreciated as I might be able to convince him to work on it. :)

Thanks in advance!

-Jesse

From bouncefilter Thu Mar 2 04:57:53 2000
Received: from mark.desktop.knowledge.com (mark.desktop.knowledge.com
[195.40.167.197]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA63376
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 04:57:25 -0500 (EST)
(envelope-from mark.jewiss@knowledge.com)
Received: from localhost (mark@localhost)
by mark.desktop.knowledge.com (8.9.3/8.9.3) with ESMTP id JAA32715
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 09:57:18 GMT
X-Authentication-Warning: mark.desktop.knowledge.com: mark owned process doing
-bs
Date: Thu, 2 Mar 2000 09:57:18 +0000 (GMT)
From: Mark Jewiss <mark.jewiss@knowledge.com>
Sender: mark@mark.desktop.knowledge.com
To: pgsql-general@postgresql.org
Subject: Transactional logging
Message-ID:
<Pine.BSO.4.21.0003020950140.25133-100000@mark.desktop.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

Haven't seen this mentioned in a while, or in the documentation (if it is
there though, please point it out). Have been trying the archives for a
while as well, but am getting no response from the server after submitting
search queries....

Currently I have my installation of Postgres storing level 3 diagnostics
to a file for analysis. This is on a devlopment server, and the log files
are being used for debugging applications, etc.

What I want to be able to do is store details of every transaction that is
made against a database to a log file. If my production server then falls
apart, I can take this log file, and run it against a backup database to
bring the backup up to date (or as close as possible to the time of the
crash).

I don't want to store all of the different connection information or other
messages that level 3 debug mode produces though - I just want to store
the SQL itself. I would assume that every transaction in the log file has
been executed against the database, which authenticated the users in
advance.

Is there any way to do this in Postgres currently, or in version 7? Or is
there another way to achieve the same result?

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

From bouncefilter Thu Mar 2 05:45:53 2000
Received: from mark.desktop.knowledge.com (mark.desktop.knowledge.com
[195.40.167.197]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA04053
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 05:45:28 -0500 (EST)
(envelope-from mark.jewiss@knowledge.com)
Received: from localhost (mark@localhost)
by mark.desktop.knowledge.com (8.9.3/8.9.3) with ESMTP id KAA12193
for <pgsql-general@postgresql.org>; Thu, 2 Mar 2000 10:45:23 GMT
X-Authentication-Warning: mark.desktop.knowledge.com: mark owned process doing
-bs
Date: Thu, 2 Mar 2000 10:45:23 +0000 (GMT)
From: Mark Jewiss <mark.jewiss@knowledge.com>
Sender: mark@mark.desktop.knowledge.com
To: pgsql-general@postgresql.org
Subject: Version 7.0 beta problem
Message-ID:
<Pine.BSO.4.21.0003021043470.25133-100000@mark.desktop.knowledge.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

Have run a full installation process for this twice now, and have
experienced the same problem both times: a psql binary is not built.

I've got around this by using the old 6.5.3 one, but still...

Running on OpenBSD 2.6.

If you need any files or logs from me, let me know - I can redo this in
full if required.

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com

From bouncefilter Thu Mar 2 10:14:55 2000
Received: from meryl.it.uu.se (root@meryl.it.uu.se [130.238.12.42])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA26511
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 10:14:17 -0500 (EST)
(envelope-from e99re41@DoCS.UU.SE)
Received: from Dront.DoCS.UU.SE (e99re41@Dront.DoCS.UU.SE [130.238.9.108])
by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id QAA16517;
Thu, 2 Mar 2000 16:14:12 +0100 (MET)
Received: from localhost (e99re41@localhost) by Dront.DoCS.UU.SE
(8.6.12/8.6.12) with ESMTP id QAA29186;
Thu, 2 Mar 2000 16:14:10 +0100
X-Authentication-Warning: Dront.DoCS.UU.SE: e99re41 owned process doing -bs
Date: Thu, 2 Mar 2000 16:14:10 +0100 (MET)
From: Peter Eisentraut <e99re41@DoCS.UU.SE>
Reply-To: Peter Eisentraut <peter_e@gmx.net>
To: Mark Jewiss <mark.jewiss@knowledge.com>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Version 7.0 beta problem
In-Reply-To:
<Pine.BSO.4.21.0003021043470.25133-100000@mark.desktop.knowledge.com>
Message-ID: <Pine.GSO.4.02A.10003021612410.27493-100000@Dront.DoCS.UU.SE>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id KAA26572

Try this:

cd {srcdir}/src/bin/psql
make clean
make
ls

and show me what it says.

In the future, please direct bug reports to pgsql-bugs@postgresql.org.

On Thu, 2 Mar 2000, Mark Jewiss wrote:

Hello,

Have run a full installation process for this twice now, and have
experienced the same problem both times: a psql binary is not built.

I've got around this by using the old 6.5.3 one, but still...

Running on OpenBSD 2.6.

If you need any files or logs from me, let me know - I can redo this in
full if required.

Regards,

Mark.

--
Peter Eisentraut Sernanders v��g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

From bouncefilter Thu Mar 2 10:17:55 2000
Received: from meryl.it.uu.se (root@meryl.it.uu.se [130.238.12.42])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA27001
for <pgsql-general@postgreSQL.org>; Thu, 2 Mar 2000 10:17:42 -0500 (EST)
(envelope-from e99re41@DoCS.UU.SE)
Received: from Dront.DoCS.UU.SE (e99re41@Dront.DoCS.UU.SE [130.238.9.108])
by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id QAA16775;
Thu, 2 Mar 2000 16:17:32 +0100 (MET)
Received: from localhost (e99re41@localhost) by Dront.DoCS.UU.SE
(8.6.12/8.6.12) with ESMTP id QAA29256;
Thu, 2 Mar 2000 16:17:30 +0100
X-Authentication-Warning: Dront.DoCS.UU.SE: e99re41 owned process doing -bs
Date: Thu, 2 Mar 2000 16:17:30 +0100 (MET)
From: Peter Eisentraut <e99re41@DoCS.UU.SE>
Reply-To: Peter Eisentraut <peter_e@gmx.net>
To: Stan Jacobs <jacobs@jtek.com>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Simple problem?
In-Reply-To: <Pine.LNX.4.10.10003012309200.7831-100000@dev.jtek.com>
Message-ID: <Pine.GSO.4.02A.10003021614480.27493-100000@Dront.DoCS.UU.SE>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id KAA27015

On Wed, 1 Mar 2000, Stan Jacobs wrote:

I must be confusing my syntax somehow, because I'm having trouble doing a
simple update with returned id... As in.... I have two tables: an order
table and an orderitems table. I need to write the order record, then use
the order_id from the order record in the insert to the orderitems record.

I assume you're using serial columns here. Table schemas always help ...

1. Can I use a transaction begin/end for the entire transaction if I need
to get the order_id in between the two writes?

Sure.

2. How do I get the order_id from the record I just wrote?

You have to select it back out. A select on max(order_id) might do, but
you might get caught if someone else does updates on your table as well. I
am personally not so fond of serial columns because of this problem.

--
Peter Eisentraut Sernanders v��g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden