Elein Mustain
el...@varlena.com
510-637-9106
> On Mar 13, 2016, at 7:22 PM, Alvaro Herrera wrote:
>
> Elein wrote:
>
> Hi Elein,
>
>> * When an insert into an enum column fails give the person a hint as to
>> valid values
>
>> -- Lousy message.
Elein Mustain
el...@varlena.com
510-637-9106
> On Mar 11, 2016, at 3:45 PM, David G. Johnston
> wrote:
>
>> On Fri, Mar 11, 2016 at 4:19 PM, Elein wrote:
>
>> An unused (yet) enum type cannot display the enum ranges. An empty table
>> containing that t
displayed is confusing.
Enums are evil because of the difficulty working with them. They should be used
for a fixed set of valid values. Otherwise use a lookup table.
Elein Mustain
el...@varlena.com
510-637-9106
> On Mar 11, 2016, at 2:06 PM, David G. Johnston
> wrote:
>
>>
> select enum_range(color) from foo;
> enum_range
>
> (0 rows)
>
> insert into foo values ('red');
> INSERT 0 1
> insert into foo values ('blue');
> INSERT 0 1
>
> -- Ooh. Only shows the enum list for valid value in a tabl
The small problem with your version, Joshua, is that the appropriate action is
not specified.
Sorry to jump in in the middle. I have not read the comments fully.
Elein Mustain
el...@varlena.com
> On Jan 12, 2016, at 2:56 PM, Joshua D. Drake wrote:
>
>> On 01/12/2016 02:
stuff explicitly so that
we can
do it during lower traffic times. Like weekends rather than weekdays.
How can we do that?
elein
el...@varlena.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
ating rules or triggers to check
> the conditions, but I'm scared that this could either (a) get really
> complicated when there are a lot more tables and constraints involved or
> (b) introduce race conditions.
Why don't you add a field in animal_types that is boolean mauler.
Then you can add a trigger on the mauling table to raise an error
when the attacker_id is an animal type mauler.
--elein
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
IP 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
>
Is this what you mean? (Where arg takes and returns text)
elein=# select arg( arg('xxx') );
arg
-
xxx
(
esql-8.2.1/src/interfaces/ecpg'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/local/src/postgresql-8.2.1/src/interfaces'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/local/src/postgresql-8.2.1/src'
make: *** [all] Error 2
Any ideas?
elein
Is there still a problem here? Does anyone know what the
problem was? I have no trouble accessing varlena.com,
but I am not a good tester for that.
I was out of town during this thread but my machine did not
go down, but my isp could have.
You could have emailed me [EMAIL PROTECTED]
---elein
e
> I'll put in a stub about the "queues" stuff and see how people like the
> whole thing.
Have you made any consideration of providing feedback on autovacuum to users?
Right now we don't even know what tables were vacuumed when and what was
reaped. This might actually be
ffect to my
> person.name() method like so:
>
> CREATE TABLE person (
> id serial PRIMARY KEY,
> firstname text NOT NULL,
> lastname text NOT NULL,
> name GENERATED ALWAYS AS (firstname || ' ' || lastname)
> );
Illustra had the equivalent of columns defined as expressions
it again and that is
a big loss. (No I cannot volunteer since I have not finished my
other project I am volunteering on yet.)
--elein
[EMAIL PROTECTED]
On Mon, Oct 02, 2006 at 04:14:40PM -0500, Jim C. Nasby wrote:
> Patches welcome. :)
>
> BTW, -docs or -www might be a better place t
The technique for a single part gapless sequence and a two-part gapless
sequence has been published today at http://www.varlena.com/GeneralBits.
I'd be interested to hear of high concurrency usage that would break it
or be notably slow.
--elein
[EMAIL PROTECTED]
--
ct that the second transaction getting the newly updated
record from the first transaction. It seems pretty clear, not counting
aggregates,
that this is true from this doc snippet. Speak now, if someone doesn't read it
this way! I'd like to understand why.
If it w
-c "query" specifies the query to run
dbname is required if it is not the default.
Also see psql --help
elein
On Thu, Jun 29, 2006 at 11:40:49AM -0500, Scott Marlowe wrote:
> On Thu, 2006-06-29 at 11:29, Jasbinder Bali wrote:
> > isn't my normal bash script different from ps
Do you need to specify test_func.so not ...test_func
or has that changed?
--elein
On Tue, Jun 20, 2006 at 05:13:32PM -0400, Jasbinder Bali wrote:
> chmod 666 filename is something i've done to give permissions to all..
> still doesn't work.
>
>
> On 6/20/06, Bil
ee up
some space so I can go in and vacuum and delete rows?
This is somewhat urgent.
Thanks for your help.
--elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Mon, May 22, 2006 at 08:10:11PM +0200, Florian G. Pflug wrote:
> elein wrote:
> >This issue is a very old issue and people have not come up with
> >the definitive solution to distributing "datablades" as Stonebraker
> >called them.
> True, but OTOH there is no
be collected somehow. I think this may be a different class
of object, though. I already have a web page of these and it
surely can be added to (feel free to recommend some!). But the
installation of these fragments is usually cut and paste.
--elein
[EMAIL PROTECTED]
On Mon, May 22, 2006 at 05:38:
This is best done by using a trigger on the table.
http://www.varlena.com/GeneralBits/38.php shows how
to do it with both a trigger and with a rule.
--elein
[EMAIL PROTECTED]
On Fri, May 05, 2006 at 04:48:28PM -0400, Sean Hamilton wrote:
> I have to log each time a user selects data fro
On Wed, Apr 19, 2006 at 03:51:27AM +0200, Florian G. Pflug wrote:
> Tom Lane wrote:
> >elein <[EMAIL PROTECTED]> writes:
> >>I think I want to:
> >>create unique index pk on table tbl (keyp1, keyp2);
> don't you want
> create unique inde pk on
n the uniqueness constraints.
Opinions?
Thanks,
elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, Apr 18, 2006 at 09:50:04AM -0400, Tom Lane wrote:
> elein <[EMAIL PROTECTED]> writes:
> > Much later in the day, a vacuum analyze of the
> > db showed that all of the indexes for that table
> > required significant vacuuming, although the
> > table did not
require the
further vacuuming? Due to the insert only activity
on the table (and the db, mostly), I cannot understand
why the indexes require further vacuuming.
Ideas?
--elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your
There is also a description of an implementation for timetravel
at http://www.varlena.com/GeneralBits/122.php
If you would like to discuss this further, please let me know.
I've know postgres's and illustra's timetravel implementations.
--elein
[EMAIL PROTECTED]
On Thu, Feb 23
ose an index scan if your joining column's datatypes do not
>match
>
Not just non-compete agreements, but purchasing of employees with
the knowledge base is how it works. That is what Informix did with
Illustra--it bought the engineers. Sleepycat people are prob
The rumor wrt to buying sleepycat is true.
http://www.oracle.com/corporate/press/2006_feb/sleepycat.html
--elein
On Tue, Feb 14, 2006 at 08:32:00AM -0800, Rich Shepard wrote:
> On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
>
> >Oracle purchases Sleepycat. From what I understand
sider prepending the schema name with an
underscore. For example:
_pgdes.tablex
_pgdes.tabley
_pgdes.tablez
Be sure you tell people that the tables are being created in their
databases when you do it.
elein
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
,
Elein
[EMAIL PROTECTED]
--
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
(510)655-2584(o) (510)543-6079(c)
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits
tgresql and oracle is
that oracle can take the source code, branch it or not and support it.
If they branch, it will have less credibility and it will become "interesting".
But support money from a big name company (Oracle) should be
forthcoming in either case.
Long term that does
On Fri, Aug 19, 2005 at 07:06:02PM -0400, Alvaro Herrera wrote:
> On Fri, Aug 19, 2005 at 11:55:19AM -0700, elein wrote:
> > I'm cross posting to INTERFACES. Please follow up
> > on INTERFACES and not on general. Cross posting is evil.
>
> Well, I'm not on -in
I'm cross posting to INTERFACES. Please follow up
on INTERFACES and not on general. Cross posting is evil.
--elein
On Thu, Aug 18, 2005 at 05:02:18PM -0700, elein wrote:
> I am also seeing this situation using hibernate.
>
> Some of the IDLE-in-transaction connections are s
tion to this problem, many people, especially
myself would be very very happy.
--elein
--
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
(510)655-2584(o) (510)543-6079(c)
PostgreS
Thanks. I understand that much. I want to know if this
is the intended behaviour.
--elein
On Wed, Jun 29, 2005 at 08:25:09PM +, Matt Miller wrote:
> On Wed, 2005-06-29 at 13:04 -0700, elein wrote:
> > default constraint
> > ...
> > elein=# insert into nulldefault val
integer NOT NULL default 1 );
CREATE TABLE
^
elein=# insert into nulldefault values (NULL);
ERROR: null value in column "one" violates not-null constraint
elein=# create table defaultnull (one integer default 1);
CREATE TABLE
elein=# insert into defaultn
he result be the exact same database schema.
If they are not, checkpoint with a schema dump and start
again with the change scripts. Of course getting the
scripts wrong is against the point of the whole exercise,
but it is not easy and requires vigilance.
changes. They must be cumulative.
Ideally you'd have corresponding undochange01.sql
but that is icing.
Never let anyone change the database without creating
the appropriate change script.
--elein
On Thu, Jun 09, 2005 at 03:25:14PM -0500, Peter Fein wrote:
> Hi-
>
> Any general tips on
http://www.varlena.com/GeneralBits/107.php has an explanation
of the statistics views pg_stat*. Perhaps those would help.
--elein
[EMAIL PROTECTED]
On Wed, May 11, 2005 at 04:12:11PM -0700, Marc Munro wrote:
> On a 7.3 production system with limited downtime available, we can
> rarely ta
QUE NOT NULL
or PRIMARY KEY. Then is will work fine.
See also: http://www.varlena.com/GeneralBits/106.php
--elein
>
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
>
ying problem is the need for a semi-sane, preferably SQL
version of jagged rows. I would certainly use the original jagged
rows if I could.
Elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
There is a new project on pgfoundry, newsysviews, that is addressing
this and similar reporting issues.
--elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Consulting, Support & Trai
to see the 1337 .po. 1 4/\/\ 57|_|d`/ing
l337 45 4 53c0/\|d 14/\|g|_|4g3.
But I am disappointed that the reference to general bits in the newsletter
was completely straight.
--elein
---(end of broadcast)---
TIP 9: the planner will ignore your desire
Aha you are right. I tried this but set log min error statement
instead and so *that* didn't work.
Setting the right variable worked and I can now see the plan.
Thanks!!
--elein
On Wed, Mar 23, 2005 at 01:05:30PM -0700, Michael Fuhr wrote:
> On Wed, Mar 23, 2005 at 11:38:21AM -0800, ele
onto irc from this client site.
--elein
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Try creating the trigger on BEFORE DELETE.
--elein
On Fri, Feb 25, 2005 at 05:14:18PM -0700, [EMAIL PROTECTED] wrote:
> Yes, thank you, I corrected my function from statement level to row level.
> This did get rid of the error message. However, I still get no output from
> an OLD vari
Alternatives to returning a set of rows is to return
a set of integers, one per row selected. Same example
as Huxton's without the row type.
Also you could return an array of integers.
--elein
On Thu, Feb 24, 2005 at 09:00:46PM +, Charl Gerber wrote:
> I'm trying to create a
RE user_id = 'bob'
AND just_digits(telephone) = '1115551212';
--elein
On Sat, Feb 12, 2005 at 12:27:20PM -0500, Tom Lane wrote:
> "F.Bissett" <[EMAIL PROTECTED]> writes:
> > On Fri=
> > , 11 Feb 2005 19:56:33 -0800, Jeff Davis wro
Installation of a new version of python (2.1) did the trick.
The apparent failure of 2.1 was because 1.x remains on the
system and I had to convince configure to ignore it.
(PYTHON=python2)
Thank you all.
--elein
On Wed, Feb 02, 2005 at 05:01:21PM -0600, Scott Marlowe wrote:
> On Wed, 2005
It did have an old python and we updated it to
python 2.1 and the problem still occurs.
Is there a documented minimum python version required?
--elein
On Wed, Feb 02, 2005 at 04:16:03PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> > Fedora as listed below is reall
Fedora as listed below is really, RedHat Enterprice Linux ES 2.1
I'm not sure about the second failing system.
--elein
On Wed, Feb 02, 2005 at 10:32:06AM -0800, elein wrote:
> Debian--works (mine)
> Fedora--doesn't work (not mine)
> RedHat--doesn't work (not mine)
>
Debian--works (mine)
Fedora--doesn't work (not mine)
RedHat--doesn't work (not mine)
Is it possible that there is a problem with glibc?
If so, what does one do about that?
--elein
On Wed, Feb 02, 2005 at 01:25:03PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> >
py
PyDict_Copy is a python standard call since forever.
nm shows it is not defined.
nm also shows some glib.c functions not defined.
build --with-python and createlang works fine on some other machines.
What is the problem here? Some python module I'm missing?
Help!
--el
I am reading it backwards.
--elein
On Sun, Jan 30, 2005 at 06:51:42PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> > I have multiple statements in a READ COMMITTED transaction that
> > can see COMMITs from another concurrent transaction (although not
> > vi
On Sun, Jan 30, 2005 at 05:46:03PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> > I tried to reproduce the case where 7.4 and 8.0 differ
> > on the scope of volitile function with READ COMMITTED
> > transactions.
>
> > In an open transaction in r
committed insert transactions by another session
while the first transaction is open.
Perhaps I'm missing something basic? Or the fix was
back ported to 7.4?
Prompt replies would be very helpful.
--elein
---(end of broadcast)---
TIP 7: don
General Bits has returned from its sabbatical.
The newest issue is now available!
Issue #94 of PostgreSQL General Bits, the weekly column of
bits, tidbits and factoids for PostgreSQL is now available at:
http://www.varlena.com/GeneralBits/
Cheers,
elein
On a 7.4 installation built --with-python...
Python installed is 2.3.4.
On createlang, I get the following error:
createlang -U postgres 'plpythonu' template1
createlang: language installation failed: ERROR: could not load
library "/usr/local/pgsql74/lib/plpython.so":
/usr/local/pgsql74/lib/
el elefante nunca olvide :)
the elephant never forgets
On Fri, Dec 10, 2004 at 04:02:42PM -0500, Mirko Coz wrote:
> Amigos:
>
> ¿Qué significado tiene el logo de PostgreSQL?
>
> Saludos,
>
> --
> Mirko Coz Berrospi
>
> ---(end of broadcast)---
What is the current wisdom on setting the fsm variables
for 8.0? How is it different from 7.4? Or is it?
I am assuming these are the values that changed with
Jan's changes. If not what were those variables?
(I can't seem to track down the threads on these things.
select count(*) from pg_stat_activity;
for detailed info use:
select * from pg_stat_activity;
On Mon, Sep 13, 2004 at 02:49:36PM -0300, MaRCeLO PeReiRA wrote:
> Hi guys,
>
> How can I know about the number of active
> connections?? (not the maximum allowed, but the number
> of open connections)
What is the linux and/or postgres limitation for very
large databases, if any? We are looking at 6T-20T.
My understanding is that if the hardware supports it,
then it can be done in postgres. But can hardware
support that?
--elein
loosely from the pgsql-general
mailing list.
--elein
[EMAIL PROTECTED]
On Sat, Jul 17, 2004 at 07:42:41PM +0430, Lee Harr wrote:
> Hi;
>
> I have been writing a ton of PL/pgSQL lately. It seems like there is
> probably a lot of code out there that would be of general use to
> other p
lementation
of R-trees that would also be helpful.
I believe it is intersects and overlaps but
it would be nice to get confirmation.
Thanks,
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Con
fails because it is a view and not a table.
Is it because updates to the catalogs can be done outside
of transactions? Is that a good enough reason?
thanks,
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
http://www.varlena.com/GeneralBits/
cheers,
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
1-866-varlena
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://w
I have some light examples in
http://www.varlena.com/GeneralBits/Tidbits
based on Stephan's.
The discussion in issue
http://www.varlena.com/GeneralBits/24.html
shows the differences between setof and rows.
--elein
On Mon, Feb 02, 2004 at 09:47:11AM -0800, Joe Conway wrote:
> Tom La
://www.varlena.com/Reports/
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://www.varlena.com/General
ETURN high;
END;
' LANGUAGE 'plpgsql' IMMUTABLE STRICT;
create table mytable (myarray text[]);
insert into mytable values ('{"abc","d e f"}');
update mytable set myarray[array_next(myarray)] = 'new element';
regression=# s
PostgreSQL General Bits Issue #56 has an article on Join Basics
which also has an example of multiple table joins.
http://cookie.varlena.com/varlena/GeneralBits/56.php
--elein
[EMAIL PROTECTED]
On Fri, Jan 30, 2004 at 03:03:35PM -0700, Anony Mous wrote:
> Hi,
>
>
>
> I??m fai
If you know about these functions before
you create your databases, install them into
template1. Then all subsequently created databases
will have them.
If the databases already exist, you need to do what you did.
--elein
[EMAIL
Yes, I did. For just the simple updating, (not the
logging you are doing) NEW is what you want. But OLD is proper
for archiving/logging.
--elein
On Mon, Jan 12, 2004 at 08:22:27PM +0700, Chris Travers wrote:
> Hi Elein;
>
> Nope, OLD is correct. I track the OLD values and then use
, I am loathe
to argue a table with no columns is
an invalid argument.
Is there a previous rule on this issue?
--elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Consulting, Support & Trai
I can create a function with a domain and
define it to return a domain.
The parameter is checked to see if it qualifies
in the constraint of the domain, however, the
return value is not.
Is this a bug? Is the author of the function
responsible for re-inforcing the constraint
at runtime?
This
) follow up each close with a DELETE of the rows
in question. The only tricky part is deciding on the
key so that it is known both before and after the connection.
Does this make sense?
elein
On Fri, Nov 07, 2003 at 01:09:15PM -0800, Boris Popov wrote:
> Hello pgsql-general,
>
> I&#x
There is an example and discussion of implementing
history tracking of updates to a table. It includes
the discussion of the update rule technique as well.
See http://www.varlena.com/GeneralBits/38.php
elein
[EMAIL PROTECTED]
On Tue, Oct 28, 2003 at 11:43:44AM +, Alex Page wrote:
>
In addition to all of the fancy tools, there is the
simple options on psql:
psql -H -c "select * from pg_user;";
This outputs the selections in HTML which I am
not including here. If you also use the -T
option you can set the table attributes.
--elein
[EMAIL
- Forwarded message from elein <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Sun, 14 Sep 2003 20:48:22 -0700
From: elein <[EMAIL PROTECTED]>
To: Avi Schwartz <[EMAIL PROTECTED]>
Cc: elein <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] is General Bits Issu
If the function is defined with ANY*
and you defer typing the arguments until the first reference
then I think you will get what you want with the CASE statement.
If the function is called if( x>y, x+1, y), the first reference
is in the argument list and so should be typed there. But if
you pas
is pertinent to postgreSQL because our
BSD license is a "selling point" for us. We need to know the differences
between BSD and other licensing schemes.
--elein
On Sun, Aug 31, 2003 at 03:26:24PM +0300, Kaarel wrote:
> I don't feel very confident when it comes to software licen
There is an article on General Bits about this.
The article contains a view to pull out the
code in a readable format (with newlines).
http://www.varlena.com/GeneralBits/39.php
[EMAIL PROTECTED]
On Fri, Aug 29, 2003 at 11:27:38AM -0700, Seth wrote:
> How do I view the arguments and deta
Can someone list susinctly the points of
failure with using a file system snapshot
solution to replicate a database for failover?
If there is an acceptable time gap (5 minutes?) and
the ability to reapply dropped changes how does
this affect a file system snapshot solution,
or does it?
[EMAIL PRO
. Implementing
the presentation ordering will probably give a
solution to the rowtype problem.
elein
On Saturday 28 June 2003 08:05, Jan Wieck wrote:
> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Is the issue of many columns in a tuple the same issue
Thanks, Scott.
I believe that was Kevin Jacobs in a message to pgsql-general
and I've sent him a message about being available for testing.
-elein
On Thursday 19 June 2003 14:27, scott.marlowe wrote:
> As I understand it, plpython currently relies on the rexec call /
> interface
t something
and being unwilling to participate.
elein
On Thursday 19 June 2003 14:39, Tom Lane wrote:
> elein <[EMAIL PROTECTED]> writes:
> > I strongly protest the pulling of plpython.
>
> I seem to have missed the part of this where you volunteer to fix it.
> Compla
I strongly protest the pulling of plpython.
Make it untrusted if necessary, but don't
pull it. The capabilities of plpython are
much too valuable to trash.
At this point I am available as a tester,
but not as a developer for any changes to the
interface. Drag me into the frey. I may also
be fr
I cannot seem to insert hex values into an int column.
I must be doing something really stupid wrong, but I
can't see it.
insert into mytable (intcolumn) values (0xaabbcc);
parser error at "xaabbcc"
insert into mytable (intcolumn) values ('0xaabbcc');
pg_atoi...can't part "xaabb
. Boy, wouldn't I love to
have a good ORDBMS schema tool... Too bad informix's isn't
good.
elein
ex-ingres, ex-miro/illustra, ex-informix
currently postgreSQL database architect
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Sorry to contribute to this list chaos, but I've got a question.
Yes, I know this is not normalized...
I have a table foo with key fookey.
I have a table bar which has as an attribute an array of fookeys called FK.
The number of elements in FK is variable.
I would like to:
select b.fookey, b
89 matches
Mail list logo
