pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedunsubscribe
113+ messages / 89 participants
[nested] [flat]
* unsubscribe
@ 1998-07-09 11:05 Roman Volkoff <rv@tlg.khv.ru>
0 siblings, 0 replies; 113+ messages in thread
From: Roman Volkoff @ 1998-07-09 11:05 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1998-07-19 06:04 Jerome Knobl <jknobl@mandanet.ch>
0 siblings, 0 replies; 113+ messages in thread
From: Jerome Knobl @ 1998-07-19 06:04 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1998-08-02 16:46 Roman Volkoff <rv@tlg.khv.ru>
0 siblings, 0 replies; 113+ messages in thread
From: Roman Volkoff @ 1998-08-02 16:46 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* UNSUBSCRIBE
@ 1998-08-06 05:46 Ricardo Romero <rromero@netfriendly.com>
0 siblings, 0 replies; 113+ messages in thread
From: Ricardo Romero @ 1998-08-06 05:46 UTC (permalink / raw)
To: pgsql-sql
UNSUBSCRIBE
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1998-10-07 19:52 Florian M Unterkircher <florian@mail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Florian M Unterkircher @ 1998-10-07 19:52 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 1998-10-28 07:03 Felix Kwong <f.kwong@ieee.org>
0 siblings, 0 replies; 113+ messages in thread
From: Felix Kwong @ 1998-10-28 07:03 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1998-11-13 02:06 Jiang Feng <fjiang@online.sh.cn>
0 siblings, 0 replies; 113+ messages in thread
From: Jiang Feng @ 1998-11-13 02:06 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1998-11-17 10:29 Nicoleta TATARU <nicol@medanet.ro>
0 siblings, 0 replies; 113+ messages in thread
From: Nicoleta TATARU @ 1998-11-17 10:29 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-01-09 20:11 Zmarzlowski <zmarzlow@club-internet.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Zmarzlowski @ 1999-01-09 20:11 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-01-24 19:56 Zmarzlowski <zmarzlow@club-internet.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Zmarzlowski @ 1999-01-24 19:56 UTC (permalink / raw)
To: pgsql-sql@hub.org
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-02-11 14:48 Thomas Schoessow <TSchoessow@t-online.de>
0 siblings, 0 replies; 113+ messages in thread
From: TSchoessow@t-online.de @ 1999-02-11 14:48 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
----------------------------------------------------------------------------
------------------
E-Mail: TSchoessow@topmail.de http://www.tschoessow.de
Secure E-Mail: secure@tschoessow.de
Certified PGP Key ID 0x3062C4A1
ICQ 18107512
----------------------------------------------------------------------------
-------------------
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-02-13 08:25 Walter Butz <walterbutz@gmx.net>
0 siblings, 0 replies; 113+ messages in thread
From: Walter Butz @ 1999-02-13 08:25 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-03-11 05:59 Vikrant Rathore <vikrant@chemquick.com>
0 siblings, 0 replies; 113+ messages in thread
From: Vikrant Rathore @ 1999-03-11 05:59 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-03-13 18:04 Ana Badillo <abadillo@mixteco.utm.mx>
0 siblings, 0 replies; 113+ messages in thread
From: Ana Badillo @ 1999-03-13 18:04 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-03-17 23:02 Bill Barber <bbarber@zebra.net>
0 siblings, 0 replies; 113+ messages in thread
From: Bill Barber @ 1999-03-17 23:02 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-07-08 11:07 Seb <unixseb@club-internet.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Seb @ 1999-07-08 11:07 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-08-05 16:16 BOUARD, Fabrice <fbouard@eurosport.co.uk>
0 siblings, 0 replies; 113+ messages in thread
From: BOUARD, Fabrice @ 1999-08-05 16:16 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-09-15 06:49 Weon-sun Lee <randy@hostbank.net>
0 siblings, 0 replies; 113+ messages in thread
From: Weon-sun Lee @ 1999-09-15 06:49 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-10-11 07:34 Martin Dolog <dolog@mcprogress.com>
0 siblings, 0 replies; 113+ messages in thread
From: Martin Dolog @ 1999-10-11 07:34 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-10-25 16:21 BOUARD, Fabrice <fbouard@eurosport.co.uk>
0 siblings, 0 replies; 113+ messages in thread
From: BOUARD, Fabrice @ 1999-10-25 16:21 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-11-03 13:24 Joel Fischer <joelf@min.ascend.com>
0 siblings, 0 replies; 113+ messages in thread
From: Joel Fischer @ 1999-11-03 13:24 UTC (permalink / raw)
To: pgsql-sql@hub.org
> -----Original Message-----
> From: owner-pgsql-sql-digest@hub.org
> [mailto:owner-pgsql-sql-digest@hub.org]
> Sent: Tuesday, November 02, 1999 10:00 PM
> To: pgsql-sql-digest@hub.org
> Subject: pgsql-sql-digest V1 #401
>
>
>
> pgsql-sql-digest Tuesday, November 2 1999 Volume 01 :
> Number 401
>
>
>
> Index:
>
> Antw: [SQL] query with subquery abnormally slow?
> ERROR: btree: lost page
> Re: Antw: [SQL] query with subquery abnormally slow?
> Re: [SQL] query with subquery abnormally slow?
> Redhat 6.0 Link Error: Undefined Reference to crypt
> Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt
> why don't this create table work?
> timestamps
>
> ----------------------------------------------------------------------
>
> Date: Tue, 02 Nov 1999 07:45:31 +0100
> From: "Gerhard Dieringer" <DieringG@eba-haus.de>
> Subject: Antw: [SQL] query with subquery abnormally slow?
>
> >>> Oskar Liljeblad <osk@hem.passagen.se> 01.11.1999 19.47 Uhr >>>
> >>I'm doing a SELECT query with a subquery on a table with 12K rows
> >>but it is very slow (10 seconds+). The query looks like this:
> >>
> >> select *
> >> from items
> >> where package in
> >> (select package
> >> from items
> >> where ...blah...
> >> group by package)
> >> .....
>
> I am sorry if I am still sleeping and don't see the problem, but
> what is the difference between this querry and the following:
>
> select *
> from items
> where ...blah...
>
> Gerhard
>
> ------------------------------
>
> Date: Tue, 2 Nov 1999 10:51:17 +0330 (IRT)
> From: Roomi <roomi@RASANEH.safineh.net>
> Subject: ERROR: btree: lost page
>
> Hi,
> i have a huge DB on the web and manage it with some perl scripts.
> recently i underestood that some fields of one of th tables make the
> postgres not to work proparely.
>
> i found out that in the table X, and row for user Y, the field Z have
> problem. when i type : "update X set Z='something' where user='Y' ; " in
> psql intractive environment, this error message occures :
>
> "FATAL 1:
> btree: lost page in the chain of duplicates"
>
> then the psql don't accept any request and queries!!!
>
> when i delete this user from table X, and re-add him with a new
> user name,
> the problem doesn't appear. also i can't add a user with his last user
> naem. !!!
>
> i am really confused . may be this is a bug of postgres?!
>
> plz send ur comments to me
>
> sincerely
> mehdi roomi
> roomi@safineh.net
>
> ------------------------------
>
> Date: Tue, 02 Nov 1999 00:42:30 PST
> From: "omid omoomi" <oomoomi@hotmail.com>
> Subject: Re: Antw: [SQL] query with subquery abnormally slow?
>
> Hello ,,,
> don't you think that you should use a multiple row function (
> such as sum()
> or ... ) along with 'group by' clause in that query?
>
> regards ,
> omid omoomi
>
> >From: "Gerhard Dieringer" <DieringG@eba-haus.de>
> >To: <pgsql-sql@postgreSQL.org>
> >Subject: Antw: [SQL] query with subquery abnormally slow?
> >Date: Tue, 02 Nov 1999 07:45:31 +0100
> >
> >
> >
> > >>> Oskar Liljeblad <osk@hem.passagen.se> 01.11.1999 19.47 Uhr >>>
> > >>I'm doing a SELECT query with a subquery on a table with 12K rows
> > >>but it is very slow (10 seconds+). The query looks like this:
> > >>
> > >> select *
> > >> from items
> > >> where package in
> > >> (select package
> > >> from items
> > >> where ...blah...
> > >> group by package)
> > >> .....
> >
> >I am sorry if I am still sleeping and don't see the problem,
> but what is
> >the difference between this querry and the following:
> >
> >select *
> > from items
> > where ...blah...
> >
> >Gerhard
> >
> >
> >
> >************
> >
> >
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
> ------------------------------
>
> Date: Tue, 2 Nov 1999 00:42:41 -0800 (PST)
> From: Zalman Stern <zalman@netcom.com>
> Subject: Re: [SQL] query with subquery abnormally slow?
>
> I inadvertently deleted Oskar's message where he described what he is
> trying to do at a higher level, but I don't think I'm completely missing
> the point with the following:
>
> The table looks like so:
>
> select * from test;
> [
> ssmldb=> select * from test;
> package |artist |song
> - ----------------------+-------------------+-----------------
> Surf Comp |Mermen |Pulpin
> Surf Comp |Bambi Molesters |Tremor
> Surf Comp |The Squares |Squaranoid
> Dumb Loud Hollow Twang|Bambi Molesters |Point Break
> Dumb Loud Hollow Twang|Bambi Molesters |Glider
> Songs of the Cows |Mermen |Songs of the Cows
> Surfmania |The Aqua Velvets |Surfmania
> Surf Comp 2 |Mermen |Slo Mo H50
> Surf Comp 2 |Los Straightjackets|Caveman
> ]
>
> select t2.* from test t1, test t2
> where t1.package = t2.package and
> t1.artist = 'Mermen' and t2.artist != 'Mermen';
> [
> package |artist |song
> - -----------+-------------------+----------
> Surf Comp |Bambi Molesters |Tremor
> Surf Comp |The Squares |Squaranoid
> Surf Comp 2|Los Straightjackets|Caveman
> (3 rows)
> ]
>
> The query above shows all songs by a different artist that share an album
> with a song by the artist in question. It however omits the songs by the
> artist in question. To get those back, you could try:
>
> select distinct t1.* from test t1, test t2
> where t1.package = t2.package and
> ((t1.artist = 'Mermen' and t2.artist != 'Mermen') or
> (t1.artist != 'Mermen' and t2.artist = 'Mermen'));
>
> or use a union clause:
> select t1.* from test t1, test t2
> where t1.package = t2.package and
> (t2.artist = 'Mermen' and t1.artist != 'Mermen')
> union select t3.* from test t3, test t4
> where t3.package = t4.package and
> (t3.artist = 'Mermen' and t4.artist != 'Mermen') ;
>
> I don't know how these do for speed as I don't care to create a big table
> and indices and all that, but they do not use EXITS and it seems with
> suitable indices they should be fairly fast.
>
> - -Z-
>
> ------------------------------
>
> Date: Tue, 2 Nov 1999 10:34:55 -0500
> From: "Klein, Robert" <rvklein@ober.com>
> Subject: Redhat 6.0 Link Error: Undefined Reference to crypt
>
> I'm trying to compile a program on Redhat 6.0 with the Postgres
> 6.4 the came
> with it.
> I get the following link error:
> /usr/lib/libpq.so: Undefined reference to "crypt"
> Does postgres need a difference libc or glibc? Redhat comes with:
> libc 5.3.13
> glibc 2.1.1
>
> Thanks!
>
> Rob Klein
> System Administrator
> Ober, Kaler, Grimes and Shriver
> 120 East Baltimore St
> Baltimore, MD 21202
>
> ------------------------------
>
> Date: Tue, 02 Nov 1999 14:09:58 -0500
> From: Tom Lane <tgl@sss.pgh.pa.us>
> Subject: Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt
>
> "Klein, Robert" <rvklein@ober.com> writes:
> > I'm trying to compile a program on Redhat 6.0 with the Postgres
> 6.4 the came
> > with it.
> > I get the following link error:
> > /usr/lib/libpq.so: Undefined reference to "crypt"
>
> You need to add -lcrypt to your link command, probably. On some
> platforms crypt() is part of regular libc, on some it comes in
> a separate libcrypt library...
>
> regards, tom lane
>
> ------------------------------
>
> Date: Tue, 2 Nov 1999 17:59:15 -0500
> From: User & <marc@oscar.noc.cv.net>
> Subject: why don't this create table work?
>
> here is the sql:
>
> nnm=> create table nnm_event_limits (
> nnm-> nodename varchar(256) not null,
> nnm-> event_oid varchar(256) not null,
> nnm-> always_never varchar(1) null,
> nnm-> limit int4);
> ERROR: parser: parse error at or near "null"
>
> This is converted from openviews table scheema. here it is without the
> trailing null on always_never:
> nnm=> create table nnm_event_limits (
> nnm-> nodename varchar(256) not null,
> nnm-> event_oid varchar(256) not null,
> nnm-> always_never varchar(1) ,
> nnm-> limit int4);
> ERROR: parser: parse error at or near "limit"
>
> limit is not a reserved word as far as I can tell, any ideas?
>
> I am useing 6.5, got it from PG_VERSION file.
>
> I am new to DB programming in general and Postgres in particular.
>
> Thanks Marc
>
> ps would useing text instead of varchar be a good thing to do?
>
> Marc
>
> ------------------------------
>
> Date: Tue, 2 Nov 1999 21:51:52 -0500
> From: David Rugge <davidrugge@mindspring.com>
> Subject: timestamps
>
> I created a table using this statement:
>
> create table timestamptest (creation_date timestamp default text 'now')
>
> But I get the creation date of the table instead of the date of the
> transaction. This is the format suggested in the manual to workaround the
> default value being set at table creation, but it doesn't work!
>
> What can I do to make a timestamp that is the date the row was
> inserted into
> the table?
>
> - --
> David Rugge
>
http://www.mindspring.com/~davidrugge/index.html
------------------------------
End of pgsql-sql-digest V1 #401
*******************************
************
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-11-07 12:23 Adrian Alb <alb@stockgroup.com>
0 siblings, 0 replies; 113+ messages in thread
From: Adrian Alb @ 1999-11-07 12:23 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-11-22 17:07 Drinks, Ivan - ITD <DrinkIX@ci.denver.co.us>
0 siblings, 0 replies; 113+ messages in thread
From: Drinks, Ivan - ITD @ 1999-11-22 17:07 UTC (permalink / raw)
To: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>
-----Original Message-----
From: owner-pgsql-sql-digest@hub.org
[mailto:owner-pgsql-sql-digest@hub.org]
Sent: Sunday, November 21, 1999 9:01 PM
To: pgsql-sql-digest@hub.org
Subject: pgsql-sql-digest V1 #420
pgsql-sql-digest Sunday, November 21 1999 Volume 01 : Number 420
Index:
RE: [SQL] Deleting indexes before vacuum?
How to optimize this simple query :-(
Re: [SQL] Deleting indexes before vacuum?
----------------------------------------------------------------------
Date: Mon, 22 Nov 1999 10:53:28 +0900
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
Subject: RE: [SQL] Deleting indexes before vacuum?
> -----Original Message-----
> From: owner-pgsql-sql@postgreSQL.org [mailto:owner-pgsql-sql@postgreSQL.
> org]On Behalf Of Tom Lane
> Sent: Sunday, November 21, 1999 2:01 AM
> To: Oleg Bartunov
> Cc: Matthew Hagerty; pgsql-sql@postgreSQL.org
> Subject: Re: [SQL] Deleting indexes before vacuum?
>
>
> Oleg Bartunov <oleg@sai.msu.su> writes:
> > The question is: what's the right way to do drop index/vacuum/create ?
> > Do I need transaction ?
>
> VACUUM should not be run inside a transaction block. (I am planning to
> make the code enforce this for 7.0, but it doesn't yet.) So you can't
> protect the whole sequence with a transaction. AFAICS the only real
> problem is that if you are depending on UNIQUE indexes to catch
> attempts to insert duplicate data, an insertion that got in between
> the drop and recreate wouldn't get checked.
>
> I have been toying with the notion of ripping out the existing VACUUM
> index handling code and putting in fresh code that would simply do an
> index drop and rebuild ;-). This could happen inside VACUUM's exclusive
> lock on the table, so it'd be perfectly safe whereas doing it the manual
> way is not. But I do not want to do this unless Vadim approves it as a
> good idea --- perhaps the existing index-vacuuming code can be fixed to
> be an even better solution than this. I haven't looked at the code to
> understand why it's so slow or whether there's a way to make it better.
>
Shouldn't vacuum preserve consistency even in case of abort ?
Currently PostgreSQL doesn't do little in case of abort(even commit also ?).
So I think it's a strong limitation.
It's well known that rebuilding indexes is faster than insert/deleting
many index tuples.
I have thought rebuilding indexes in vacuum for half a year.
But I don't have a reasonable solution yet.
Rebuiding indexes in vacuum has a big flaw that index may vanish in
case of abort and we may have to recreate index manually.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp
------------------------------
Date: Sun, 21 Nov 1999 12:12:00 +0100 (CET)
From: marten@feki.toppoint.de
Subject: How to optimize this simple query :-(
I've the follwoing two tables:
Table P3AT
AO CHAR(15)
AT Integer
AV VARCHAR(80)
AB LargeInteger
Table P3RL
RELS CHAR(15)
RELT CHAR(15)
SRCT Integer
and some other columns
Indices are on: P3AT.AO, P3AT.AT, P3RL.RELS, P3RL.RELT, P3RL.SRCT
Now I do the query:
a) SELECT AO,AT,AV FROM P3AT WHERE AO IN
(SELECT RELT FROM P3RL WHERE RELS='9#####3#####RW#' AND (SRCT=1004025))
or via
b) SELECT AO,AT,AV FROM P3AT WHERE EXISTS
(SELECT RELT FROM P3RL WHERE (RELT=AO) AND (RELS= ..) AND ...)
Both statements have the same explain result:
Seq Scan on p3at (cost=14458.84 rows=327480 width=28)
SubPlan
-> Index Scan using reltrgind om p3rl (cost=2.05 rows=1 width=12)
Both statements need about 3300 milliseconds to do the job ... and return
the
three result rows ...
I gave it another sql-query and this works much better:
c) SELECT AO,AT,AV FROM P3AT,P3RL WHERE
(P3AT.AO=P3RL.RELT) AND (RELS= ...) AND (SRCT= ...)
This gives the following explain result (and the one I would have expected):
NestedLoop (cost=4.1 rows=5 width=40)
-> Index Scan using relsrcind on p3rl (cost=2.05 rows=1 width=12)
-> Index Scan using atrownind on p3at (cost=2.05 rows=327480 width=28)
and needs only 5 ms !
Marten
------------------------------
Date: Sun, 21 Nov 1999 22:18:24 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [SQL] Deleting indexes before vacuum?
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
>> I have been toying with the notion of ripping out the existing VACUUM
>> index handling code and putting in fresh code that would simply do an
>> index drop and rebuild ;-).
> Shouldn't vacuum preserve consistency even in case of abort ?
That would be nice, certainly, but the existing code doesn't guarantee
it either, and I don't see how we could guarantee it by any method.
If you're moving tuples around then you are going to have some
inconsistent intermediate states :-(. However, the big problem in
that respect is an abort while vacuum is reshuffling the data in the
table itself; changing our approach to index vacuuming isn't going
to make any difference there. Once the table is finished and vacuum
moves on to fixing the indexes, an abort would leave the index(es)
corrupt but the table data should be OK. So the issue is how to
recover the indexes after that happens.
> Rebuiding indexes in vacuum has a big flaw that index may vanish in
> case of abort and we may have to recreate index manually.
The index won't "vanish" --- I see no reason to touch the system-table
entries for it. The data in the index might be corrupt, but that can
happen now.
ISTM that a big advantage of the rebuild approach is that if something
does go wrong during the index-fixing phase, you can try to recover just
by doing another vacuum. That strikes me as less "manual" than dropping
and rebuilding the indexes, which is the only available recovery path
now. It might even work for an index on a system table...
regards, tom lane
------------------------------
End of pgsql-sql-digest V1 #420
*******************************
************
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 1999-12-29 15:15 Steven Pennie <Steven@ksdot.org>
0 siblings, 0 replies; 113+ messages in thread
From: Steven Pennie @ 1999-12-29 15:15 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
end
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2000-01-02 15:12 lyman1@mindspring.com
0 siblings, 0 replies; 113+ messages in thread
From: lyman1@mindspring.com @ 2000-01-02 15:12 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe
-----Original Message-----
From: pgsql-sql-digest <owner-pgsql-sql-digest@hub.org>
To: pgsql-sql-digest@hub.org <pgsql-sql-digest@hub.org>
Date: Saturday, January 01, 2000 11:00 PM
Subject: pgsql-sql-digest V1 #453
>
>pgsql-sql-digest Saturday, January 1 2000 Volume 01 : Number
453
>
>
>
>Index:
>
>timespan problem
>Re: [SQL] timespan problem
>
>----------------------------------------------------------------------
>
>Date: Sat, 1 Jan 2000 21:48:47 +0100 (CET)
>From: Tulassay Zsolt <zsolt@tek.bke.hu>
>Subject: timespan problem
>
>hi,
>i ran into a strange result using the timespan type. No,
>it's not related to y2k, but i don't know whether it is a
>bug or i just used wrong typecasting.
>here it is:
>
>
>forum=> select datetime(now()) as ido;
>ido
>- ----------------------------
>Sat Jan 01 21:35:32 2000 CET
>(1 row)
>
>forum=> select datetime(now())+'74565 days'::timespan as ido;
>ido
>- ------------------------
>Thu Jan 19 14:07:30 2068
>(1 row)
>
>forum=> select datetime(now())+'74566 days'::timespan as ido;
>ido
>- ----------------------------
>Tue Dec 15 08:39:21 1931 CET
>(1 row)
>
>forum=> select datetime(now())+'70 years'::timespan as ido;
>ido
>- ------------------------
>Wed Jan 01 20:36:01 2070
>(1 row)
>
>forum=>
>
>
>I don't see anything wrong in the third query, but the result
>is a bit surprising... and notice the error in the second query
>too: the time fields don't match.
>
>I'm using version 6.5.2 on Red Hat Linux 6.0
>
>Zsolt Tulassay
>zsolt@tek.bke.hu
>
>------------------------------
>
>Date: Sat, 01 Jan 2000 18:58:30 -0500
>From: Tom Lane <tgl@sss.pgh.pa.us>
>Subject: Re: [SQL] timespan problem
>
>Tulassay Zsolt <zsolt@tek.bke.hu> writes:
>> forum=> select datetime(now())+'74565 days'::timespan as ido;
>> ido
>> ------------------------
>> Thu Jan 19 14:07:30 2068
>> (1 row)
>
>> forum=> select datetime(now())+'74566 days'::timespan as ido;
>> ido
>> ----------------------------
>> Tue Dec 15 08:39:21 1931 CET
>> (1 row)
>
>Of course, both of the above are drastically wrong, since 74575 days
>should be upwards of 200 years. The problem appears to be an internal
>overflow in timespan_in, since you can show wrong results just with:
>
>regression=> select '74565 days'::timespan;
>?column?
>- -------------------------------------
>@ 24854 days 17 hours 31 mins 44 secs
>(1 row)
>
>regression=> select '74566 days'::timespan;
>?column?
>- -----------------------------------------
>@ 24854 days 12 hours 56 mins 32 secs ago
>(1 row)
>
>Looking into it, the guilty party seems to be tm2timespan() which
>blithely assumes that it need not worry about overflow from its
>"time" field to its "month" field:
>
> span->month = ((tm->tm_year * 12) + tm->tm_mon);
> span->time = ((((((tm->tm_mday * 24) + tm->tm_hour) * 60) + tm->tm_min)
* 60) + tm->tm_sec);
> span->time = JROUND(span->time + fsec);
>
>Thomas, you want to deal with this one? Or is this code all going
>away in 7.0 anyway?
>
> regards, tom lane
>
>------------------------------
>
>End of pgsql-sql-digest V1 #453
>*******************************
>
>
>************
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2000-10-30 14:39 Vadim Govorov <vadimg@piter.com>
0 siblings, 0 replies; 113+ messages in thread
From: Vadim Govorov @ 2000-10-30 14:39 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2000-10-30 15:28 Schlobohm, Jack <SchlobohmJ@DNB.com>
0 siblings, 0 replies; 113+ messages in thread
From: Schlobohm, Jack @ 2000-10-30 15:28 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-07-01 16:28 Simeone, Mario <msimeone.c@mail.tim.it>
0 siblings, 0 replies; 113+ messages in thread
From: Simeone, Mario @ 2002-07-01 16:28 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
????????????????????????????????????????????????????????????????????????????
su www.tim.it puoi iscriverti gratis alle TimNews, un modo rapido e tempestivo per conoscere le ultime novita di TIM.
????????????????????????????????????????????????????????????????????????????
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-08-26 09:29 Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 0 replies; 113+ messages in thread
From: Gaetano Mendola @ 2002-08-26 09:29 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-08-28 07:30 Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 0 replies; 113+ messages in thread
From: Gaetano Mendola @ 2002-08-28 07:30 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-12-18 17:07 Kristopher Yates <kris@grinz.com>
0 siblings, 0 replies; 113+ messages in thread
From: Kristopher Yates @ 2002-12-18 17:07 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-12-19 12:32 david williams <dw_remote@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: david williams @ 2002-12-19 12:32 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
^ permalink raw reply [nested|flat] 113+ messages in thread
* Re: unsubscribe
@ 2002-12-19 12:39 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 1 reply; 113+ messages in thread
From: Christoph Haller @ 2002-12-19 12:39 UTC (permalink / raw)
To: pgsql-sql; +Cc: dw_remote@hotmail.com
David and all others on the list,
who want to turn off mailing over xmas and new year,
please send your unsubscribe to
majordomo@postgresql.org
Otherwise it will not be processed.
Regards, Christoph
^ permalink raw reply [nested|flat] 113+ messages in thread
* Re: unsubscribe
@ 2002-12-19 14:47 Robert Treat <xzilla@users.sourceforge.net>
parent: Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 113+ messages in thread
From: Robert Treat @ 2002-12-19 14:47 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; +Cc: pgsql-sql; dw_remote@hotmail.com
If you just want to take a break, your better off sending
"set ALL nomail-14d" to majordomo.
Robert Treat
On Thu, 2002-12-19 at 07:39, Christoph Haller wrote:
>
> David and all others on the list,
> who want to turn off mailing over xmas and new year,
> please send your unsubscribe to
>
> majordomo@postgresql.org
>
> Otherwise it will not be processed.
>
> Regards, Christoph
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-12-30 17:09 jrJAMES <migraine007ph@yahoo.com>
0 siblings, 1 reply; 113+ messages in thread
From: jrJAMES @ 2002-12-30 17:09 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org
unsubscribe
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2002-12-30 17:21 Rajesh Krishnamoorthy <raj_krishnamoorthy@yahoo.com>
parent: jrJAMES <migraine007ph@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: Rajesh Krishnamoorthy @ 2002-12-30 17:21 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org
unsubscribe
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-02-03 16:40 Josef Astner <joastner@dnet.it>
0 siblings, 0 replies; 113+ messages in thread
From: Josef Astner @ 2003-02-03 16:40 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-01 16:59 V. Cekvenich <netsql@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: V. Cekvenich @ 2003-04-01 16:59 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
--- Tomasz Myrta <jasiek@klaster.net> wrote:
> Date: Mon, 31 Mar 2003 19:58:31 +0200
> From: Tomasz Myrta <jasiek@klaster.net>
> To: cio198 <cio198@plasa.com>
> CC: pgsql-sql@postgresql.org
> Subject: Re: [SQL] create view with numeric data
>
> Uz.ytkownik cio198 napisa?:
> > Hello,
> >
> > i've created this table
> >
> > CREATE TABLE "budget" (
> > "year" character varying NOT NULL,
> > "month" character varying NOT NULL,
> > "accountno" character varying NOT NULL,
> > "costid" character varying NOT NULL,
> > "valutacode" character varying,
> > "budgetvalue" numeric(9,2) DEFAULT '0',
> > "deptname" character varying,
> > Constraint "budget_pkey" Primary Key
> ("year", "month",
> > "accountno", "costid")
> > );
> >
> > And I want to create the a view using query
> bellow.
> > The problem is the numeric data in the view isn't
> limited to
> > numeric(9,2) instead it become numeric(65535,
> 65531).
> > Is there any way i can restrict it to numeric
> (9,2)
> >
> > TIA
> >
> >
> > CREATE VIEW view_budget
> > AS SELECT b.year, b.accountno, a.name,
> > sum(CASE WHEN month='01' THEN budgetvalue
> ELSE '0' END) AS
> > january,
> > sum(CASE WHEN month='02' THEN budgetvalue
> ELSE '0' END) AS
> > february,
> > sum(CASE WHEN month='03' THEN budgetvalue
> ELSE '0' END) AS
> > march,
> > sum(CASE WHEN month='04' THEN budgetvalue
> ELSE '0' END) AS
> > april,
> > sum(CASE WHEN month='05' THEN budgetvalue
> ELSE '0' END) AS
> > may,
> > sum(CASE WHEN month='06' THEN budgetvalue
> ELSE '0' END) AS
> > june,
> > sum(CASE WHEN month='07' THEN budgetvalue
> ELSE '0' END) AS
> > july,
> > sum(CASE WHEN month='08' THEN budgetvalue
> ELSE '0' END) AS
> > august,
> > sum(CASE WHEN month='09' THEN budgetvalue
> ELSE '0' END) AS
> > september,
> > sum(CASE WHEN month='10' THEN budgetvalue
> ELSE '0' END) AS
> > october,
> > sum(CASE WHEN month='11' THEN budgetvalue
> ELSE '0' END) AS
> > november,
> > sum(CASE WHEN month='12' THEN budgetvalue
> ELSE '0' END) AS
> > december,
> > sum(budgetvalue) as totalvalue
> > FROM budget b inner join account a on
> b.accountno=a.accountno
> > GROUP BY year, b.accountno, a.name
> > ORDER BY b.accountno;
> Sure, change all of your sums to:
> cast(sum(...) as numeric(9,2)) as ...
>
> Regards,
> Tomasz Myrta
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
=====
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-03 11:21 Jose Luis LG <jlopezgonz@terra.es>
0 siblings, 1 reply; 113+ messages in thread
From: Jose Luis LG @ 2003-04-03 11:21 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-04 19:57 Raj Arya <raj.arya@lineone.net>
0 siblings, 0 replies; 113+ messages in thread
From: Raj Arya @ 2003-04-04 19:57 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* Re: unsubscribe
@ 2003-04-05 20:48 CIC mail <cguzman@cic.ipn.mx>
parent: Jose Luis LG <jlopezgonz@terra.es>
0 siblings, 0 replies; 113+ messages in thread
From: CIC mail @ 2003-04-05 20:48 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
Atentamente
M. en C. César Saúl Guzmán Rentería
Jefe de la Unidad de Desarrollo de Aplicaciones
Subdirección de Investigación Aplicada
Centro de Investigación en Computación
Teléfono: 57-29-60-00, extensiones: 56551, 56587
----- Original Message -----
From: Jose Luis LG
To: pgsql-sql@postgresql.org
Sent: Thursday, April 03, 2003 5:21 AM
Subject: [SQL] unsubscribe
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-04-06 18:37 Charles McClain <chasmccl@pacbell.net>
0 siblings, 0 replies; 113+ messages in thread
From: Charles McClain @ 2003-04-06 18:37 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
Charlie McClain
6590 N. West
Fresno CA 93711
Voice/Fax 559-432-5770
Cellular 559-709-0317
chasmccl@pacbell.net
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-08 10:51 2000info <2000info@netsite.com.br>
0 siblings, 0 replies; 113+ messages in thread
From: 2000info @ 2003-04-08 10:51 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-08 15:41 Antony Gubert <vagreaty@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Antony Gubert @ 2003-04-08 15:41 UTC (permalink / raw)
To: pgsql-sql
_________________________________________________________________
Find a partner. For life. http://www.shaadi.com/ptnr.php?ptnr=hmlql
Meet@Shaadi.com
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-09 13:28 Charles McClain <chasmccl@pacbell.net>
0 siblings, 0 replies; 113+ messages in thread
From: Charles McClain @ 2003-04-09 13:28 UTC (permalink / raw)
To: pgsql-sql
Charlie McClain
6590 N. West
Fresno CA 93711
Voice/Fax 559-432-5770
Cellular 559-709-0317
chasmccl@pacbell.net
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-11 04:16 2000info <2000info@netsite.com.br>
0 siblings, 0 replies; 113+ messages in thread
From: 2000info @ 2003-04-11 04:16 UTC (permalink / raw)
To: pgsql-sql
2000 Informática
Rua Macapa, 492 - Centro
São Joaquim da Barra - SP
0xx16 3818 0431
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-16 22:20 Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Ricardo Javier Aranibar León @ 2003-04-16 22:20 UTC (permalink / raw)
To: pgsql-sql
How I can unsubscribe?
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-04-30 01:00 David Durst <ddurst@larubber.com>
0 siblings, 0 replies; 113+ messages in thread
From: David Durst @ 2003-04-30 01:00 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-05-29 09:08 Mona Shah <monashah@ipr.res.in>
0 siblings, 0 replies; 113+ messages in thread
From: Mona Shah @ 2003-05-29 09:08 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-07-29 14:04 Mark Roberts <RoberM1@gosh.nhs.uk>
0 siblings, 0 replies; 113+ messages in thread
From: Mark Roberts @ 2003-07-29 14:04 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
_______________________________________
Disclaimer: Great Ormond Street Hospital for Children NHS Trust
SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note
that Internet E-mail is simply not a secure communication medium.
We strongly advise that you understand & observe this lack of security
when e-mailing us.
This email and any files transmitted with it are intended solely for
the use of the individual to whom they are addressed. If you have
received this email in error please notify your email administrator.
Any views or opinions are solely those of the author of this email
and do not represent those of Great Ormond Street Hospital for
Children NHS Trust unless specifically stated.
VIRUSES: This email message has been checked for the presence of
computer viruses by Sophos antivirus software. However, this does
not guarantee that this email is free of viruses, and the recipient
should perform their own check.
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-07-29 15:14 Antony Gubert <vagreaty@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Antony Gubert @ 2003-07-29 15:14 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
_________________________________________________________________
Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d
Register in India's No 1 Matrimony.
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-07-29 20:46 ww zz <ts_999@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: ww zz @ 2003-07-29 20:46 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-07-29 23:06 Vishal Charan (IT Fiji) <VCharan@courts.com.fj>
0 siblings, 0 replies; 113+ messages in thread
From: Vishal Charan (IT Fiji) @ 2003-07-29 23:06 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-07-31 00:25 2000info <2000info@netsite.com.br>
0 siblings, 0 replies; 113+ messages in thread
From: 2000info @ 2003-07-31 00:25 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-07-31 08:35 rute solipa <rutes@eselx.ipl.pt>
0 siblings, 0 replies; 113+ messages in thread
From: rute solipa @ 2003-07-31 08:35 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-09-02 08:29 Rute Solipa <rutes@eselx.ipl.pt>
0 siblings, 0 replies; 113+ messages in thread
From: Rute Solipa @ 2003-09-02 08:29 UTC (permalink / raw)
To: pgsql-sql
----- Original Message -----
From: rute solipa
To: pgsql-sql@postgreSQL.org
Sent: Thursday, July 31, 2003 9:35 AM
Subject: [SQL] Unsubscribe
Unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-09-03 17:46 Antony Gubert <vagreaty@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Antony Gubert @ 2003-09-03 17:46 UTC (permalink / raw)
To: pgsql-sql
_________________________________________________________________
Need a naukri? Your search ends here. http://www.msn.co.in/naukri/ 50,000 of
the best jobs!
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-09-23 02:54 Rudi Starcevic <rudi@oasis.net.au>
0 siblings, 0 replies; 113+ messages in thread
From: Rudi Starcevic @ 2003-09-23 02:54 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-10-01 09:28 Rute Solipa <rutes@eselx.ipl.pt>
0 siblings, 0 replies; 113+ messages in thread
From: Rute Solipa @ 2003-10-01 09:28 UTC (permalink / raw)
To: pgsql-sql
please remove my email from your database contacts.
best regards,
etur
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-10-01 09:35 dnaren@hss.hns.com
0 siblings, 0 replies; 113+ messages in thread
From: dnaren@hss.hns.com @ 2003-10-01 09:35 UTC (permalink / raw)
To: pgsql-sql
please remove my email from your database contacts.
Best Regards,
Naren
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-10-01 09:44 Mark Roberts <RoberM1@gosh.nhs.uk>
0 siblings, 0 replies; 113+ messages in thread
From: Mark Roberts @ 2003-10-01 09:44 UTC (permalink / raw)
To: pgsql-sql
please remove my email from your database contacts.
Kind Regards,
Mark.
_______________________________________
Disclaimer: Great Ormond Street Hospital for Children NHS Trust
SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note
that Internet E-mail is simply not a secure communication medium.
We strongly advise that you understand & observe this lack of security
when e-mailing us.
This email and any files transmitted with it are intended solely for
the use of the individual to whom they are addressed. If you have
received this email in error please notify your email administrator.
Any views or opinions are solely those of the author of this email
and do not represent those of Great Ormond Street Hospital for
Children NHS Trust unless specifically stated.
VIRUSES: This email message has been checked for the presence of
computer viruses by Sophos antivirus software. However, this does
not guarantee that this email is free of viruses, and the recipient
should perform their own check.
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2003-10-27 08:11 Antony Gubert <vagreaty@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Antony Gubert @ 2003-10-27 08:11 UTC (permalink / raw)
To: pgsql-sql
_________________________________________________________________
Making your life easy! That is Citibank Suvidha.
http://server1.msn.co.in/msnleads/citi_cards_sept03/CitiSuvidha.asp Get your
account now!
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2003-10-27 11:03 Mukta Telang <mukta@darya.nio.org>
0 siblings, 0 replies; 113+ messages in thread
From: Mukta Telang @ 2003-10-27 11:03 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* UNSUBSCRIBE
@ 2003-11-05 04:49 Atul Pedgaonkar <atul@imcindia.net>
0 siblings, 0 replies; 113+ messages in thread
From: Atul Pedgaonkar @ 2003-11-05 04:49 UTC (permalink / raw)
To: pgsql-sql
UNSUBSCRIBE
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-02-06 11:33 jan bok <janbok@xs4all.nl>
0 siblings, 0 replies; 113+ messages in thread
From: jan bok @ 2004-02-06 11:33 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-02-06 17:15 Mona H. Kapadia <monashah@ipr.res.in>
0 siblings, 0 replies; 113+ messages in thread
From: Mona H. Kapadia @ 2004-02-06 17:15 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-02-09 17:22 Mona <monashah@ipr.res.in>
0 siblings, 0 replies; 113+ messages in thread
From: Mona @ 2004-02-09 17:22 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-02-11 19:45 Mona <monashah@ipr.res.in>
0 siblings, 0 replies; 113+ messages in thread
From: Mona @ 2004-02-11 19:45 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: mohan@physics.gmu.edu; pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-06-28 18:27 beyaNet <beyanet@ntlworld.com>
0 siblings, 0 replies; 113+ messages in thread
From: beyaNet @ 2004-06-28 18:27 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2004-09-20 21:30 Ramiro Batista da Luz <ramiro@onda.com.br>
0 siblings, 0 replies; 113+ messages in thread
From: Ramiro Batista da Luz @ 2004-09-20 21:30 UTC (permalink / raw)
To: pgsql-sql
----------------------------------------------------------------
Mensagem Enviada utilizando o Onda Mail.
http://www.onda.com.br
Onda Provedor de Servicos S/A
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-04-24 16:38 Alexander Vlasenko <intrnl_edu@ilyichevsk.odessa.ua>
0 siblings, 0 replies; 113+ messages in thread
From: Alexander Vlasenko @ 2005-04-24 16:38 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-05-26 12:52 U K Laxmi <laxmiuk@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: U K Laxmi @ 2005-05-26 12:52 UTC (permalink / raw)
To: hatuan <hatuan05@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-06-01 17:28 Cordova Juillerat Jorge Alejandro <jcordova@entel.cl>
0 siblings, 1 reply; 113+ messages in thread
From: Cordova Juillerat Jorge Alejandro @ 2005-06-01 17:28 UTC (permalink / raw)
To: pgsql-es-ayuda-owner@postgresql.org; +Cc: pgsql-es-ayuda@postgresql.org
> unsubscribe pgsql-es-ayuda
>
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-06-01 17:35 Ing. Jhon Carrillo - Caracas, Venezuela <jdigital@cantv.net>
parent: Cordova Juillerat Jorge Alejandro <jcordova@entel.cl>
0 siblings, 0 replies; 113+ messages in thread
From: Ing. Jhon Carrillo - Caracas, Venezuela @ 2005-06-01 17:35 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-08-09 22:31 Timothy Smith <timothy@open-networks.net>
0 siblings, 0 replies; 113+ messages in thread
From: Timothy Smith @ 2005-08-09 22:31 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
Timothy Smith wrote:
> i have the following function in plpgsql giving stynax errors all over
> the place.
> i have doen createlang on the db, as far as i can see i'm right. is
> there anything obviously wrong?
> one thing to note is i followed this example
> http://www.zigo.dhs.org/postgresql/#insert_or_update and it gives the
> same errors.
>
> "ERROR: unterminated dollar-quoted string at or near "$$
> BEGIN
> LOOP"
>
>
> CREATE OR REPLACE FUNCTION insert_update_daily_takings (ID BIGINT,
> TillName VARCHAR,
> Tape
> NUMERIC(10,2),
> Cash
> NUMERIC(10,2),
> GM NUMERIC(10,2),
> VenueManager
> NUMERIC(10,2),
> AsstManager
> NUMERIC(10,2),
> BarManager
> NUMERIC(10,2),
> PRCards
> NUMERIC(10,2),
> otherPromo
> NUMERIC(10,2),
> Functions
> NUMERIC(10,2),
> Accounts
> NUMERIC(10,2),
> Spill
> NUMERIC(10,2),
> Orings
> NUMERIC(10,2),
> Variance
> NUMERIC(10,2)
> ) RETURNS VOID AS
> $$
> BEGIN
> LOOP
> UPDATE daily_takings SET till_name = TillName,
> tape = Tape,
> cash = Cash,
> promo_manager = GM,
> venue_manager = VenueManager,
> asst_manager = AsstManager,
> bar_manager = BarManager,
> pr_cards = PRCards,
> other_promo = otherPromo,
> functions = Functions,
> accounts = Accounts,
> spill = Spill,
> o_rings = Orings,
> variance = Variance
> WHERE id = ID
> AND till_name = TillName;
> IF found THEN
> RETURN;
> END IF;
> BEGIN
> INSERT INTO daily_takings (id,
> till_name,
> tape,
> cash,
> promo_manager,
> venue_manager,
> asst_manager,
> bar_manager,
> pr_cards,
> other_promo,
> functions,
> accounts,
> spill,
> o_rings,
> variance)
> VALUES (ID,
> TillName,
> Tape,
> Cash,
> GM,
> VenueManager,
> AsstManager,
> BarManager,
> PRCards,
> otherPromo,
> Functions,
> Accounts,
> Spill,
> Orings,
> Variance);
> RETURN;
> EXCEPTION WHEN unique_violation THEN
> NULL
> END;
> END LOOP;
> END;
> $$
> LANGUAGE plpgsql;
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-08-12 07:24 Jack Tiger <gftigerjack@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Jack Tiger @ 2005-08-12 07:24 UTC (permalink / raw)
To: pgsql-sql
[SQL] unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-09-29 04:45 Ricky Sutanto <ricky.sutanto@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Ricky Sutanto @ 2005-09-29 04:45 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-09-29 06:17 noor@cs.man.ac.uk
0 siblings, 1 reply; 113+ messages in thread
From: noor@cs.man.ac.uk @ 2005-09-29 06:17 UTC (permalink / raw)
To: pgsql-sql
please take me out from this group.
^ permalink raw reply [nested|flat] 113+ messages in thread
* Re: unsubscribe
@ 2005-09-29 06:27 Kenneth Gonsalves <lawgon@thenilgiris.com>
parent: noor@cs.man.ac.uk
0 siblings, 0 replies; 113+ messages in thread
From: Kenneth Gonsalves @ 2005-09-29 06:27 UTC (permalink / raw)
To: pgsql-sql
On Thursday 29 Sep 2005 11:47 am, noor@cs.man.ac.uk wrote:
> please take me out from this group.
ask the guy who put you in the group to do it
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-09-30 02:16 Ricky Sutanto <ricky.sutanto@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Ricky Sutanto @ 2005-09-30 02:16 UTC (permalink / raw)
To: pgsql-sql
Please unsubscribe me
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-11-04 08:00 oliverp21@free.fr
0 siblings, 0 replies; 113+ messages in thread
From: oliverp21@free.fr @ 2005-11-04 08:00 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-12-09 05:37 Dinesh Pandey <dpandey@secf.com>
0 siblings, 0 replies; 113+ messages in thread
From: Dinesh Pandey @ 2005-12-09 05:37 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2005-12-20 23:53 William Lai <wlai2768@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: William Lai @ 2005-12-20 23:53 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-03-04 20:37 Peter Ivarsson <peter.ivarsson@onskefoto.se>
0 siblings, 0 replies; 113+ messages in thread
From: Peter Ivarsson @ 2006-03-04 20:37 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-03-14 04:04 Arulmani V A <arulmani_s@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: Arulmani V A @ 2006-03-14 04:04 UTC (permalink / raw)
To: pgsql-sql; majordomo@postgresql.org
unsubscribe
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-03-14 04:09 RaFaeL <rafael.rf@gmail.com>
0 siblings, 1 reply; 113+ messages in thread
From: RaFaeL @ 2006-03-14 04:09 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-03-14 04:25 Kenneth Hutchinson <kenneth.hutchinson@mpfyieldstar.com>
parent: RaFaeL <rafael.rf@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Kenneth Hutchinson @ 2006-03-14 04:25 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
This message is intended only for the use of the individual(s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to RealPage and its affiliated companies. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-07-08 11:35 Patrice OLIVER <oliverp21@free.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Patrice OLIVER @ 2006-07-08 11:35 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* UnSubscribe
@ 2006-09-21 04:47 vijay balan <vijay_gensec@yahoo.co.in>
0 siblings, 0 replies; 113+ messages in thread
From: vijay balan @ 2006-09-21 04:47 UTC (permalink / raw)
To: pgsql-sql
gould@embl.de wrote: Date: Fri, 15 Sep 2006 11:16:06 +0200
From: gould@embl.de
To: pgsql-sql@postgresql.org
Subject: [SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
hi
I am upgrading from pgsql 7.4.1 to pgsql 8.1.4. However, some of the application
queries won't run on the newer version of pgsql.
An example of the type of query is:
SELECT
protein_external_links.protein_id, external_links.external_id,
proteins.public_name
WHERE
protein_external_links.external_link_id = external_links.id and
protein_external_links.protein_id = proteins.id and
external_links.external_database_id != 8 and
external_links.external_id_type_id = 2;
on pgsql7.4.1 what tables need to be queried seems to be implicitly deduced from
the rest of the SQL without the need for a FROM clause.
However, on pgsql 8.1.4 the following error is given:
ERROR: missing FROM-clause entry for table "protein_external_links"
Is there some query optimization config setting I can set in pgsql 8.1.4 to fix
this problem rather than having to change the queries in the code? I've read
over the changes between pgsql 7 and pgsql 8 but nothing seems to stand out to
me as referencing this problem. Anyone with more knowledge that can point me in
the right direction?
Thanks
Kate
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------------
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
^ permalink raw reply [nested|flat] 113+ messages in thread
* UnSubscribe
@ 2006-09-21 06:13 dmz@streamyx.com
0 siblings, 0 replies; 113+ messages in thread
From: dmz@streamyx.com @ 2006-09-21 06:13 UTC (permalink / raw)
To: pgsql-sql; pgsql-sql
***********************
Your mail has been scanned by InterScan MSS.
***********************
^ permalink raw reply [nested|flat] 113+ messages in thread
* Unsubscribe
@ 2006-09-21 06:36 David Klugmann <dklugmann@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: David Klugmann @ 2006-09-21 06:36 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2006-11-08 12:41 Alejandro Fernandez <alejof8@yahoo.es>
0 siblings, 0 replies; 113+ messages in thread
From: Alejandro Fernandez @ 2006-11-08 12:41 UTC (permalink / raw)
To: pgsql-sql
Buenos días…
No me he podido dar de baja en la lista, alguien me pueden ayudar,
indicandome que debo hacer
gracias
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-08 13:30 oliverp21@free.fr
0 siblings, 0 replies; 113+ messages in thread
From: oliverp21@free.fr @ 2007-02-08 13:30 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-08 13:36 Susan Evans <sevans@haywood.k12.nc.us>
0 siblings, 0 replies; 113+ messages in thread
From: Susan Evans @ 2007-02-08 13:36 UTC (permalink / raw)
To: pgsql-sql
Unsubscribe
Susan Evans
Haywood County Schools
NCWISE Coordinator
216 Charles Street
Clyde, NC 28721
828-627-8314 (Phone)
828-627-8277 (Fax)
216 Charles Street
Clyde, NC 28721
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-08 14:45 Wilkinson, Jim <Jim.Wilkinson@cra-arc.gc.ca>
0 siblings, 0 replies; 113+ messages in thread
From: Wilkinson, Jim @ 2007-02-08 14:45 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-08 15:12 Adrien Lebre <lebre.adrien@free.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Adrien Lebre @ 2007-02-08 15:12 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
--
Adrien LEBRE
------------------------------------
Projet PARIS / XtreemOS
IRISA, Rennes, France
+33(0)2 99 84 22 39
------------------------------------
http://www.xtreemos.org
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-08 19:18 David Klugmann <dklugmann@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: David Klugmann @ 2007-02-08 19:18 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-09 04:25 Arulmani V A <arulmani_s@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: Arulmani V A @ 2007-02-09 04:25 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-09 08:26 Patrice Oliver <oliverp21@free.fr>
0 siblings, 0 replies; 113+ messages in thread
From: Patrice Oliver @ 2007-02-09 08:26 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
--
Patrice Oliver
Utilisateur GNU / Linux Enregistré 430054 http://counter.li.org
Jabber ID : oliverp21@jabber.fr
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-10 13:23 Franz Stuetzle <franz.stuetzle@gmx.net>
0 siblings, 0 replies; 113+ messages in thread
From: Franz Stuetzle @ 2007-02-10 13:23 UTC (permalink / raw)
To: pgsql-sql
Franz Stuetzle
Schertlinstr. 11-144
D-86159 Augsburg
Tel. +49821-2590898
mobil +49177-7394117
Fax +4969-13304974649
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-18 13:58 S.F. Lee <sflee_tw@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: S.F. Lee @ 2007-02-18 13:58 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-28 01:56 S.F. Lee <sflee_tw@yahoo.com>
0 siblings, 0 replies; 113+ messages in thread
From: S.F. Lee @ 2007-02-28 01:56 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
____________________________________________________________________________________
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-02-28 21:02 Franz Stuetzle <franz.stuetzle@gmx.net>
0 siblings, 0 replies; 113+ messages in thread
From: Franz Stuetzle @ 2007-02-28 21:02 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-14 20:38 Stefan <ionitastefan@hotmail.com>
0 siblings, 1 reply; 113+ messages in thread
From: Stefan @ 2007-03-14 20:38 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-15 06:50 Stefan Ionita <ionitastefan@hotmail.com>
parent: Stefan <ionitastefan@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Stefan Ionita @ 2007-03-15 06:50 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-15 08:40 Neelam Goyal <neelam.goyal@gmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Neelam Goyal @ 2007-03-15 08:40 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-15 11:56 Susan Evans <sevans@haywood.k12.nc.us>
0 siblings, 0 replies; 113+ messages in thread
From: Susan Evans @ 2007-03-15 11:56 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
--
Susan Evans
Haywood County Schools
NCWISE Coordinator
216 Charles Street
Clyde, NC 28721
828-627-8314 (Phone)
828-627-8277 (Fax)
216 Charles Street
Clyde, NC 28721
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-20 09:17 Stefan Ionita <ionitastefan@hotmail.com>
0 siblings, 2 replies; 113+ messages in thread
From: Stefan Ionita @ 2007-03-20 09:17 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-20 09:27 Stefan Ionita <ionitastefan@hotmail.com>
parent: Stefan Ionita <ionitastefan@hotmail.com>
1 sibling, 0 replies; 113+ messages in thread
From: Stefan Ionita @ 2007-03-20 09:27 UTC (permalink / raw)
To: pgsql-sql
unsubscribe ionitastefan@hotmail.com
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
^ permalink raw reply [nested|flat] 113+ messages in thread
* Re: unsubscribe
@ 2007-03-20 12:46 Alvaro Herrera <alvherre@commandprompt.com>
parent: Stefan Ionita <ionitastefan@hotmail.com>
1 sibling, 0 replies; 113+ messages in thread
From: Alvaro Herrera @ 2007-03-20 12:46 UTC (permalink / raw)
To: Stefan Ionita <ionitastefan@hotmail.com>; +Cc: pgsql-sql@postgresql.org, Marc Fournier <scrappy@hub.org>
Stefan Ionita wrote:
> unsubscribe
Marc, I would think that these list don't have the "administrativia"
flag set in the configuration. This is in the "moderation" class. The
help for this option is:
If the administrivia setting is set to "yes", posted messages which
match the patterns in the admin_body and admin_headers settings will
be sent to the moderators for review. These two settings are used to
keep commands, such as "remove" or "unsubscribe", from being posted to
a mailing list.
If the administrivia setting is set to "no", the admin_body and
admin_headers settings will have no effect.
The pgsql-es-ayuda list had it set to "no" (I just changed it), and it said
This value was determined by the DEFAULT settings.
So maybe the other lists are missing this setting. I remember Bruce
complaining about this not long ago (and threatening with Mailman!?)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-21 06:11 Stefan <ionitastefan@hotmail.com>
0 siblings, 0 replies; 113+ messages in thread
From: Stefan @ 2007-03-21 06:11 UTC (permalink / raw)
To: pgsql-sql
unsubscribe Stefan Ionita
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-21 06:36 Piotr Dabrowski <piotrdab@ks.onet.pl>
0 siblings, 0 replies; 113+ messages in thread
From: Piotr Dabrowski @ 2007-03-21 06:36 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 113+ messages in thread
* unsubscribe
@ 2007-03-22 11:55 Susan Evans <sevans@haywood.k12.nc.us>
0 siblings, 0 replies; 113+ messages in thread
From: Susan Evans @ 2007-03-22 11:55 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
--
Susan Evans
Haywood County Schools
NCWISE Coordinator
216 Charles Street
Clyde, NC 28721
828-627-8314 (Phone)
828-627-8277 (Fax)
216 Charles Street
Clyde, NC 28721
^ permalink raw reply [nested|flat] 113+ messages in thread
end of thread, other threads:[~2007-03-22 11:55 UTC | newest]
Thread overview: 113+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-09 11:05 unsubscribe Roman Volkoff <rv@tlg.khv.ru>
1998-07-19 06:04 unsubscribe Jerome Knobl <jknobl@mandanet.ch>
1998-08-02 16:46 unsubscribe Roman Volkoff <rv@tlg.khv.ru>
1998-08-06 05:46 UNSUBSCRIBE Ricardo Romero <rromero@netfriendly.com>
1998-10-07 19:52 unsubscribe Florian M Unterkircher <florian@mail.com>
1998-10-28 07:03 Unsubscribe Felix Kwong <f.kwong@ieee.org>
1998-11-13 02:06 unsubscribe Jiang Feng <fjiang@online.sh.cn>
1998-11-17 10:29 unsubscribe Nicoleta TATARU <nicol@medanet.ro>
1999-01-09 20:11 unsubscribe Zmarzlowski <zmarzlow@club-internet.fr>
1999-01-24 19:56 unsubscribe Zmarzlowski <zmarzlow@club-internet.fr>
1999-02-11 14:48 unsubscribe Thomas Schoessow <TSchoessow@t-online.de>
1999-02-13 08:25 unsubscribe Walter Butz <walterbutz@gmx.net>
1999-03-11 05:59 unsubscribe Vikrant Rathore <vikrant@chemquick.com>
1999-03-13 18:04 unsubscribe Ana Badillo <abadillo@mixteco.utm.mx>
1999-03-17 23:02 unsubscribe Bill Barber <bbarber@zebra.net>
1999-07-08 11:07 unsubscribe Seb <unixseb@club-internet.fr>
1999-08-05 16:16 unsubscribe BOUARD, Fabrice <fbouard@eurosport.co.uk>
1999-09-15 06:49 unsubscribe Weon-sun Lee <randy@hostbank.net>
1999-10-11 07:34 unsubscribe Martin Dolog <dolog@mcprogress.com>
1999-10-25 16:21 unsubscribe BOUARD, Fabrice <fbouard@eurosport.co.uk>
1999-11-03 13:24 unsubscribe Joel Fischer <joelf@min.ascend.com>
1999-11-07 12:23 unsubscribe Adrian Alb <alb@stockgroup.com>
1999-11-22 17:07 unsubscribe Drinks, Ivan - ITD <DrinkIX@ci.denver.co.us>
1999-12-29 15:15 unsubscribe Steven Pennie <Steven@ksdot.org>
2000-01-02 15:12 unsubscribe lyman1@mindspring.com
2000-10-30 14:39 unsubscribe Vadim Govorov <vadimg@piter.com>
2000-10-30 15:28 unsubscribe Schlobohm, Jack <SchlobohmJ@DNB.com>
2002-07-01 16:28 unsubscribe Simeone, Mario <msimeone.c@mail.tim.it>
2002-08-26 09:29 unsubscribe Gaetano Mendola <mendola@bigfoot.com>
2002-08-28 07:30 unsubscribe Gaetano Mendola <mendola@bigfoot.com>
2002-12-18 17:07 unsubscribe Kristopher Yates <kris@grinz.com>
2002-12-19 12:32 unsubscribe david williams <dw_remote@hotmail.com>
2002-12-19 12:39 Re: unsubscribe Christoph Haller <ch@rodos.fzk.de>
2002-12-19 14:47 ` Robert Treat <xzilla@users.sourceforge.net>
2002-12-30 17:09 unsubscribe jrJAMES <migraine007ph@yahoo.com>
2002-12-30 17:21 ` Rajesh Krishnamoorthy <raj_krishnamoorthy@yahoo.com>
2003-02-03 16:40 unsubscribe Josef Astner <joastner@dnet.it>
2003-04-01 16:59 unsubscribe V. Cekvenich <netsql@yahoo.com>
2003-04-03 11:21 unsubscribe Jose Luis LG <jlopezgonz@terra.es>
2003-04-05 20:48 ` CIC mail <cguzman@cic.ipn.mx>
2003-04-04 19:57 unsubscribe Raj Arya <raj.arya@lineone.net>
2003-04-06 18:37 Unsubscribe Charles McClain <chasmccl@pacbell.net>
2003-04-08 10:51 unsubscribe 2000info <2000info@netsite.com.br>
2003-04-08 15:41 unsubscribe Antony Gubert <vagreaty@hotmail.com>
2003-04-09 13:28 unsubscribe Charles McClain <chasmccl@pacbell.net>
2003-04-11 04:16 unsubscribe 2000info <2000info@netsite.com.br>
2003-04-16 22:20 unsubscribe Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
2003-04-30 01:00 unsubscribe David Durst <ddurst@larubber.com>
2003-05-29 09:08 unsubscribe Mona Shah <monashah@ipr.res.in>
2003-07-29 14:04 unsubscribe Mark Roberts <RoberM1@gosh.nhs.uk>
2003-07-29 15:14 Unsubscribe Antony Gubert <vagreaty@hotmail.com>
2003-07-29 20:46 Unsubscribe ww zz <ts_999@yahoo.com>
2003-07-29 23:06 Unsubscribe Vishal Charan (IT Fiji) <VCharan@courts.com.fj>
2003-07-31 00:25 Unsubscribe 2000info <2000info@netsite.com.br>
2003-07-31 08:35 Unsubscribe rute solipa <rutes@eselx.ipl.pt>
2003-09-02 08:29 unsubscribe Rute Solipa <rutes@eselx.ipl.pt>
2003-09-03 17:46 unsubscribe Antony Gubert <vagreaty@hotmail.com>
2003-09-23 02:54 unsubscribe Rudi Starcevic <rudi@oasis.net.au>
2003-10-01 09:28 Unsubscribe Rute Solipa <rutes@eselx.ipl.pt>
2003-10-01 09:35 Unsubscribe dnaren@hss.hns.com
2003-10-01 09:44 Unsubscribe Mark Roberts <RoberM1@gosh.nhs.uk>
2003-10-27 08:11 unsubscribe Antony Gubert <vagreaty@hotmail.com>
2003-10-27 11:03 Unsubscribe Mukta Telang <mukta@darya.nio.org>
2003-11-05 04:49 UNSUBSCRIBE Atul Pedgaonkar <atul@imcindia.net>
2004-02-06 11:33 unsubscribe jan bok <janbok@xs4all.nl>
2004-02-06 17:15 unsubscribe Mona H. Kapadia <monashah@ipr.res.in>
2004-02-09 17:22 unsubscribe Mona <monashah@ipr.res.in>
2004-02-11 19:45 unsubscribe Mona <monashah@ipr.res.in>
2004-06-28 18:27 unsubscribe beyaNet <beyanet@ntlworld.com>
2004-09-20 21:30 unsubscribe Ramiro Batista da Luz <ramiro@onda.com.br>
2005-04-24 16:38 unsubscribe Alexander Vlasenko <intrnl_edu@ilyichevsk.odessa.ua>
2005-05-26 12:52 unsubscribe U K Laxmi <laxmiuk@yahoo.com>
2005-06-01 17:28 unsubscribe Cordova Juillerat Jorge Alejandro <jcordova@entel.cl>
2005-06-01 17:35 ` Ing. Jhon Carrillo - Caracas, Venezuela <jdigital@cantv.net>
2005-08-09 22:31 unsubscribe Timothy Smith <timothy@open-networks.net>
2005-08-12 07:24 unsubscribe Jack Tiger <gftigerjack@gmail.com>
2005-09-29 04:45 unsubscribe Ricky Sutanto <ricky.sutanto@gmail.com>
2005-09-29 06:17 unsubscribe noor@cs.man.ac.uk
2005-09-29 06:27 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2005-09-30 02:16 unsubscribe Ricky Sutanto <ricky.sutanto@gmail.com>
2005-11-04 08:00 unsubscribe oliverp21@free.fr
2005-12-09 05:37 unsubscribe Dinesh Pandey <dpandey@secf.com>
2005-12-20 23:53 unsubscribe William Lai <wlai2768@gmail.com>
2006-03-04 20:37 unsubscribe Peter Ivarsson <peter.ivarsson@onskefoto.se>
2006-03-14 04:04 unsubscribe Arulmani V A <arulmani_s@yahoo.com>
2006-03-14 04:09 unsubscribe RaFaeL <rafael.rf@gmail.com>
2006-03-14 04:25 ` Kenneth Hutchinson <kenneth.hutchinson@mpfyieldstar.com>
2006-07-08 11:35 unsubscribe Patrice OLIVER <oliverp21@free.fr>
2006-09-21 04:47 UnSubscribe vijay balan <vijay_gensec@yahoo.co.in>
2006-09-21 06:13 UnSubscribe dmz@streamyx.com
2006-09-21 06:36 Unsubscribe David Klugmann <dklugmann@hotmail.com>
2006-11-08 12:41 unsubscribe Alejandro Fernandez <alejof8@yahoo.es>
2007-02-08 13:30 unsubscribe oliverp21@free.fr
2007-02-08 13:36 unsubscribe Susan Evans <sevans@haywood.k12.nc.us>
2007-02-08 14:45 unsubscribe Wilkinson, Jim <Jim.Wilkinson@cra-arc.gc.ca>
2007-02-08 15:12 unsubscribe Adrien Lebre <lebre.adrien@free.fr>
2007-02-08 19:18 unsubscribe David Klugmann <dklugmann@hotmail.com>
2007-02-09 04:25 unsubscribe Arulmani V A <arulmani_s@yahoo.com>
2007-02-09 08:26 unsubscribe Patrice Oliver <oliverp21@free.fr>
2007-02-10 13:23 unsubscribe Franz Stuetzle <franz.stuetzle@gmx.net>
2007-02-18 13:58 unsubscribe S.F. Lee <sflee_tw@yahoo.com>
2007-02-28 01:56 unsubscribe S.F. Lee <sflee_tw@yahoo.com>
2007-02-28 21:02 unsubscribe Franz Stuetzle <franz.stuetzle@gmx.net>
2007-03-14 20:38 unsubscribe Stefan <ionitastefan@hotmail.com>
2007-03-15 06:50 ` Stefan Ionita <ionitastefan@hotmail.com>
2007-03-15 08:40 unsubscribe Neelam Goyal <neelam.goyal@gmail.com>
2007-03-15 11:56 unsubscribe Susan Evans <sevans@haywood.k12.nc.us>
2007-03-20 09:17 unsubscribe Stefan Ionita <ionitastefan@hotmail.com>
2007-03-20 09:27 ` Stefan Ionita <ionitastefan@hotmail.com>
2007-03-20 12:46 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-03-21 06:11 unsubscribe Stefan <ionitastefan@hotmail.com>
2007-03-21 06:36 unsubscribe Piotr Dabrowski <piotrdab@ks.onet.pl>
2007-03-22 11:55 unsubscribe Susan Evans <sevans@haywood.k12.nc.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox