functions.
> >
> > In 9.6:
> >
>
> That's why in 9.1 I didn't find that command...
You can use the 9.6 client without problems on 9.1, well, apart from
the fact that 9.1 is already past its end of life.
Best,
David.
--
David Fetter http://fetter.org/
Phone: +1 415
s there something constructive you might have been asking about that
you forgot to include in this email? If so, what was it?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: web
C-Language-Functions-tp5734656.html
> > Sent from the PostgreSQL - general mailing list archive at Nabble.com.
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> > To make changes to your subscription:
> > http://www
b
To restore on the 9.2 machine:
pg_restore -C mydb.dump
Hope this helps.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Rem
$subject!
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org
uestion I never asked (never bothered to, really)
> was: Is it really any better than simply doing the first insert and
> retrieving the ID in my application? :)
One crucial difference is the number of round trips to the database.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415
> regards, tom lane
Factoring in NULLable columns, that's:
(x IS NOT DISTINCT FROM y) <> (a IS NOT DISTINCT FROM b)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.
cause in my case, operations over tuples are
> done very lightly (one or two in the same sentence at a time). So, for
> a case as such, rules end up beeing more expensive than triggers
> (right?).
There's an even better reason not to use rules: they're going away in
a not too
whos processes got
> killed.
You have the choice between taking those users offline and not doing
the change.
> V8.3.4 on linux.
Upgrade to 8.3.16 immediately, if not sooner. Oh, and start planning
the 9.1 migration, too. December of 2012 is closer than you think. :)
Cheers,
David.
ar in many ways to stored
procedures, have a fundamental difference: they can't control
transactions. Any stored procedures that have a COMMIT or ROLLBACK in
them will have to be re-architected in a fundamental way.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AI
ise as a result of email transmission. If
> verification is required please request a hard copy version.
In future, please to elide these "disclaimers." The serve no legal or
practical purpose, but they do give people they annoy a convenient
excuse not to reply.
Cheers,
David.
--
nt? In all the
> testing I've done it's worked, but I don't know if I was just lucky :)
That would be more of the SQL standard UNNEST, with the WITH
ORDINALITY clause. We don't have it yet :/
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
e
> serves as President of the Board of PostgreSQL Europe.
>
> Regards, Dave.
>
> --
> Dave Page
> PostgreSQL Core Team
> http://www.postgresql.org/
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org)
> To make changes to your subscription:
upgrade to a modern version of PostgreSQL. While
you will of course need to do tests with your applications, 9.0 has no
significant backward-incompatibility with 8.3.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMP
On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote:
> On Mon, Mar 21, 2011 at 9:45 PM, David Fetter wrote:
> > Who proposes, volunteers! How are you going to help?
>
> being on a different continent and unable to attend doesn't actually
> enable me to do s
the shoulders of the conference organizers, who are
> > already working hard just to pull off the live show.
>
> never said that it's not so just that i'm surprised/disappointed that
> it's so low priority.
Who proposes, volunteers! How are you going to help?
rg/dfetter/index.php?/archives/59-Partitioning-Glances.html
Cheers,
David (hoping PostgreSQL will be able to infer how to automate this some day).
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: we
On Wed, Dec 15, 2010 at 03:43:45PM -0800, Adrian Klaver wrote:
> On Wednesday 15 December 2010 1:27:19 pm David Fetter wrote:
> > On Wed, Dec 15, 2010 at 01:50:54PM -0600, Jack Christensen wrote:
> > > I was just surprised when accidentally selecting a non-existent name
> &g
ot; habit
of using the argument.function notation, so you called the "name"
function, i.e. the one that casts to name, on the entire row from your
accounts table.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfe
f PostgreSQL
are 9.0, 8.4, 8.3, etc., not 9 and 8 :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vo
l address will be plastered all over the internet, guaranteed to
> be picked up by spiders, make sure you have a good anti-spam."
If you imagine that not signing up for a mailing list in any way
alleviates this need, I have a bridge to sell you. It connects
Manhattan with Brooklyn.
Cheers,
Davi
esting on things that work
for the vast majority of people. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Re
o
production, or a solid evidence that you need to find another gig.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
how to do this or even whether you can do this.
You can do it like this:
BEGIN;
ALTER TABLE foo DROP CONSTRAINT your_constraint;
ALTER TABLE foo ADD FOREIGN KEY ...;
COMMIT;
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype:
00MB
> max_prepared_transactions = 100 # guideline: same number as max_connections
This should be either 0 (no 2PC) or the bounded from below by
max_connections.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMP
you need to do is start that process and work to make it shorter
for PostgreSQL upgrades, or failing that, find something to do with
your life, because processes like that are a bright red warning sign
of the kind of dysfunction that tanks organizations, no matter how big
or important they ar
On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote:
> Hi,
> today I noticed that in the documentation there is DROP INDEX
> CASCADE. I've got one question: what is that for? What can depend
> on index?
A foreign key can, if the index is unique.
Cheers,
David.
--
D
t; second-degree derivation, which rather diminishes its power.
>
> It gets confused as to who's the questioner, which yanks some sense out
> of it. At the start, the MySQL aficionado is the speaker, taking
> questions, but at the end, somehow the Postgres guy ends up th
TP user :)
We've all been there.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Cons
ures in
> each version here: http://wiki.postgresql.org/wiki/Version_History
>
> Haven't updated that yet to include anything but the one big 9.0
> article you were referring to so far.
Should we have a 9.1 one? There's already been at least one large,
new feature, namely INS
On Sun, Oct 10, 2010 at 12:08:13AM -0700, Mike Christensen wrote:
> While I do appreciate the vote of confidence, rest assured you will
> never see a post from me that starts with "So I've been hacking the pg
> code and..."
Actually, we get *plenty* of those.
Cheers,
art of step 7.
If you think that getting all outstanding patches through step 5 is
not doable, let me know. If you think it is, this is your chance to
help make it happen. Write back either way.
Cheers,
David.
[1] If you do have them, help out with step 6, too.
[2] If you are one, help out with st
and clean it up.
I can't really recommend that you put in workarounds, as they don't
actually fix the bugs you've found.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.c
On Sun, Sep 26, 2010 at 10:15:00AM -0400, Tom Lane wrote:
> David Fetter writes:
> > On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote:
> >> period() might be immutable, but those casts from date to
> >> timestamptz are not, because they depend on the TimeZone
it be to point out the first expression found to be
mutable? All of them?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit
is for?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postg
> my_table_history <http://postgresql.pastebin.com/cGm617Cp>
> [etc.]
> Does anybody have any idea what is going on?
Yes. You're using RULEs where TRIGGERs would do. Change to TRIGGERs.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfe
On Wed, Sep 15, 2010 at 05:30:51AM +0530, tamanna madaan wrote:
> I know upgrading postgres will resolve the problem permanently .
> But I wanted some workaround for now before I actually upgrade.
I want a pony, but I'm not getting one. Upgrade PostgreSQL :)
Cheers,
David.
--
D
On Wed, Sep 15, 2010 at 02:39:26AM +0530, tamanna madaan wrote:
> Hi All
>
>
>
> I am using postgres-8.1.2. I am getting the following error while
> autovacuum.
Please upgrade your software to PostgreSQL 8.1.21 and try again.
Cheers,
David.
--
David Fetter http://fetter.
ke that. I'm
aware that it's common in one of those Oracle properties, but it needs
to stay confined there.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripi
ase_Support_Policy
> Should I just INSERT?
Nope.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
the BSDs) user is the database superuser. Once it's
installed, try:
su - postgres
psql -l
Happy PostgreSQLing :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal:
On Fri, Sep 10, 2010 at 02:35:29AM +0530, tamanna madaan wrote:
> Hi David
>
> You mean to say , change the binary to postgres-8.1.21 and then restart
> postgres . that's it ?? please confirm..
Yes. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
ich is for autovacuum error.
Your idea is silly. Change the binary, restart, and have done.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/peop
27;s UPDATE are at:
http://www.postgresql.org/docs/current/static/sql-update.html
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/trip
ssed in item 1 run an index scan on posicoes to check if
> the key
> is in the table posicoes
> 3) If the parent found is not found on posicoes then remove the row from
> posicoes_controles
>
> Am I thinking correctly?
I believe so.
Cheers,
David (whose pt_BR is pretty w34k)
-
oes_controles WHERE NOT EXISTS (
SELECT 1 FROM pesicoes WHERE pesicoes.protocolo =
pescioes_controles.protocolo
);
ALTER TABLE posicoes_controles add
CONSTRAINT protocolo FOREIGN KEY (protocolo)
REFERENCES posicoes (protocolo) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE;
uot; with any
> of the values of the synonyms fields.
Try the LIKE function.
http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTIONS-LIKE
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMP
> lead to this sort of deadlock?
DDL is a "don't do it at peak load" event. More realistically, it's
more like a "down time" event. Maybe when we have "real"
partitioning...
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
On Sun, Aug 08, 2010 at 12:33:40PM -0700, David Fetter wrote:
> On Sun, Aug 08, 2010 at 01:55:19AM -0700, John R Pierce wrote:
> > >The condition
> > >
> > > and table.item = 'laptop' and table.item = 'Desktop'
> > >
> > >sa
... AND (table.item = 'laptop' OR table.item='Desktop') ...
OR doesn't account for duplicates. Two laptops on the same date would
cause a false positive.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
S
E SQL
AS $$
SELECT ARRAY(SELECT * FROM unnest($1) ORDER BY 1);
$$;
The "=" query would look like this:
SELECT TID, "Date"
FROM "table"
GROUP BY TID, "Date"
HAVING array_sort(ARRAY['Laptop','Desktop']) = array_sort(array_agg(item));
Cheers
Password for user hsnoh:
>
> Thanks..
Overall, it's better to use a .pgpass (pgpass.conf on Windows)
http://www.postgresql.org/docs/current/static/libpq-pgpass.html
It's also possible, but not recommended, to set an environment
variable.
Cheers,
David.
--
David Fetter http:/
ang.html
As The Fine Manual is very extensive, telling people just to Read it
from some arbitrary point is just barely more helpful than not
specifying one, i.e. not terribly. Perhaps asking a few more
questions would be. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235
es table, you'd do something like this:
WITH descendants AS (
SELECT head FROM edges WHERE tail=1 /* the root node */
UNION
SELECT e.head FROM edges e JOIN descendants d ON (e.tail = d.head)
)
SELECT * FROM descendants;
You might want to index edges.tail and edges.head.
Cheers,
David.
re they executed in some random order?
They're executed in alphabetical order, to the extent that that is
deterministic, which is not very, and that's not even the wackiest
thing about them. If you have any alternative of any nature, do NOT
use rules.
Cheers,
David.
--
David Fetter ht
t having to SELECT * on each table.
>
> Thanks in advance!
> Scott
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
David Fetter http://fet
w.postgresql.org/docs/8.1/static/release.html.
You might also want to note that 8.1's end of life is in November, so
start planning the upgrade to 9.0 right now. You will likely need to
clean up some client code in order for that to work, as modern
versions of PostgreSQL don't allow some
ing constants and
> single-evaluation variables like the above would be really, really
> nice, and would avoid some ugly SQL mangling and any need for
> compliated planner features that try to match up and combine
> subquery trees.
I'm all for extending WITH, as are some ot
ol of charsets,
> date formats, EOL conventions & Co. and do not have to won-
> der whether this and that file is in this and that stage of
> the conversion process, the disadvantage is obviously that
> you lose any speed benefit of bulk "COPY".
You can do your transfor
Springfields, it may help to
mention that Josh is going to the one in Wisconsin.
Cheers,
David
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tri
On Thu, Jul 01, 2010 at 12:37:55PM +0100, Sam Mason wrote:
> On Thu, Jul 01, 2010 at 04:26:38AM -0700, David Fetter wrote:
> > On Wed, Jun 30, 2010 at 12:11:35AM -0700, Nick wrote:
> > > Is this the most efficient way to write this query? Id like to
> > > get a
ies
GROUP BY user_id
HAVING array_sort(array_agg(category_id)) = ARRAY[1,2,3]
ORDER BY user_id;
to get only exact matches.
As to speed, you'd have to test on your actual data sets. Indexing
user_id may help here.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 2
ersion of DBI-Link using the "Download
Source" link at <http://github.com/davidfetter/DBI-Link>
There is also a low-traffic mailing list for the project, where
questions like this are more on point :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 377
ting it from being as well optimised as Postgres.
Having it divided off at the place where it's divided in MySQL is
certainly such a barrier. Having a storage API, as PostgreSQL used to
have, and will have again with SQL/MED, doesn't necessarily present
such a barrier.
Cheers,
David.
y to PostgreSQL
Generally, getting the schema and data moved over are the first two
steps in a much longer process, wherein all the apps use the database
as an active database rather than a passive one, the latter being all
MySQL really allows.
Hope this helps :)
Cheers,
David.
--
David Fett
e here is that nobody's saying what kind of
> >app they want to write.
> Or what sort of performance requirements are tied to that app.
It's not performance requirements that tend to tank such projects, but
the amount of maintenance involved. Extending the app gets
quadraticall
out the best
> > > way to encourage it.
> >
> > You want to encourage the use of databases that don't support relational
> > integrity?
> no, I want to encourage "The quickest way is to write code that will
> work on any db but won't take advantage of db-spe
/index.php?/archives/33-Portability-Part-II.html
Fortunately, another strategy whose effect is to defend against the
above-mentioned strong-arm tactics--making a wide selection of
non-proprietary RDBMSs--has succeeded. Just pick an RDBMS and max out
its capabilities.
Cheers,
David.
--
David Fetter
rchives/33-Portability-Part-II.html
> That way its not a matter of porting, more a matter of starting off
> right.
You're assuming that the goal of "database agnostic code" is
reasonable. I'd take a hard look at the trade-offs first. "Database
agnostic code" sounds
tual requirements? Things that would be nice to have?
What are your priorities for both?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/
tore the dump file from 8.3 without
> errors.
Use 8.4's pg_dump on the running 8.3 database, and your problem will
be fixed :)
Cheers,
David (oh, and pg_dump -Fc will let pg_restore, an enormously powerful
utility, do its magic).
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
ation.
> >>
> >>
> >> http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#IBM_DB2
> >>
> >> --
> >> Regards,
> >> Richard Broersma Jr.
> >>
> >> Visit the Los Angeles PostgreSQL Users Group (LAPUG)
&
On Wed, Jun 02, 2010 at 05:41:10PM +0100, Mark Cave-Ayland wrote:
> David Fetter wrote:
>
> >Is PostGIS following these guidelines?
>
> In short, no. Due to various problems in the early days with C++
> exceptions generated by the GEOS library causing problems in C (a
orizing any day. The array-based approaches are
there pretty much for convenience, i.e. for not having to input the
numbers more than once, as they could easily get mistyped if you need
to repeat them.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!
On Wed, Jun 02, 2010 at 03:33:16PM +0100, Sam Mason wrote:
> On Wed, Jun 02, 2010 at 06:28:14AM -0700, David Fetter wrote:
> > On Tue, Jun 01, 2010 at 06:16:06PM -0400, m. hvostinski wrote:
> > > I have a simple query like:
> > >
> > > SELECT * FROM cus
cleanly separated modules with pure C interfaces. If you don't #include
> any Pg backend headers into any compilation units compiled with the C++
> compiler, that should do the trick.
>
> If you must mix Pg calls and C++, restrict your C++ objects to the heap
> (ie use pointers to them
e_subscripts((SELECT a FROM t)::integer[], 1))
SELECT i, a[i]
FROM
s
CROSS JOIN
t;
$$;
You can then use that set-returning function in your query.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.
On Sat, May 29, 2010 at 08:21:46PM -0700, Richard Broersma wrote:
> On Sat, May 29, 2010 at 6:25 PM, David Fetter wrote:
>
> >> I wondering if write-able CTE's will be the silver bullet that
> >> will make rule based update-able views based multiple vertically
>
nterfaces.
>
> This was very much pain-free, but I certainly wouldn't want to try
> to use C++ code tightly intermixed with Pg backend-using code. It'd
> be a nightmare.
These two paragraphs, suitably changed to be more like the rest of the
docs, would be a great start
On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote:
> > > This might be a premature question considering write-able CTEs
> > > are not in core, but...
> > >
&
ues in writeable
CTEs get fixed, they could become a mechanism for doing what you
describe, but I suspect there would be significant work involved in
harnessing them to that task.
They'll be pretty nice even without the automated view stuff, though :)
Cheers,
David.
--
David Fetter http
hough, check out the GRANT command.
Also check out host-based authentication, which you control with an
external file called pg_hba.conf:
http://www.postgresql.org/docs/current/static/client-authentication.html
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: df
working on it, to my knowledge. While the "SELECT *" case
doesn't interest me too much, it would be part of the infrastructure
needed for PostgreSQL to optimize storage by placing all fixed-length
columns before any variable-length ones.
Cheers,
David.
--
David Fetter http://fetter
On Thu, May 13, 2010 at 08:08:31PM -0400, Tom Lane wrote:
> David Fetter writes:
> > On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
> >> I'm surprised no one has yet suggested an ENUM type.
>
> > I didn't suggest it because I didn't know about
On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
> Josh Kupershmidt writes:
> > On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
> >> If you've measured a performance issue for a table that tiny, it's a
> >> bug that needs fixing in Postgre
27;t change as fast as we all hoped and we all
> think it is best now that I focus on getting back to speed and do some
> serious hacking.
>
> I hope to see many of you in Ottawa.
You can run, but you can't hide ;)
Thanks for your deep and broad contributions so far, and I
gt; constraint for performance reasons. (Does that make sense?)
If you've measured a performance issue for a table that tiny, it's a
bug that needs fixing in PostgreSQL. What measurements have you done
so far?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
e changes, or propose that some be made,
please feel free to do so after 9.0 comes out.
In the mean time, please test 9.0beta1 along with any ensuing betas
and release candidates, and report back the results of the
aforementioned testing.
Cheers,
David.
--
David Fetter http://fetter.org/
Pho
SQL is the community version.
Proprietary forks exist, but they don't fix this kind of problem. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/fe
gt; test=*# create table foo_2 () inherits (foo);
> CREATE TABLE
> test=*# alter table foo_2 add primary key (i);
> NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "foo_2_pkey" for table "foo_2"
> ALTER TABLE
Kinda.
http://people.planetpostgresql.
after finding out how the trick
is accomplished, you still have this goal, you'll know how.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/
iggers are much better than RULEs for this kind of
thing. The underlying functions can be made quite efficient.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: web
is out past Q3
of this year, to 9.0.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider
quot; that our
docs implicitly and falsely assume in many spots, and we need to make
them stop including this idea.
The only standard actually worth citing today is SQL:2008, and the day
the next one comes out, we need to change all our references to cite
it.
Cheers,
David.
--
David Fetter h
> MySql is by default case insensitive, I just figured there'd be an option to
> turn it on in PG as well.
You can use citext, a supplied module.
> What about 9.0 ? How is that going to be offered ?
When it's ready! :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phon
o try DBI-Link.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.
On Thu, Jan 14, 2010 at 09:51:34AM +0200, Dave Coventry wrote:
> Yes, I'm in South Africa, which might make it problematic!
You're on the right land mass, assuming you count being able to cross
the Suez canal on foot ;)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1
ata (i.e. they do not _need_ to "sync" with each other, nor do I
> want them to be sync'd).
>
> Would it be possible to use PostgreSQL PITR feature to support this
> functionality ?
No, but you could use something like Slony to do this.
Cheers,
David.
--
David Fetter htt
> this is what I want to avoid.
The appropriate place to protect your IP is in legal agreements.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/i
1 - 100 of 565 matches
Mail list logo
