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
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
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
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
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
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
to address this?
—Jason
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
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
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
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
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
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
... 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
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
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
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
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
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
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
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
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
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
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
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
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
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
. 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
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
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
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
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
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
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
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
--
"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
>>
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
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
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
--
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
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
)
If noone has scripts, can anyone suggest how to implement.
-Jason
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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]
"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.
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
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
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
>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
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
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
"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
"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.
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)---
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:/
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.)
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
>
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
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
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
>
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
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
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
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 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
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
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
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
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.
see any recent CVS commits to indicate this.
Jason
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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
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
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
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]
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])
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
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
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
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
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
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
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
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
85 matches
Mail list logo