See the attached file for details
---(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
David--
My boss has given me approval to put up to 8 hours per week of SourceLabs'
time in on the SQL99 hierarchical query implementation. (I'm free, of
course, to supplement this with whatever of my own time I can spare.) I'm
willing to take on the work. What's the
ng “Project -> C/C++ Index ->
Rebuild” (I think).
--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com
signature.asc
Description: Message signed with OpenPGP using GPGMail
ables? If so, can someone provide an example where the foreign scan has found
a tuple, passed it to `ExecForeignDelete`, and then no delete takes place (i.e.
`ExecForeignDelete` returns `NULL`)? As far as I can reason, if the foreign
scan has found a tuple, the update and delete actions need to do
by C
standards (and as seen here implemented differently by two different compilers).
The workaround is to make separate assignments on separate lines, which act as
sequence points to impose a total order on the side-effects in question.
—Jason
On Jan 28, 2014, at 2:12 PM, Christian Kruse
Bump.
I’m interested in many of the issues that were discussed in this thread. Was
this patch ever wrapped up (I can’t find it in any CF), or did this thread die
off?
—Jason
On Aug 6, 2013, at 12:18 AM, Amit Kapila wrote:
> On Friday, June 28, 2013 6:20 PM Robert Haas wrote:
>> On
documentation use BuildTupleFromCStrings in examples without mentioning this precaution. Is it just well-known, or did I miss a README or comment somewhere?
--Jason PetersenSoftware Engineer | Citus Data303.736.9255ja...@citusdata.com
tup_memleak.c
Description: Binary data
signature.asc
Description
to-SQL function would be a huge improvement
for now.
I trawled through the archives but couldn’t find any discussion of why this
function was kept static.
--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com
signature.asc
Description: Message signed with OpenPGP
even some
commercial projects can be influenced in this way.
IANAL, but it is hard to recommend relying on a reading of the GPL that
is inconsistent with the folks that wrote the license.
Jason
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
t variables in sql from
files. Minor typo in the documentation:
"The content is escapeaed as bytea value."
Hope this helps!
Jason O'Donnell
Crunchy Data
The new status of this patch is: Waiting on Author
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.or
x);
}
pg_stat_statements_with_timestamp_v2.patch
<http://postgresql.nabble.com/file/n5912461/pg_stat_statements_with_timestamp_v2.patch>
Regards,
Jason Kim.
--
View this message in context:
http://postgresql.nabble.com/PROPOSAL-timestamp-informations-to-pg-stat-statements-tp59123
quot;too many triggers" when creating
gratuitous indices on these tables, I feel as it may be possible to do what
I want without breaking everything. But then again, am I taking too many
liberties with technology that maybe didn't have use cases like t
he woods with the query analyzer? Doesn't seem like
it would, necessarily, at least.
On 8/11/07, Josh Berkus <[EMAIL PROTECTED]> wrote:
>
> Jason,
>
> > Aside from running into a known bug with "too many triggers" when
> creating
> > gratuitous indices on these
ant, in any
way shape or form, to suggest that you can't pay money for PostgreSQL.
Nor are they likely to limit themselves to competing with free
(libre/gratis) databases.
Some of them might even object to the use of the word "damn" :).
Jason
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
than willing to tell you which bits of PostgreSQL are dicey.
That's a huge bonus to someone creating and maintaining an
application.
However, it's not exactly the sort of salesmanship that my boss is
looking for.
Jason
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
is, I'll be happy to dig in and answer this.
Saravanan Bellan has provided a file list, but not a package list.
Would you be willing to do the conversion? See the following:
http://archives.postgresql.org/pgsql-cygwin/2002-05/msg00030.php
> > http://www.tishler.net/jason/softwar
ed by the normal Cygwin gcc (and hence, linked against cygwin1.dll)
is effectively GPL'd or at least required to be open source.
> [snip]
Jason
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
PC, etc. So, this code base may be a more
suitable starting point to satisfy PostgreSQL's native Win32 System V
IPC needs.
Jason
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
in fork() to fail) that are
avoidable by rebasing the appropriate DLLs. AFAICT, Cygwin PostgreSQL is
currently *not* affected by this issue where as other Cygwin applications
such as Python and Apache are.
Jason
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Mon, Jun 03, 2002 at 09:36:51AM -0400, mlw wrote:
> Jason Tishler wrote:
> >
> > On Sun, Jun 02, 2002 at 09:33:57PM -0400, mlw wrote:
> > > Bruce Momjian wrote:
> > > > mlw wrote:
> > > > > Like I told Marc, I don't care. You spec o
libpq, etc. Hence, most people will not be required to purchase
this license from Red Hat.
Jason
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
no longer uses the Perl extension infrastructure. However,
upgrading Cygwin Perl to 5.8.0 solves the problem because this version
uses the conventional name for libperl.a instead of one that has the
version embedded in it.
Thanks again for the heads up.
Jason
---(end of broadc
see any recent CVS commits to indicate this.
Jason
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Peter,
On Thu, Sep 05, 2002 at 02:51:31PM -0400, Bruce Momjian wrote:
> Jason Tishler wrote:
> > On Thu, Sep 05, 2002 at 08:33:20PM +0200, Peter Eisentraut wrote:
> > > Should all be fixed now.
> >
> > Huh? I don't see any recent CVS commits to indicate this.
Peter,
On Fri, Sep 06, 2002 at 12:54:13PM +0100, Dave Page wrote:
> Seems to build cleanly here now.
And here (and now) too.
> Perhaps anoncvs just hadn't sync'd up when you tried Jason?
I guess so -- very strange...
Anyway, sorry (again) for the noise and thanks for fixing
don't know.
> Will it be based on cygwin dll's?
No.
> Will the reliability and performance be comparable to the unix-version?
I don't know.
> Will it be free for commercial use?
I presume so.
Maybe others on the CC'd lists can answer your questions better
he problem with
> the listen() backlog queue in the parallel test perhaps?
I haven't looked into the above yet due to the build problems. Any help
regarding these issues is gratefully appreciated.
Thanks,
Jason
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Dave,
On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net]
> > Sent: 28 October 2002 13:33
> > Subject: Re: [HACKERS] Request for supported platforms
> >
> > Please try
Dave,
On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote:
> On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote:
> > Ok, but this is going to take a while as few of the mirrors seem to
> > have this release yet. I also need to download a new set of everything
&g
Dave,
On Mon, Oct 28, 2002 at 08:58:12PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net]
> > Sent: 28 October 2002 20:42
> > Subject: Re: [HACKERS] Request for supported platforms
> >
> > On Mon, Oct
ing
> from CVS, since the bison stuff is preprocessed for released tarballs.
> So you might want to try the just release beta3.
Thanks for the above, but see my recent, related posts (if interested).
Jason
---(end of broadcast)---
TIP 2: you can
the
> binary distribution that Jason builds, I would think this is OK to be
> listed as supported if no-one disagrees...
Umm... Should I disagree? :,)
Jason
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org
Dave,
On Tue, Oct 29, 2002 at 09:00:20PM -, Dave Page wrote:
> > -Original Message-
> > From: Jason Tishler [mailto:jason@;tishler.net]
> > Sent: 29 October 2002 18:58
> >
> > > Hackers: As the Cygwin release that is actively supported is the
>
ately, the cygipc maintainer is "AWOL" right now
because of Ph.D. thesis commitments. Hence, even if I can get the
Cygwin community to agree to this change, there may not be an official
cygipc release for a while.
Thanks,
Jason
--
GPG key available on key servers or http://www.tishler.net/jason/gpg.txt
msg24667/pgp0.pgp
Description: PGP signature
Peter,
On Wed, Oct 30, 2002 at 07:36:40PM +0100, Peter Eisentraut wrote:
> Dave Page writes:
> > Hackers: As the Cygwin release that is actively supported is the
> > binary distribution that Jason builds, I would think this is OK to
> > be listed as supported if no-on
This post is just for closure -- both of the issues below have been
resolved:
On Tue, Oct 29, 2002 at 09:47:35AM -0500, Jason Tishler wrote:
> > > 1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e.,
> > > 1.50+) to process src/interfaces/ecpg/preproc/preproc.y
>
Tom,
Peter,
On Mon, Nov 04, 2002 at 03:05:25PM -0500, Jason Tishler wrote:
> On Mon, Nov 04, 2002 at 02:43:01PM -0500, Tom Lane wrote:
> > If you can detect that cygipc is not running, then ENOSYS seems the
> > best choice for reporting that. (ENOSPC would be misleading too.)
ate
> error). Only when I downgraded to version 1.09 (office) and upgraded
> to 1.13 (home) did initdb succeed. So I'd suggest also covering this
> scenario.
If you feel strongly about the above, then submit a patch to
pgsql-patches@ for consideration.
Jason
--
PGP/GPG Key: http:/
n't mind being
put out of the Cygwin PostgreSQL support business... :,)
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
---(end of broadcast)---
press releases,
then that's fine and dandy. But if all you want to do is throw rocks
at the people doing the marketing, then that's another story
altogether.
Jason Earl
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
>Nutshell:
> "Easy to install but is horribly slow."
>
> or
>
> "Took a couple of minutes to configure and it rocks!"
Since when is it easy to install on win32?
The easiest way I know of is through Cygwin, then you have to worry about
installing the IPC service (an gettin
ow Im a supposed to escape my string and get it through
the parser correctly so i can retrieve it correctly?
Thanks for your time.
PS: Using RedHat.
Jason H. Ory
Medprint+
Software Developer
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
x27;t know what
to escape and not to escape. So it keeps failing. I cand find any docs. on
what to escape either?
SUMMARY
What datatype do I use? How Im a supposed to escape it and get it though the
parser correctly so i can
retrieve it correctly?
Thnks for your time.
PS: Using RedHat.
Jas
of hack.
What should I do? Please help. Thanks!
--
Jason Orendorff
P.S. I would love to help improve PostgreSQL's documentation.
Whom should I contact?
---(end of broadcast)---
TIP 2: you can get off all lists at once with
Pardon my ignorance, but there's no way to auto-tune? Ship it with a thread
that gathers statistics and periodically re-tunes the database parameters.
Of course, be able to turn it off. People that actually take the time to run
tune manually will turn it off as to not have the overhead or interrupt
re I can think of off hand).
As for the rest of the discussion, poking fun at development languages
and tools is an age-old part of computers. PHP has the disadvantage
of being both very popular, very new, and primarily a web technology
(and of not being Lisp like :) so it draws more than its shar
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> On 14 Mar 2003, Jason Earl wrote:
>
> > It's all good Scott. Anyone wanting to use PostgreSQL arrays
> > would undoubtedly open up the corresponding part of the manual
> > that covers array functions.
don't have to read the manual to see that these variables are not
to be trifled with.
There are some cases where this particular feature would be useful.
What needs to be done is to make the feature less dangerous to the
newbie without making it less useful to the person who actually needs
this problem since it runs all tests sequentially instead of in
large concurrent groups.
I no longer use make check even though make installcheck is much less
convenient.
> Also included for ease of testing is a patch sepratly sent to patches
> for ecpg.
Thanks for the patch!
Jason
--
he dev cycle shortened by a month, then extended ...
Why couldn't you just release the win32 version of 7.4 when it was
finished. If it takes an extra month then that just gives you guys
the chance to circulate *two* press releases. The Native Win32 port
is likely to make a big enough spl
s release of
7.4.2 should allow the PostgreSQL hackers to simply chase down Windows
specific problems.
Adding a new platform--especially a platform as diverse from the rest
of PostgreSQL's supported platforms as Windows--is what adds the work.
Testing the new platform is relatively easy. All you n
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> -Original Message-
>> From: Jason Earl [mailto:[EMAIL PROTECTED]
>> Sent: Friday, June 20, 2003 3:32 PM
>> To: Dann Corbit
>> Cc: Jason Earl; The Hermit Hacker; PostgreSQL-development
>>
oblems. However, Cygwin still needs the following patch:
http://archives.postgresql.org/pgsql-patches/2003-06/msg00186.php
Thanks,
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
--
sn't need it anyway. Testing for the size of sa_family_t is
> possible via configure, but if only cygwin needs it, we can just
> hard-code that platform in the template files. Cygwin folks, would
> you test CVS and let me know.
The above seems to be OK for Cygwin too.
Ja
Bruce,
On Tue, Jun 24, 2003 at 03:04:05PM -0400, Bruce Momjian wrote:
> Kurt Roeckx wrote:
> > All that probably needed to change for cygwin was to no longer
> > use sa_family_t in the getaddrinfo.c.
>
> But Jason reported he needed that typedef for sa_family_t. Jason, is
on about this ( under linux or cygwin :) ) ??
>
> I have found this on PostgreSQL docs :) i have it configured yet.
Is this just the "--with-openssl" option? Does it build cleanly under
Cygwin? If so, would you like me to include this in the next Cygwin
PostgreSQL release?
Jason
Thomas,
[I would have responded sooner, but I have been on vacation.]
On Thu, Aug 21, 2003 at 11:10:05AM -0500, Thomas Swan wrote:
> On 8/8/2003 5:49 AM, Jason Tishler wrote:
> >Is this just the "--with-openssl" option? Does it build cleanly
> >under Cygwin? If so, wou
Thomas,
On Sun, Aug 24, 2003 at 04:55:42PM -0400, Jason Tishler wrote:
> On Thu, Aug 21, 2003 at 11:10:05AM -0500, Thomas Swan wrote:
> > On 8/8/2003 5:49 AM, Jason Tishler wrote:
> > >Is this just the "--with-openssl" option? Does it build cleanly
> > >under
. Cygwin provides all the necessary tools (e.g., bison and flex).
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
---(end of broadcast)---
TIP 8: explai
examples that I found don't match with I'm trying to do.
Please help!
thanks,
jason.
---(end of broadcast)---
TIP 8: explain analyze is your friend
... but it's surely a waste of cycles to do it deliberately
> during postmaster startup.
AFAICT, this should be fixed in Cygwin CVS:
http://cygwin.com/ml/cygwin/2005-08/msg00249.html
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405
cklog is 200 under server versions of Windows (e.g., 2000 Advanced
Server) and 5 on all other versions (e.g., XP Pro).
Can you try make installcheck instead?
Thanks,
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2
Andrew,
On Fri, Oct 10, 2003 at 08:56:51AM -0400, Andrew Dunstan wrote:
> Jason Tishler wrote:
> >Are you getting hangs or connection refused errors. The Cygwin
> >PostgreSQL README documents the following issue:
> >[snip]
>
> hangs - I have to kill the psql proce
ckers/2002-10/msg00767.php). Is the
functionality still required (I know it's not in cvs yet) failing that are
there any other similar sized tasks requiring attention?
Rgds,
Jason
---(end of broadcast)---
TIP 9: the planner will ignore your
need to issue an error if an invalid octal or hex
character is found following a \ or \x. No errors are currently flagged by the octal
(or this hex) import.
Rgds,
Jason
cvs server: Diffing .
Index: copy.c
===
RCS file: /projects
hats the case then
octal needs attention as well because it makes a similar assumption. Peter
Eisentraut commented that this should be in the string literal parser.
Should this be the case? and if so should i migrate both octal and hex to
this parser?
Rgds,
Jason
---(end o
nges proposed here to the macro
and repost the patch to pgsql-patches (and do some reading on Unicode!). I
guess at this stage I would like to offer any of my time to any janitorial
work that might be needed as until im more knowledgeable about the pg source
I think any large scale stuff is off the cards.
Rgds,
Jason
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
one of the core Cygwin developers might be more willing to attempt to
fix it.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
---(end of broadcast)---
TIP 5
ening again.
I will keep a copy of the data directory if anyone wants me to do any
analysis on it (I will need instructions).
Any insights would be appreciated.
Thanks
Jason Essington
[EMAIL PROTECTED]
hedgehog=# \d tfxtrade_details
Table "public.tfxtrade_details&q
Both vacuum [full] and reindex fail with that same error.
vacuum is run regularly via a cron job.
-jason
On Feb 14, 2004, at 2:29 PM, Joshua D. Drake wrote:
Hello,
When was the last time you ran a reindex? Or a vacuum / vacuum full?
Sincerely,
Joshua D. Drake
On Sat, 14 Feb 2004, Jason
ed this from cp:
cp: data/base/16976/17840: Result too large
might be a clue
-jason
On Feb 14, 2004, at 5:01 PM, Joshua D. Drake wrote:
Hello,
There are a couple of things it could be. I would suggest that you take
down the database, start it up with -P? (I think it is -o '-P' it
andardized */
if (errno)
psql_error("could not save history to file \"%s\": %s\n", fname,
strerror(errno));
else
return true;
and it seems to have cured the problem for me. Is this even
reasonable? I'm not a C p
I don't think that we (cygwin) don't need
> that anymore. With newer binutils it should get autogenerated. But
> I'll have to test before you can remove that dir.
I concur with Reini. The DLLINIT stuff is a vestige from b20.1. FWIW,
I attempted to remove it 3 - 4 years ago, but was
doc/postgresql-7.4.5/contrib/autoinc.example
...
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
---(end of broadcast)---
TIP 5: Have you checked
Actually with version 3.0 of PyGreSQL there is a
DB-API v2.0 compliant wrapper pgdb.py.
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Bruce Momjian writes:
>
> > I need to know how this is different than our
> current python interface,
> > PyGreSQL.
>
> > > PgSQL is a package of two (2) mod
to address this?
—Jason
ransaction number or some similar sequence? It would
accurately track “age” in the sense we care about: how long ago in “units of
real work being done by the DB” something was added.
—Jason
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> I am working with David Wheeler on DBD:pg and hope to have a release
> packaged up tomorrow.
Bruce, David,
I'm updating all the test scripts to properly use the standard DBI
testing env vars, e.g. DBI_DSN, DBI_USER, DBI_PASS, and to use
Test::More.
"Jason E. Stewart" <[EMAIL PROTECTED]> writes:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > I am working with David Wheeler on DBD:pg and hope to have a release
> > packaged up tomorrow.
>
> Bruce, David,
>
> I'm updat
Hello...
I haven't been subscribed in a while, but I've got an issue and am trying to
determine if the Right Way(tm) is the quickest way to fix it.
Basically, I have some very expensive stored procedures that determine whether
a user should have access to particular rows in a query (not a postgre
On Mon, Mar 10, 2003 at 09:49:47AM -0500, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Joe Conway kirjutas E, 10.03.2003 kell 05:35:
> >> CREATE OR REPLACE FUNCTION array_push (anyarray, anyscalar)
> >> RETURNS anyarray
>
> > could you make it
> > RETURNS typeof($1)
>
> Not dir
end much time on it but bounce things off me and I'll
do whatever hacking I can squeeze in. What soap implementation would you
use for the PostgreSQL plugin? libsoap, last I checked, is a wee bit
out of date. And not documented.
-Jason
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ol which postmaster can listen to it would rule.
I'm making a habit of putting all the business logic into stored procedures,
and this would basically publish the business logic in a very useful way.
-Jason
---(end of broadcast)---
TIP 5: Have
)
If noone has scripts, can anyone suggest how to implement.
-Jason
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, Apr 03, 2003 at 07:54:13AM -0500, [EMAIL PROTECTED] wrote:
> > I have been planning to "test" the whole thing with a few .NET
> > applications. I am currently using expat to parse the output to ensure
> > that it all works correcty.
>
> That, unfortunately, probably implies that your imp
85 matches
Mail list logo
