Yup- it's attached.
Mike
From: Brar Piening [mailto:b...@gmx.de]
Sent: Tuesday, June 07, 2011 6:58 PM
To: Mike Pultz
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] smallserial / serial2
On Wed, 20 Apr 2011 21:27:27 -0400, Mike Pultz <mailto:m...@mikepultz.com
s.postgresql.org/pgsql-hackers/2011-02/msg01878.php).
However if Tom does mean that xpath is the culprit, it may be with the
way the libxml2 library works. It's a very messy singleton. If I'm
wrong, I'm sure I'll be corrected!
Regards,
--
Mike Fowler
Registered Linux use
reasonable and necessary AFAICT
I can confirm that I added the three keywords as described in the
SQL/XML standard (section 8.4). Apologies for the delayed confirmation,
I missed the thread when it was started and only noticed when your
commit message arrived.
Regards,
--
Mike Fowler
Regist
at http://www.postgresql.org/docs/9.0/static/xml2.html.
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ARRAY['field 1', 'field 2', 'field 3'],
regexp_matches(fixed_field,'(.{4})(.{10})(.{5})')
)
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Manage
code.
If no one has any objections, I'll mark it ready for committer.
Mike
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3
ame manual.
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
mike.blackw...@rrd.com
http://www.rrdonnelley.c
This would default to being available to superusers only, right? Details
of the file system shouldn't be available to any random user.
______
*Mike Blackwell | Technical Analyst, Distribution Services/Ro
On Fri, Feb 13, 2015 at 3:13 PM, Jim Nasby wrote:
>
> If we exclude the issue of needing one or two oddball partitions for +/-
> infinity, I expect that fixed sized partitions would actually cover 80-90%
> of cases.
That would not be true in our case. The data is not at all evenly
distributed
he bug fixed in that commit for ages by
spelling my xpath like this:
xpath('/*[local-name()="Bar"]/*[local-name()="Baz"]/text()', data)
I've modularized my XML handling functions so the source of 'data' is
immaterial -- maybe it's a full document, maybe it's a fragment from a
previous xpath() call -- and the referenced commit is going to make correct
XPATH much more sane, readable, and maintainable. I, for one, welcome it
wholeheartedly.
HTH,
--Mike
can on public.sortordertest
Output: n1, n2, n1
(6 rows)
DROP TABLE sortordertest;
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles,
On Tue, Dec 16, 2014 at 10:15 AM, Mark Cave-Ayland <
mark.cave-ayl...@ilande.co.uk> wrote:
>
> Well as I mentioned in my last email, practically all developers will
> rebase and run "make check" on their patched tree before submitting to
> the list.
Even when this is true, and with people new t
Looking forward to the new patch. I'll give it a more complete testing
when you post it.
Mike
______
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave
against the
style of surrounding code.
Multi-line comments should follow the existing format.
There are no tests for the "... is LC_COLLATE" and "COLLATE..." cases.
Section 14.1 of the documentation may need t
utput format looks like it should be acceptable to Heikki.
I'll mark this as ready for committer.
Thanks for the patch!
Mike
Tom,
Thanks for the comments on what you ended up changing. It helps point out
the kind of things I should be looking for. I'll try to let less slip
through in the future.
Mike
______
*Mike Blackwell | Tech
patch is the same as before, but the function is now named
XMLEXISTS instead of xpath_exists.
Regards,
--
Mike Fowler
Registered Linux user: 379787
Index: src/backend/utils/adt/xml.c
===
RCS file: /home/mfowler/cvsrepo/pgrepo/pgsq
olean was added (unbelievably) in the very
next version from yours, 2.6.27 (see:
http://mail.gnome.org/archives/xml/2006-October/msg00119.html).
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
Robert Haas wrote:
On Tue, May 25, 2010 at 12:04 PM, Mike Fowler wrote:
Erik Rijkers wrote:
libxml2.x86_64 2.6.26-2.1.2.8 installed
libxml2-devel.x86_642.6.26-2.1.2.8 installed
Thanks for testing my patch Erik. It turns out I've got libxml2 installed at
ve
Tom Lane wrote:
Robert Haas writes:
On Tue, May 25, 2010 at 1:09 PM, Mike Fowler wrote:
We're unlikely to accept this patch if it changes the minimum version
of libxml2 required to compile PostgreSQL
Why? 2.6.27 is almost 4 years old.
At a minimum, I think it's f
Peter Eisentraut wrote:
On tis, 2010-05-25 at 15:31 +0100, Mike Fowler wrote:
I've been reading the SQL/XML standard and discovered that it defines a
function named XMLEXISTS that does exactly what the todo item
xpath_exists defines. My original patch named the function as per the
tod
Peter Eisentraut wrote:
On ons, 2010-05-26 at 11:47 +0100, Mike Fowler wrote:
The XMLEXISTS function works with XQuery expressions and doesn't have
the call signature that your patch implements
Looking at the manuals of Oracle, Derby and DB2 I see how the call
signature diffe
mitting a
patch, or is someone else eager?
Thanks for your consideration.
-Mike
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ep I'm failing to figure out is where the actual c function that
implements the function gets called/associated within the grammar. What
am I missing?
Thanks in advance,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@pos
ed a comment. Not quite sure if it's the appropriate format, but
I didn't feel it warranted 3 lines.
Thanks,
Mike Lewis
detoast-headers-for-array-functions-003.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your sub
lly I'm unsure as to what next. Anyone know what the missing step is?
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ion and it's target function textpos
as examples but I fail to see any other file that they live in other
than their implementation. As far as I can tell, I'm not doing anything
different from position. Any thoughts?
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-ha
ression PASSING BY REF xml_value [BY REF] )
Though the full grammar makes everything after the xpath_expression
optional, I've left it has mandatory simply to avoid lots of rework of
the function (would need new null checks, memory handling would need
reworking).
--
Mike Fowler
Registered
ts to the code so that we remember why we didn't use the
latest function.
Regards,
--
Mike Fowler
Registered Linux user: 379787
*** a/src/backend/utils/adt/xml.c
--- b/src/backend/utils/adt/xml.c
***
*** 3495,3497 xpath(PG_FUNCTION_ARGS)
--- 3495,3681
return 0
Robert Haas wrote:
On Sun, Jun 27, 2010 at 12:04 PM, Mike Fowler wrote:
Thanks again for your help Robert, turns out the fault was in the pg_proc
entry (the 3 up there should've been a two!). Once I took the grammar out it
was quickly obvious where I'd gone wrong.
Gla
line 1: parser error : Extra content at the end of the document
^
Is there some way to use the new, core XML functionality to simply return a
truth value
in the way that we need?.
Thanks,
-- Mike Berrow
On Mon, Jun 28, 2010 at 11:08 AM, Mike Berrow wrote:
> We need to make extensive use of the 'xml_is_well_formed' function provided
> by the XML2 module.
> Yet the documentation says that the xml2 module will be deprecated since
> "XML syntax checking and XPath queri
Robert Haas wrote:
On Mon, Jun 28, 2010 at 11:42 AM, Mike Rylander wrote:
You could do something like this (untested):
CREATE OR REPLACE FUNCTION my_xml_is_valid ( x TEXT ) RETURNS BOOL AS $$
BEGIN
PERFORM XMLPARSE( DOCUMENT x::XML );
RETURN TRUE;
EXCEPTION WHEN OTHERS THEN
RETURN FALSE
line 1: parser error : Extra content at the end of the document
^
Is there some way to use the new, core XML functionality to simply return a
truth value
in the way that we need?.
Thanks,
-- Mike Berrow
'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION xml_is_ok(text) OWNER TO postgres;
It worked fine. Thanks Mike and David.
The only other issue is that when I benchmarked it on a 5,000 record data
set that I have,
the original XML2 function ('xml_is_well_formed') took about
Mike Fowler wrote:
Bruce Momjian wrote:
I have added this to the next commit-fest:
https://commitfest.postgresql.org/action/commitfest_view?id=6
Thanks Bruce. Attached is a revised patch which changes the code
slightly such that it uses an older version of the libxml library.
I&#x
Mike Fowler wrote:
Thanks again for your help Robert, turns out the fault was in the
pg_proc entry (the 3 up there should've been a two!). Once I took the
grammar out it was quickly obvious where I'd gone wrong.
Attached is a patch with the revised XMLEXISTS function, complete wit
Quoting Mike Fowler :
Should the IS DOCUMENT predicate support this? At the moment you get
the following:
template1=# SELECT
'Bidford-on-AvonCwmbranBristol'
IS
DOCUMENT;
?column?
--
t
(1 row)
template1=# SELECT
'Bidford-on-AvonCwmbranBristolIS
DOCUMENT;
ERRO
ou could say:
val IS NOT DOCUMENT AND val IS NOT CONTENT
I think having the direct predicate support would be useful for
columns of text where you know that some, though possibly not all,
text values are valid XML.
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers m
Quoting Peter Eisentraut :
On fre, 2010-07-02 at 14:07 +0100, Mike Fowler wrote:
So if IS CONTENT were
to be implemented, to determine that you have something that is
malformed
But that's not what IS CONTENT does. "Content" still needs to be
well-formed.
What I was hoping
Peter Eisentraut wrote:
On lör, 2010-07-03 at 09:26 +0100, Mike Fowler wrote:
What I will do
instead is implement the xml_is_well_formed function and get a patch
out in the next day or two.
That sounds very useful.
Here's the patch to add the 'xml_is_well_formed
Robert Haas wrote:
On Fri, Jul 9, 2010 at 4:06 PM, Peter Eisentraut wrote:
On ons, 2010-07-07 at 16:37 +0100, Mike Fowler wrote:
Here's the patch to add the 'xml_is_well_formed' function.
I suppose we should remove the function from contrib/xml2 at the same
t
; in the patch file in some way or this just an artifact
of HTML parsing a patch?
Regards,
--
Mike Fowler
Registered Linux user: 379787
*** a/contrib/xml2/xpath.c
--- b/contrib/xml2/xpath.c
***
*** 27,33 PG_MODULE_MAGIC;
/* externally accessible functions */
- Datum xml_is
;ll look to get a patch addressing these concerns out in the next
day or two, work/family/sleep permitting! :)
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 21/07/10 08:33, Mike Fowler wrote:
Why is the first argument AexprConst instead of a_expr? The SQL
standard says it's a character string literal, but I think we can very
well allow arbitrary expressions.
Yes, it was AexprConst because of the specification. I also found that
using it s
s or (b) it decompressed less than that
> many bytes and you can call it again with another chunk of data if you
> want to keep going. That'd probably be a good thing to have, but I
> don't think it needs to be a prerequisite for this patch.
>
Hopefully this is the case. I can try tackling the first part, however.
Thanks,
Mike
--
Michael Lewis
lolrus.org
mikelikes...@gmail.com
ing false here and not causing an
exception. I have corrected this in the attached patch.
Regards,
--
Mike Fowler
Registered Linux user: 379787
*** a/contrib/xml2/xpath.c
--- b/contrib/xml2/xpath.c
***
*** 27,33 PG_MODULE_MAGIC;
/* externally accessible functions */
- Datum
be even, see
parse_params() */
! #define EXTEND_PARAMS 20 /* must be even, see
parse_params() */
#endif /* USE_LIBXSLT */
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subsc
On 02/08/10 07:46, Pavel Stehule wrote:
I have not any suggestions now - so I'll change flag to "ready to commit"
sorry - contrib module should be a fixed
patch attached
Thanks Pavel, you saved me some time!
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
ot of
different cases for the detoast stuff, and I think I would need a full
understanding of toast functionality. (for example, I didn't even know
there was lzma compression in postgres until one of the replies to this
thread)
Thanks,
Mike
--
Michael Lewis
lolrus.org
mikelikes...@gmail.com
On
Hi Pavel,
On 02/08/10 09:21, Pavel Stehule wrote:
Hello
2010/8/2 Mike Fowler:
Hi Pavel,
Currently your patch isn't applying to head, from the looks of things a
function signature has changed. Can you update your patch please?
yes - see attachment
Thanks, the new patch applies cl
n the
xmlexists patch?
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
_is_well_formed('foo');
xml_is_well_formed
t
(1 row)
with the inverse for DOCUMENTS? To me this makes the most sense as it makes the
function behave much more like the other xml functions.
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hacke
boolean
function, I'll rework the patch over the weekend.
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 06/08/10 15:08, Andrew Dunstan wrote:
On 08/06/2010 02:29 AM, Pavel Stehule wrote:
2010/8/6 David Fetter:
On Fri, Aug 06, 2010 at 05:57:37AM +0200, Pavel Stehule wrote:
2010/8/6 Andrew Dunstan:
On 08/05/2010 06:56 PM, Mike Fowler wrote:
SELECT
xslt_process('cim30400'::text,
On 06/08/10 20:55, Peter Eisentraut wrote:
On fre, 2010-08-06 at 09:04 +0100, Mike Fowler wrote:
If the patch is to be committed, does it make sense for me to refine
it such that it uses the new xpath internal function you extracted in
the xmlexists patch?
Yes, you can probably shrink this
On 06/08/10 21:55, Peter Eisentraut wrote:
On fre, 2010-08-06 at 14:43 +0100, Mike Fowler wrote:
Or perhaps it could return a string instead of a boolean: content,
document, or NULL if it's neither.
I like the sound of that. In fact this helps workaround the IS
DOCUMENT
and IS CO
the whole of xml2 can be dropped. I also think that the errors should be
reported, even if libxslt doesn't behave properly in all scenarios.
Of course there's that whole other issue around how you pass the
parameters in the first place that needs resolving too...
Regards,
--
Mike Fow
On 09/08/10 04:07, Tom Lane wrote:
Robert Haas writes:
On Sun, Aug 8, 2010 at 11:36 AM, Mike Fowler wrote:
1) XML2 is largely undocumented, giving rise to the problems encountered.
Since the module is deprecated anyways, does it make more sense to get xslt
handling moved into core and get it
it doesn't seem like
a helpful choice.
As a project management note, this CommitFest is over in 4 days, so
unless we have a new version of this patch real soon now we need to
defer it to the September 15th CommitFest
Yes. Mike, are you expecting to submit a new version before the end of
t
ting functions. Full instructions
can be found at http://wiki.postgresql.org/wiki/Regression_test_authoring
Regards,
--
Mike Fowler
Registered Linux user: 379787
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresq
I like Darren's proposal. It is elegant.
> Date: Fri, 8 Jul 2011 18:38:59 +1200
> From: gavinflo...@archidevsys.co.nz
> To: dar...@darrenduncan.net
> CC: pg...@j-davis.com; guilla...@lelarge.info; mbee...@hotmail.com;
> pgsql-gene...@postgresql.org; pgsql-hackers@postgresql.org
> Subject: Re:
gnorance on how the DDL for functions in pg_catalog
are defined. I can only assume they are generated from their internal
C functions, as I can't find a pg_catalog.sql file in the source.
Thanks for your thoughts,
-Mike
[1] http://www.postgresql.org/docs/current/static/functions-admin.htm
A Google search suggests Oracle 9.x supports a unary '?' operator (fuzzy
match), so the use of '?' in an operator name is not without precedent.
__
*Mike Blackwell | Technical Analyst, Distribut
ward Compatibility Syntax".
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
mike.blackw...@rrd.com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* *
On Tue, May
Ah. I see. Thanks for the clarification.
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Does pg_config show the correct location? If so, perhaps pg_upgrade could
get the .conf location the same way rather than requiring a command line
option.
__
*Mike Blackwell | Technical Analyst, Distribution Services
On Fri, Jul 10, 2015 at 2:10 PM, Alvaro Herrera
wrote:
> Joshua D. Drake wrote:
> >
> > On 07/10/2015 11:01 AM, Mike Blackwell wrote:
> > >Does pg_config show the correct location?
> > Good idea but:
> >
> > postgres@ly19:~$ pg_config
> > Y
added the process name so as to minimize
impact on anything that might be trying to parse that line?
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St
On Sun, Jul 17, 2016 at 10:34 AM, Tom Lane wrote:
> It occurs to me that we could also remove the update_process_title GUC:
> what you would do is configure a process_title pattern that doesn't
> include the %-escape for current command tag, and the infrastructure
> could notice that that escape
hough it being part
of core as XPath is would be even better.
Just my $0.02... even if I'm a bit late to the conversation.
Thanks!
Mike
On 3/6/07, Mike Rylander <[EMAIL PROTECTED]> wrote:
On 3/6/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Mike Rylander wrote:
> > The patch adds support for default XML namespaces in xml2 by providing
> > a mechanism for supplying a prefix to a named namespace U
x27;ve seen on -hackers, nothing surrounding explicit
support for said issue jumped out at me.
Thanks again.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 7: You
On 6/1/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Mike Rylander wrote:
> I understand that XML support is planned and at least partially
> implemented for 8.3, but many production instances will be unable
> (or, in fact, unwilling) to upgrade to 8.3 for quite some time.
>
avoided.
Thanks for listening (and for all the great work on getting tsearch
into core! :) ...
--
Mike Rylander
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
On 6/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Mike Rylander" <[EMAIL PROTECTED]> writes:
> I can certainly understand the benefit of making the default
> configuration a simple locale to language map, but there are
> definitely uses for searching using dif
On 8/13/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Heikki Linnakangas wrote:
> > Bruce Momjian wrote:
> > > Heikki Linnakangas wrote:
> > >> Removing the default configuration setting altogether removes the 2nd
> > >> problem, but that's not good from a usability point of view. And it
> > >> do
On 8/14/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> Mike Rylander wrote:
[snip]
>
> Don't you need to use the right configuration to parse the query into a
> tsquery as well?
>
Only if the user (or user agent) can supply enough information to move
away from the
On 8/14/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Bruce Momjian wrote:
>
> > Basically, the default GUC doesn't work because of:
> >
> > error prone
> > if super-user only, non-super-user doesn't work on restore
> > if non-super-user, can cause mismatch (perhaps this is the
On 8/14/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Oleg Bartunov wrote:
> > On Tue, 14 Aug 2007, Alvaro Herrera wrote:
> >
> >> Oleg Bartunov wrote:
> >>> On Thu, 9 Aug 2007, [EMAIL PROTECTED] wrote:
> >>>
> Maybe I'm missing something, but it seems to me that the configuration
> is
On 8/14/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Mike Rylander" <[EMAIL PROTECTED]> writes:
>
> > My application (http://open-ils.org, which run >80% of the public
> > libraries in Georgia, USA, http://gapines.org and
> > http://georgialibr
On 8/15/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> I have added another idea for index-only scans to the TODO list:
>
> > A third idea would be for a heap scan to check if all rows are visible
> > and if so set a per-table flag which can be checked by index scans.
> > Any change to the ta
On 8/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Fri, Aug 17, 2007 at 04:06:15PM -0700, Josh Berkus wrote:
> > Bruce,
> >
> > > Oh, so you want the config inside each tsvector value. Interesting
> > > idea.
> >
> > Yeah, hasn't anyone
On Dec 22, 2007 1:04 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Wouldn't SSL work over Unix-domain sockets as well? The API only deals with
> > file descriptors.
>
> Hmm ... we've always thought of SSL as being primarily comm security
> and thus usel
t TEXT columns, as the
xml2 versions do. I hope these (attached) will be of some help to
others. Note, these are not the exact functions I use, they are
lightly edited to remove the use of wrappers I've created to paper
over the transition from xpath_nodeset() to core XPATH().
--
Mike Rylan
> (Mike, it lacks a copyright notice, I take it BSD is okay).
Thats fine with me..
Also - for completeness (for the list) - I think the plan is to convert the
awk to perl (via a2p + some tweaking) if awk is not already used as part of
the build process (to avoid adding another prerequis
already and we're trying to help automate the process..
(ducks for cover)
> As against that ... does a2p produce code that is readable/maintainable?
> If the code wasn't perl to start with I'd be a little worried about
> ending up with ugly hard-to-read code.
--
Mike Au
o the existing
ecpglib/connect.c file :
PGconn* ECPGget_PGconn(const char *connection_name) {
struct connection * con;
con=ecpg_get_connection(connection_name);
if (con==NULL) return NULL;
return con->connection;
}
TIA
--
Mike Aubur
Email: [EMAIL PROTECTED]
> ---
>--- Make your life a dream, make your dream a reality. (St Exupery)
--
Mike Aubury
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clay
tional fetch to get back to our last row..
For reference - heres what I get as output :
CREATE TABLE
INSERT 32429 1
INSERT 32430 1
INSERT 32431 1
BEGIN
DECLARE CURSOR
a
---
1
(1 row)
a
---
2
(1 row)
a
---
3
(1 row)
a
---
(0 rows)
a
---
3
(1 row)
a
---
2
(1 row)
a
---
1
;
> The version mismatch warning would remain, of course.
>
> I'd also like to get rid of the SSL notice but I'm not sure what to replace
> it by. Something in the prompt perhaps?
>
> Btw., any user could put the welcome message in his own psqlrc file via
> \echo comm
it was a text
it was a text
This to me looks 'wrong', especially when previous versions of ecpg (<8.0?)
gave the correct :
it was a date
it was a int
it was a text
Any thoughts ?
(This is manifesting itself as arithmetic errors when I'm using dates in my
applicat
files are not
particularly compressable to be sure, but due to (and given) the
nature of the data bzip2 works pretty well, and much better than gzip.
>
> So you may have some kB changes in the wal logfile every minute but you
> still copy 16 MB data. Sure, it's not so much - but if you rot
dot De, Michael at Meskes dot (De|Com|Net|Org)
> ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED]
> Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!
--
Mike Aubury
http://www.aubit.com/
Aubit Computing Ltd is registered in England and Wales, Number: 3112
It might depend on the tokens..
Are ">=", "++" etc single tokens ?
On Wednesday 04 June 2008 17:06:44 Tom Lane wrote:
> Mike Aubury <[EMAIL PROTECTED]> writes:
> > On Wednesday 04 June 2008 16:11:49 Michael Meskes wrote:
> >> There is some small m
noticed that I didn't answer this email. ]
>
> On Wed, Jun 04, 2008 at 05:06:41PM +0100, Mike Aubury wrote:
> > It might depend on the tokens..
> > Are ">=", "++" etc single tokens ?
> > ...
> >
> > > Wouldn't it work to just a
heres also another thing that needs to be decided, which is if the generated
ecpg grammer should be developer generated (ie. Michael Meskes runs a script
and commits the output), or should be generated for each and every source
based installation. I personally would stongly favour the script being
eloper changes the original gram.y?
> Is he expected to run the script before committing too? That sounds
> brittle to me.
>
--
Mike Aubury
http://www.aubit.com/
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clayton House,59 Piccadilly,Manch
umption.
>
> Now, if we had a DSL line we could hook it to, I could see using it for the
> buildfarm; it would be interesting old HW / old Solaris for us.
>
Would you like an IPC instead? Though building PG on it might take
longer than the average release cycle. ;)
--
Mike Rylander
| VP,
.
3. It appears the the default for -n namespace uses the default_path
variable (typically "public"). However, I'm only guessing this
based on the behaviour, and it isn't mentioned in the
documentation for -n namespace.
Thanks for any input, and apologies if
101 - 200 of 495 matches
Mail list logo
