On Fri, Apr 29, 2016 at 10:16 PM Thomas Munro
wrote:
> On Sat, Apr 30, 2016 at 10:48 AM, Eric Ridge wrote:
> > I want to force my database to wraparound, just to see what happens. How
> > can I do this without consuming a few billion transactions?
>
> Take a look at t
I want to force my database to wraparound, just to see what happens. How
can I do this without consuming a few billion transactions?
My google-fu is failing me. :(
Thanks for your time!
eric
# select version();
version
---
PostgreSQL 9.
Hi!
What's the incantation one needs to recite before compiling Postgres
8.4.x on OS X 10.7 such that psql's tab completion will work?
I love my Mac, but Apple really dorked up libedit/readline and I just
can't figure out what I'm supposed to do.
Any hints will be greatly appreciated!
eric
--
On Wed, Jul 27, 2011 at 2:12 PM, Sebastian Jaenicke
wrote:
> On Wed, Jul 27, 2011 at 09:34:20AM -0700, Ioana Danes wrote:
>
>> #ifdef PG_MODULE_MAGIC
>
> #ifndef
Just to avoid confusion... #ifdef *is* correct. See:
http://www.postgresql.org/docs/current/static/xfunc-c.html
(I can't commen
PostgreSQL 8.4.8 on i386-apple-darwin10.7.0, compiled by GCC
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664),
64-bit
I'm not sure exactly what's going on, but I've got a table defined like this:
CREATE TABLE foo (
...
tags varchar(1000)[],
...
);
CREATE INDEX i
On Tue, Aug 10, 2010 at 6:46 PM, Tom Lane wrote:
>
> That's just one SELECT command. Sub-SELECTs inside a query don't
> count as separate commands for this purpose; the use of SELECT in
> that way is just an artifact of the SQL grammar.
Thanks. That's what I figured, but wanted to make sure.
e
I think I've been studying the documentation too long and have thought
myself into a circle.
http://www.postgresql.org/docs/8.4/static/transaction-iso.html says:
"Also note that two successive SELECT commands can see different data,
even though they are within a single transaction, if other
trans
On Sat, Apr 17, 2010 at 1:42 PM, Adrian Klaver wrote:
I can get to both sites and telnet also. Must be something on your end :(
>
Yup, it was. :( I appreciate the confirmation that it was me, thanks!
eric
try again.
You can also try using OpenDNS servers.
--
Jorge Godoy
On Sat, Apr 17, 2010 at 11:57, Eric Ridge wrote:
> I'm only subscribed to -general and -hackers, so if this message should go
> to a different list, please feel free to forward it along, but I've been
>
I'm only subscribed to -general and -hackers, so if this message should go
to a different list, please feel free to forward it along, but I've been
unable to get to a couple of the Postgres websites for quite awhile.
Back on March 20 Bruce Momjian posted a link in -hackers to the 9.0 release
notes
On Feb 11, 2004, at 10:00 PM, Bruce Momjian wrote:
No one really has thought of that before. We could do it, though there
are admin reasons for restricting that ability. If we said only
superusers could change it, it wouldn't be very useful.
That's a good point.
It would be cool if SET could chan
Using PG 7.3.x, how stupid is this:
UPDATE pg_attribute SET atttypmod= WHERE ;
I had to do this on a database, and surprisingly it seems to have
worked just fine. The columns accept a larger value, the existing
values are still intact, and I've seen no other strange errors...
Am I l
On Apr 26, 2004, at 3:12 PM, Timothy Perrigo wrote:
I'm trying to set up some basic rules to log inserts, updates, and
deletes to tables in an inheritance hierarchy (by inserting records
into a log table), and I've got a couple of questions.
(1) Is it possible to create a rule on a base table a
On Apr 7, 2004, at 12:43 AM, Joe Conway wrote:
Eric Ridge wrote:
On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
And now you know why they are so good if you don't use all rows.
This benefit I think goes away if you use Joe Conway's suggestion of
WITH HOLD.
Okay, so WITH HOLD i
On Apr 7, 2004, at 7:51 AM, Jan Wieck wrote:
Eric Ridge wrote:
On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
If the underlying query is for example a simple sequential scan,
then the result set is not materialized but every future fetch
operation will read directly from the base table. This
On Feb 12, 2004, at 12:08 PM, Bruce Momjian wrote:
Yes, I think that would be the only way to go, but I would like to have
some other folks interested in extending the ps display before adding
such a capability.
Too bad nobody responded. I still think it would be a useful feature.
eric
On Feb 13, 2004, at 6:05 PM, Ron St-Pierre wrote:
I am using postgres 7.3.4 and need to be able to determine which
database a query is being run in (from a script). pg_database lists
databases but doesn't tell me which one is currently active. Is there
a query I can use along the lines of:
The
On Feb 12, 2004, at 11:54 AM, Bruce Momjian wrote:
Well, let's see if someone else like the feature because adding it
might
reduce its usability as a guaranteed value for admins.
Maybe making the ability to do this a configuration option (off by
default, of course) would make everyone happy?
eri
On Jan 24, 2004, at 3:58 PM, Tom Lane wrote:
True. So if your goal is to force the timestamp column to be the
correct value even when the user tries to set it to something else,
you'd still have to use a trigger or rule.
Maybe the rule is that the computed value is always used, unless:
UP
On Jan 24, 2004, at 2:34 PM, Tom Lane wrote:
The restriction is not that: the restriction is that you can't have an
infinite recursion in your rules. The above is infinitely recursive
because it says that for any UPDATE on mytable, you should also do an
UPDATE on mytable ... but then for that UPDA
On Sep 27, 2003, at 7:41 PM, Tom Lane wrote:
I'm not sure whether we are planning another 7.3 release or not. I'd
like to push forward to a 7.4 release, myself. Do you have any idea
when OS X 10.3 will be released? If it's further out than next month,
we could probably plan that 7.4 will win the
On Sep 21, 2003, at 3:11 PM, Tom Lane wrote:
BTW, is anyone interested in looking into whether we can be made to
build without using either flag? I tried it and saw a number of
I did this... before I knew about -no-cpp-precomp. :( I read all
about -traditional-cpp in the gcc man page, but cou
Hi!
I've got a UNIQUE constraint on a field, and obviously, when I try to
insert a duplicate value, I get a WARNING via psql (and an Exception via
the JDBC drivers) saying I tried to violate the constraint. No biggie.
This is what I expect.
The tricky part comes in when I violate the constraint
> I tried
>
> select distinct job_num, (select count(*) from search_records j where
> j.job_num=k.job_num) from search_records k
can't you just do:
select job_num, count(job_num) from search_records group by job_num
order by job_num
http://www.postgresql.org/idocs/index.php?queries.html#QUERIE
> It would be convenient to have fast access to binary data in
> the database
> that is similar to what other databases do. This would allow more
> applications to run on PostgreSQL.
For small sets of files you're probably right. When you start to reach
millions of files, it makes much more s
> only, a problem can be 30% grow of data... (you can use
> "lztext" that is compressed datype:-).
Alternativly, you can store "pointers" to the images in the database.
Such as a local filepath or url (file:///usr/local/myimages/foo.gif or
ftp://user:passwd@host/pub/myimages/foo.gif). Then you
27 matches
Mail list logo
