I want to understand how Postgres organizes data and handles IO
operations so that I will better know how to optimize a Postgres
database server. I am looking for answers to specific questions and
pointers to where this stuff is documented.
How does Postgres organize its data? For example, is it g
ts
this
wrong. pg_autovacuum is another good step in this direction.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
hive transaction log protocol. If my proposed
usage is flawed, then negative kudos to my puny mind.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nom
On Jun 10, 2004, at 10:30 AM, [EMAIL PROTECTED] wrote:
Prior to lazy vacuum, this was impossible.
Do you know for sure that lazy vacuum and/or autovacuum does
not indeed solve / alleviate the symptoms of the general problem
of very high rate table updates?
Back to lurking!
James Robinson
naged transactions *by the middleware container*, and, if the
middleware container is configured to cache prepared statements between
transactions, then it will expect them to live well beyond their
initial explicitly-managed transaction.
James Robinson
Socialserv
ent code in the
backend could be written , say, somewhere in the internals document
around the coding conventions chapter:
http://developer.postgresql.org/docs/postgres/source.html
I myself don't have a clue, not being a backend hacker, so I'll just
slink back to my cave.
James
implementation?
Quotas per user per tablespace, assuming 7.5 gets tablespaces.
User quotas would make postgres on a shared university box much more
pleasant.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
instead of for update
locks.
How much work is involved in getting this done? Is interested in getting
paid to undertake this?
Please contact my email directly as I am not subscribed to this list.
James Pharaoh
---(end of broadcast)---
TIP 1
ng this type of feature (automatic
table layout optimization), but I thought I would check with the people
currently hacking on the system first, to see if there was a showstopper or
if someone is already working on this.
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of b
lassic scenario for this is when you have a large collection of
time-series data stored in a table, with each series keyed to another
table. The the typical tuple distribution creates pathological
behaviors when buffer space becomes tight.
Cheers,
-James Rogers
[EMAIL PROTECTED]
number of relevant tuples per buffer is low for a given query, so we
aren't getting much tuple bang for the buffer buck. I suppose one could
look at it as trying to improve the intra-buffer hit rate for a given
query.
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
R index doesn't tell you much about which
pages would currently be a good place to put a new tuple. You could
always markup the index that CLUSTER uses to keep track of good
candidates (plus some additional structures), but the more I think about
that, the more it looks like a nasty hack
On 10/2/03 11:34 PM, "Hannu Krosing" <[EMAIL PROTECTED]> wrote:
> James Rogers kirjutas N, 02.10.2003 kell 23:44:
>> Not exactly. What you are describing is more akin to partitioning or
>> hash-organized tables i.e. sorting insert/update tuples to various pages
>
need to understand the
limitations, nonetheless when tables and databases get really big it becomes
an important tool in the tool belt.
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
o I guess I have two questions:
1) Does anyone object to me working on these two areas?
2) What version target should I realistically be shooting for?
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to
ports/databases/postgresql/work/
.darwinports.postgresql.state file then needs to be edited to cause a
reconfigure of the source with the new template.
sudo vim
{DarwinPortsDir}/dports/databases/postgresql/work/
.darwinports.postgresql.state
Remove the following lines:
target: com.apple.configure
Try the build of postgresql again, DO NOT clean it, just try the
install again.
-
Best of luck (was re: works for me.)
---
James Wilson
CCIE #6662
LithiumCorp Pty Ltd
mobile: 0422 22 3742
email: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
mbols:
_PQfreemem
_PQresultErrorField
_PQsetNoticeReceiver
_last_path_separator
I noticed it's not linking with the "-undefined suppress" flag which
I've found it required when building 'bundles' for darwin.
Cheers,
On 12/10/2003, at 3:28 AM, Marko Karppinen wrote:
James
s move to a database kernel eventually for a lot
of reasons, but it would a relatively significant change. Maybe v8? :-)
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
a set of operating system APIs
is never going to give stellar or even results across all platforms because
the operating system APIs usually aren't written so that you could write
your database optimally.
Theoretically, it is the difference between middling performance in the
typical case and
On 10/14/03 11:31 PM, "James Rogers" <[EMAIL PROTECTED]> wrote:
>
> There is some abstraction in Postgres and the database is well-written, but
> it isn't written in a manner that makes it easy to swap out operating system
> or API models. It is written to be po
nport-installed readline et.al. which are in /opt/local/lib and
/opt/local/include
Removing the old postgres libs would resolve this build issue, but
makes it a bit painful for users upgrading from an existing
installation.
On 15/10/2003, at 4:03 AM, Tom Lane wrote:
James Wilson <[EMAIL P
If you think they are orthogonal, you don't understand the
nature of this particular beast.
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
postgres. 'Cause its our butt on the
line hosting our client's data.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
for going about doing
this?
Cheers,
-James Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I've gotten the green light (and many responses from people interested
in doing it) to start writing up RFQs for specific features, which I
will post to the pg-hackers list. It is all stuff previously determined
to be doable within the current PostgreSQL framework, and just requiring
some work that
get better
performance by allocating most of the memory to the buffer cache rather
than leaving it to the kernel file cache.
I'm actually fairly curious to see what the new buffer management scheme
will mean in terms of real world performance and parameter tuning.
-James Rogers
I'm interested in poking though and taking a shot at getting my feet
wet with pl/python. I see the file is copyright Andrew Bosma -- is he
still around perhance? Is anyone currently the 'owner' ?
James Robinson
Socialserve.com
---(e
example, I see that plpython functions cannot be declared
to return void. That can't be too tough to remedy. Implementing the
DBI 2.0 API interface to SPI can wait another day.
On Feb 24, 2006, at 11:08 PM, Joshua D. Drake wrote:
James Robinson wrote:
I'm interested in poking though
yet, then it just fails as normal.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
this table.
Finally, the only possibly potentially interesting event database-
wise happened on Wed. Nov. 23'rd -- we SIGHUP'd the postmaster to
have it learn a higher value for work_mem (10240, up from default of
1024). But the hourly crons went great for the subsequent two days.
m
y mounting issue
here. args: 'postgres: postgres social [local] VACUUM waiting'
28861 -- production servicing backend, now back in idle state. [ not
in tx idle by regular idle ].
On Nov 28, 2005, at 11:09 AM, Tom Lane wrote:
James Robinson <[EMAIL PROTECTED]> writes:
Comparing t
ostgresMain ()
#16 0x0816ffa9 in ServerLoop ()
#17 0x08170de9 in PostmasterMain ()
#18 0x0813e5e5 in main ()
(gdb) quit
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
remote?
James Robinson
Socialserve.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 do not
match
ind that additional buffering a damnable offense?
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Nov 28, 2005, at 1:46 PM, Tom Lane wrote:
James Robinson <[EMAIL PROTECTED]> writes:
backtrace of the sshd doesn't look good:
Stripped executable :-( ... you won't get much info there. What of
the client at the far end of the ssh connection? You should probably
assume t
iness afoot perhaps
hardware-wise?
James Robinson
Socialserve.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 g
exactly two tables
(t3 and t4), not the t1, t2, t3 cartesian product joined with t4.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
tarting up
LOG: database system is ready
We were back online within minutes of the interruption w/o any data
loss.
So, I raise my glass to you! Thank you!
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
casts the literal int4 to an int8, making the int8
column index useable.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
atus = 8
Foreign-key constraints:
"unit_building_fkey" FOREIGN KEY (building) REFERENCES building(id)
"unit_city_fkey" FOREIGN KEY (city) REFERENCES housingcity(id)
"unit_leadpaintunit_fkey" FOREIGN KEY (leadpaintunit) REFERENCES
leadpaintun
it(id)
Patch applied, fixes beta4 for the query with our data. Many thanks
again!
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
COMMIT
Many thanks in advance,
James
pets.sql
Description: Bina
hanks.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: 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
ELSIF and ELSEIF as legal spellings of the keyword. This seems a
bit ugly but I can't think of any really good objections.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
has seemed to suit us just fine.
----
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
e to run
inside PG. Ugly savepoint handling and all.
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Dec 13, 2010, at 6:16 PM, Tom Lane wrote:
> how do you identify which type OID is really hstore?
How about an identification field on pg_type?
CREATE TYPE hstore ..., IDENTIFIER 'org.postgresql.hstore';
-- Where the "identifier" is an arbitrary string.
Type information can be looked up by th
On Dec 23, 2010, at 3:38 AM, Jan Urbański wrote:
> Oh, didn't know that. I see that it does some more fancy things, like
> defining a inheritance hierarchy for these exceptions and adding some
> more into the mix.
Right, there were some cases that appeared to benefit from larger
buckets than what
org accordingly. If the user community grows or
>> if one of the committers takes an interest in this down the road, I
>> think we could consider it for a future release.
>>
>
> I spoke with James offline about this as well. My understanding (correct
> me James) is that he
On Feb 1, 2010, at 2:13 PM, Bruce Momjian wrote:
> I would love to know why PL/Python can't be incrementally improved like
> the rest of our code.
AFAICT, there are two primary, perhaps identifying, parts to a PL extension:
code management (compilation, execution, etc) and type I/O (conversion in
On Feb 1, 2010, at 1:23 PM, Nathan Boley wrote:
>> I think it would be great for you to review it... I doubt that will
>> cause it to get committed for 9.0, but my doubt is no reason for you
>> to hold off reviewing it.
>
> I assumed so, but the pretense of a chance will probably help to motivate
On Feb 5, 2010, at 1:34 PM, Marko Kreen wrote:
> py-postgresql seems to be more serious, but as it's python3 only
> which makes it irrelevant today.
Furthermore, if it did work on python2, it's *not* something that's going to
appeal to mainstream users (Python heavy web frameworks) as it *partial
On Feb 5, 2010, at 11:34 AM, Josh Berkus wrote:
> For people who use Python a lot, could I have a list of the deficiencies
> in DBAPI? I've got my horse and lance ready.
>
> Given that SQLAlchemy isn't for everyone, of course ... it couldn't be,
> or Django would use it, no?
Here are some to st
On Feb 5, 2010, at 8:00 AM, Peter Eisentraut wrote:
> I think another difference is that the Perl DBI interface is very rich,
> whereas the Python DB-API is quite minimal and almost forces people to
> write (incompatible) extensions.
Yep.
> The DB-SIG at Python that ought to drive all this is a
On Feb 6, 2010, at 5:51 PM, Josh Berkus wrote:
>> Finally, I just don't see the existing (often PG specific) goals that I have
>> in mind for it appealing to the majority of [web framework/abstraction]
>> users.
>
> What are those goals?
I think the most interesting one that has yet to be imple
On Nov 10, 2009, at 9:54 AM, Bruce Momjian wrote:
> FYI, Heikki has fixed this bug and the fix will appear in Postgres 8.5.
>> Heikki> Oops, you're right. The check is indeed confusing julian day
>> Heikki> numbers, with epoch at 23th of Nov 4714 BC, with
>> Heikki> postgres-reckoning day numbers
On Apr 20, 2010, at 10:03 PM, feng tian wrote:
> Another way to do this, is to send the client an "redirect" message. When
> client connect to 127.0.0.10, instead of accepting the connection, it can
> reply to client telling it to reconnect to one of the server on
> 127.0.0.11-14.
ISTM that
On Feb 1, 2010, at 12:18 PM, James William Pye wrote:
> Right now, I'm trying to trim some of the easy issues[1] and getting a
> project web page up. I expect to be able to make a release soon, and I'll
> follow-up to this thread when I do.
Well, I ended up doing some ot
On Mar 1, 2011, at 12:10 PM, Jan Urbański wrote:
> So you end up with a context message saying "PL/Python function %s" and
> a detail message with the saved detail (if it's present) *and* the
> traceback. The problem is that the name of the function is already in
> the traceback, so there's no need
On Jul 7, 2010, at 12:07 AM, Peter Froehlich wrote:
> I joined this list under the mis-impression that it was about hacking
> the Python interfaces to pgsql. Is there possibly another list for
> that? Or is the Python stuff just mixed in with all the rest? Sorry
> for the meta-question...
For BSD/
On Jul 23, 2010, at 7:11 AM, Tom Lane wrote:
> I can't help thinking that the JDBC driver must be being overly cute
> if this breaks it ...
I was wondering the same thing when I first saw Kris' message. However, iff I
understand what JDBC is trying to achieve, I don't think I would call it
"over
On Jul 25, 2010, at 8:01 AM, Kris Jurka wrote:
> The JDBC driver reads server messages for multiple reasons.
> One of them is indeed to do early failure detection.
That's high quality. =)
> Another is to pickup NoticeResponse messages to avoid a network buffer
> deadlock.
That's a good catch.
On Jul 28, 2010, at 9:53 AM, Kris Jurka wrote:
> Technically you won't get NotificationResponse until transaction end, so you
> don't need to worry about that mid copy.
Ah, thanks for noting that. It would appear my original reading of the async
section didn't get far enough beyond "Frontends mu
On Aug 6, 2010, at 4:31 PM, Kris Jurka wrote:
>
I think there's a snag in the patch:
postgres=# COPY data FROM '/Users/jwp/DATA.bcopy' WITH BINARY;
ERROR: row field count is -1, expected 1
CONTEXT: COPY data, line 4
Probably a quick/small fix away, I imagine.
But, I was able to trigger the
On Aug 13, 2010, at 5:20 PM, Tom Lane wrote:
> According to a discussion over in Fedora-land, $subject is true:
> http://lists.fedoraproject.org/pipermail/devel/2010-August/140995.html
>
> I see several calls in plpython.c that seem to refer to PyCObject stuff.
> Anybody have any idea if we need t
On Aug 14, 2010, at 9:08 AM, Tom Lane wrote:
> Just to clarify, you're recommending something like
>
> proc->me = PyCObject_FromVoidPtr(proc, NULL);
> + if (proc->me == NULL)
> + elog(ERROR, "could not create PyCObject for function");
> P
On Aug 9, 2010, at 11:49 AM, Kris Jurka wrote:
> Oh, duh. It's a server side copy not going through the client at all. Here's
> a hopefully final patch.
Trying it out... Works for me.
I understand the resistance to the patch, but it would be
quite nice to see this wart in the rear view. =\
--
In the event that my plpython3 patch does not make it, it seems prudent to try
and get a *much* smaller patch in to allow the PL to easily exist out of core.
I added a couple SPI functions in order to support the database access
functionality in plpython3u. Also, a getelevel() function for condi
On Dec 20, 2009, at 12:03 AM, Tom Lane wrote:
> Why not code a loop around one of the existing SPI execution functions?
*shrug* seemed nicer to push it on the parser than to force the user to split
up the statements/calls. Or split up the statements myself(well, the parser
does it so swimmingly
On Dec 20, 2009, at 1:36 AM, Peter Eisentraut wrote:
> Please check that it is sane.
I'm up, so:
Works for me on snow leopard.
But it doesn't seem to want to stop configure'ing on my fbsd8/amd64 box:
$ ./configure --prefix=/src/build/pg85a3
$ gmake # GNU make 3.81
... (last few lines before i
On Dec 20, 2009, at 9:20 AM, Tom Lane wrote:
> Usually that means timestamp skew, ie file timestamps are later than
> your system clock.
Yep. It's working now.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
On Dec 20, 2009, at 12:03 AM, Tom Lane wrote:
> This looks like it's most likely redundant with the stuff I added
> recently for the plpgsql parser rewrite. Please see if you can use that
> instead.
The parser param hooks will definitely work. As for getting the result
TupleDesc prior to executi
On Jan 13, 2010, at 11:08 AM, Joshua D. Drake wrote:
> My argument would be now, what is the benefit of the James Pye version
> over our version. James can you illustrate succinctly why we should be
> supporting a new version?
Doing so, succinctly, is unfortunately difficult.
It is pr
On Jan 13, 2010, at 2:27 PM, Peter Eisentraut wrote:
> The problem I'm having with this discussion is that every time someone
> asks what the supposed advantages of this new Python PL are, a feature
> list like the above is dumped,
I agree that this is unfortunate, but how else can we to discuss t
On Jan 13, 2010, at 12:15 PM, Robert Haas wrote:
> 1. It's not just a rewrite, it's an incompatible rewrite that will
> present significant user-visible behavioral differences. So replacing
> the current implementation wholesale would produce massive breakage
> for anyone actually using PL/python
On Jan 14, 2010, at 12:17 AM, Greg Smith wrote:
> Code samples.
Okay.
> I don't know, because even with several thousand lines of basic Python code
> to my credit I cannot understand a single one of the arguments you presented
> for why your implementation is better--except agreeing that, yes,
On Jan 14, 2010, at 2:03 PM, Joshua D. Drake wrote:
> What I would (as a non hacker) would look for is:
>
> (1) Generalized benchmarks between plpython(core) and plpython3u
>
> I know a lot of these are subjective, but it is still good to see if
> there are any curves or points that bring the per
On Jan 14, 2010, at 7:08 PM, Greg Smith wrote:
> So more targeted examples like you're considering now would help.
So far, I have three specific examples in mind:
The first will illustrate the advantages of function modules wrt setup code in
the module body. Primarily this is about convenience.
On Jan 14, 2010, at 7:08 PM, Greg Smith wrote:
> So more targeted examples like you're considering now would help.
Here's the first example. This covers an advantage of function modules.
This is a conversion of a plpythonu function published to the wiki:
http://wiki.postgresql.org/wiki/Google_T
On Jan 20, 2010, at 12:27 PM, Magnus Hagander wrote:
> Well, it needs the version to match it to the DLL name. For python
> 2.6, it needs python26.dll. But yes, there should probably be some way
> to ask python itself about that - that would be the non-naive method.
> But as long as python is insta
On Jan 14, 2010, at 2:03 PM, Joshua D. Drake wrote:
> What I would (as a non hacker) would look for is:
>
> (1) Generalized benchmarks between plpython(core) and plpython3u
>
> I know a lot of these are subjective, but it is still good to see if
> there are any curves or points that bring the per
On Jan 14, 2010, at 7:08 PM, Greg Smith wrote:
> So more targeted examples like you're considering now would help.
Here's the trigger example which should help reveal some of the advantages of
"native typing". This is a generic trigger that constructs and logs
manipulation statements for simple
On Jan 27, 2010, at 1:00 PM, Joe Conway wrote:
> Implementing true value_per_call is still something on my TODO list, but
> obviously has not risen to a very high priority for me as it has now
> been an embarrassing long time since it was put there. But that said,
> materialize mode has proven extr
On Jan 30, 2010, at 3:36 PM, Ivan Sergio Borgonovo wrote:
>> For development purposes you would be far better off building a
>> private version of postgres (with configure --prefix=/path) and
>> using its pgxs to build, install and test your module.
>
> That's pretty expensive.
eh:
j...@torch[]:
On Mon, Jun 02, 2008 at 08:10:19PM +0200, Pavel Stehule wrote:
> > * I have a mild preference for "array_fill" instead of "array_init".
>
> maybe, maybe array_set. Any ideas are welcome
array_create?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your s
On Tue, Jun 03, 2008 at 01:17:43AM -0400, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > I would like to add the flags given to pg_dump into the output of the
> > pg_dump
> > file.
+1, FWIW
> > Anyone see any issues with this?
>
> I'm a bit worried about breaking diff-equality o
Is there anyway to bind a cursor with SCROLL and WITH HOLD at the
protocol level?
Or perhaps configuring it so after binding it?
I know you can use DECLARE, but I believe that this inhibits the
driver from being
able to select the transfer format for individual columns; it's all
binary or i
On Jun 12, 2008, at 10:08 AM, Tom Lane wrote:
James William Pye <[EMAIL PROTECTED]> writes:
Is there anyway to bind a cursor with SCROLL and WITH HOLD at the
protocol level?
No, and for at least the first of those I don't see the point,
since the protocol doesn't offer an
On Jun 12, 2008, at 3:59 PM, Tom Lane wrote:
Sure, but if you're willing to use a SQL-level operation on the portal
then you could perfectly well declare the cursor at SQL level too.
Indeed, but like I said in my initial e-mail::
I know you can use DECLARE, but I believe that this inhibits
On Jun 12, 2008, at 4:45 PM, Tom Lane wrote:
Huh? I don't see why... you might have such a limitation in a
particular driver, but not in the protocol.
Oh? I know when you bind a prepared statement you have the ability
state the formats of each column, but I'm not aware of the protocol's
capaci
You guys call this "simplification"? You're out of your minds.
This proposal is ridiculously complicated, and yet it still fails
even to consider adjusting non-numeric parameters. And what about
things that require more than a trivial arithmetic expression to
compute? It's not hard at all to im
On Jun 13, 2008, at 9:24 AM, Tom Lane wrote:
You'd do it while Binding a FETCH command.
Indeed, that is true. It seems quite unfortunate that drivers
have to jump through such hoops to provide a convenient
programmer's interface to held and/or scrollable cursors; bearing in
mind all that has be
On Jun 13, 2008, at 4:40 PM, Kris Jurka wrote:
The JDBC driver would also like this ability, but a GUC is a pretty
ugly hack.
I completely agree that it is an ugly hack. :)
Also, since you still have to go to the SQL level to issue the MOVE
or FETCH BACKWARD, you're still not all the way t
On Sun, Sep 17, 2006 at 07:38:38PM -0400, Tom Lane wrote:
> We have three possible choices for this: do nothing, install a
> bug-compatible, allegedly-clean-room implementation in contrib:
> http://archives.postgresql.org/pgsql-patches/2006-09/msg00077.php
> or put a hopefully-cleaner design into c
On Sat, 2005-04-30 at 16:17 -0400, Tom Lane wrote:
> An example that Elein put up yesterday:
> http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php
> caused me to realize that type output functions that depend on
> additional arguments to determine what they are dealing with are
> fund
]http://python.projects.postgresql.org/license.html
[4]http://lists.pgfoundry.org/mailman/listinfo/python-general
[5]http://python.projects.postgresql.org/quick.html
--
Regards, James William Pye
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
sitate to contact me by e-mail or on freenode where
I go by the nick 'jwp'.)
[1]http://python.projects.postgresql.org
[2]http://python.projects.postgresql.org/project/be.html
[3]http://python.projects.postgresql.org/license.html
[4]http://lists.pgfoundry.org/mailman/listinfo/py
think it would be a good goal to have.
...
I asked on IRC and I'm still curious, does PG have a API styling
standard/guide? I see formatting and info about error messages, but
nothing about function/global/typedef naming.
--
Regards, James William Pye
---(end of broa
ng()))
PyEncoding_FromPgEncoding is defined in encoding.c.
Also, it should be noted that to get the interpreter to read the
function code as a specific encoding, one must use, afaik, the # -*-
encoding: utf-8 -*- magic.
--
Regards, James William Pye
---(end of broa
non-SRFs.
Am I missing something?
(This question comes from trying to keep non-SRF generator support in PL/Py
from leaking all over the floor..)
Regards,
James William Pye
pgpLEIU51G2Ic.pgp
Description: PGP signature
201 - 300 of 359 matches
Mail list logo