dot geeks home page
" The new server will *not support PostgreSQL* so please migrate your DB
to MySQL (using the mygeek area of the site) or SQLite. "
Why they would switch from Postgres to MySQL and not allow the postgres
anymore is beyond me.
Ambitious Lemon does.
"Jaqui Greenlees" <[EMAIL
On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
> Empty data is a date which is less that all other dates.
Why would that be ? " of type " cannot be less
than (nor more than nor equal to) " of type ".
If you want to express the valid idea of "
of type " you are better off using a logical
I am aware of the max_connections and recompiling the kernel (FreeBSD),
but how many connections can one database server handle without
degrading performance to much.
I am in a situation where I can end up in handling thousands of
connections, not doing much load each, but they are connected.
Of
Marc G. Fournier wrote:
From the Mono web site:
"Mono can run existing programs targeting the .NET or Java frameworks."
does this mean that something written for Java (or .Net) could be
compiled without mods?
Mono runs Java using IKVM.NET http://www.ikvm.net/. It's not yet fully
compliant with
Sim Zacks wrote:
dot geeks home page
" The new server will *not support PostgreSQL* so please migrate your DB
to MySQL (using the mygeek area of the site) or SQLite. "
Why they would switch from Postgres to MySQL and not allow the postgres
anymore is beyond me.
maybe they feel the slight improv
Le dimanche 03 avril 2005 à 04:10 -0700, Jaqui Greenlees a écrit :
> Sim Zacks wrote:
> > dot geeks home page
> > " The new server will *not support PostgreSQL* so please migrate your DB
> > to MySQL (using the mygeek area of the site) or SQLite. "
> > Why they would switch from Postgres to MyS
On Tue, Mar 29, 2005 at 18:40:56 +0200,
Robin Ericsson <[EMAIL PROTECTED]> wrote:
> Devrim GUNDUZ wrote:
> >PostgreSQL RPM Building Project[1] has built RPMs for 8.0.2beta1. RPMs
> >for Red Hat Linux 9, Red Hat Enterprise Linux Enterprise Server 3.0,
> >Fedora Cor 1,2,3 are now available, and m
On Wed, Mar 30, 2005 at 13:09:33 -0500,
Adam Siegel <[EMAIL PROTECTED]> wrote:
>
> We perform a vacuum full after each mass delete. This cycle can happen
> many times during over a couple of weeks. We are in a test lab
> environment and are generating a lot of data.
>
> One of the problems
Tony Caduto wrote:
I think he means PL C#
I thought I saw a project started for PL C# or PL Mono on Gborg.
plmono sounds very interesting. It would basically mean you could
program procedures in any language that has a .NET bytecode compiler,
including C#, C++, VB(!) and I believe java. I wouldn'
Hello,
I found this: http://www.postgresql.org/community/survey.32
However, I think one of the bests improvement is that you don't have to
typecast every value in pgsql8 to force it using indexes.
Casting int4 values to int8 in case of bigint primary key was so
annoying in 7.4.
On Sun, Apr 03, 2005 at 11:06:22 +0200,
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
>
> > Empty data is a date which is less that all other dates.
>
> Why would that be ? " of type " cannot be less
> than (nor more than nor equal to) " of
> > type " or some such. However the best would be to use
> > "-infinity".
>
> +/- infinity are only available as timestamps, not dates.
Hm, any particular reason why ? Apart from no one having
gotten around to doing it...
Strange enough, on 7.4.6 I am unsure as to how to interpret
the output of:
Hello *,
I am puzzeling around, how to query a postgresql from a BASH script.
Generaly it must do nothing else as
1) Get VALUEs from a DB/TABLE
e.g.
program --db pgsql.sld.tld --search "$COLNAME,$VAL" \
--get "COL1,COL3,COL4,..."
2) Write one or more new
On Sun, Apr 03, 2005 at 15:46:18 +0200,
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> > > type " or some such. However the best would be to use
> > > "-infinity".
> >
> > +/- infinity are only available as timestamps, not dates.
> Hm, any particular reason why ? Apart from no one having
> gotten
On Sun, 3 Apr 2005, Michelle Konzack wrote:
> Hello *,
>
> I am puzzeling around, how to query a postgresql from a BASH script.
> Generaly it must do nothing else as
>
Hello,
There is more solutions. The best is pgbash (pgbash is patch for bash)
http://www.psn.co.jp/PostgreSQL/pgbash/index-e.h
Michelle,
There may be other answers for this, but if you need to connect 2-3 times
per second, you probably need a persistent connection which, as far as I
know, can't be obtained (and maintained) from bash. Is there a reason not
to do this from the server side or even from a standard client-s
Hello
maybe
http://gborg.postgresql.org/project/plmono/projdisplay.php
but I am not know more
regards
Pavel Stehule
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Pavel Stehule wrote:
Hello
maybe
http://gborg.postgresql.org/project/plmono/projdisplay.php
but I am not know more
Judging from the CVS, that project hasn't had any activity at all the
last 14 months or so. Is it still active? Has it been moved?
Regards,
Thomas Hallgren
-
Thomas Hallgren wrote:
Pavel Stehule wrote:
Hello
maybe
http://gborg.postgresql.org/project/plmono/projdisplay.php
but I am not know more
Judging from the CVS, that project hasn't had any activity at all the
last 14 months or so. Is it still active? Has it been moved?
I've had a browse of the 4 e
Am 2005-04-03 10:41:06, schrieb Sean Davis:
> Michelle,
>
> There may be other answers for this, but if you need to connect 2-3 times
> per second, you probably need a persistent connection which, as far as I
> know, can't be obtained (and maintained) from bash. Is there a reason not
> to do t
Marc G. Fournier wrote:
From the Mono web site:
"Mono can run existing programs targeting the .NET or Java frameworks."
does this mean that something written for Java (or .Net) could be
compiled without mods?
Mono would give someone inclined to code that a fairly easy inroad into
several operat
On Tue, 2005-03-29 at 12:58 -0600, Caleb Simonyi-Gindele wrote:
> We have a billing system and we want the ability to send users out into
> the field with an unconnected (no WAN, VPN etc) laptop containing our pg
> db and software. Upon their return we need to synchronize changes to the
> main d
> I agree with your disagreement. This design is present in lots of
> non-RDB systems - CVS, IMAP, PDA syncing, etc. It's clearly more
> complicated, but can be made to work, and has been many times. I don't
> see anything about databases in general, or Postgres specifically, that
> indica
Hello Pavel,
Am 2005-04-03 16:36:47, schrieb Pavel Stehule:
> Hello,
>
> There is more solutions. The best is pgbash (pgbash is patch for bash)
> http://www.psn.co.jp/PostgreSQL/pgbash/index-e.html
Wow... realy cool.
Unfortunatly I can not get the bash-2.0.5a tarball - ServerError
I will try
> If there was idea to implement a .NET support in Windows
>version of PostgreSQL? Like existing Pl/Java
We have a .Net client. You want server-side .Net? No one has ever
talked about that, sorry.
>>>
>>> not knowin gmuch about .Net ... what is a 'server-side
>.Net'? Like a
> area=> select 'infinity'::timestamp::date is null;
> ?column?
> --
> t
> (1 row)
Ah, thanks.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end of broadcast)---
TIP 5: Have you ch
Anyone know an easy way to increment IP type inet?
For example, I'd like to create a list of all Ips contained in a subnet. For
that, I can grab the network address and broadcast address from a given CIDR
subnet type, and then fill in all the Ips between the two.
I know I can:
* convert an INET a
On Sunday 03 April 2005 07:16 am, Michelle Konzack wrote:
> Hello *,
>
> I am puzzeling around, how to query a postgresql from a BASH script.
> Generaly it must do nothing else as
>
I recently came across this program-ShellSQL. I haven't had time to try it,
just read through the documentation. It
On Fri, Apr 01, 2005 at 09:51:25AM -0600,
John Hughes <[EMAIL PROTECTED]> wrote
a message of 49 lines which said:
> I ran into a brick wall when I realized that inheritance in postgres
> isnt really there...
I have a problem which MAY be in the same category.
CREATE TABLE base (
id serial n
FYI
Postgresql 8.0.1
$ uname -a
Linux example.example.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 19
01:53:23 GMT 2005 i686 i686 i386 GNU/Linux
Incrementing the loop counter by a factor of 10, from 1000 to 1
makes the process take more than 100 times longer. (I only saw
this happen when I happen
Stephane Bortzmeyer schrieb:
I have a problem which MAY be in the same category.
CREATE TABLE base (
id serial not null primary key,
);
CREATE TABLE specialized (
) INHERITS base;
Now, I try to set up a trigger AFTER UPDATE ON base but, when I update
"specialized", the trigger is not called. Same
> So if I understand it right, if I have a table like
>
> Table: ip_table
>ip | ctime| atime
> ++
> aaa.bbb.ccc.ddd | 1234567890 | 2345678901
> eee.fff.ggg.hhh | 3456789012 | 4567890123
>
> and I need only
>
> CONNECT TO localhos
on 3/30/05 11:43 PM, [EMAIL PROTECTED] purportedly said:
> I have a ODBC client which uses empty dates in its native data engine.
> Unfortunately, empty data causes error if trying to store it.
> This is serious Postgres limitation.
> For a partial fix ODBC driver or postgres should convert empty
> Incrementing the loop counter by a factor of 10, from 1000 to 1
> makes the process take more than 100 times longer. (I only saw
> this happen when I happened upon using a numeric() datatype
> and then dividing i/100 to avoid overflow. It does not happen
> without the array and working with
Hello,
I found different behavior of array inicialised from plperl than plpgsql.
I use code from my prev. mail
tarif=# select speed(10);
speed
---
{0,1,2,3,4,5,6,7,8,9}
(1 row)
Time: 2,304 ms
tarif=# select speed2(10);
speed2
---
On Sat, Apr 02, 2005 at 07:29:02AM -0800, Joshua D. Drake wrote:
> This argument doesn't hold too much weight. Namely because there are only
> 3-5 really popular languages out there. They are marketing languages.
> The are languages you include because your database doesn't "sound"
> complete with
On Sat, Apr 02, 2005 at 06:23:56PM -0500, [EMAIL PROTECTED] wrote:
> Clients aside, and as Christopher wrote, there are lots of differences
> between the two systems. PostgreSQL supports higher-end Enterprise-level
> RDBMS features. MySQL tends to be quicker. For example, and as just one
MySQL is
Karsten Hilbert <[EMAIL PROTECTED]> writes:
>> area=> select 'infinity'::timestamp::date is null;
>> ?column?
>> --
>> t
>> (1 row)
> Ah, thanks.
I think this is a bug BTW. If we can't convert the value correctly,
we ought to raise an error not return NULL.
regard
The format_type function is great, except for the way it formats varchars,
it always returns Character Varying or whatever, it would be nice if it
had a option to return a short version of
these names. i.e.
format_type(a.atttypid, a.atttypmod,true) would return all short names
format_type(a.att
Pavel Stehule <[EMAIL PROTECTED]> writes:
> the array from speed2 is ok, but array from speed is mal formated.
They both look OK to me.
> I declare all function as numeric(7,2)[]
Type modifiers applied to function arguments and results are generally
ignored. What you have here is functions ret
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Incrementing the loop counter by a factor of 10, from 1000 to 1
> makes the process take more than 100 times longer. (I only saw
> this happen when I happened upon using a numeric() datatype
> and then dividing i/100 to avoid overflow. It does not
Tony Caduto <[EMAIL PROTECTED]> writes:
> The format_type function is great, except for the way it formats varchars,
> it always returns Character Varying or whatever,
> ...
> I don't know of any other system that shows varchars in this way, they
> should just be formated as varchar(50).
Hmm ...
Jim C. Nasby wrote:
On Sat, Apr 02, 2005 at 07:29:02AM -0800, Joshua D. Drake wrote:
This argument doesn't hold too much weight. Namely because there are only
3-5 really popular languages out there. They are marketing languages.
The are languages you include because your database doesn't "sound"
On Sun, Apr 03, 2005 at 08:41:15PM -0700, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
>
> >On Sat, Apr 02, 2005 at 07:29:02AM -0800, Joshua D. Drake wrote:
> >
> >
> >>This argument doesn't hold too much weight. Namely because there are only
> >>3-5 really popular languages out there. They are m
Would it not be possible to add another param to the function like I mentioned
and keep everyone happy? Users coming from MS SQL server look puzzled when
they see the huge Character Varying(n) in a admin tool.
I have not programmed in C since 1993, but I know in pascal you can have a
parameter
I'm Sorry for my english.
Why Postgresql community do not use a "patch" style updates, I think this is
usefull.
Example: postgresql-7.4.6-7.4.7.tar.bz2
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I'm Sorry for my english.
Why Postgresql community do not use a "patch" style updates, I think this is
usefull.
Example: postgresql-7.4.6-7.4.7.tar.bz2
---(end of broadcast)---
TIP 8: explain analyze is your friend
47 matches
Mail list logo
