Elein Mustain
el...@varlena.com
510-637-9106
> On Mar 13, 2016, at 7:22 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote:
>
> Elein wrote:
>
> Hi Elein,
>
>> * When an insert into an enum column fails give the person a hint as to
>> valid values
>
Elein Mustain
el...@varlena.com
510-637-9106
> On Mar 11, 2016, at 3:45 PM, David G. Johnston <david.g.johns...@gmail.com>
> wrote:
>
>> On Fri, Mar 11, 2016 at 4:19 PM, Elein <el...@varlena.com> wrote:
>
>> An unused (yet) enum type cannot dis
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 <david.g.johns...@gma
ows)
>
> 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 table.
> select enum_range(color) from foo;
> enum_range
> ---
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 <j...@commandprompt.com> wrote:
>
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/pgsql
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
, 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
(1 row)
--elein
---(end of broadcast
/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
---(end of broadcast
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
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 another topic.
---elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
as expressions.
I don't remember the syntax, but it was simpler than GENERATED.
But better go with the spec.
Late on the thread,
--elein
I think the generated column idea has some usefulness, but isn't quite
what I'm after. You can't use it with additional parameters (c.f. my
earlier birthday(int
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 to discuss
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]
---(end
caught a duplicate
value and tried again, looping.
I may publish the gapless sequence technique on general bits if there is no
discrepancy in the understanding of the status of the second transaction's
row value (updated).
--elein
[EMAIL PROTECTED]
--
Adrian Klaver
[EMAIL PROTECTED
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 psql.
In a bash script how wud u specify
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, Bill Moran [EMAIL PROTECTED] wrote
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
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:35PM +0200, Florian G. Pflug wrote:
Agent M wrote:
I
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 definitive solution for OS-level package
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 from a table
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.
What do you mean by that exactly
the uniqueness constraints.
Opinions?
Thanks,
elein
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
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 table tbl (keyp1, keyp2) where keyp3 is null
here
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, 2006 at 10:52
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, BerkeleyDB
_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 http
case.
Long term that does not help the support companies, like mine and those
mentioned above. Or maybe it does because we're smaller and faster.
--elein
--
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
(510)655-2584(o
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 sitting
there holding
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 -interfaces, so I'll reply to both :-) I
, especially
myself would be very very happy.
--elein
--
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
(510)655-2584(o) (510)543-6079(c)
PostgreSQL Consulting, Support Training
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 defaultnull values (NULL
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 values (NULL);
ERROR: null
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 using version
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.
--elein
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 take
table pagesrc
!--!
thoughts?
thanks,
aaron
You need to alter table Fooey to add fooid as UNIQUE NOT NULL
or PRIMARY KEY. Then is will work fine.
See also: http://www.varlena.com/GeneralBits/106.php
--elein
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 unregister command
(send unregister YourEmailAddressHere
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 Training
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 to choose an index scan if your
joining column's datatypes do not match
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])
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, elein wrote
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 function
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 variable
= '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:
/headBODY BGCOLOR=3D#F0F0F0 pSPAN style=3Dfont-size:10pt;On Fri=
, 11 Feb 2005 19:56:33 -0800, Jeff Davis wrote:br //SPANSPAN
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!
--elein
[EMAIL PROTECTED
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:
When I createlang
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)
Is it possible
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 really, RedHat
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-02-02
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't forget
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 read committed mode.
Then I access
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
vice versa, of course). The behaviour
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:
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)---
TIP 8:
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.)
--elein
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
-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 Consulting, Support
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
://www.varlena.com/GeneralBits/
cheers,
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
1-866-varlena
PostgreSQL Consulting, Support Training
PostgreSQL General Bits http://www.varlena.com
element';
regression=# select * from mytable;
myarray
-
{abc,d e f,new element}
(1 row)
Elein
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
://www.varlena.com/Reports/
elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Consulting, Support Training
PostgreSQL General Bits http://www.varlena.com/GeneralBits
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 Lane wrote
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
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 fairly new
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 the view
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
, 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 Training
) 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'm trying to implement
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 PROTECTED
- 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 Issue # 43 correct?
In-Reply
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 licenses. But
there are some cases I would
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
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
. 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 as a SELECT
having many
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.
Complaining will not change anything; someone stepping up
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 to function
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
. 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 Of Alex Pilosov
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,
84 matches
Mail list logo