00551d53 in RelnameGetRelid (relname=0x1d3f288 "t1") at
namespace.c:673
#6 0x005514a7 in RangeVarGetRelidExtended (relation=0x1d3f2a8,
lockmode=1, missing_ok=1 '\001', nowait=0 '\000', callback=0x0,
callback_arg=0x0)
at namespace.c:326
Is this expected behavior?
Thanks
-Richard
On 5 Dec 2014, at 22:41, Jim Nasby wrote:
>
>
> Perhaps we should also officially recommend production servers be setup to
> create core files. AFAIK the only downside is the time it would take to write
> a core that's huge because of shared buffers, but perhaps there's some way to
> avoid wr
d to touch most of the buffers, this patch saves nearly 8MB of
memory per backend and improves performances by just over 2% on average.
It is still WIP as there are a couple of points that Andres has pointed
out to me that haven't been addressed yet; also, the documentation is
incomplete.
Richa
us what's a good way to fix it without losing the benefits
of that commit.
Thanks Alvaro and Andres for helping me get from "why is my copy getting
these signals" to understanding what's actually going on.
Richard
--
Richard Poole http://www.2ndQuadrant.c
ing Bruce, but I fear this
is one itch that'll go unscratched.
Rest assured I'm not about to storm off and replace all my installations
with MySQL :-)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ms to
have noticed before now.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
"
password retrieved from file "/home/richardh/.pgpass"
I'm a bit puzzled how it manages without the escaping in the first case.
There's a lack of consistency though that either needs documenting or
fixing.
[1] http://www.postgresql.org/docs/9.1/static/libpq-
=# select '1894-01-01'::timestamp with time zone;
timestamptz
--
1894-01-01 00:00:00-05:17:32
Floating-point timestamps? Although I thought integer was the default
for 9.x - hmm INSTALL says since 8.4
--
Richard Huxton
Archonet Ltd
--
Sent via pgs
7;
COPY (SELECT :x) TO STDOUT;
-- Doesn't work
\copy (SELECT :x) TO '/tmp/test2.txt'
=== end script ===
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
end a
vector result from fastpath function call?
2011/5/9 Tom Lane
> lee Richard writes:
> > I still can not see how it return a single return value to the client,
> and
> > why it call FunctionCall1() again when it want to send the result.
>
> pq_endmessage is where the by
the client, and
why it call FunctionCall1() again when it want to send the result.
Regards
Clipper
2011/5/8 Merlin Moncure
> On Sun, May 8, 2011 at 8:01 AM, lee Richard
> wrote:
> > Hi,
> >
> > I am reading the source code of fastpath to understand the internal of
Hi,
I am reading the source code of fastpath to understand the internal of
fastpath. I can not understand how does it send result to the client, I hope
somebody can help me on this.
I see it call it invoke the function in
HandleFunctionRequest()
-> retval = FunctionCallInvoke(&fcinfo);
-> Se
configuration-for-extension. It allows the extension to decide whether
to load the new config or reject it. It lets you test/demonstrate
multiple configurations fairly simply.
The "system_data" column scenario can then be a default implementation
of read_your_config().
--
Richard Huxton
Ar
entees should be opaque
to the community so as to prevent distraction. There should be no
appearance of community endorsement of such programs.
--
Regards,
Richard Broersma Jr.
ach to
community for assistance. In addition, third party organizations should
maintain a healthy disconnection from the community.
Is this correct?
--
Regards,
Richard Broersma Jr.
up to do it has some intrinsic
> motivation.
>
> http://www.nytimes.com/2005/05/15/books/chapters/0515-1st-levitt.html
>
Interesting.
--
Regards,
Richard Broersma Jr.
er (student). The mentors are part of the educational process.
--
Regards,
Richard Broersma Jr.
rning a
new skill. And hopefully, such a person might continue to offer support for
the project after the initial experience.
--
Regards,
Richard Broersma Jr.
this effect already taken place among the volunteering patch writers?
--
Regards,
Richard Broersma Jr.
ding the
reviewer. The utlimate goal is to add more people to the ranks of
reviewers.
> Are the mentors restricted to being US members?
>
The mentors can be anyone. If the possibility exists that PgUS can fund
mentors, then prospective mentors will need to be or become members of
PgUS.
--
Regards,
Richard Broersma Jr.
n a way that will meet the
requirements of the 501c.
It needs to be a learning experience and there needs to be a well defined
criteria of what will be delivered by the person awarded with the grant.
--
Regards,
Richard Broersma Jr.
prospective
mentors the ablility to spend more time with mentee's.
--
Regards,
Richard Broersma Jr.
alleviate your
concern?
--
Regards,
Richard Broersma Jr.
On Mon, Jan 24, 2011 at 5:53 PM, Josh Berkus wrote:
> On 1/24/11 12:17 PM, Richard Broersma wrote:
> > PgUS is preparing to fund a grant for PgUS members to learn and
> > participate in the patch review process. We looking for experienced
> > reviewers that can assist a
posted to Hackers.
Would anyone be available to assist with this?
Thoughts?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Wed, Dec 22, 2010 at 10:44 AM, Marko Tiikkaja
wrote:
> I'd prefer something short but easily understandable, but those two might be
> mutually exclusive.
Volatile CTE's doesn't add any more clarity either. Maybe "Round Trip
Reduction" CTE's. :)
--
Regards
od for indexing hypothetical data ;-)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
CONSTRAINT TRIGGER documentation that says the trigger
function must explicitly raise an exception to create the notification
that the custom constraint was violated.
Would this be a good place for it?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.p
g system rather than a new app I'm pretty sure it would have
confused me for a lot longer than it did.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
7;t know, maybe this is already possible.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Sorry, wrong word, it should be job.
You mean the wrong type of checkpoint causes XLOG file recovery fail?
I was confused, the XLOG files seem corrupted, is it also caused by the
checkpoint type? If so , why it can do this?
--
Richard
2010-08-05
All jods are done by client code, not manually.
I still did't not understand what you said.
What break what?
Thandks!
--
Richard
2010-08-05
-
发件人:Heikki Linnakangas
发送日期:2010-08-05
I am sorry, my English is poor.
I was confused by what you said.
What do you mean by saying "that'd break it"!
--
Richard
2010-08-05
-
发件人:Tom Lane
发送日期:2010-08-05 22:44:50
I am sorry, my English is poor.
I was confused by what you said.
What do you mean by saying "that'd break it"!
--
Richard
2010-08-05
-
发件人:Tom Lane
发送日期:2010-08-05 22:44:50
should not be missing some XLOG, can be the XLOG file or buffer was
corrupted.
--
Richard
2010-08-05
-
发件人:Robert Haas
发送日期:2010-08-05 22:38:37
收件人:Richard
抄送:Andrew Dunstan; pgsql-hackers
主题:Re:
atter?
--
Richard
2010-08-05
-
发件人:Tom Lane
发送日期:2010-08-05 22:04:30
收件人:Richard
抄送:pgsql-hackers
主题:Re: [HACKERS] Online backup cause boot failure, anyone know why?
"Richard" writes:
> PS : I am using PG 8.3.7
I believe there
the running error log not the XLOG.
--
Richard
2010-08-05
-
发件人:Robert Haas
发送日期:2010-08-05 22:07:45
收件人:Richard
抄送:Andrew Dunstan; pgsql-hackers
主题:Re: [HACKERS] Re: Re: [HACKERS] Online
?
--
Richard
2010-08-05
-
发件人:Tom Lane
发送日期:2010-08-05 22:04:30
收件人:Richard
抄送:pgsql-hackers
主题:Re: [HACKERS] Online backup cause boot failure, anyone know why?
"Richard" writes:
> PS : I am using PG 8.3.7
I believe there
what?
--
Richard
2010-08-05
-
发件人:Andrew Dunstan
发送日期:2010-08-05 21:40:13
收件人:Richard
抄送:pgsql-hackers
主题:Re: [HACKERS] Online backup cause boot failure, anyone know why?
On 08/05/2010 09:19 AM, Richard
PS : I am using PG 8.3.7
--
Richard
2010-08-05
-
发件人:Richard
发送日期:2010-08-05 21:19:27
收件人:pgsql-hackers
抄送:
主题:Online backup cause boot failure, anyone know why?
I want to create a
et this before? Please help me!
--
Richard
2010-08-05
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
he LSN where the error occured contained the wrong
pageaddr, the pageaddr was 8K before it's real address.What was wrong?
2010-08-04
Richard
he LSN where the error occured contained the wrong
pageaddr, the pageaddr was 8K before it's real address.What was wrong?
--
Richard
2010-08-03
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
olumns that get placed after the numeric. If you went from 10 bytes
down to 8, that should be visible.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
tgres from the existing psql
Arse.
It's little details like this that demonstrate why I'm a user and not a
hacker :-)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgres
Trying to format the data in the backend is probably just going to
frustrate writers of different clients (of which I think we have quite a
few now).
* These functions could then be back-ported as an admin-pack too for
clients/apps that wanted cross-version compatibility for these sorts of
th
e alpha testing
cycles on it."
Should we do this? Patch attached.
Any reason not to add a line to the 9.0 docs/release notes saying
"WARNING: The PGDG currently plan to change this setting's default in 9.1"?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers m
On 30/06/10 18:11, Magnus Hagander wrote:
On Wed, Jun 30, 2010 at 18:33, Richard Huxton wrote:
IMHO The real solution would be something that could strip/rewrite the
constraint on restore rather than trying to prevent people being stupid
though. People *will* just tag their functions as
p can no longer
restore the oldest record :-(
IMHO The real solution would be something that could strip/rewrite the
constraint on restore rather than trying to prevent people being stupid
though. People *will* just tag their functions as immutable to get them
to work.
--
Richard Huxton
queued WAL
before letting new transactions start. Or perhaps it replays any vacuum
activity it comes across and then stops. That should sync with #2
assuming the slave doesn't lag the master too much.
5. I've been mixing "defer" and "delay", as do the docs. We should
On 26/02/10 14:45, Heikki Linnakangas wrote:
Richard Huxton wrote:
On 26/02/10 08:33, Greg Smith wrote:
I'm not sure what you might be expecting from the above combination, but
what actually happens is that many of the SELECT statements on the table
*that isn't even being updated* ar
x27;s hard to do, but that would really be
the most robust fix possible.
Something like snapshotting a filesystem, so updates continue while
you're still looking at a static version.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
ably meaning we need *another* config setting to prevent excessive
bloat on a heavily updated table on the master.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 25/02/10 17:10, Andrew Dunstan wrote:
Richard Huxton wrote:
Presumably "Safe" just clamps down and my
sub isn't marked as acceptable. Is this intended, or am I doing
something stupid?
It's intended (at least by me).
Also, please see the recent discussion about load
unction "add_one_e"
-- plperlu - TestModule::add_one
richardh=# SELECT add_one_u(1);
add_one_u
---
2
(1 row)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
CT;
CREATE FUNCTION add_one(integer) RETURNS integer
AS 'My::Package', 'add_one'
LANGUAGE plperl STRICT;
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
nstall the adminpack etc. over the top of your now working installation.
If you didn't find the data directory, create it, grant permissions to
"postgres" and then try a full re-install.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgr
- not sure
those carry any extra info. It also treads on the toes of
"PG->not_a_function" should such a beast be needed.
I like "F->funcname" or "FN->funcname" myself.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@po
On 16/02/10 17:51, David E. Wheeler wrote:
On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote:
Perhaps it would be better to be explicit about what's going on?
SEARCHPATH->function()
SCHEMA('public')->function2()
Or did "SP" mean "Stored Procedure"
t about what's going on?
SEARCHPATH->function()
SCHEMA('public')->function2()
Or did "SP" mean "Stored Procedure"?
On a (kind of) related note, it might be worthwhile to mention
search_path in the docs and point out it has the same pros/cons as unix
file pa
On 15/02/10 10:32, Tim Bunce wrote:
On Mon, Feb 15, 2010 at 07:31:14AM +, Richard Huxton wrote:
Is there any value in having a two-stage interface?
$seq_fn = get_call('nextval(regclass)');
$foo1 = $seq_fn->($seq1);
$foo2 = $seq_fn->($seq2);
;
$foo1 = $seq_fn->($seq1);
$foo2 = $seq_fn->($seq2);
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
struck me:
1. Why have a separate recovery.conf file rather than just put the
commands inline? We can use the include directive to have them in a
separate file if required.
2. Why have a finish.replication file, rather than "SELECT
pg_finish_replication()"?
--
Richard Huxton
Archon
On 09/02/10 14:25, Jeroen Vermeulen wrote:
Richard Huxton wrote:
= Actual-cost threshold =
Also stop using the generic plan if the statement takes a long time to
run in practice.
Do you mean:
1. Rollback the current query and start again
2. Mark the plan as a bad one and plan again next
turns out
better than the specific plan (due to bad stats or config settings or
just planner limitations). The question is (I guess): How many more
winners will there be than losers?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
be
Wait for it
9.0.
You don't have a code-name. All the cool kids have code-names for their
projects.
There - that should distract everyone from actual release-related work
for the next week or so :-)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (
Greg Stark wrote:
> On Tue, Dec 1, 2009 at 9:57 PM, Richard Huxton wrote:
>> Why are we writing out the hint bits to disk anyway? Is it really so
>> slow to calculate them on read + cache them that it's worth all this
>> trouble? Are they not also to blame for the &
writing out the hint bits to disk anyway? Is it really so
slow to calculate them on read + cache them that it's worth all this
trouble? Are they not also to blame for the "write my import data twice"
feature?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing
',NULL]);
It should, but probably depends on whether "IS NOT DISTINCT" should be
considered an "operator".
http://www.postgresql.org/docs/8.4/static/functions-comparisons.html#AEN16561
Got caught by the same thing a couple of days ago.
--
Richard Huxton
Archonet Ltd
--
mporal Keys - We need two types of temporal keys. A primary key,
>> exclusion type prevents overlap so someone isn't at two places at the
>> same time.
You're going to upset a lot of managers if they can't do that ;-)
--
Richard Huxton
Archonet Ltd
--
Sent via
low string operations. Would string comparisons be safe (because a
literal would be caught before the view gets evaluated)?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
> a │ b
> ───┼───
> (0 rows)
>
> still I have not bad result, but, yes, I see what I could not to see.
Ah - that's the problem. It's not possible to get the "hidden" values
into the result set, but it is possible to see them. It only matters if
you are using the view to p
Richard Huxton wrote:
> Heikki Linnakangas wrote:
>> CREATE VIEW phone_number AS
>> SELECT person, phone FROM phone_data WHERE phone NOT LIKE '6%';
>
>> CREATE OR REPLACE FUNCTION expose_person (person text, phone text)
>> RETURNS bool AS $$
>
ostgres=# create view v as select * from x where b <> 20;
^^^
This is the expression that needs to be expensive. Then the exposing
function needs to be cheap. That makes the planner run the exposing
function first.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers maili
'6%';
END;
$$ LANGUAGE plpgsql COST 999;
CREATE VIEW phone_number AS
SELECT person, phone FROM phone_data WHERE NOT row_hidden(phone);
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
e the behavior user-controllable, something along the lines of
> "CREATE RESTRICTED VIEW ...", to avoid the performance impact when views
> are not used for access control.
Not pretty, but solves the problem.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
I was just troubleshooting a slow query
SELECT * FROM da_answer a
WHERE
a.provider_id IN ( SELECT visibility_bypass_providers( 0, 0 ) ) OR --
ownership
(
EXISTS ( -- Visibility grant
SELECT v.client_answer_id FROM sp_client_answervisibility v
JOIN sp_sharing_grou
David E. Wheeler wrote:
> On Oct 1, 2009, at 1:12 AM, Richard Huxton wrote:
>
>>> Why wouldn't the entire TOC be in a collapsed list?
>>
>> Permanently on-screen? My only concern there would be for people viewing
>> on phones etc.
>
> I have to admit
David E. Wheeler wrote:
> On Sep 29, 2009, at 8:55 AM, Richard Huxton wrote:
>
>> For the browser, does the following match what you're after, Andrew?
>> - clicking chapter title opens the browser panel
>> - panel stays open until you click close icon
>> -
Peter Eisentraut wrote:
> On Fri, 2009-07-17 at 13:58 +0100, Richard Huxton wrote:
>> 2. Titles on navigation links.
>> Run ./STYLING/title_links.pl and it should add title attributes to the
>> navigation links. This means hovering over the top links gives the title
>&g
Andrew Dunstan wrote:
>
>
> Alvaro Herrera wrote:
>> Did this go anywhere?
>
> Well, it was sorta nice but what Richard sent wasn't really what I want,
> at least, which is more along the lines of the menu David Wheeler uses
> for the Bricolage API docs.
Well,
sql text
, echo boolean
) RETURNS text LANGUAGE plpgsql AS $exec$
Perhaps another two functions too:
list_all(objtype, schema_pattern, name_pattern)
exec_for(objtype, schema_pattern, name_pattern, sql_with_markers)
Obviously the third is a simple wrapper around the first two.
--
Rich
er. After all, the first three characters are perfectly well
established.
I hope that provides some clarity.
It's useful to learn that `ROW(NULL, NULL)` is NULL, but I find the
whole thing totally bizarre. Is it me?
Yes, just you. None of the rest of us have any problems with this at all :-
n *at all*
- You can separate extension installation from usage (good for
multi-user setups).
Cons:
- Extra layer of indirection (find my namespace => namespace lookup =>
object)
- Extensions need to list what they export in what sections
- More code required
--
Richard Huxton
A
er's navigation (see upthread) that he uses
for the Bricolage docs does, however.
Ah, if you can change the overall layout then the world is your
shellfish of choice. Would it be possible to include jquery? It's
GPL/MIT dual-licence.
--
Richard Huxton
Archonet Ltd
--
Sent via p
uld
now be a link that toggles the menu on/off.
The menu could be as simple/complex as you like - this is just what I
hacked together by parsing the TOC on index.html
I've tested it on Firefox, Opera, IE7 and Safari. Realistically, the
only real problem platforms will be IE6 and perhaps
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Andrew Dunstan wrote:
Richard Huxton wrote:
Andrew Dunstan wrote:
Yes, really. What you suggest here is just not adequate, IMNSHO. I
don't want to have to scroll to the top or bottom of the page to get
navigation, and I want to be able to see the navigation and go where
I want dir
s, or something else here?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
first-served
- if your patch goes over the limit it goes in the next commit-fest.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
probably installed by default,
but they need not be hardcoded into the backend.
Presumably would help the prospective upgrader too. Upgrade tool can't
cope with the change to inet types? No problem, I *know* they're not in
use, since they're not loaded.
--
Richard Huxton
Archon
t of view, but
the idea is to map extension name to a schema. If possible, this should
work anywhere in PG that a schema can be specified.
So - If extension foo is installed in schema1 then ext:foo.fn1() is the
same as schema1.fn1()
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-
ssed rows? Also - compile settings, character set and
locale details might be relevant too.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
>Surely we'd have seen more complaints, then.
> regards, tom lane
This gets a definite +1 here as we are using "SET TIMEZONE" at the
beginning of each transaction so that each user sees/records dates
automatically in whatever timezone they have associated with them.
Works bea
On Wed, Apr 01, 2009 at 05:41:53PM -0400, Andrew Dunstan wrote:
> Richard Boulton wrote:
>> As I understand it, ASL 2 is incompatible with GPL 2, at least according to
>> the FSF. This would be a showstopper problem for me.
>
> Er, what does Postgres have that is covered by
are
> completely compatible
As I understand it, ASL 2 is incompatible with GPL 2, at least according to
the FSF. This would be a showstopper problem for me.
--
Richard
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgre
f the problem is that whenever someone has
Windows-related difficulties there's no standard tools we can use to
diagnose.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ough.
> FATAL: could not reattach to shared memory (key=1804, addr=0170): 487
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
NOTICE 'r.b=%, r.c=%', r.b, r.c;
-- This works, though notice we treat the function as a row-source
SELECT (f1(a,b)).* INTO b,c;
RAISE NOTICE 'a=%, b=%, c=%', a,b,c;
RETURN true;
END;
$$ LANGUAGE plpgsql;
SELECT f2();
ROLLBACK;
--
Richard Huxton
Archo
es to the row
then deletions can be used to spot it.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
1 - 100 of 476 matches
Mail list logo