e data
> consistency.
--
Scott Ribe
scott_r...@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nutes. So
what you want is:
timestampcol1 - timestampcol2 <= '1 hour' and timestampcol2 - timestampcol1
<= '1 hour'
Because intervals can be negative...
BTW, you can figure out some of these things in psql, by trying things like
"select '2008-03-06 08:00:00':tim
ial subscription. My data set is quite a bit smaller, and I've
gotten into the habit of turning off fsync during the initial post-upgrade
load, to shorten my downtime.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailin
*contiguous* hole in the middle of the table would matter as much for
queries, because most rows would still be close to each other--most queries
would pull from one side or other of the hole, and even for those that
didn't, it would be one seek across the hole, not seeking all over
> Wouldn't new / updated tuples just get put in the hole, fairly rapidly
> un-clustering the table again?
How is that different than putting them in newly-allocated space at the end
of the table?
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
-
> Huh? A plain vacuum wouldn't fix that; a vacuum full would close up the
> hole, but (a) it'd not preserve the row ordering, and (b) it'd take an
> exclusive lock.
OK.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pg
ults in both changes being seen by the query.)
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tes, or a heavier load, and I might have a bigger
problem.)
Four years of using PostegreSQL, and finally there's a bug that actually
affects the correct operation of my software. Not too shabby ;-)
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Se
I don't remember if MagicDraw supports multiple schema or not, but back when
I was looking at CASE-type tools it was one the nicer ones that I found that
would run on platforms other than Windows.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sen
It's not open source; it's expensive; but the products from Embarcadero work
pretty well.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
f course schema
changes would be locked out during the cluster, even if it takes days ;-)
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Agreed that would be more desirable; thought it might be more difficult.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
If I had an admin roaming through my document server deleting document files
out from under my database, that's a problem I would solve very
quickly--with a completely non-technical "solution".
After all, what's to prevent such a person from deleting pgsql data files???
--
inds of sense.
On the contrary, I think backup is one of the primary reasons to move files
*out* of the database. Decent incremental backup software greatly reduces
the I/O & time needed for backup of files as compared to a pg dump. (Of
course this assumes the managed files are long-lived
g to selecting from a select:
select dt, count(1), numpgs from (
select docs.imported_when::date as dt, count(1) as numpgs
from docs, pages
where docs.id = pages.doc_id
group by docs.imported_when::date, docs.id
) as t1 group by dt order by dt;
--
Scott Ribe
scott_r...@killer
Yes, obviously that should have been sum(numpgs) in the select list of the
last query... Question remains the same...
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
> If I understand you correctly..?
Yes, exactly! I think I was suffering from a flashback to a very old DBMS
that didn't support that use of distinct...
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing lis
Shut down the postmasters and rsync. (Assuming same architecture & build
options...)
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
> You mean rsync the "data" folder, or the entire PG folder?
I meant the data folder.
> Will this be a challenge?
Yes, if you're using different major PG releases, then the data files are
not binary compatible.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.kille
ou
don't want to copy some config files, or you have some table spaces off on
another volume, you may need to do something a little more involved.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gener
as "function(args)". Do you really have some setup
where you have function pointer variables and your compiler requires that
outdated syntax? Or is this more basic C confusion?
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent v
> I didn't remember seeing anywhere in the docs that you were supposed to check
> for pqr==NULL, I wish they would document that in PQexec.
It's right there in the first sentence of the discussion.
> There is no mention of return values!
???
--
Scott Ribe
scott_r...@k
mely unlikely to get to that
point without having generated any duplicates.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
ull terminator of a C string and
including it in the encoded string.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Your encoder is incorrect.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> The only thing that comes to mind is two separate build trees, one 32bit
> and the other 64bit and then somehow gluing the two libpqs together...
Basically, probably the easiest way to proceed--man lipo to figure out how
to combine the libraries.
--
Scott Ribe
scott_r...@killerbytes.co
> Any thoughts?
Yeah, the heat death of the universe will occur before you use up bigint
ids. Of course you could do a quick check for uniqueness first, then only
enter a begin/exception block for atomicity if the value was unique.
--
Scott Ribe
scott_r...@killerbytes.com
h
Table "v2.Document"
Column | Type | Modifiers
---++-
id| bigint | not null default nextval(('"DbRowIds"'::text)::regclass)
...
Should I really have to re-specify the default in this c
create table "PatientDocument" () inherits ("PatientRelated", "Document");
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
left of the decimal point.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
?
(8.3.7, OS X 10.5.8, 32-bit build)
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Neither, really. The cast shortcut you're using is binding to the
> digits more tightly than the minus prefix.
I see, thanks.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgre
he way.
I don't actually have multiple tables with the same name (nor even multiple
databases in the cluster), I'm just trying to understand how to generalize
my query to correctly work in all cases.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 v
s, and got confused
thinking "yeah well, what about all the owning databases".
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Use iconv; it's a command shipped with OS X, man iconv for more info.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
> Maybe iconv knows about it?
On OS X it definitely does; on other platforms it may not since supported
encodings are platform-dependent.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gene
check for the presence of wal sender process vs wal
receiver process? Or is there a query that could executed against sys tables to
find current running config of the local postmaster?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via
On Sep 25, 2013, at 6:13 PM, Michael Paquier wrote:
> "SELECT pg_is_in_recovery();" can be used to make the difference
> between a master and a slave.
Exactly what I need; thanks.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
= '2013-04-30 06:00:00-05'::timestamp with time zone))
Filter: ((colb)::text ~~ '%foobar%'::text)
Rows Removed by Filter: 261725
Total runtime: 230.689 ms
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsq
n, but it most certainly is possible.)
Besides, you've given me the hint, if I really care about this I can try a
covering index ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thank you all. Both the double index & pg_trgm would be good solutions.
On Oct 14, 2013, at 3:40 PM, Merlin Moncure wrote:
> On Sat, Oct 12, 2013 at 4:28 PM, Torsten Förtsch
> wrote:
>> On 12/10/13 20:08, Scott Ribe wrote:
>>> select * from test where tz >= star
What checksum algorithm wound up in 9.3?
(I found Simon Riggs 12/2011 submittal using Fletcher's, Michael Paquier's
7/2013 post stating CRC32 reduced to 16, and another post online claiming that
it was changed from CRC before release but not stating what it was changed to.)
--
comprehensive source of current
advice.
(I want to do a prophylactic dump/restore, after a middle-of-the-day OS crash
caused by a third-party in-kernel driver--which I am going to remove now.)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
On Apr 21, 2011, at 9:44 AM, Florian Weimer wrote:
> But log files are recycled, so looking at the directory alone does not
> seem particularly helpful.
You have to look at the file timestamps. From that you can get an idea of
traffic.
--
Scott Ribe
scott_r...@elevated-dev.co
y a very healthy skepticism factor.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
study of large numbers of disks in data
centers, and the result was that actual lifespans were so far from MBTF specs,
that the remaining disks would have to just about outlive the universe in order
to get the mean near the same order of magnitude as the published numbers.
--
Scott Ribe
scott_
n't really exist. What's usually proposed as a
natural key, will upon further investigation, either not be guaranteed unique,
or not guaranteed to be unchanging, or both.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-g
The
scheme, which had been stable for 20+ years, had to change when a new variant
of product was introduced which cut across family & product. I don't remember
the details. I do remember that I hadn't used the supposedly stable product ids
as PKs ;-)
--
Scott Ribe
scott_r
Yeah, on that subject, anybody else see this:
<>
Absolutely pathetic.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On May 4, 2011, at 10:50 AM, Greg Smith wrote:
> Your link didn't show up on this.
Sigh... Step 2: paste link in ;-)
<http://www.codinghorror.com/blog/2011/05/the-hot-crazy-solid-state-drive-scale.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
many others I've read about are not in high-write db workloads, so they're
not write wear, they're just crappy electronics failing.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gener
mples--more if we've been around for a while. Original design cutting
corners on power regulation; final manufacturers cutting corners on specs;
component manufacturers cutting corners on specs or selling outright
counterfeit parts...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.ele
ated total rows in a table, nothing useful for this.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; that is slow. Generally, the
> system table is good enough for that, I find. (Someone: "How long
> will this take?" Me: "There are about 400 million rows to go
> through." Even if you're off by 50 million at that point, it doesn't
> matter.)
FYI, I ha
g) subset of the data at the same
time, but now I think I'm really set!
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to
ask regarding this and/or what brands/buzzwords to look for.
Any and all advice and links appreciated ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
s.
(But then again, db tools in general aren't really masters of the obvious when
it comes to user interface...)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
RAID 5 is not generally recommended for good db
performance. But if the database is not huge (10-20GB), and the server has
enough RAM to keep most all of the db cached, and the RAID uses
(battery-backed) write-back cache, is it sill really an issue?
--
Scott Ribe
scott_r...@elevated-dev.com
http:
use RAID 5; it's RAID 6 that I'm considering...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
her digging, I discover that ATTO ExpressSAS is an option for me.
Anyone got comments on these? (I notice that they use ultracapacitor/flash to
protect cache...)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list
robably go for safety. (FYI this is not my only margin for failure. Two
geographically-distributed WAL-streaming replicas with low-end RAID1 are the
next line of defense. Followed by, god forbid I should ever have to use them,
daily dumps.)
Thanks for all the info. I guess about all I have rema
On Jun 19, 2011, at 12:33 AM, David Boreham wrote:
> One thing I don't understand is why is the BBU option never available with
> "integrated" LSI controllers?
Because "integrated" means it's on the mobo to save costs.
--
Scott Ribe
scott_r...@elevated
On Jun 20, 2011, at 1:32 PM, Leon Match wrote:
> How can I insert a dynamic timestamp value in postgress, please?
< http://www.postgresql.org/docs/9.0/static/functions-datetime.html>
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
r is, I
think, not useful.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rds
>> with subjective meaning.
>>
>> I'd like in ask the pgsql community for suggestions on how they name tables.
Well, when I avoid camel case, then I use _ to separate words in a table name,
and __ to separate table names.
Likewise with column names for foreign keys
correct calculations...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing on the server so you can see what the actual CREATE TABLE
> command sent to the server looks like.
That's it. Rake is part of Ruby on Rails, and RoR wants every table to start
with an integer synthetic key column.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com
re going to
get on a Postgres mailing list ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jul 19, 2011, at 9:27 AM, Martin Gainty wrote:
> I do'nt believe Rao would discriminate against anyone that speaks the Kings
> English.
So, what makes you think they won't hire us Americans?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303
ould include information about
supported platforms. Any announcement submitted without that info should be
rejected, and the vendor instructed to add it before re-submission.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gener
amp; ABc are all equal, so any
order for those 3 would be correct...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t and the other is 64-bit, or one machine is
big-endian and the other is little-endian...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
oblems.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> After open source for the software, we will wait for open resource for the
> hardware (this is just a first example http://www.arduino.cc/, even if of
> different nature).
While the plans may be free, the actual hardware sure as hell won't be.
--
Scott Ribe
scott_r...@elevate
1-21','Potassium','0.94988','mg/L','','','','...
> ^
> The column is NULLable and if there's no value a NULL should be entered.
An empty string is not null.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www
On Aug 17, 2011, at 12:53 AM, Sim Zacks wrote:
> In your scenario, if you send the NOTIFY message and then you roll back the
> transaction, the helper application will still send the email.
How? NOTIFY doesn't get delivered until the transaction commits.
--
Scott Ribe
scott_r.
se may be
something else, but either way I doubt it's a problem with NOTIFY/LISTEN.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Mods: FYI, this is not a one-off thing. I've seen this email on 4 other lists
so far this morning. So some turd is spamming every list he can subscribe to.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing
succeed.
That DDL is also kind of nasty... Why the big effort to set the sequence to 1
immediately after creating the table? Why the creation of a unique index when
the "primary key" attribute already causes a unique index to be created on the
id? Ugh.
--
Scott Ribe
scott_r...@el
words, this is a bug in your clients, and
no, you really would not want PG automatically terminating connections
mid-transaction just because it thought the client was taking too long to get
to the next step.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voi
re are you? You are issuing a command to the server
to create a file at that path on the server.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Aug 30, 2011, at 8:22 AM, Dan Scott wrote:
> Perhaps because I'm locking the table with my query?
Do you mean you're explicitly locking the table? If so, why???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via
On Aug 31, 2011, at 9:51 AM, Don wrote:
> Both machines are 64bit.
Are all your server & client builds 64-bit?
32M rows, unless the rows are <50 bytes each, you'll never be able to
manipulate that selection in memory with a 32-bit app.
--
Scott Ribe
scott_r...@elevat
k of enabled/disabled elsewhere, so you really need to use
launchctl instead of editing the plist.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
, so you can't even use all of what's left.
So no, you can't manipulate 32M of anything except plain numbers or very simple
structs in RAM in a 32-bit process.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gener
On Sep 1, 2011, at 9:04 AM, Bob Pawley wrote:
> Would it be possible for you to point me to an example??
The EXECUTE command is what you want.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-gene
to produce the corrected query.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oat8(3)
1.0/3
1/3.0
1::float8 / 3
...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sep 17, 2011, at 1:09 AM, Raghavendra wrote:
> However, I was curious to know any thing stored at Page-Level(like XID) to
> help me in getting the transaction timestamp.
No, there is no such thing. If you want timestamps, you have to record them
yourself.
--
Scott Ribe
scott_r...@el
ers as strings???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n that path, you should seriously
consider whether you really need that, rather than a higher-level solution.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
> But I would like to know why isn't the type conversion from unlimited varchar
> to varchar(255) invoked in the pl/pgsql function?
What if t1 || t2 is longer than 255? You need to explicitly specify.
--
Scott Ribe
scott_r.
#x27;re on a recent version of OS X, you do this in /etc/sysctl.conf.
Also the /usr/bin/postgres that you seen running is not where macports puts it
and not the one you tried to start a couple of lines earlier, so you have
something already installed on your system that is running a postgre
any actual pg instances running there. What you have is
some kind of wrapper that tries to launch pg. That wrapper is failing to
launch, and either looping, or quitting and being relaunched--depending on how
it is set up, which I have no idea about.
--
Scott Ribe
scott_r...@elevated-dev.com
h
e the normal UNIX way:
./configure, make, sudo make install... That's the way I do it, and it works
fine on OS X.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
will usually pretty explicitly tell you why
the server is quitting on launch. So you might just need to read those wrapper
scripts to see how exactly they invoke postgres.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-gene
On Oct 11, 2011, at 8:18 PM, The Great SunWuKung wrote:
> This shop is number 1 at my shop-list!
So why the fuck is your spam title "7"???
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (
As part of anonymizing some data, I want to do something like:
update foo set bar = (select bar2 from fakes order by random() limit 1);
But of course, that sets them all to the same value, whereas I want them all
different.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com
If you install the latest ARD update (which does not require a reboot), it
apparently does something similar to:
sudo killall postmaster
Oops. Thanks, Apple.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing
already know about lots & lots of options ;-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
101 - 200 of 394 matches
Mail list logo
