Tom Spencer wrote:
Is there a way to get the date/time of the last commit on a database?
Not unless you're logging them or have triggers on all the tables you
want to monitor.
What problem are you trying to solve?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list
Xavier Bugaud wrote:
Postgresql is supposed to have the correct Mauritius timezone since 8.3.5
(http://www.postgresql.org/docs/8.3/interactive/release-8-3-5.html).
From a debian box configured in the Mauritius timezone :
PostgreSQL on Debian uses the operating system's time zone database.
On Wednesday 04 March 2009 15:04:56 Peter Eisentraut wrote:
Xavier Bugaud wrote:
Postgresql is supposed to have the correct Mauritius timezone since 8.3.5
(http://www.postgresql.org/docs/8.3/interactive/release-8-3-5.html).
From a debian box configured in the Mauritius timezone :
Xavier Bugaud xavier.bug...@gloptv.com writes:
Hi,
Mauritius use daylight saving since 2008-11.
The Olson database has been updated to reflect the Mauritius timezone change
at the end of 2008 (maybe since tzdata-2008f or tzdata-2008g, not really
sure).
Postgresql is supposed to have
On Wednesday 04 March 2009 01:58:14 Michelle Konzack wrote:
Am 2009-03-03 21:38:39, schrieb Douglas J Hunley:
Hi everyone:
I really wanted to let everyone know that I've created @PGSQL_Announce on
Twitter and setup a cron job to parse the feed and post it to Twitter.
It's been working
Tom Lane wrote:
shadrack shadke...@hotmail.com writes:
My basic question is...are php4 and postgresql 8.3 compatible?
I'm running Linux Redhat 3.4.6, php4.3.9, and postgresql 8.3. I know,
some of those versions are old...its government, and I unfortunately
don't have control over the
Following lines produce an error message under 8.3. - but not under 8.1.
Why?
CREATE OR REPLACE FUNCTION dodi() RETURNS boolean AS
$$
BEGIN
SELECT 'abc' INTO TEMPORARY foonana;
RETURN FALSE;
END;
$$
LANGUAGE 'plpgsql';
FEHLER: syntax error at TEMPORARY
DETAIL: Expected record
- Andreas Moeller a.moel...@teia.de wrote:
Following lines produce an error message under 8.3. - but not under
8.1.
Why?
CREATE OR REPLACE FUNCTION dodi() RETURNS boolean AS
$$
BEGIN
SELECT 'abc' INTO TEMPORARY foonana;
RETURN FALSE;
END;
$$
LANGUAGE 'plpgsql';
FEHLER:
- Adrian Klaver akla...@comcast.net wrote:
- Andreas Moeller a.moel...@teia.de wrote:
Following lines produce an error message under 8.3. - but not under
8.1.
Why?
CREATE OR REPLACE FUNCTION dodi() RETURNS boolean AS
$$
BEGIN
SELECT 'abc' INTO TEMPORARY foonana;
Adrian Klaver akla...@comcast.net writes:
Out of curiosity I went back to 8.0 and ran the function and got:
production= SELECT dodi();
WARNING: column ?column? has type unknown
DETAIL: Proceeding with relation creation anyway.
Pre-8.2 plpgsql was willing to treat INTO as not special if the
Am 2009-03-04 09:48:30, schrieb Douglas J Hunley:
I'm sorry you've had such a bad experience. If I could do something for you,
I
would. I'm also not at all sure what led to your situation as I literally
receive /no/ emails from Twitter. It's all SMS for me.
The problem are the peoples,
On Wednesday 04 March 2009 12:19:01 Michelle Konzack wrote:
I'm sorry you've had such a bad experience. If I could do something for
you, I would. I'm also not at all sure what led to your situation as I
literally receive no emails from Twitter. It's all SMS for me.
The problem are the
On Wed, 2009-03-04 at 07:58 +0100, Michelle Konzack wrote:
Am 2009-03-03 21:38:39, schrieb Douglas J Hunley:
Hi everyone:
I really wanted to let everyone know that I've created @PGSQL_Announce on
Twitter and setup a cron job to parse the feed and post it to Twitter.
It's been working
On Tue, Mar 03, 2009 at 12:35:37AM +0900, Hiroshi Saito wrote:
Sorry very late reaction.
I desire problem solution.
So do I :-)
Ganbatte !
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list
2009/3/5 Joshua D. Drake j...@commandprompt.com:
Not sure what the complainer is talking about here. pgsql-announce is
moderated so spam should be almost nil.
Isn't she the one who keeps complaining about the reply-to-all
on the list and isn't subscribed because of the volume? ;}
--
Sent via
On Mar 4, 2009, at 9:54 AM, Joshua D. Drake wrote:
Not sure what the complainer is talking about here. pgsql-announce is
moderated so spam should be almost nil.
I'm not 100% sure what Twitter spam *is*, for that matter.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On 04/03/2009 17:54, Joshua D. Drake wrote:
Anyway, I think this is a great thing that you have done as it allows
further exposure to our great project. Good Work.
+1
I think it's a great idea.
Ray.
--
Raymond O'Donnell,
On Wed, Mar 04, 2009 at 06:19:01PM +0100, Michelle Konzack wrote:
The problem are the peoples, whish create an accound there and then
promoting the stuff per spam... The Debian Mailinglists are regulary
hit by this shit. But since my e-mails (23 in total) have found there
way inon
Hi,
SET DATESTYLE takes predefined keywords such as ISO or US as arguments,
but I can't find a way to specify a custom format string for
timestamps.
What I'd like to find is an equivalent to Oracle's
ALTER SESSION SET nls_date_format='DD/MM/ HH24' for example,
where the format follows
On Wed, Mar 4, 2009 at 11:05 AM, Adrian Klaver akla...@comcast.net wrote:
- Andreas Moeller a.moel...@teia.de wrote:
Following lines produce an error message under 8.3. - but not under
8.1.
Why?
CREATE OR REPLACE FUNCTION dodi() RETURNS boolean AS
$$
BEGIN
SELECT 'abc' INTO
Christophe wrote:
On Mar 4, 2009, at 9:54 AM, Joshua D. Drake wrote:
Not sure what the complainer is talking about here. pgsql-announce is
moderated so spam should be almost nil.
I'm not 100% sure what Twitter spam *is*, for that matter.
Redundant.
;-)
--Josh
--
Sent via pgsql-general
I can't drop a sequence. I get the error cannot drop sequence
sequence name because other objects depend on it. I've tried to use
the pg_depend table to find out what object(s) depend on it, and have
found nothing.
I tried drop cascade in a transaction, hoping to see a list of objects
On Wednesday 04 March 2009 15:39:36 Mark Styles wrote:
On Tue, Mar 03, 2009 at 09:38:39PM -0500, Douglas J Hunley wrote:
I really wanted to let everyone know that I've created @PGSQL_Announce on
Twitter and setup a cron job to parse the feed and post it to Twitter.
It's been working for a
Glen Parker glene...@nwlink.com writes:
I can't drop a sequence. I get the error cannot drop sequence
sequence name because other objects depend on it. I've tried to use
the pg_depend table to find out what object(s) depend on it, and have
found nothing.
What's the whole contents of the
Tom Lane wrote:
What's the whole contents of the rows with refobjid matching the
sequence's OID? In particular, classid::regclass would tell you
where to look for the dependent object.
oms=# select * from pg_depend where objid = 1011680210;
classid | objid| objsubid | refclassid |
Glen Parker glene...@nwlink.com writes:
For some reason I got into my head the notion that a sequence could be
dropped even if reference by a field default. This seems pretty silly now.
It was true once upon a time, but we have an enforcement mechanism now
to catch that. Did you find the
Tom Lane wrote:
Glen Parker glene...@nwlink.com writes:
For some reason I got into my head the notion that a sequence could be
dropped even if reference by a field default. This seems pretty silly now.
It was true once upon a time, but we have an enforcement mechanism now
to catch that. Did
On Mon, 2009-01-12 at 14:42 +0800, Phoenix Kiula wrote:
ALTER COLUMN TYPE is intended for cases where actual transformation of
the data is involved. Obviously varchar(20) to varchar(35) doesn't
really require any per-row effort, but there's no operation in the
system that handles that
Hello everyone,
The PostgreSQL community gave our project amazing feedback when we first
announced TurnKey PostgreSQL appliance a few months back. This was a
huge encouragement for us to push forward with our development efforts.
Since then we've been busy busy beavers and have just released a
Brent Wood wrote:
I was wondering if this includes, or could include, Postgis either by default
or as an option?
Postgis is easily the best FOSS OGC compliant spatial database implementation
available is inherently compatible with many FOSS GIS related applications.
FYI, thanks to your
Almost forgot to mention this, we also released a new version of the
LAPP appliance:
http://www.turnkeylinux.org/appliances/lapp
* Includes phpPgAdmin (listening on port 12322 - uses SSL)
* Added Python and Perl support for apache2 and postgresql, so the P in
our LAPP stack appliance now
On Tue, Mar 03, 2009 at 09:38:39PM -0500, Douglas J Hunley wrote:
I really wanted to let everyone know that I've created @PGSQL_Announce on
Twitter and setup a cron job to parse the feed and post it to Twitter.
It's been working for a little while now and I think it's stable enough to
So it looks like at one time we had a cookbook. But the links are dead
now. Does anyone know what ever happened to that, or if it lives on
somewhere else?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, 4 Mar 2009, Artacus wrote:
So it looks like at one time we had a cookbook. But the links are dead now.
I'm not sure why Roberto Mello stopped hosting that, but you can see the
last content posted there at
On Wednesday 04 March 2009 16:32:27 Gregory Stark wrote:
Xavier Bugaud xavier.bug...@gloptv.com writes:
$ psql -c SELECT '2009-01-01 00:56:00 MUST'::timestamp
ERROR: invalid input syntax for type timestamp: 2009-01-01 00:56:00
MUST
I think the problem is that MUST is missing from the
Greg Smith wrote:
On Wed, 4 Mar 2009, Artacus wrote:
So it looks like at one time we had a cookbook. But the links are dead
now.
I'm not sure why Roberto Mello stopped hosting that, but you can see the
last content posted there at
36 matches
Mail list logo