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
http://web.archive.org/web/20031207045017/http://www.brasile
On Wednesday 04 March 2009 16:32:27 Gregory Stark wrote:
> Xavier Bugaud 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 Default
> t
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
http://web.archive.org/web/20031207045017/http://www.brasileiro.net/postgres/co
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:
http://www.postgresql.org/mailpr
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
> an
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 stand
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
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 ne
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 t
Tom Lane wrote:
Glen Parker 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 defaul
Glen Parker 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 default you needed to
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 | refob
Glen Parker writes:
> I can't drop a sequence. I get the error "cannot drop sequence
> 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 rows with refobjid matching
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 f
I can't drop a sequence. I get the error "cannot drop sequence
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
dropped in the c
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
On Wed, Mar 4, 2009 at 11:05 AM, Adrian Klaver wrote:
>
> - "Andreas Moeller" 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;
>> RE
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 th
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 in
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, Direc
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)
T
2009/3/5 Joshua D. Drake :
> 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 pgsql-general mailing
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 (pgsql-gene
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 wo
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 t
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,
Adrian Klaver 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 word
right
- "Adrian Klaver" wrote:
> - "Andreas Moeller" 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;
>
- "Andreas Moeller" 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: synta
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
Tom Lane wrote:
> shadrack 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 version.
>
> Er ...
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 w
Xavier Bugaud 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 the correct Mauriti
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 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. So
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 (pg
36 matches
Mail list logo
