view columm size.....
From bouncefilter Thu Feb 10 10:51:53 2000
Received: from ara.zf.jcu.cz (root@ara.zf.jcu.cz [160.217.161.4])
by hub.org (8.9.3/8.9.3) with ESMTP id KAA17080
for <pgsql-general@postgreSQL.org>;
Thu, 10 Feb 2000 10:50:56 -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 KAA21739;
Thu, 10 Feb 2000 10:34:00 +0100
Date: Thu, 10 Feb 2000 10:33:59 +0100 (CET)
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Thomas Egge <teg@ratio.de>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Read values from Trigger out
In-Reply-To: <00020916434500.16346@Thomy>
Message-ID: <Pine.LNX.3.96.1000210102741.21359A-100000@ara.zf.jcu.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
On Wed, 9 Feb 2000, Thomas Egge wrote:
I have created a trigger function.
could somebody tell me how I get the values from the insert in the trigger
function.
I tried the functionSPI_getvalue(trigger,tupdesc,attnum)
Example:
TupleDesc tupdesc;
HeapTuple rettuple = NULL;
char *value;
if (!CurrentTriggerData)
elog(ERROR, "triggers are not initialized");
if (TRIGGER_FIRED_BY_UPDATE(CurrentTriggerData->tg_event))
rettuple = CurrentTriggerData->tg_newtuple;
else if (TRIGGER_FIRED_BY_INSERT(CurrentTriggerData->tg_event))
rettuple = CurrentTriggerData->tg_trigtuple;
else if (TRIGGER_FIRED_BY_DELETE(CurrentTriggerData->tg_event))
rettuple = CurrentTriggerData->tg_trigtuple;
tupdesc = CurrentTriggerData->tg_relation->rd_att;
if (SPI_connect() < 0)
elog(ERROR, "SPI_connect()");
value = SPI_getvalue(rettuple, tupdesc, SPI_fnumber(tupdesc, "column_name"));
...see the PostgreSQL programmer's guide for more...
Karel
From bouncefilter Thu Feb 10 05:56:44 2000
Received: from serdis.dis.ulpgc.es (serdis.dis.ulpgc.es [193.145.145.17])
by hub.org (8.9.3/8.9.3) with ESMTP id FAA41695
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 05:56:12 -0500 (EST)
(envelope-from a1649@dis.ulpgc.es)
Received: from dis.ulpgc.es (proyecto5.dis.ulpgc.es [193.145.145.234])
by serdis.dis.ulpgc.es (8.9.2/8.9.2) with ESMTP id KAA379773
for <pgsql-general@postgresql.org>; Thu, 10 Feb 2000 10:55:28 GMT
Message-ID: <38A29B0F.D11FB9C6@dis.ulpgc.es>
Date: Thu, 10 Feb 2000 11:03:43 +0000
From: Jaume Pausas <a1649@dis.ulpgc.es>
Organization: CCDIS
X-Mailer: Mozilla 4.08 [en] (WinNT; I)
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: how to insert data in a row with serial type
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi!
How to insert data in a registry like
create table pp (
cod serial primary key,
des text not null allowed
);
insert into pp values ('','hola');
From bouncefilter Thu Feb 10 06:20:43 2000
Received: from oxmail.ox.ac.uk (oxmail1.ox.ac.uk [129.67.1.1])
by hub.org (8.9.3/8.9.3) with ESMTP id GAA47017
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 06:20:03 -0500 (EST)
(envelope-from moray.mcconnachie@computing-services.oxford.ac.uk)
Received: from ermine.ox.ac.uk ([163.1.2.13])
by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1)
id 12IrX3-0006m5-00; Thu, 10 Feb 2000 11:13:09 +0000
Received: from ermine.ox.ac.uk ([163.1.2.13] helo=moraypc ident=root)
by ermine.ox.ac.uk with smtp (Exim 3.13 #1)
id 12IrX3-0002q2-00; Thu, 10 Feb 2000 11:13:09 +0000
Message-ID: <010c01bf73b7$ce5fd6a0$760e01a3@oucs.ox.ac.uk>
From: "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>
To: "Jaume Pausas" <a1649@dis.ulpgc.es>, <pgsql-general@postgresql.org>
References: <38A29B0F.D11FB9C6@dis.ulpgc.es>
Subject: Re: [GENERAL] how to insert data in a row with serial type
Date: Thu, 10 Feb 2000 11:13:06 -0000
Organization: Oxford University
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.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
----- Original Message -----
From: Jaume Pausas <a1649@dis.ulpgc.es>
To: <pgsql-general@postgreSQL.org>
Sent: Thursday, February 10, 2000 11:03 AM
Subject: [GENERAL] how to insert data in a row with serial type
Hi!
How to insert data in a registry like
create table pp (
cod serial primary key,
des text not null allowed
);insert into pp values ('','hola');
INSERT INTO pp (des) VALUES ('hola');
From bouncefilter Wed Feb 9 20:39:37 2000
Received: from jktmail02.indosat.net.id (jktmail02.indosat.net.id
[202.155.15.22]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA46726
for <pgsql-general@hub.org>; Wed, 9 Feb 2000 20:39:33 -0500 (EST)
(envelope-from slathems@indosat.net.id)
Received: from slatem ([202.155.26.36]) by jktmail02.indosat.net.id with
Microsoft SMTPSVC(5.5.1877.977.9); Thu, 10 Feb 2000 08:42:49 +0700
Message-ID: <003a01bf73c1$007652a0$8301a8c0@slatem>
From: "slamet pramono" <slathems@indosat.net.id>
To: <pgsql-general@hub.org>
Subject: UNSUBSCRIBE
Date: Thu, 10 Feb 2000 19:18:33 +0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0035_01BF73FB.9F3E29A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
This is a multi-part message in MIME format.
------=_NextPart_000_0035_01BF73FB.9F3E29A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
UNSUBSCRIBE
END
------=_NextPart_000_0035_01BF73FB.9F3E29A0
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><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 =
HTML//EN">
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>UNSUBSCRIBE</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>END</FONT></DIV></BODY></HTML>
------=_NextPart_000_0035_01BF73FB.9F3E29A0--
From bouncefilter Thu Feb 10 08:54:45 2000
Received: from smtp-2.nordnet.fr (smtp-2.nordnet.fr [194.206.126.252])
by hub.org (8.9.3/8.9.3) with ESMTP id IAA89751
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 08:54:25 -0500 (EST)
(envelope-from aflorent@iris-tech.fr)
Received: from scomm.iris-tech.fr (port9.adsl1.nordnet.fr [195.146.233.9])
by smtp-2.nordnet.fr (8.9.3/8.9.0) with ESMTP id OAA24137
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 14:54:14 +0100
Received: from (mail@localhost)
by scomm.iris-tech.fr (8.9.3/jtpda-5.3) id OAA11550
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 14:55:48 +0100
X-Authentication-Warning: scomm.iris-tech.fr: mail set sender to
<aflorent@iris-tech.fr> using -f
Received: from siris.iris-tech.fr(192.168.0.100) by scomm.iris-tech.fr via
smap (V2.1) id xma011548; Thu, 10 Feb 00 14:55:44 +0100
Received: from iris-tech.fr (aflorent@afl.iris-tech.fr [192.168.0.5])
by siris.iris-tech.fr (8.9.3/jtpda-5.3) with ESMTP id OAA07847
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 14:52:27 +0100
Message-ID: <38A2C29E.EC6694EF@iris-tech.fr>
Date: Thu, 10 Feb 2000 14:52:30 +0100
From: Arnaud FLORENT <aflorent@iris-tech.fr>
X-Mailer: Mozilla 4.7 [fr] (Win95; I)
X-Accept-Language: fr,en
MIME-Version: 1.0
To: PostgreSQL general ML <pgsql-general@hub.org>
Subject: Memory exhausted in AllocSetAlloc()
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi,
i have this message during an update query:
FATAL 1: Memory exhausted in AllocSetAlloc() (State:08S01, Native
Code:1)
Error: could not begin, a transaction;
what does this mean?
how can i make my query work?
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent@iris-tech.fr
______________________________
From bouncefilter Thu Feb 10 09:20:45 2000
Received: from rage.hub.org (root@nat195.216.mpoweredpc.net [142.177.195.216])
by hub.org (8.9.3/8.9.3) with ESMTP id JAA95459
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 09:20:28 -0500 (EST) (envelope-from jeffm@pgsql.com)
Received: from localhost (jeffm@localhost)
by rage.hub.org (8.9.3/8.9.3) with ESMTP id KAA29589
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 10:20:40 -0400 (AST) (envelope-from jeffm@pgsql.com)
X-Authentication-Warning: rage.hub.org: jeffm owned process doing -bs
Date: Thu, 10 Feb 2000 10:20:38 -0400 (AST)
From: "Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.com>
X-Sender: jeffm@rage.hub.org
Reply-To: Jeff MacDonald <jeff@pgsql.com>
To: pgsql-general@postgresql.org
Subject: Vacuum/corruption
Message-ID: <Pine.BSF.4.10.10002101020220.10395-100000@rage.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Hi folks,
Looking for suggestions..
Have a table with 5 cols. about 1 gig, on a dual
PII 450, 512 megs of ram, running redhat. How long
should a vacuum take ?
Also , could droping an index while data is being inserted
corrupt a table ? I thinking there is data corruption because
i get the following error in 2 situations
1: while trying to do a select into
2: while trying to recreate the index.
getranked=> create index click_timestamp_idx on clicks (timestamp);
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.
also got this error in the log..
StartTransactionCommand
ProcessUtility
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 31209 exited with status 139
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 31208
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 31204
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 31203
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 31201
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
/usr/bin/postmaster: CleanupProc: reinitializing shared memory and
semaphores
shmem_exit(0) [#0]
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
/usr/bin/postmaster: CleanupProc: pid 31208 exited with status 0
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
/usr/bin/postmaster: CleanupProc: pid 31201 exited with status 0
/usr/bin/postmaster: reaping dead processes...
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 31203 exited with status 0
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 31204 exited with status 0
======================================================
Jeff MacDonald
jeff@pgsql.com irc: bignose on EFnet
======================================================
From bouncefilter Thu Feb 10 10:43:46 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 KAA14935
for <pgsql-general@postgreSQL.org>;
Thu, 10 Feb 2000 10:43:32 -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
KAA26864;
Thu, 10 Feb 2000 10:36:28 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200002101536.KAA26864@candle.pha.pa.us>
Subject: Re: [GENERAL] features of PGSQL
In-Reply-To: <000901bf6e17$54b34080$323536ca@w01> from Sanjay Minni at "Feb 3,
2000 12:51:20 pm"
To: Sanjay Minni <sminni@vsnl.com>
Date: Thu, 10 Feb 2000 10:36:28 -0500 (EST)
CC: pgsql-general@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL66 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
[Charset iso-8859-1 unsupported, filtering to ASCII...]
Hi,
all along we have been using other RDBMSs in NT
environment and now we are thinking of LinuxBut these features we need, Are they available
in PG-SQL1. Log of transactions than can be disassembled
into SQL and placed on different media for recovery
In process for 7.1 called WAL. Should 6 months.
2. Replication accross mutli-site file-based
Asked for a lot.
3. Specifying a sub-query in place of a column-name
or in place of a table-name (in the from clause)
Column name will be in 7.0, from clause is on TODO list.
--
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 19026From bouncefilter Thu Feb 10 10:51:52 2000
Received: from barb.worldchat.com (IDENT:root@barb.wchat.on.ca
[204.138.239.65]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA17167
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 10:51:21 -0500 (EST)
(envelope-from forsyth@dataforge.on.ca)
Received: from dataforge.on.ca (asv90-1-p16.wchat.on.ca [205.210.137.32])
by barb.worldchat.com (8.9.3/8.9.0) with ESMTP id KAA29491
for <pgsql-general@postgresql.org>; Thu, 10 Feb 2000 10:51:11 -0500
Sender: danielf@barb.worldchat.com
Message-ID: <38A2DE25.8398F6EC@dataforge.on.ca>
Date: Thu, 10 Feb 2000 15:49:57 +0000
From: Daniel Forsyth <forsyth@dataforge.on.ca>
Organization: Dataforge
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.36 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Quick Varchar Question
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi all,
Just wondering if there is any way in Postgres 6.5 to force varchars
to be interpreted on an insert string as UPPER case only? ie: insert
into bla values ('lala') ....
'lala' would be forced to uppercase WITHOUT using the upper()
function in the insert string.
I need this because I'm shooting data in from applixware, and users
tend to type lower case.
Thanks, please reply to my email address
--
Dan
From bouncefilter Thu Feb 10 11:02:46 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 LAA20835
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 11:01:52 -0500 (EST)
(envelope-from reedstrm@wallace.ece.rice.edu)
Received: by wallace.ece.rice.edu via sendmail from stdin
id <m12Iw2Q-000LEMC@wallace.ece.rice.edu> (Debian Smail3.2.0.102)
for pgsql-general@hub.org; Thu, 10 Feb 2000 10:01:50 -0600 (CST)
Date: Thu, 10 Feb 2000 10:01:50 -0600
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: Arnaud FLORENT <aflorent@iris-tech.fr>
Cc: PostgreSQL general ML <pgsql-general@hub.org>
Subject: Re: [GENERAL] view columm size.....
Message-ID: <20000210100150.B8184@rice.edu>
References: <38A28565.B72BF288@iris-tech.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <38A28565.B72BF288@iris-tech.fr>;
from aflorent@iris-tech.fr on Thu, Feb 10, 2000 at 10:31:18AM
+0100
On Thu, Feb 10, 2000 at 10:31:18AM +0100, Arnaud FLORENT wrote:
hi,
i 've create a view
one of the column is the result of col1 || col2.....
col1 is 8 char long
col 2 is 4 char longbut my column view is 254 char long........
so i can't UPDATE a 12 char length col using this view a table because
"Length is not equal to length of the target column"what should i do to force the length of the view column to 12 char?
Hmm, try something like:
substr("ColView",1,12)
That should give you the first 12 characters, i.e. all of them. See if
the UPDATE likes it.
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
From bouncefilter Thu Feb 10 11:02:47 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 LAA22406
for <pgsql-general@postgreSQL.org>;
Thu, 10 Feb 2000 11:02:32 -0500 (EST)
(envelope-from e99re41@DoCS.UU.SE)
Received: from Zebra.DoCS.UU.SE (e99re41@Zebra.DoCS.UU.SE [130.238.9.158])
by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id RAA20866;
Thu, 10 Feb 2000 17:02:19 +0100 (MET)
Received: from localhost (e99re41@localhost) by Zebra.DoCS.UU.SE
(8.6.12/8.6.12) with SMTP id RAA19079;
Thu, 10 Feb 2000 17:02:19 +0100
X-Authentication-Warning: Zebra.DoCS.UU.SE: e99re41 owned process doing -bs
Date: Thu, 10 Feb 2000 17:02:19 +0100 (MET)
From: Peter Eisentraut <e99re41@DoCS.UU.SE>
Reply-To: Peter Eisentraut <peter_e@gmx.net>
To: Sanjay Minni <sminni@vsnl.com>
cc: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] features of PGSQL
In-Reply-To: <000901bf6e17$54b34080$323536ca@w01>
Message-ID: <Pine.GSO.4.02A.10002101700060.19049-100000@Zebra.DoCS.UU.SE>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
On Thu, 3 Feb 2000, Sanjay Minni wrote:
Hi,
all along we have been using other RDBMSs in NT
environment and now we are thinking of LinuxBut these features we need, Are they available
in PG-SQL1. Log of transactions than can be disassembled
into SQL and placed on different media for recovery
Nope.
2. Replication accross mutli-site file-based
Nope.
3. Specifying a sub-query in place of a column-name
or in place of a table-name (in the from clause)
Target list yes, from clause nope.
At least item 1 and 3 are slated to be implemented some time, but that
won't help you very much right now. :(
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From bouncefilter Thu Feb 10 11:19:47 2000
Received: from smtp-2.nordnet.fr (smtp-2.nordnet.fr [194.206.126.252])
by hub.org (8.9.3/8.9.3) with ESMTP id LAA27542
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 11:19:20 -0500 (EST)
(envelope-from aflorent@iris-tech.fr)
Received: from scomm.iris-tech.fr (port9.adsl1.nordnet.fr [195.146.233.9])
by smtp-2.nordnet.fr (8.9.3/8.9.0) with ESMTP id RAA01952
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 17:19:12 +0100
Received: from (mail@localhost)
by scomm.iris-tech.fr (8.9.3/jtpda-5.3) id RAA11634
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 17:20:53 +0100
X-Authentication-Warning: scomm.iris-tech.fr: mail set sender to
<aflorent@iris-tech.fr> using -f
Received: from siris.iris-tech.fr(192.168.0.100) by scomm.iris-tech.fr via
smap (V2.1) id xma011632; Thu, 10 Feb 00 17:20:33 +0100
Received: from iris-tech.fr (aflorent@afl.iris-tech.fr [192.168.0.5])
by siris.iris-tech.fr (8.9.3/jtpda-5.3) with ESMTP id RAA08714
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 17:17:13 +0100
Message-ID: <38A2E48E.2091B2B4@iris-tech.fr>
Date: Thu, 10 Feb 2000 17:17:18 +0100
From: Arnaud FLORENT <aflorent@iris-tech.fr>
X-Mailer: Mozilla 4.7 [fr] (Win95; I)
X-Accept-Language: fr,en
MIME-Version: 1.0
CC: PostgreSQL general ML <pgsql-general@hub.org>
Subject: Re: [GENERAL] view columm size.....
References: <38A28565.B72BF288@iris-tech.fr> <20000210100150.B8184@rice.edu>
Content-Type: text/plain; charset=iso-8859-1
X-MIME-Autoconverted: from 8bit to quoted-printable by siris.iris-tech.fr id
RAA08714
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id LAA27655
"Ross J. Reedstrom" a �crit :
On Thu, Feb 10, 2000 at 10:31:18AM +0100, Arnaud FLORENT wrote:
hi,
i 've create a view
one of the column is the result of col1 || col2.....
col1 is 8 char long
col 2 is 4 char longbut my column view is 254 char long........
so i can't UPDATE a 12 char length col using this view a table because
"Length is not equal to length of the target column"what should i do to force the length of the view column to 12 char?
Hmm, try something like:
substr("ColView",1,12)
That should give you the first 12 characters, i.e. all of them. See if
the UPDATE likes it.
this works but i would like to understant this behaviour......
i've got the same problem with a select into
MAX( <char(12) column>) becomes a char (8190)!!!!!!!!!!!!
this column should be used as a joined key, and the join gave no results....
--
______________________________
Arnaud FLORENT
IRIS Technologies
phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90
mailto:aflorent@iris-tech.fr
______________________________
From bouncefilter Thu Feb 10 11:53:47 2000
Received: from brianp.demon.co.uk (IDENT:brian@brianp.demon.co.uk
[158.152.38.192]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA37856
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 11:53:03 -0500 (EST)
(envelope-from brian@brianp.demon.co.uk)
Received: from localhost (localhost [[UNIX: localhost]])
by brianp.demon.co.uk (8.9.3/8.8.7) id QAA00957
for pgsql-general@postgresql.org; Thu, 10 Feb 2000 16:52:49 GMT
From: Brian Piatkus <brian@brianp.demon.co.uk>
To: pgsql-general@postgresql.org
Subject: Vacuum goes into spin
Date: Thu, 10 Feb 2000 16:47:22 +0000
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
MIME-Version: 1.0
Message-Id: <00021016524900.00859@brianp>
Content-Transfer-Encoding: 8bit
Hi
Running 6.5.3 on RedHat 6 (But kernel 2.2.13 or thereabouts)
Vacuum analyze table happily reports the stats on the table and on one of
the 3 indexes.
It then goes into a spin - i.e. 99+ % of the cpu & no disc activity.
Should I be concerned about the table structure or the solidity of vacuum ?
From bouncefilter Thu Feb 10 05:09:42 2000
Received: from serbal.pntic.mec.es (serbal.pntic.mec.es [193.144.238.33])
by hub.org (8.9.3/8.9.3) with ESMTP id FAA33522
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 05:09:13 -0500 (EST)
(envelope-from jnavar13@serbal.pntic.mec.es)
Received: from director (infc235.pntic.mec.es [195.53.123.235])
by serbal.pntic.mec.es (8.8.7/8.8.7) with SMTP id LAA01256
for <pgsql-general@postgresql.org>; Thu, 10 Feb 2000 11:22:32 +0100
Message-ID: <000801bf73e9$5bae7f80$0d01a8c0@director>
From: "=?iso-8859-1?Q?Jos=E9_A._Navarro?=" <jnavar13@serbal.pntic.mec.es>
To: <pgsql-general@postgresql.org>
Subject: subscribe pgsql-general
Date: Thu, 10 Feb 2000 11:07:38 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0005_01BF73B7.0AF4FBA0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01BF73B7.0AF4FBA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
subscribe pgsql-general
------=_NextPart_000_0005_01BF73B7.0AF4FBA0
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.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>subscribe =
pgsql-general</FONT></DIV></BODY></HTML>
------=_NextPart_000_0005_01BF73B7.0AF4FBA0--
From bouncefilter Thu Feb 10 12:19:48 2000
Received: from mail.vr.IN-Berlin.DE (gnu.in-berlin.de [192.109.42.4])
by hub.org (8.9.3/8.9.3) with ESMTP id MAA44397
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 12:19:05 -0500 (EST)
(envelope-from mkresse@slyde.in-berlin.de)
Received: from slyde (DialIN101.vr.in-berlin.de [193.175.22.229])
by mail.vr.IN-Berlin.DE (8.9.3/8.9.3) with ESMTP id SAA02895
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 18:19:03 +0100 (CET)
(envelope-from mkresse@slyde.in-berlin.de)
Message-Id: <200002101719.SAA02895@mail.vr.IN-Berlin.DE>
From: "Martin Kresse" <mkresse@slyde.in-berlin.de>
To: pgsql-general@postgresql.org
Date: Thu, 10 Feb 2000 18:21:34 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: How to quietly increment a SEQUENCE
Priority: normal
X-mailer: Pegasus Mail for Win32 (v3.12a)
How can I (quietly) increment a SEQUENCE without having to use
SELECT, or is there a way to dump the result of a query (SELECT
NEXTVAL('...'))?
Thanks for your help,
Martin Kresse
From bouncefilter Thu Feb 10 12:38:20 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 MAA51026
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 12:35:18 -0500 (EST)
(envelope-from reedstrm@wallace.ece.rice.edu)
Received: by wallace.ece.rice.edu via sendmail from stdin
id <m12IxUk-000LEMC@wallace.ece.rice.edu> (Debian Smail3.2.0.102)
for pgsql-general@hub.org; Thu, 10 Feb 2000 11:35:10 -0600 (CST)
Date: Thu, 10 Feb 2000 11:35:10 -0600
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: Arnaud FLORENT <aflorent@iris-tech.fr>
Cc: PostgreSQL general ML <pgsql-general@hub.org>
Subject: Re: [GENERAL] view columm size.....
Message-ID: <20000210113510.A8742@rice.edu>
References: <38A28565.B72BF288@iris-tech.fr> <20000210100150.B8184@rice.edu>
<38A2E48E.2091B2B4@iris-tech.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.0i
In-Reply-To: <38A2E48E.2091B2B4@iris-tech.fr>;
from aflorent@iris-tech.fr on Thu, Feb 10, 2000 at 05:17:18PM
+0100
On Thu, Feb 10, 2000 at 05:17:18PM +0100, Arnaud FLORENT wrote:
"Ross J. Reedstrom" a �crit :
On Thu, Feb 10, 2000 at 10:31:18AM +0100, Arnaud FLORENT wrote:
hi,
Hmm, try something like:
substr("ColView",1,12)
That should give you the first 12 characters, i.e. all of them. See if
the UPDATE likes it.this works but i would like to understant this behaviour......
i've got the same problem with a select into
MAX( <char(12) column>) becomes a char (8190)!!!!!!!!!!!!
This depends on the field definitions you're using. The SQL standard
says that CHAR(X) values will be padded with whitespace to the full
column width. Sometimes, when moving data around, one needs to be
careful where it's going to be expanded, and were not. Usually, I don't
need the whitespace at all, so I can fix things with btrim() (removes
whitespace from both ends)
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
From bouncefilter Thu Feb 10 13:22:48 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 NAA63357
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 13:22:47 -0500 (EST)
(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.93.36.157]) by mail.austin.rr.com with
Microsoft SMTPSVC(5.5.1877.197.19); Thu, 10 Feb 2000 12:23:20 -0600
Sender: ed
Message-ID: <38A3026E.8A6F247E@austin.rr.com>
Date: Thu, 10 Feb 2000 12:24:46 -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: Brian Piatkus <brian@brianp.demon.co.uk>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Vacuum goes into spin
References: <00021016524900.00859@brianp>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Brian Piatkus wrote:
Hi
Running 6.5.3 on RedHat 6 (But kernel 2.2.13 or thereabouts)
Vacuum analyze table happily reports the stats on the table and on one of
the 3 indexes.
It then goes into a spin - i.e. 99+ % of the cpu & no disc activity.
Should I be concerned about the table structure or the solidity of vacuum ?
What does your server log say?
From bouncefilter Thu Feb 10 13:51:49 2000
Received: from gg.genua.de (gg.GeNUA.DE [193.141.169.30])
by hub.org (8.9.3/8.9.3) with ESMTP id NAA70726
for <pgsql-general@postgresql.org>;
Thu, 10 Feb 2000 13:50:58 -0500 (EST)
(envelope-from Magnus_Harlander@genua.de)
Received: (from root@localhost) by gg.genua.de (8.9.3/8.9.3) id TAA16315
for pgsql-general@postgresql.org; Thu, 10 Feb 2000 19:50:55 +0100 (CET)
Received: (from localhost) by gg.genua.de (MSCAN) id
2/gg.genua.de/smtp-gw/mscan; Thu Feb 10 19:50:54 2000
Message-Id: <200002101850.TAA12171@auryn.genua.de>
X-Mailer: exmh version 2.1.0 09/18/1999
To: pgsql-general@postgresql.org
cc: Magnus_Harlander@genua.de
Subject: Dont understand Performance problem
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Thu, 10 Feb 2000 19:50:41 +0100
From: Magnus Harlander <Magnus_Harlander@genua.de>
Hi,
does anybody known why this takes so long (> 2 seconds).
update Request set Feedback = r.Erzeugt + q.Alarm2
from Request r, Queue q
where r.Request_Id = 4312 and r.Queue_Id = q.Queue_Id;
There are indices on all relevant columns but Alarm2.
The tables are:
Table = queue
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| queue_id | int4 | 4 |
| name | varchar() | 128 |
| qtag | varchar() | 16 |
| absender | text | var |
| adresse | text | var |
| bearbeiter | varchar() | 16 |
| bearbeiter1 | varchar() | 16 |
| bearbeiter2 | varchar() | 16 |
| revisor | varchar() | 16 |
| revisor1 | varchar() | 16 |
| revisor2 | varchar() | 16 |
| alarm1 | reltime | 4 |
| alarm2 | reltime | 4 |
| sofort | bool | 1 |
| lastmoddate | abstime | 4 |
| lastmoduser | varchar() | 16 |
+----------------------------------+----------------------------------+-------+
indices on: queue_id, revisor, bearbeiter
total entries about 10Table = request
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| request_id | int4 | 4 |
| erzeugt | abstime | 4 |
| bearbeitet | abstime | 4 |
| bearbeiter | varchar() | 16 |
| beschreibung | text | var |
| status | int4 | 4 |
| stadium | varchar() | 16 |
| level | int4 | 4 |
| locked | bool | 1 |
| qtag | varchar() | 16 |
| queue_id | int4 | 4 |
| priority | varchar() | 16 |
| sender | varchar() | 128 |
| lastmoddate | abstime | 4 |
| lastmoduser | varchar() | 16 |
| erstreaktion | abstime | 4 |
| feedback | abstime | 4 |
+----------------------------------+----------------------------------+-------+
indices on: request_id, queue_Id, Erzeugt, Erstreaktion, Feedback, some more
total entries about 4000erstreaktion and feedback was added later using 'alter table add column...'
I did my vacuum on both tables recently.
Postgres Version 6.3.2
Any ideas?
\magnus
--
From bouncefilter Thu Feb 10 15:59:50 2000
Received: from aulne.infini.fr (aulne.infini.fr [212.208.100.11])
by hub.org (8.9.3/8.9.3) with ESMTP id PAA26133
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 15:58:57 -0500 (EST)
(envelope-from christophe.touze@infini.fr)
Received: from chris (ppptc19.infini.fr [212.208.100.79])
by aulne.infini.fr (8.9.1/8.9.1/R&D&B-990119) with SMTP id VAA17756
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 21:58:17 +0100
Message-ID: <009801bf740a$8656e580$0201a8c0@chris>
From: "=?iso-8859-1?Q?Christophe_Touz=E9?=" <christophe.touze@infini.fr>
To: "PostgreSQL general ML" <pgsql-general@hub.org>
Subject: [ODBC]
Date: Thu, 10 Feb 2000 22:05:12 +0100
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 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Hello,
Is there someone aware of an ODBC access (even commercial) available for
Postgres ?
Thanks
chris
From bouncefilter Thu Feb 10 16:22:50 2000
Received: from swan.prod.itd.earthlink.net (swan.prod.itd.earthlink.net
[207.217.120.123]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA34859
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 16:22:44 -0500 (EST)
(envelope-from aardvark@ibm.net)
Received: from fries (ip244.altoona6.pa.pub-ip.psi.net [38.26.211.244])
by swan.prod.itd.earthlink.net (8.9.3/8.9.3) with SMTP id NAA03802;
Thu, 10 Feb 2000 13:22:21 -0800 (PST)
From: "Barnes" <aardvark@ibm.net>
To: "=?iso-8859-1?Q?'Christophe_Touz=E9'?=" <christophe.touze@infini.fr>,
"'PostgreSQL general ML'" <pgsql-general@hub.org>
Subject: RE: [GENERAL] [ODBC]
Date: Thu, 10 Feb 2000 16:26:11 -0500
Message-ID: <006401bf740d$748a70d0$0a64a8c0@fries>
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 CWS, Build 9.0.2416 (9.0.2910.0)
In-Reply-To: <009801bf740a$8656e580$0201a8c0@chris>
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
http://www.insightdist.com/psqlodbc/
-----Original Message-----
From: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of Christophe Touz�
Sent: Thursday, February 10, 2000 4:05 PM
To: PostgreSQL general ML
Subject: [GENERAL] [ODBC]
Hello,
Is there someone aware of an ODBC access (even commercial) available for
Postgres ?
Thanks
chris
************
From bouncefilter Thu Feb 10 15:51:50 2000
Received: from picasso.realtyideas.com (IDENT:kaiq@207-18-128-210.flex.net
[207.18.128.210] (may be forged))
by hub.org (8.9.3/8.9.3) with ESMTP id PAA23875
for <pgsql-general@postgreSQL.org>;
Thu, 10 Feb 2000 15:51:10 -0500 (EST)
(envelope-from kaiq@picasso.realtyideas.com)
Received: from localhost (kaiq@localhost)
by picasso.realtyideas.com (8.9.3/8.9.3) with ESMTP id PAA15135
for <pgsql-general@postgreSQL.org>; Thu, 10 Feb 2000 15:44:41 -0600
Date: Thu, 10 Feb 2000 15:44:41 -0600 (CST)
From: <kaiq@realtyideas.com>
To: pgsql-general@postgreSQL.org
Subject: NT binary dbd or odbc?
In-Reply-To: <Pine.OSF.4.21.0002091225270.22846-100000@csgrad.cs.vt.edu>
Message-ID:
<Pine.LNX.4.10.10002101534140.12875-100000@picasso.realtyideas.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
To please my customer, I'm porting an app from Linux/PG/perl-cgi
to NT/MSsql/perl-cgi. In the process, I'd like to make some testing.
so, I need perl-cgi on NT talk to pg on linxu.
questions:
1) Should I use DBD::PG or use DBD::ODBC.
2) Where I can get the binary files (I do not have the
compiler -- even if I have, I do not want to get into THAT).
thanks!!!
Kai
From bouncefilter Fri Feb 11 04:15:54 2000
Received: from gg.genua.de (gg.GeNUA.DE [193.141.169.30])
by hub.org (8.9.3/8.9.3) with ESMTP id EAA05280
for <pgsql-general@postgresql.org>;
Fri, 11 Feb 2000 04:15:21 -0500 (EST)
(envelope-from postgres@genua.de)
Received: (from root@localhost) by gg.genua.de (8.9.3/8.9.3) id IAA20720
for pgsql-general@postgresql.org; Fri, 11 Feb 2000 08:28:17 +0100 (CET)
Received: (from localhost) by gg.genua.de (MSCAN) id
2/gg.genua.de/smtp-gw/mscan; Fri Feb 11 08:28:15 2000
Date: Fri, 11 Feb 2000 08:28:06 +0100 (CET)
From: Postgres User <postgres@genua.de>
Message-Id: <200002110728.IAA11092@auryn.genua.de>
Subject: Dont understand my performance problem
To: undisclosed-recipients:;
Hi,
does anybody known why this takes so long (> 2 seconds).
update Request set Feedback = r.Erzeugt + q.Alarm2
from Request r, Queue q
where r.Request_Id = 4312 and r.Queue_Id = q.Queue_Id;
There are indices on all relevant columns but Alarm2.
The tables are:
Table = queue
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| queue_id | int4 | 4 |
| name | varchar() | 128 |
| qtag | varchar() | 16 |
| absender | text | var |
| adresse | text | var |
| bearbeiter | varchar() | 16 |
| bearbeiter1 | varchar() | 16 |
| bearbeiter2 | varchar() | 16 |
| revisor | varchar() | 16 |
| revisor1 | varchar() | 16 |
| revisor2 | varchar() | 16 |
| alarm1 | reltime | 4 |
| alarm2 | reltime | 4 |
| sofort | bool | 1 |
| lastmoddate | abstime | 4 |
| lastmoduser | varchar() | 16 |
+----------------------------------+----------------------------------+-------+
indices on: queue_id, revisor, bearbeiter
total entries about 10Table = request
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| request_id | int4 | 4 |
| erzeugt | abstime | 4 |
| bearbeitet | abstime | 4 |
| bearbeiter | varchar() | 16 |
| beschreibung | text | var |
| status | int4 | 4 |
| stadium | varchar() | 16 |
| level | int4 | 4 |
| locked | bool | 1 |
| qtag | varchar() | 16 |
| queue_id | int4 | 4 |
| priority | varchar() | 16 |
| sender | varchar() | 128 |
| lastmoddate | abstime | 4 |
| lastmoduser | varchar() | 16 |
| erstreaktion | abstime | 4 |
| feedback | abstime | 4 |
+----------------------------------+----------------------------------+-------+
indices on: request_id, queue_Id, Erzeugt, Erstreaktion, Feedback, some more
total entries about 4000erstreaktion and feedback was added later using 'alter table add column...'
I did my vacuum on both tables recently.
Postgres Version 6.3.2
Any ideas?
\magnus