"Ken Winter" <[EMAIL PROTECTED]> writes:
> The documentation
> (http://www.postgresql.org/docs/7.4/static/datetime-keywords.html) =
> doesn't
> have an entry for Indian Standard Time, nor for any other time zone with =
> a
> GMT+5:30 offset.
I don't see any such entry in datetktbl in datetime.c, e
The documentation (http://www.postgresql.org/docs/7.4/static/datetime-keywords.html)
doesn’t have an entry for Indian Standard Time, nor for any other time
zone with a GMT+5:30 offset.
Is this just an omission from the documentation? If
so, what are the name and codes of the GMT+5:30
On Tue, Feb 14, 2006 at 11:47:49PM +0100, andrew wrote:
> Can I implement a stateful UDF in C? i.e. storing the state of the
> previous run of the function and access them in the succeeding runs.
> Is it supported? How do I implement it? Thanks.
Do you need to maintain state across sessions or jus
Tom,
Thanks. Good suggestions, both. I'm going to defer this problem until
we are able to upgrade.
__
Marc
On Mon, 2006-02-13 at 14:18 -0500, Tom Lane wrote:
> Marc Munro <[EMAIL PROTECTED]> writes:
> > I want to allow a non-superuser to alter objects owned by another user.
>
> Use 8.1, have t
Hi
Can I implement a stateful UDF in C? i.e. storing the state of the
previous run of the function and access them in the succeeding runs.
Is it supported? How do I implement it? Thanks.
--
andrew
---(end of broadcast)---
TIP 4: Have you searched o
On Tue, Feb 14, 2006 at 02:43:05PM -0800, CSN wrote:
> I have a bunch of timestamps like:
>
> 2005-11-20 20:45:48.281653-07
>
> How can I change it so they never get saved with
> seconds fractions?
You could set the fields to be of type TIMESTAMP(0) WITH TIME ZONE.
Cheers,
D
--
David Fetter [E
I have a bunch of timestamps like:
2005-11-20 20:45:48.281653-07
How can I change it so they never get saved with
seconds fractions?
Thanks
csn
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.co
Frank Church <[EMAIL PROTECTED]> writes:
> I get this error when I try to delete a column in a table in PG 7.4
> "ERROR: multiple INTERNAL dependencies for table"
That's fairly interesting ... can you provide a recipe for reproducing
it? PG 7.4.what-exactly?
regards, tom
I get this error when I try to delete a column in a table in PG 7.4
"ERROR: multiple INTERNAL dependencies for table"
What could the cause be and how do I get rid of it?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
At 11:16 PM +0200 2/14/06, Marko Kreen wrote:
On 2/14/06, Dan Sugalski <[EMAIL PROTECTED]> wrote:
Zend isn't, last time I looked (which, granted, was ages ago), needed
to run PHP, but it may be now.
I guess you are thinking about "Zend - PHP Optimizer" not "Zend - PHP Core".
Yeah. The core
On 2/14/06, Dan Sugalski <[EMAIL PROTECTED]> wrote:
> Zend isn't, last time I looked (which, granted, was ages ago), needed
> to run PHP, but it may be now.
I guess you are thinking about "Zend - PHP Optimizer" not "Zend - PHP Core".
--
marko
---(end of broadcast)
On Tue, Feb 14, 2006 at 02:00:13PM -0500, Tom Lane wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > Has there been any actual test (ie: court case) of a piece of software
> > being released under an open source (BSD, GPL, whatever) license and
> > then the licensor revoking that and stopping
The rumor wrt to buying sleepycat is true.
http://www.oracle.com/corporate/press/2006_feb/sleepycat.html
--elein
On Tue, Feb 14, 2006 at 08:32:00AM -0800, Rich Shepard wrote:
> On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
>
> >Oracle purchases Sleepycat. From what I understand, BerkeleyDB w
Chris Browne wrote:
> This assumes that the MySQL AB plan was to have the "new transaction
> engine" be based on Sleepycat DB.
>
> There was certainly plenty of speculation that assumed that, but I
> don't recall seeing anything actually said by principals of MySQL AB
> to that effect...
http://de
Is there some way/utility that allows dumping
according to specified criteria? Say, for example, you
have these tables:
members
comments
items
Where comments and items both have f/k's to members,
and you'd like to dump all data for a specific member
id. Possible?
Thanks
csn
merlyn@stonehenge.com (Randal L. Schwartz) writes:
> Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> "other" way that MySQL could have transactions if Oracle decided to
> restrict InnoDB tables (after purchasing Innobase last year).
>
> Does this mean the other shoe has dr
On Tue, 2006-02-14 at 13:53 -0500, Kevin Murphy wrote:
> A Windows PostgreSQL guru who cares (;-)) might help this guy with his
> benchmark of mysql, firebird, sqlite, and postgresql:
>
> http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Yeah, see recent discussion:
http://archives.postgresq
On Tue, 2006-02-14 at 12:54, Marc G. Fournier wrote:
> On Tue, 14 Feb 2006, Stephen Frost wrote:
>
> > * Marc G. Fournier ([EMAIL PROTECTED]) wrote:
> >> As of this moment, if Oracle buys Zend, they could effectively kill PHP
> >> ... the core engine that PHP is built around is a Zend engine, so i
A Windows PostgreSQL guru who cares (;-)) might help this guy with his
benchmark of mysql, firebird, sqlite, and postgresql:
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Obviously I don't care (and I don't use Windows).
-Kevin Murphy
---(end of broadcast)-
Stephen Frost <[EMAIL PROTECTED]> writes:
> Has there been any actual test (ie: court case) of a piece of software
> being released under an open source (BSD, GPL, whatever) license and
> then the licensor revoking that and stopping everyone from distributing
> the code?
AFAIK it's not possible to
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
> On Tue, 14 Feb 2006, Stephen Frost wrote:
> >Has there been any actual test (ie: court case) of a piece of software
> >being released under an open source (BSD, GPL, whatever) license and
> >then the licensor revoking that and stopping everyone from d
At 2:15 PM -0400 2/14/06, Marc G. Fournier wrote:
On Tue, 14 Feb 2006, Scott Marlowe wrote:
On Tue, 2006-02-14 at 10:51, Leonel Nunez wrote:
Rich Shepard wrote:
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way
On Tue, 14 Feb 2006, Stephen Frost wrote:
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
As of this moment, if Oracle buys Zend, they could effectively kill PHP
... the core engine that PHP is built around is a Zend engine, so if they
were to revoke the license for that, PHP would be dead ... ki
Tom Lane wrote:
> merlyn@stonehenge.com (Randal L. Schwartz) writes:
>> Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
>> "other" way that MySQL could have transactions if Oracle decided to
>> restrict InnoDB tables (after purchasing Innobase last year).
>
>> Does this mea
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
> As of this moment, if Oracle buys Zend, they could effectively kill PHP
> ... the core engine that PHP is built around is a Zend engine, so if they
> were to revoke the license for that, PHP would be dead ... kinda like
> MySQL with InnoDB ... now,
Marc G. Fournier wrote:
On Tue, 14 Feb 2006, Scott Marlowe wrote:
On Tue, 2006-02-14 at 10:51, Leonel Nunez wrote:
Rich Shepard wrote:
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was
the
"other" way that MySQL could have tr
On Tue, 14 Feb 2006, Scott Marlowe wrote:
On Tue, 2006-02-14 at 10:51, Leonel Nunez wrote:
Rich Shepard wrote:
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decid
merlyn@stonehenge.com (Randal L. Schwartz) writes:
> Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> "other" way that MySQL could have transactions if Oracle decided to
> restrict InnoDB tables (after purchasing Innobase last year).
> Does this mean the other shoe has dro
On Tue, 2006-02-14 at 10:51, Leonel Nunez wrote:
> Rich Shepard wrote:
> > On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
> >
> >> Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> >> "other" way that MySQL could have transactions if Oracle decided to
> >> restrict InnoDB ta
Ok, thanks. I guess that was a stupid question, sorry :)
I guess we'll have to use INSERTs instead of UPDATEs.
Sebastjan
On 2/14/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Am Dienstag, 14. Februar 2006 16:13 schrieb Sebastjan Trepca:
> > As I understood from books and docs every statemen
Rich Shepard wrote:
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
From what I read a few
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
From what I read a few days ago, Oracle is
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
Does this mean the other shoe has dropped for MySQL AB?
--
Randal L. Schwartz - Stonehenge Co
Hello,
May I know whether plpgsql supports "switch / case " or I have to use IF
/ELSIF please?
Thanks,
Emi
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
Am Dienstag, 14. Februar 2006 16:13 schrieb Sebastjan Trepca:
> As I understood from books and docs every statement in Postgres takes
> O(1) because of it's versioning system, right?
Absolutely not.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Sebastjan Trepca <[EMAIL PROTECTED]> writes:
> As I understood from books and docs every statement in Postgres takes
> O(1) because of it's versioning system, right?
Finding an existing row is not O(1), so this is not the case for
anything but INSERT. You also have to consider index update costs,
Tham Shiming <[EMAIL PROTECTED]> writes:
> ctid(tid) xmin(xid) xmax(xid) datname(name)
> (0,5) 2 2213800494 db2 (pgAdmin says this DB does not
> exist)
> (0,8) 2 2214815770 db3 (pgAdmin says this DB does not
> exist)
> (0,10) 2 2213853192 db
PostgreSQL minor version 8.1.3 has been released, containing a patch for a
serious security issue present in the 8.1 branch. All users of 8.1 are
urged to upgrade at the earliest opportunity.
Minor versions 8.0.7, 7.4.12, and 7.3.14 are being released at the same
time. These contain onl
Hi everybody!
As I understood from books and docs every statement in Postgres takes
O(1) because of it's versioning system, right?
I'm talking about INSERT,UPDATE,SELECT and DELETE statement.
Is it true? or did I get it wrong.
I'm specially interested in UPDATE statement. We'll have lots of the
Sorry, I wasn't being clear. For the sample output from pgAdmin below, I
just did a select * from pg_database, then just typed out the 2 columns
that I thought would be relevant.
OK, here's the output for select ctid, xmin, xmax, datname from pg_database;
ctid(tid) xmin(xid) xmax(xid) da
40 matches
Mail list logo
