The video archive for the 10/13 SFPUG meeting, The Mighty GUCS: A
guide to the essential PostgreSQL settings you need to know, is now
available:
http://thebuild.com/blog/2009/10/16/the-mighty-gucs/
It's also available on Vimeo:
http://vimeo.com/7109722
--
-- Christophe
It looks like I have to abandon xml2 functions in PostgreSQL 8.4. The
problem is I can't seem to find an incantation of xpath that will
perform the same thing. I have tried the following snippet:
select xpath('/trade/trade-info/id/text()', cast(xml as xml))[1] as id
from risk.trade_table
On Fri, 16 Oct 2009, Christophe Pettus wrote:
The video archive for the 10/13 SFPUG meeting, The Mighty GUCS: A guide to
the essential PostgreSQL settings you need to know, is now available:
http://thebuild.com/blog/2009/10/16/the-mighty-gucs/
It's also available on Vimeo:
On Fri, 16 Oct 2009, Christophe Pettus wrote:
The video archive for the 10/13 SFPUG meeting, The Mighty GUCS: A guide to
the essential PostgreSQL settings you need to know, is now available:
http://thebuild.com/blog/2009/10/16/the-mighty-gucs/
It's also available on Vimeo:
On Fri, Oct 16, 2009 at 6:11 PM, Kirk Wythers kwyth...@umn.edu wrote:
On Oct 16, 2009, at 4:51 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers kwyth...@umn.edu wrote:
Any ideas what the problem could be here?
Use the pg_dump from the target
On 16/10/2009 20:38, Raymond O'Donnell wrote:
Does PG = PostgreSQL? If so, it can do LDAP, Kerberos and PAM, among
other things:
Apologies for the noise - I thought I was replying to a non-PG list. :-)
Ray.
--
Raymond O'Donnell,
Josip wrote:
Hello,
Could somebody please try to help me with this problem?
So, let’s say that I have the query:
CREATE SEQUENCE c START 1;
SELECT a, nextval('c') as b
FROM table1
ORDER BY a DESC LIMIT 5;
I.e., I want to pick the 5 largest entries from table1 and show them
alongside a new
Hi,
I have a problem with snprintf function which insert the variables to string
with error.
This code I wrote for PostgreSQL 8.3.7 on Fedora 10 and it worked fine. But
now I use CentOS 5.3 and PostgreSQL 8.3.8.
Function:
Datum calculateAccount(PG_FUNCTION_ARGS) {
int64 accountId =
2009/10/17 Ilya Urikh ilya.ur...@gmail.com:
Hi,
I have a problem with snprintf function which insert the variables to string
with error.
This code I wrote for PostgreSQL 8.3.7 on Fedora 10 and it worked fine. But
now I use CentOS 5.3 and PostgreSQL 8.3.8.
Function:
Datum
Is this the right place to post this?
No, pgsql-general@postgresql.org is no place for posting questions
about PgAdmin3, or for fatuous left wing rants.
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Pavel,
Could you provide some example? I don't really understand which placeholder
I can use.
On Sun, Oct 18, 2009 at 1:20 AM, Pavel Stehule pavel.steh...@gmail.comwrote:
2009/10/17 Ilya Urikh ilya.ur...@gmail.com:
Hi,
I have a problem with snprintf function which insert the variables
2009/10/17 Ilya Urikh ilya.ur...@gmail.com:
Pavel,
Could you provide some example? I don't really understand which placeholder
I can use.
here is one fragment from orafce:
it's for delete statement, but SELECT statement is similar
ItemPointer tid;
Oid
Karl Koster klkos...@optonline.net wrote:
It looks like I have to abandon xml2 functions in PostgreSQL
8.4. The problem is I can't seem to find an incantation of
xpath that will perform the same thing. I have tried the
following snippet:
select xpath('/trade/trade-info/id/text()', cast(xml
I wrote:
[...]
You have to put brackets around the function call:
| select (xpath('/trade/trade-info/id/text()', cast(xml as xml)))[1] as id
from risk.trade_table;
... or, after a look in the dictionary, whatever you call
( and ) :-).
Tim
--
Sent via pgsql-general mailing list
Ilya Urikh ilya.ur...@gmail.com writes:
This code I wrote for PostgreSQL 8.3.7 on Fedora 10 and it worked fine. But
now I use CentOS 5.3 and PostgreSQL 8.3.8.
It looks to me like you're assuming that %ld is the appropriate format
string for an int64 value. This might be true on a 64-bit
On Oct 17, 2009, at 2:05 AM, Gerhard Wiesinger wrote:
Can you also upload the sample config files and the presentation.
Josh Berkus is on the road right now, but I'm sure he'll upload them
quite soon.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list
16 matches
Mail list logo