> On Oct 22, 2017, at 3:24 PM, Peter Geoghegan wrote:
>
> On Sun, Oct 22, 2017 at 2:19 PM, Eric Ridge wrote:
>> I'm looking for the status as any concurrent open transaction might see it.
>> For example, if any concurrent transaction might see it as "in prog
n the 9.3 sources. Maybe it's necessary for 10 or maybe I just missed it
in 9.3?
Thanks for your time!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
> On Oct 22, 2017, at 1:50 PM, Peter Geoghegan wrote:
>
> On Sun, Oct 22, 2017 at 12:23 PM, Eric Ridge wrote:
>> Can anyone confirm or deny that this is correct? I feel like it is correct,
>> but I'm no expert.
>
> What are you going to use the code for? I thi
rted/crashed and no active transaction cares */
}
}
Can anyone confirm or deny that this is correct? I feel like it is correct,
but I'm no expert.
Thanks so much for your time!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscrip
On Tue, Oct 17, 2017 at 12:34:17PM +0900, Michael Paquier wrote:
> On Tue, Oct 17, 2017 at 12:51 AM, Eric Radman wrote:
> > This administrative compromise is necessary because the WalReceiver is
> > not resumed after a network interruption until all records are read,
> >
On Tue, Oct 17, 2017 at 12:34:17PM +0900, Michael Paquier wrote:
> On Tue, Oct 17, 2017 at 12:51 AM, Eric Radman wrote:
> > This administrative compromise is necessary because the WalReceiver is
> > not resumed after a network interruption until all records are read,
> >
y/t/005_replay_delay.pl | 8 ++--
3 files changed, 76 insertions(+), 15 deletions(-)
commit b8807b43c6a44c0d85a6a86c13b48b47f56ea45f
Author: Eric Radman
Date: Mon Oct 16 10:07:55 2017 -0400
Add recovery_min_apply_delay_reconnect recovery option
'recovery_min_apply_delay_
On Sat, Mar 11, 2017 at 2:14 PM Andres Freund wrote:
> On 2017-03-11 04:31:16 +0000, Eric Ridge wrote:
> > Well shoot. That kinda spoils my plans.
>
> I think you should elaborate on what you're trying to achieve -
> otherwise our advice will be affected by the
choice.
Well shoot. That kinda spoils my plans.
What about this? Is the tuple currently being evaluated (I suppose in the
case of a sequential scan) available in the context of a function call?
Thanks again for your time! It's much appreciated.
eric
've got nothing.
Of the various examples in the PG sources that use
PG_GETARG_HEAPTUPLEHEADER, or otherwise deal with a HeapTupleHeader, I
can't find any that want to access a system column, so I'm starting to
think I'm just doing it wrong entirely.
Can anyone point me in the right direction?
Thanks for your time!
eric
On Tue, Mar 7, 2017 at 6:39 PM Amit Langote
wrote:
>
> Here you go: https://github.com/kaigai/ctidscan
Thanks for the link, Amit! I think that'll get me bootstrapped!
This was proposed originally [1] to go into contrib/, but that didn't
> happen somehow.
>
Too bad. :(
eric
27;m kinda surprised there isn't an example in contrib/, actually.
Thanks for your time!
eric
hat's basically statically determined at parse time.
I suspect what I should be doing for this particular problem is taking
advantage of the Custom Scan API, but I'm trying to support PG 9.3.
We weren't planning to do that.
>
Great!
eric
#x27;t mind that you're changing this for 9.6... 9.6 is going to change so
much other stuff around custom AMs that I'll deal with it when the time
comes, but back-patching this into 9.3/4/5 would make life very difficult.
Thanks for listening!
eric
On Wed, Dec 9, 2015 at 5:07 PM Tom Lane wrote:
>
> FWIW, it's exposed in 9.4 and up. But in older branches you could
> probably just copy it, it's not that big.
>
That's good to know, thanks. I did copy it and it's almost 3x faster than
going through SPI. Thanks again for the pointer.
eric
On Wed, Dec 9, 2015 at 4:04 PM Tom Lane wrote:
> Eric Ridge writes:
> > I'm doing some extension development (in C) and have a situation where I
> > need to examine the target list of a view, but all I have is the view's
> oid.
>
> Open the relation and
st a query
like "SELECT * FROM viewname" but the target list of the actual query
wasn't what I was expecting (individual entry tags don't match those of the
SPI approach above).
Thanks for your time!
eric
On Thu, Jun 18, 2015 at 8:07 PM, Eric Ridge wrote:
>
> According to pg_proc.probin, all 32 of my C language functions point
> to $libdir/my_extension_lib,
That's a damn lie. The deployment server has a number of databases
that have this extension installed and some of them have
hat it matches what's happening
in local_preload_libraries? And is it safe to directly update
pg_proc.probin (and ya know, terminate all existing backends)?
Thanks so much for your time!
eric
ps, I think if we just changed our deploy process to terminate
existing backends this would jus
okay. I'll not check for the condition in the hook functions so
that when this does happen again I can do what you suggest.
thanks!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
athname check would fail.
According to the docs, anything listed in 'local_preload_libraries'
has to be in $libdir/plugins (whereas extensions just go to $libdir),
so rather than duplicate the .so, the "copy" in $libdir/plugins is
just a symlink to ../my_extension.so.
Could t
flag dependant?
I didn't. As far as compiler flags go, the extension is just
inheriting Postgres' defaults. Any suggestions around which flag(s)
to adjust?
I appreciate your time!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscr
.so or something, I
dunno?). I always seem to hear about the problem after a backend has been
endlessly spinning for a few days. :(
Have any of y'all seen anything like this and could I be on the right track
with my second theory?
*scratching head*,
eric
n such an order that the current
session is processed last. They'd be consistent with NOTIFY too, which
might be an added bonus.
eric
ps, sorry my last message was from corporate email w/ the stupid "legal"
disclaimer.
ot;SELECT * FROM pg_stat_activity" is kinda useless
anyways.
eric
PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATIONS
The information contained in this communication is intended only for
the use of the addressee. Any other use is strictly prohibited.
Please notify the sender if you have recei
>
> I think even something that just does that in pure SQL/plpgsql would be a
> big step forward, even if we wouldn't want it directly in the codebase.
Something like creating a trigger under the hood each time a MV is created,
that checks the changed rows on every statement against the query th
er, tuning, etc.
Eric
2015-02-20 22:35 GMT-02:00 Tomas Vondra :
> On 21.2.2015 00:20, Kevin Grittner wrote:
> > Tomas Vondra wrote:
> >
> >> I share the view that this would be very valuable, but the scope
> >> far exceeds what can be done within a single GSoC proje
sed to read them.
Thank you and regards,
Eric
2015-02-21 16:09 GMT-02:00 Robert Haas :
> On Sat, Feb 21, 2015 at 1:04 PM, Tom Lane wrote:
> > Robert Haas writes:
> >> I'm not really sure what Josh was talking about in that answer. In
> >> terms of doing this aut
Hello Everyone,
I'm Eric Grinstein, an Comp. Engineering undergrad at PUC-Rio, Brazil.
I'm very excited about contributing to Postgres, and thought GSoC would be
a very good program to get me started.
Some commercial RDBMS such as oracle implement a feature called 'Query
I would also like to participate as a student.
2015-02-16 13:28 GMT-02:00 Dmitry Dolgov <9erthali...@gmail.com>:
> I would like to participate as student.
>
> On 10 February 2015 at 03:52, Thom Brown wrote:
>
>> Hi all,
>>
>> Google Summer of Code 2015 is approaching. I'm intending on registeri
r time,
--
Eric Grinstein
Computer Engineering Student
PUC-Rio
love to understand the thoughts around handling
extension-based AMs.
eric
nt. I'll switch to that.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
CREATE INDEX idxfoo ON table USING myindex (col) WITH (option = some
complex string);
(note the lack of quotes around the option value)
Looks like (at least) ruleutils.c:flatten_reloptions() needs to be smarter.
eric
PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATION
flex from a GNU mirror site or download an
official distribution of PostgreSQL, which contains pre-packaged flex output"
I get this same error for "bison". I can install it with "sudo apt-get install
bison" and "sudo apt-get install flex". However shouldn't the ./configure
script be checking for these first?
Eric
On Thu, Jun 28, 2012 at 7:02 AM, Rob Wultsch wrote:
> On Thu, Jun 28, 2012 at 8:16 AM, David E. Wheeler
> wrote:
>> Hackers,
>>
>> Very interesting design document for SQLite 4:
>>
>> http://www.sqlite.org/src4/doc/trunk/www/design.wiki
>>
>> I'm particularly intrigued by "covering indexes". Fo
it might be a
> good idea for transformTargetList to throw an error instead of silently
> ignoring the column label.
Let me take a stab at fixing it in the grammar... if it's even do-able.
If it can be fixed at the grammar, it'll get me a lot closer to doing
what I want to do with the actu
t example was confusing. I wasn't also suggesting
expanding COPY's syntax. I was merely pointing out that if
"EXCLUDING(…)" were implemented, you'd be able to use it within the
query given to the COPY command.
eric
ps, it seems my messages aren't hitting the
nd deal with it in an
external tool.
I generally agree with everyone that says using this in application
code is a bad idea, but I don't think that's reason alone to reject
the idea on its face.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make change
x27;ve come to.
However, why is
select table.* foo from table
allowed? What does that even mean?
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
DING (x.a, x.b, x.c) FROM (SELECT x);
I've already got gram.y working the way it needs to, and I've started
to get the exclusion list passed into the places it needs to go.
If y'all would be willing to accept it in this "limited" form, I'll
continue to work
ind a solution. My gram.y-fu is at its limits right now.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
r without the AS)
I don't know what the above actually means, but it stops SELECT
pg_class.* EXCLUDING(...) dead in its tracks. So, I'd have to break a
syntax (albeit silly?) that currently works to support this. :(
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.
ht about
"EXCEPT", but that doesn't work for obvious reasons, and "NOT" might
just be confusing.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
$$->name = NULL;
$$->indirection = NIL;
$$->val = (Node *)n;
$$->location = @1;
}
And it looks like something similar would be necessary in the
"indirection_el"
blem that maybe shouldn't exist in the first place?
> It's
> a like buying a rug, so that nobody sees the scratches on the floor.
Sometimes, rugs are cheaper than new floors.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
be a "reserved keyword"?
Alternatively, would it be okay to use an existing reserved keyword?
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ort required for pg_dump)?
Anyways, at first I thought it would be about 8hrs of work just to get
something working. Maybe it's more like 20, but even still, it seems
fairly straightforward.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
COPY ( SELECT * EXCLUDING (x.col) FROM ( ) x ) TO '/tmp/foo.out' WITH CSV;
Anyways, looks like it might be an uphill battle to get the idea accepted (let
alone any code I write!), but I ain't givin' up just yet.
eric
PROPRIETARY AND COMPANY CONFIDENTIAL COMMUN
On Sun, Oct 30, 2011 at 1:51 PM, Eric B. Ridge wrote:
> eric
>
> PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATIONS
my bad. Switched email accounts without realizing. :(
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscript
27; from psql and
> then you could remove the columns from the list easily..?
Probably really dang hard, especially when you consider a "SELECT *"
involving lots of joins. And even if it turned out to be easy, it
would be limited to psql.
Anyways, it's just something I've
e the SQL spec says something about this and nobody's done the work yet?
Thanks for your input!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
e with a constrained length. No timestamps,
geometry, XML, user-defined types, etc. allowed. So it's not really as much
of an "any value" type as it might look on the surface. Don't know any
details of Oracle's implementation.
-Eric
On Tue, Dec 21, 2010 at 2:33 PM, Robert Haas wrote:
> The point of the patch was to improve cases where attaching gdb
> *didn't* work well. Any cases where it was already working for you
> aren't going to be made worse by this.
Okay, great. Thanks for the clarification.
f picking up 9.x later in '11. Just
wondering if we need to actually be a bit more careful in the future?
Thanks!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
At 01:36 AM 11/16/2010, Shigeru HANADA wrote:
Thanks for the information about Informix VTI. Because I'm not
familiar to Informix, I might have missed your point. Would you mind
telling me more about Informix VTI?
On Mon, 15 Nov 2010 08:45:14 -0800
Eric Davies wrote:
> With Info
o support virtual
tables with more than 4 billion rows.
Eric
At 07:41 PM 11/14/2010, Shigeru HANADA wrote:
On Fri, 12 Nov 2010 08:27:54 -0800
Eric Davies wrote:
> Thank you for the time estimate and the interface discussion. It
> sounds like the PostgreSQL SQL/MED code will be very u
me is indexing support. Will it be
possible to index a SQL/MED table as if it were a regular table? What
would be the equivalent of Informix's row ids?
Eric.
**
Eric Davies, M.Sc.
Senior Programmer Analyst
Barrodale Computing Services Ltd.
109
it will be before SQL/MED on
PostgreSQL will be available, and perhaps how similar it will be to
Informix VTI?
Thanks,
Eric.
**
Eric Davies, M.Sc.
Senior Programmer Analyst
Barrodale Computing Services Ltd.
1095 McKenzie Ave., Suite 418
Victoria
Tom,
That was it! My implementation of cancel() was swallowing the result
message. Thanks so much, I've got it working now.
--
Eric Simon
The IQ Group, Inc.
-Original Message-
From: pgsql-hackers-ow...@postgresql.org
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom
ch resides between the two alarm() calls above) doesn't continue on, but
rather stays frozen, waiting for data. Does PQcancel not communicate back
to the execute statement so that it unblocks?
--
Eric Simon
The IQ Group, Inc.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.
On Jan 21, 2010, at 12:35 PM, David E. Wheeler wrote:
> And where do you think baby powder comes from? Sheesh.
You won the thread!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
for stuff like this, so it'd be great if we could find and resolve
the issues sooner rather than later. We implemented better coding
practices later on in the project to help us disambiguate between
variables and columns, but there's still a bunch of legacy stuff
that's goin
error
throw? During CREATE FUNCTION or during runtime? I'm secretly hoping
that it'll throw during CREATE FUNCTION. I'd rather have my entire
schema creation transaction abort so I can fix the problems up-front,
rather than at "random" while the application is ru
ature:
log_line_prefix, but for process name.
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
x27;t seen mention of
including the setting as part of the process name, so a 'ps' (on Unix)
would display it. Thoughts?
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ments.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
BEGIN
OPEN stuff;
FETCH stuff INTO rec;
WHILE FOUND LOOP
RETURN NEXT rec;
FETCH stuff INTO rec;
END LOOP;
END;
HTH,
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscrip
nd works without the nested subquery.
I ran into SQL like the above when trying to use the Npgsql .Net driver 2.0.5
via Microsoft's Entity Framework (edmgen.exe). It happened against two
different databases. Both have UTF-8 encoding and English, United States
language.
--
Eric
--
On Apr 22, 2009, at 10:47 PM, Tom Lane wrote:
I think this is due to a change that was made in 8.2:
Cool. Thanks for the followup!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
one that in the first place, but I thought it was worth
mentioning that v8.1 did a much better job planning in this particular
case.
If my test schema will be beneficial, please let me know.
Thanks!
eric
foo=# explain analyze select count(*) from c w
On Apr 20, 2009, at 2:27 PM, Eric B. Ridge wrote:
Some investigation showed that the use of non-IMMUTABLE PL/PGSQL
functions as view columns, when these views are joined with other
views, cause the query to be planned poorly.
I'm sorry. I should have said VOLATILE functions. Which i
k on, especially regarding multi-
gigabyte databases w/ full text, I'll be happy to provide it.
Keep up the great work!
eric
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, Oct 19, 2008 at 11:21:09PM -0400, Tom Lane wrote:
> Eric Haszlakiewicz <[EMAIL PROTECTED]> writes:
> > On Sun, Oct 19, 2008 at 10:15:22PM -0400, Tom Lane wrote:
> >> What platform is this, anyway?
> > I'm running on NetBSD 4.
>
> > Well, it seem
On Sun, Oct 19, 2008 at 10:15:22PM -0400, Tom Lane wrote:
> Eric Haszlakiewicz <[EMAIL PROTECTED]> writes:
> > On Sat, Oct 18, 2008 at 12:48:13PM -0400, Tom Lane wrote:
> >> That's already documented not to work, and not for any hidden
> >> implementation rea
On Sat, Oct 18, 2008 at 12:48:13PM -0400, Tom Lane wrote:
> Eric Haszlakiewicz <[EMAIL PROTECTED]> writes:
> > I just spent a couple of days trying to figure out why I couldn't start
> > two servers on the same port, even though I was configuring separate
> > li
a bit easier to find, so here's a couple patches to the
documentation to mention how this works.
eric
--- doc/src/sgml/config.sgml.orig 2008-10-18 00:08:50.0 -0500
+++ doc/src/sgml/config.sgml2008-10-18 00:10:58.0 -0500
@@ -337,6 +337,12 @@
same port numbe
I guess you can also get this before writing code from
select typbyval from pg_type where typname='mytype'
...thanks again.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
>
> Everything is always passed as a Datum, so yes, it's is determined by
> the storage clause in CREATE TYPE.
Still not sure what to do in some scenarios. One example is the gist
example code for btree (btree_gist). If you look at the int4 example
consistent function, it gets an int32 value (p
GiST takes you a long way but not
quite all the way for these types of scenarios.
Thanks
Eric
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
Can't remember if it was in this forum, but a few people asked why I
was downloading source and not binary. The reason is that I am
experimenting with a different indexing (multi-dimensional) method.
I looked hard at GiST, but it doesn't look like GiST supports multi-
dimensional indexing method
Sorry, here's the first post, just now included hackers (more info in
previous post)...
The following error occurred when issuing a vanilla initdb command on
my Windows system.
FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds.
Post
A little more info that might help: I had to put a hack into two .h
files (libpq.h, libpq-int.h) and add
typedef int ssize_t
to get things to compile. I did notice that libpq-int.h had this
typedef inside an #ifdef WIN32_ONLY_COMPILER which apparently wasn't
triggered.
Have now also tried:
downloading 8.2.2 and compiling it - no luck when running initdb (same
error)
rerunning configure with and without --with-includes=/mingw/include --
with-libraries=/mingw/lib (always running --without-zlib) - same error
I have been searching newsgroups, archives, etc. in hop
I'm trying to setup Kerberos authentication with PG on Windows 2000.
I have installed the MIT Kerberos Windows dlls into the PG bin directory
- replacing the krb5_32.dll and comerr32.dll from the PG install.
I did this because the PG install did not have the krbcc32.dll,
which is needed to find t
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Merlin Moncure
> Sent: 12 avril 2006 12:22
> To: Neil Conway
> Cc: Tom Lane; David Fetter; Jim C. Nasby; Joshua D. Drake;
> [EMAIL PROTECTED]; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] p
rebird.
Thanks for your patience.
Eric LEGUILLIER
Well, first, you ought to learn the name of the product. It's Postgres
or PostgreSQL, but not PostGre.
I suspect that you will find other issues anyway in running from a
datadir on a read-only medium. I suggest you see if you can do it
rega
this option, I CANNOT use PostGre, and
I think I'm not the only one...
Eric LEGUILLIER
Projet BriqueBackup
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
>> To be honest, the fact that Postgres forces you to run as a
>> non-admin user has given me nothing but heada
PostGre developpers think the users are children.
I'm deeply disappointed to be forced to compile my own PostGre and I will
not.
Eric LEGUILLIER
> > I explain myself about running PostGre as admin.
> >
> > In fact I don't want specifically run PostGre as admin. The pr
or
willingly authorize an user with special rights to run the application
would be great for me.
Regards,
Eric LEGUILLIER
Why do you need to run PostgreSQL as admin? There shouldn't be any need
for this.
Someone has done a PostgreSQL demo CD, I believe based on Knoppix.
The list archive
be on the DVD...). Is it possible? If not, can
it be added (add of a 'read-only' option).
Thanks in advance for your help.
Regards,
Eric LEGUILLIER
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
TO console
WITH GRANT OPTION;
--FUNCTION CALLER
SELECT * from get_source_rule_level_1() AS (hits int8,src int8,bid
int8,tid int4,min_time int8,max_time int8)
-Eric Lauzon
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, 2005-10-12 at 13:00 -0400, Eric Sproul wrote:
> We are interested in finding a way to directly translate the
> data files from one version to the next. We can devote resources to
> work on this if the development team can give us guidance.
Please excuse the followup to myself...
ave the online storage to be able to run two instances
concurrently. This is the root cause of our desire to upgrade in place.
We might not even have enough space for a full logical export-- it would
be pretty tight.
Eric
---(end of broadcast)---
TIP 5
x27;t work
properly). We are interested in finding a way to directly translate the
data files from one version to the next. We can devote resources to
work on this if the development team can give us guidance.
Thanks in advance,
Eric Sproul
---(end of
On Apr 1, 2005, at 3:55 PM, Tom Lane wrote:
"Eric B.Ridge" <[EMAIL PROTECTED]> writes:
Like I said, everything
usually works without problems, but from time to time it crashes.
If you rebuild with --enable-cassert, does the crash get more
reproducible?
Indeed. Every time. This is
In the past I've had
issues with incorrectly using SPI (esp with recursion), and I'm not
entirely sure how it should work with SRF's. Like I said, everything
usually works without problems, but from time to time it crashes.
Below is the basic outline of my code.
Any in
I've brought this back on-list, probably best that way..?
Eric Parusel wrote:
Tom Lane wrote:
What it kinda looks like from here is that you suffered a "page tear":
the itemid pointers at the front of the page may be self-consistent, but
they don't quite match the state of
Tom Lane wrote:
Eric Parusel <[EMAIL PROTECTED]> writes:
./pg_filedump -i -f -R 28393 /data1/pgsql/data/base/17760/18004
--snip--
Item 2 -- Length: 1728 Offset: 6464 (0x1940) Flags: USED
XMIN: 12 CMIN: 196608 XMAX: 122552335 CMAX|XVAC: 177664675
Block Id: 0 linp Index: 47241 Attr
here my problem lies.
What do I do now? Can this be repaired?
This tuple is not needed, I can "get rid of it" or somehow dereference
it if need be.
How does an inconsistency like this typically arise?
Thanks very much,
Eric
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
);
else
SRF_RETURN_DONE(funcctx);
test=# select * from unnest('{1,2,3,4,5}'::int8[]);
unnest
1
2
3
4
5
(5 rows)
Also works for the few other datatypes I checked.
Am I missing something obvious?
eric
---(end of
1 - 100 of 143 matches
Mail list logo
