someone else created the same
file name you'll delete the wrong file?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
There is no question things would be clearer with only one text search
data type. The only value I can see to having a tsquery data type is
that you can store a tsquery value
didn't specify a tablespace.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
)
postgres=# select * from b;
i
---
2
3
(2 rows)
postgres=# select * from a full outer join b on (a.i=b.i) where a.i is null or
b.i is null;
i | i
---+---
1 |
| 3
(2 rows)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
Alvaro Herrera [EMAIL PROTECTED] writes:
Gregory Stark escribió:
I think it would be ok only if a pg_dump/pg_restore reliably restored the
same
oid-enum value mapping. Otherwise a binary dump is useless. But as I
understand it that's the case currently, is it?
er, lost
I wouldn't be confident that all operating
systems do so or that they work correctly in all circumstances.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
Andrew Sullivan [EMAIL PROTECTED] writes:
On Fri, Aug 31, 2007 at 07:07:40PM +0100, Gregory Stark wrote:
It shouldn't be easy. Ident uses TCP, which is rather harder to
spoof.
Say what? It's actually quite easy to spoof TCP. There are even command-line
tools to do it available
and then cached for subsequent accesses. So xid_age() would
measure relative to a fixed xid, it just wouldn't be *our* xid necessarily.
Just a thought.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4
in the release
announcement as possible compatibility gotchas is what's needed.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
could be in
it by default. But that might depend on how expensive it is at run-time. I
wouldn't want trivial SQL functions to no longer be inline-able because one
might one day use a regexp for example.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I think security definer functions should automatically inherit their
search_path. The whole secure by default thing.
This assumes that the search path at creation time has something to do
with the path you'd like
, digits, underscore?
Or does it need to be weaker than that?
What's the problem with .?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
I made it reject all but latin letters, which is the same restriction
that's in place for timezone set filenames. That might be overly
strong, but we definitely have to forbid
of Linux and I thought it was false
for other modern OSes -- I'm surprised it's not for Solaris even.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
.
I thought that was a good argument actually.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the three hashes
together which reduces it to the solved problem.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
was
discussing PostgreSQL. So presumably he was speaking on behalf of the postgres
community.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
an
error if someone opens a file in read-only mode when they actually do
have write permission?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
for large I/O bound databases
That seems too vague for the TODO. Did you have specific items in mind?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
is executed.
I'm a bit afraid the plan will stay cached longer than would be ideal. If the
plan doesn't use the new index then ideally we would want to invalidate it
from the cache at the end of this transaction I suppose.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
the sleep time. So it would always
process a full cycle for example but adjust the sleep time based on what
percentage of the cycle the backends used up in the last sleep time.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
Hannu Krosing [EMAIL PROTECTED] writes:
Is this apoc9009 guy real ?
Please, just don't respond.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
with a smaller scale factor?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
the percentages on the transactions. I think Stock
Level and Order Status are entirely read-only but I would have to check. Stock
Level is a very intensive query though so I wouldn't suggest raising the
percentage on that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
any old tuples in broken chains
uses the serializable snapshot as a conservative proxy for the oldest snapshot
which might be in use. That will work for both serializable and read
committed.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
than the build farm.
Especially when it comes to vacuum and vacuum full and cluster and so on given
that autovacuum barely has a chance to start looking at things before the
regression tests are done.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
of
consisting of those three bytes described above?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org
.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
for and tried a lot of different approaches to solve this problem.
This was the lowest impact solution and the only one that was convincingly
correct (imho).
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP
for this contraption before we had
plan invalidation, but what use is it now?
Argh, sorry, rereading your message I see there are a few details which I
missed which completely change the meaning of it. Ignore my previous mail :(
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
AFAICS, the whole indcreatexid and validForTxn business is a waste of
code. By the time CREATE INDEX CONCURRENTLY is ready to set indisvalid,
surely any transactions that could see the broken HOT chains are gone
Tom Lane [EMAIL PROTECTED] writes:
It's a corner case, but I say it's a must-fix.
Of course
Those bug reports have been bothering me for most of a year ...
Are there any other outstanding reports like that?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
the user to do something?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
that.
No intervention is required for normal expression indexes using those
functions or hash indexes which will be rebuilt during a database upgrade
anyways. I don't think hash_any itself changed so this wouldn't affect
hashtext or any hash function which was already using hash_any.
--
Gregory Stark
data in a container format or something.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
/* exists in Solaris
headers */
+ #undef V_FALSE
+ #endif
/*
* output values for result output parameter of clean_fakeval_intree
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
for their intended purpose of client-server
communication if they're not.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
won't worry.
I tend to agree with you. We should only use overloading when the function is
essentially the same just tweaked as appropriate for the datatype, not when
the meaning is different.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
copying it to new memory instead of memory which is almost
certainly likely in processor caches which would need to be invalidated would
actually be faster and avoiding the use of memmove could be faster too.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
to slip this into the upcoming 8.2.5?
I haven't been able to find anything which specifies precisely when it'll
happen though. Just knowing the week or even day isn't enough.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
(windows,solaris,openbsd and
linux).
Is this exhaustive? That is, are we sure this never happened before Sept 11th?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list
)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---End Message---
--
Gregory
minutes to do
that. I'm surprised it would have such a large effect though.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Guillaume Smet [EMAIL PROTECTED] writes:
Gregory,
On 9/21/07, Gregory Stark [EMAIL PROTECTED] wrote:
Hm, it does seem I missed like.c when I converted all the text operators to
avoid detoasting packed varlenas. I'll send a patch in a few minutes to do
that. I'm surprised it would have
))
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
Brendan Jurd [EMAIL PROTECTED] writes:
On 9/22/07, Gregory Stark [EMAIL PROTECTED] wrote:
The canonical way to do it is with
DatumGetCString(DirectFunctionCall1(textout, t))
Ah, I see. Thanks.
In that case, would it be helpful if I submitted a patch for the
various code fragments
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Ok, this removes what should be most if not all of the call sites where we're
detoasting text or byteas. In particular it gets all the regexp/like
functions
and all the trim/pad functions. It also gets hashtext
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
(It might be interesting to make textin produce a packed result when
possible, just to see what breaks; but I would be afraid to try to do
that for production...)
This all brings up the question of what other files
table?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
32768 11691023
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes
(result), inputText, len);
+ SET_VARSIZE_SHORT(result, len+VARHDRSZ_SHORT);
+ PG_RETURN_TEXT_P(result);
+ }
+ #endif
+
result = (text *) palloc(len + VARHDRSZ);
SET_VARSIZE(result, len + VARHDRSZ);
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
of 1st digit */
uint16 n_sign_dscale; /* Sign + display scale */
+ int16 n_weight; /* Weight of 1st digit */
charn_data[1]; /* Digits (really array of
NumericDigit) */
} NumericData;
--
Gregory Stark
Tom Lane [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I think we also should move the NumericData and declaration to numeric.c and
make the Numeric type an opaque pointer for the rest of the source
tree.
I don't agree with that; we
not much point in making an exception
for something which will only be really useful once further work is done in
the same area.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9
be building 7.2.8, an unsupported
release over two years and 5 major releases old?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
they'll break if you swap the
shared library out from under them?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http
a
loophole for anyone for whom the test didn't work properly.
That sounds like a good combination
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
is that things like pgadmin can connect properly to
either 8.3, 8.2, and even 8.1 using the new libraries regardless of how the
server authentication is configured. Do they work correctly if the server
tries to do password authentication, ident, kerberos, etc.
--
Gregory Stark
EnterpriseDB http
the idea of keeping the VARHDRSZ/VARSHDRSZ offset in
the varlen header seem pretty silly; hindsight is 20/20 and all that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I'm wondering whether it doesn't make sense to lower VARATT_SHORT_MAX to 0x70
to allow for at least a small number of constant values which could indicate
some special type of datum. That could be used to indicate
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I'm wondering whether it doesn't make sense to lower VARATT_SHORT_MAX to 0x70
to allow for at least a small number of constant values which could indicate
some special type of datum. That could be used to indicate
that makes the macro
VARSIZE_EXTERNAL_EXHDR_EXHDR() :/ )
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
the datum pointer into a separate
local variable of that type to suppress the optimization.
Fascinating.
Why do you cast arguments to memcmp to char* ?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Why do you cast arguments to memcmp to char* ?
Well, *I* haven't done it in a long time,
I'm referring to tuptoaster.c:488
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
? That would
solve the problem for the narrow case of pg_restore.
In the long run we could think about exposing some kind of command for
pg_restore to use which would disable autovacuum from touching a table. (Or
take a session-level lock on the table -- shudder)
--
Gregory Stark
EnterpriseDB
for details.
STATEMENT: CREATE DATABASE contrib_regression TEMPLATE=template0
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
Gregory Stark [EMAIL PROTECTED] writes:
dugong (icc on ia64) has been failing the contrib installcheck consistently
since 6 days ago with errors like:
ERROR: could not fsync segment 0 of relation 1663/40960/41403: No such file
or directory
I checked a cvs diff between the two timestamps
Simon Riggs [EMAIL PROTECTED] writes:
On Fri, 2008-03-28 at 09:08 +, Gregory Stark wrote:
A more invasive form of this patch would be to assign and pin a buffer when
the preread is done. That would men subsequently we would have a pinned
buffer
ready to go and not need to go back
reading) as well.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
want even
larger prefetch sizes.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce, you seem to have removed one of my three patches from the queue. I
would actually prefer you remove the other two and put back that one. It's
the
one I most urgently need feedback on to continue.
I talked to Greg on IM
reviews.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
involved in.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
other processes after all...
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
*on* rows. I'm not sure the
standard entirely adopts that model however.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
of text. Then copy
it all to another table doing transformations. Not impressed.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
but abysmally on most other
libc's.
From that point forward we would go about adding support for strcoll_l() and
other interfaces to handle case (d) on various platforms. For platforms with
no reasonable interface we could add a --enable-ICU users or packagers could
choose to use.
--
Gregory Stark
assume you're right about there being bigger problems but I don't follow how
the division is actually being done in enough detail to judge that for my
self.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql
, something like:
/usr/lib/postgresql/modules;/usr/local/lib/postgresql/modules
That way users can compile and install their own modules into /usr/local
without interfering with modules which come from OS packages.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained
for the May
commitfest. There are only a handful of lines to put in the May commitfest and
I think Alvaro's already put them in.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I would suggest a guc for the safe place and I would suggest it be a list
of
places. And I would suggest that for OS packagers they really want two
locations on that list, something like:
/usr/lib/postgresql
create this
situation we could have an assertion that calls the constructor a second time
(with palloc generating garbage data) and compares the results with
datumEqual.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about
indispensable rather than just be
doomed to being forgotten and ignored.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
The alternative seems to be to forbid uninitialized pad bytes within
Datums. That's not very pleasant to contemplate either, since it'll
forever be vulnerable to sins of omission
mean that if you try to run a query which doesn't exist you
won't accidentally type a real command or get a command not found error.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
--
Sent via pgsql-hackers mailing
Brendan Jurd [EMAIL PROTECTED] writes:
On Sat, Apr 5, 2008 at 10:00 AM, Gregory Stark wrote:
Regardless of whether we go ahead with this (and I'm not fond of it
primarily
because I want \c to work),
Okay, but what on earth is \c and what would you expect it to do
when it works? I
or type make install in
some source tree -- but actually log into each customer's database and run an
SQL script. That does seem like more work and more risk than a lot of ISPs
will be willing to take on.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about
is in. Not coincidentally the lack of that info is also
why your list isn't very helpful.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
wonder if people wouldn't feel more comfortable taking baby steps at first
which will have less impact in cases where it's not being heavily used.
I think the way it is now is neat and simple and enough for now.
Thanks.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get
Greg Smith [EMAIL PROTECTED] writes:
On Fri, 28 Mar 2008, Gregory Stark wrote:
I described which interfaces worked on Linux and Solaris based on empirical
tests. I posted source code for synthetic benchmarks so we could test it on a
wide range of hardware. I posted graphs based on empirical
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
The hard part is reading the email and figuring out
what status the patch is in.
Certainly. What we've got to do is make sure that after someone has
made that decision, it doesn't cost them a couple of minutes
. Better to go our
own way with a command that makes sense for psql than to try to turn psql into
a traditional command-line shell.
[1] http://archives.postgresql.org/pgsql-hackers/2006-12/msg00214.php
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about
customers have
signed up?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
it
for any of those reasons.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
faster than a decent
crc32 implementation?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
random regression
tests. It seems likely the day that happens will be the day that we provide an
SQL standard UNNEST anyways though.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent
pretty dirty but on the other hand the idea of
having modules consist of a bunch of objects rather than arbitrary SQL
actually seems cleaner and more robust.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I've been hacking on the idea of an Append node which maintains the ordering
of its subtables merging their records in order.
I finally got round to looking at this ...
A lot of things to chew on. Thanks very much
better off focusing on the patches I've
already started rather than starting yet another project though so perhaps I
should put this aside until I can construct a good demonstration.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS
601 - 700 of 1641 matches
Mail list logo