On Fri, Dec 02, 2005 at 07:37:49PM -0500, Tom Lane wrote:
> So the product I fancifully mentioned would weigh in somewhere around
> 10^300, and thus be *well* within the capability of even the proposed
> restricted numeric format.
I think numbers much bigger than that are only useful for theoretic
unsubscribe
Ramachandran.Chidambram
91(422)2496638 (Coimbatore.Res)
91(4923)262362 (Kollengode.Res)
91(4923)275576 (Kollengode.Works)
Check Out the new free AIM(R) Mail -- 2 GB of storage and
industry-leading spam and emai
RE Gurus:
I have a situation where I need to extract a couple pieces of information from
a string. The string, if entered perfectly by the user, would look someting
like this: DUN: 006235835 SID: KT-3616*
I need to extract the 006235835 into one variable and the KT-3616 into
another. Both "num
On Fri, 2 Dec 2005, Harakiri wrote:
> Hi, thanks for the response ,
>
> >
> > It's hard to say with just the above. Are you doing
> > other things in the
> > transactions besides a single update of that table
> > and/or is the order of
>
> in each transaction i do basically the same stuff :
>
> in
Will Glynn <[EMAIL PROTECTED]> wrote:
> Postgres completely for a few seconds didn't lower the number. It wasn't
> taken by any process, which leads me to believe that it's a kernel bug.
If it was a shared memory segment allocated a particular way (I
*think* it's "shm_open", I'm not 100%
Richard Huxton wrote:
Matias Silva wrote:
Hi everyone, I'm totally new here and I got a little issue.
I just got done installing PostgreSQL 8.1. I have configured PostgreSQL
to start automatically upon system start via an init script. Problem
is that when CentOS boots it halts on "Starting Pos
Hi.
this might not be the correct place to ask but i see not better place.
i use the news server news.postgresql.org. every now and then i go
offline and i usually do a offline synchronization before (download
every message, head + body).
the news.postgresql.org server seems to have some spee
Martijn van Oosterhout writes:
> On Fri, Dec 02, 2005 at 07:37:49PM -0500, Tom Lane wrote:
>> So the product I fancifully mentioned would weigh in somewhere around
>> 10^300, and thus be *well* within the capability of even the proposed
>> restricted numeric format.
> I think numbers much bigger
On 12/03/2005 01:43:38 AM, Andreas Kretschmer wrote:
Karl O. Pinc <[EMAIL PROTECTED]> schrieb:
> Hi,
>
> I'm trying to make sure I understand what I'm doing.
>
> Where is new.* and old.* documented, as regards
> using them as arguments to functions called from
> rules? If it's not documented t
On 12/03/2005 05:48:59 AM, Terry Lee Tucker wrote:
RE Gurus:
I have a situation where I need to extract a couple pieces of
information from
a string. The string, if entered perfectly by the user, would look
someting
like this: DUN: 006235835 SID: KT-3616*
I need to extract the 006235835 into
Matias Silva <[EMAIL PROTECTED]> writes:
> I just got done installing PostgreSQL 8.1. I have configured PostgreSQL
> to start automatically upon system start via an init script. Problem
> is that when CentOS boots it halts on "Starting PostgeSQL". I have
> to press the key to resume the boot.
On Sat, Dec 03, 2005 at 12:38:16PM -0500, Tom Lane wrote:
> Matias Silva <[EMAIL PROTECTED]> writes:
> > I just got done installing PostgreSQL 8.1. I have configured PostgreSQL
> > to start automatically upon system start via an init script. Problem
> > is that when CentOS boots it halts on "Star
Can anyone specify from his/her experience what would be the benefits of using
postgresql 8.04 versus 8.03 in terms of reliability and/or performance.
My organizations intends to upgrade one of the servers from 7.3 to 8.03 (the
version of the secondary server) or to 8.04 which is the latest
[EMAIL PROTECTED] wrote:
Can anyone specify from his/her experience what would be the benefits of using postgresql 8.04 versus 8.03 in terms of reliability and/or performance.
My organizations intends to upgrade one of the servers from 7.3 to 8.03 (the version of the secondary server) or to 8
Hi,
Am Saturday 03 December 2005 12:48 schrieb Terry Lee Tucker:
| I have a situation where I need to extract a couple pieces of
| information from a string. The string, if entered perfectly by the user,
| would look someting like this: DUN: 006235835 SID: KT-3616*
|
| I need to extract the 006
On Sat, Dec 03, 2005 at 01:34:19PM -0500, [EMAIL PROTECTED] wrote:
> Can anyone specify from his/her experience what would be the benefits
> of using postgresql 8.04 versus 8.03 in terms of reliability and/or
> performance.
See the 8.0.4 Release Notes for a description of the changes, most
of wh
On Sat, 3 Dec 2005, stig erikson wrote:
Hi.
this might not be the correct place to ask but i see not better place.
i use the news server news.postgresql.org. every now and then i go offline
and i usually do a offline synchronization before (download every message,
head + body).
the news.pos
On Fri, Dec 02, 2005 at 03:53:20PM -0800, Tyler MacDonald wrote:
> Will Glynn <[EMAIL PROTECTED]> wrote:
> > Postgres completely for a few seconds didn't lower the number. It wasn't
> > taken by any process, which leads me to believe that it's a kernel bug.
>
> If it was a shared memory se
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Why would you prefer 8.0.3 over 8.0.4? PostgreSQL's point releases
> aren't for adding new features but rather for fixing known problems,
> so in theory a branch's latest point release should be the best
> version in that branch. It's possible that one o
Hello to the list.
On Saturday 03 December 2005 03:10 pm, Andrew Toth saith:
> Hello to the list.
Howdy...
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
Dear List,
I have managed some small databases with FoxPro, but something is not known by me to manage postgresql databases
I had created a database as 'postgres' user and I tried the following as 'postgres' user too under Debian SID with postgresql 8.1:
(it seems to be a Hungarian version
I'm not familiar with version 8.1; however, you to use single quotes, not
double quotes as in:
INSERT INTO media VALUES ('000', 120, '1');
That should work...
On Saturday 03 December 2005 03:48 pm, Andrew Toth saith:
> Dear List,
>
> I have managed some small databases with FoxPro, but some
thx,
it's working!
And the last question - today:
how can i change the orter of the fields in a table?
2005-12-03, szo keltezéssel 20.59-kor Raymond O'Donnell ezt írta:
On 3 Dec 2005 at 21:48, Andrew Toth wrote:
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: c
Andrew Toth <[EMAIL PROTECTED]> schrieb:
> thx,
>
> it's working!
>
> And the last question - today:
>
> how can i change the orter of the fields in a table?
If you have a table with field1, field2, field3, and you want to see
this table as field3, field2, field1, simple do 'select field3, fie
On Sat, Dec 03, 2005 at 11:43:00 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Martijn van Oosterhout writes:
> > On Fri, Dec 02, 2005 at 07:37:49PM -0500, Tom Lane wrote:
> >> So the product I fancifully mentioned would weigh in somewhere around
> >> 10^300, and thus be *well* within the capabil
On 3 Dec 2005 at 21:48, Andrew Toth wrote:
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: column "000" does not exist
I think you should use single-quotes rather than doubles:
insert into media values ('000', 120, '1');
--Ray.
-
dont use " user '
Andrew Toth wrote:
Dear List,
I have managed some small databases with FoxPro, but something is not
known by me to manage postgresql databases :(
I had created a database as 'postgres' user and I tried the following
as 'postgres' user too under Debian SID with postgresq
the ctid seems to be the solution to my problem. I'm inserting the record in a
transaction so the ctid shouldn't change while the transaction isn't finished
(either rolled back or committed).
One question though. How would I get the ctid of the just inserted record. GET
DIAGNOSTICS only handles
Hi All,
I have a quick question. So I pass an array (int containing primary
keys) to a pgSQL function and I want the results to be in the exact
same order as the ints in the array. Is there a way to do this ?
currently my code looks like this
CREATE OR REPLACE FUNCTION getlms(_int4)
RETURNS S
On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:
>
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: column "000" does not exist
>
> What the Hell could be wrong?
Your quotes. Use ' and that command will work.
Peter
---(end of broadcast
Marc G. Fournier wrote:
On Sat, 3 Dec 2005, stig erikson wrote:
Hi.
this might not be the correct place to ask but i see not better place.
i use the news server news.postgresql.org. every now and then i go
offline and i usually do a offline synchronization before (download
every message, hea
Dear All.
is there any function that can translate INT to INET type?
the table contains ip and mask in different fields (int fields):
ip | integer | default 0
mask| integer | default -1
db=> select ip, mask from ips limit 2;
ip | mask
Anton Nikiforov <[EMAIL PROTECTED]> writes:
> is there any function that can translate INT to INET type?
Nothing built-in, and given the fact that "inet" no longer means "IPv4",
it's unlikely we'd add one in the future. But there's nothing stopping
you from adding one of your own. For example
r
Based on this email, should we be showing ROLE from SHOW ALL?
---
Florian G. Pflug wrote:
> Tom Lane wrote:
> > "Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> >
> >>The per-session variable "role" is not shown when
> >>do
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> 2nd, nowhere have I found a NEW.* syntax (as written).
This could certainly stand to be better documented, but there is an
example for instance here:
http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN31568
In general, "foo.*" where foo is
Bruce Momjian writes:
> Based on this email, should we be showing ROLE from SHOW ALL?
Only if you think we should be showing session_authorization too.
That was marked "no_show_all" quite a long time ago, and we have
not got complaints about it...
regards, tom lane
-
On 12/3/2005 1:34 PM, [EMAIL PROTECTED] wrote:
Can anyone specify from his/her experience what would be the benefits of using postgresql 8.04 versus 8.03 in terms of reliability and/or performance.
Unless forced because there is no other way to fix a bug, we do not
change any functionalit
On 12/03/2005 10:29:43 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> 2nd, nowhere have I found a NEW.* syntax (as written).
In general, "foo.*" where foo is a visible table alias is meaningful
anywhere that a rowtype value would be accepted. There is a special
case at the
FYI, FWIW.
Speaking of documentation, it's none too clear that
%ROWTYPE does not seem to work when declaring plpgsql
functions. (pg 8.0.3 I looked at the release notes
and didn't see anything fixed in newer versions.)
So, either the docs are broken, postgres is broken, or
I'm not reading thing
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Speaking of documentation, it's none too clear that
> %ROWTYPE does not seem to work when declaring plpgsql
> functions.
There is noplace that claims that it does. Perhaps you
are looking for %TYPE?
regards, tom lane
-
On 12/03/2005 11:31:34 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> Speaking of documentation, it's none too clear that
> %ROWTYPE does not seem to work when declaring plpgsql
> functions.
There is noplace that claims that it does. Perhaps you
are looking for %TYPE?
Nope.
Hi all,
I have a design decission to make. I am using Lucene (Java Search
API) and I need to update lucenes index from time to time.
Is there a way one can keep track of all the inserts coming
into a table (holding onto their Primary key's are sufficient) and
then reseting that after a c
"Assad Jarrahian" <[EMAIL PROTECTED]> wrote
> Hi all,
> I have a design decission to make. I am using Lucene (Java Search
> API) and I need to update lucenes index from time to time.
>Is there a way one can keep track of all the inserts coming
> into a table (holding onto their Primary k
44 matches
Mail list logo
