Dann Corbit [EMAIL PROTECTED] writes:
Probably, the important meaningful cases are ones that have small
exponents (HOPEFULLY less than 25) used in interest calculations.
No, even in interest calculation floating point arithmetic is perfectly fine.
You do your floating point arithmetic to
Hello folks,
Problem:
I would need some help with the system I am working on. It is an
information system built on PgSQL 8 and after searching all over the
net I found no function I could use to determine where the request to
the DB (select...) came from. I need it to prevent using fake user ID
does postgres support materialized view.. if yes can somebody post any links which might be useful in learning how to use them...
thx
Himanshu__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
A quick google search for materialized views on postgres brings up
this very helpful page that I've used before:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
On May 19, 2005, at 11:40 PM, Himanshu Baweja wrote:
does postgres support materialized view.. if yes can
Hrishikesh Deshmukh wrote:
What they have is for version 7.2 and i want for 7.4.7 only, i have
tried to follow instructions on how to make the pdf/ps version and all
i get is errors. If someone already has a pdf/ps and can email it,
will be a big help.
Apparently, it is tricky to produce them. I'm
Tom Lane wrote:
Berend Tober [EMAIL PROTECTED] writes:
Now what, oh most wise one?
OK, now I finally get the point: you are creating child tables in
different schemas than their parents live in. This creates a problem
because reverse-listing of the constraints varies depending on what
the
Hello Mike.
I have found your code to be very usefull for me.
I combined it with some other codes in order to establich a procedure for
startup on client.
The problem apers with relinking tables. It seems that Access creates fake
indexes automaticcaly whern relinking using your proposed
Hello.
When building ODBC connection string for PostgreSQL there are constants
beginning with A, B and C. Where can I find description of each of these ?
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Hi all,
I'm trying to write a function that takes the following records
|Field1|Field2 |Field3 |Field 4
| A | P |Name1 | 51
| A | P |Name2 | 20.143
| A | P |Name3 |
Hi,
I'm working on carrying out application on Oracle database to PostgreSQL.
The server is weblogic.
For Oracle we use XA connection but there isn't in PostgreSQL so I try to use
XA emulate Connection taht allows weblogic. But I don't succeed to use it
correctly.
The connection seems correct,
Hi,
We are currently using a 32byte varchar for our
primary keys. We tried to reduce this down to 16 bytes but varchar didnt
seem to store this correctly. Id like to use bytea instead so we could
use 16bytes, but are indexes used properly ? Does anyone have any other
suggestions on how to
Hi,
We have lots of schemas .. one of which is public. They
all have the same set of tables and some of these have triggers. However when a
trigger is fired in a schema it works on tables in the public schema instead of
the current schema. We can put a statement similar to set
search_path
On Thu, 2005-05-19 at 23:27 -0400, Tom Lane wrote:
Berend Tober [EMAIL PROTECTED] writes:
Now what, oh most wise one?
OK, now I finally get the point: you are creating child tables in
different schemas than their parents live in.
...
Comments anyone?
Best thing to do is to prevent
Hi,
you
can use
SET
search_path TO :"defaultSchema";
with
replacing "defaultSchema" by the name of schema you want as
default.
Then
all create are automatically done in this schema.
Nicolas
-Message
d'origine-De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]De la part de Paul
Paul Newman wrote:
We are currently using a 32byte varchar for our primary keys. We tried
to reduce this down to 16 bytes but varchar didn't seem to store this
correctly.
In what way was it not stored correctly? The size limit should not
significantly affect varchar behavior, other than bounding
Hi,
I made some tests of
plsh with Postgresql 8.0.2 but it seems that it doesn't
work.
What's the easiest
way to execute shell commands from a PostgreSQL function (afraid not possible
from pgsql function...).
Regards,
Patrick
On Fri, May 20, 2005 at 08:40:26 +0200,
BARTKO, Zoltán [EMAIL PROTECTED] wrote:
Hello folks,
Problem:
I would need some help with the system I am working on. It is an
information system built on PgSQL 8 and after searching all over the
net I found no function I could use to determine
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
folks, Postgres gets used for more than business cases.
- John D. Burger
MITRE
hi,
Does anyone know of a tool for filling the database with alot of random data...
so that I can add millions of rows to test approx how well it will scale ?
tia
-
http://linuxtoday.com/news_story.php3?ltsn=2004-12-08-004-32-OS-BZ-DT-0005
snip MS Office is popular in the same way as heart
Simon Riggs wrote:
On Thu, 2005-05-19 at 23:27 -0400, Tom Lane wrote:
Berend Tober [EMAIL PROTECTED] writes:
Now what, oh most wise one?
OK, now I finally get the point: you are creating child tables in
different schemas than their parents live in.
...
Comments anyone?
Inpreet Singh wrote:
Hello Sir,
Please don't email people directly - instead, send your messages to one
of the mailing lists. Apart from anything else, your email may not get
noticed.
I am facing a problem on my linux server. After some hours of usage my
linux server refuses to authenticate
EMS PostgreSQL Data Generator
http://sqlmanager.net/products/postgresql/datagenerator
And you can write you own pgplsql function that fill you database with any random data.
I think it would be better and cheaper =)
2005/5/20, [EMAIL PROTECTED] [EMAIL PROTECTED]
:hi,Does anyone know of a tool
Hi everybody,
i'm looking for the way to change the schema of a table.
I've lots of tables (400), each of these being on the public schema, and,
willing to organize this a little bit, i'd like to use some schemas (20).
But i seem to be unable to find this in the documentation ; is there a
Hello! I am novice in Postgres and first of all I have problems during
install :-)
I've get error during installation
===
Failed to connect to the database. Procedural language files are
installed, but are not activated in any databases
===
After I press OK another message
Hi there,
1. As I have installed thePostgreSQL
8.0.2in French, when I start "psql to template1" in console mode, I
receive a message telling that my code page 850 is not the one of the
application (1252) and consequently the display could be erroneous. It's true,
all the accented
[EMAIL PROTECTED] (Jan Sunavec) writes:
I am using libpg.so.
I assume that you mean libpq ?
I tryed find solution for this problem in
internet but, I don't find nothing yet. I have idea get rowcount
throught some function write in C. Or is there any plan add this
feature into PostgreSQL?
On Thu, 19 May 2005, Hrishikesh Deshmukh wrote:
Hi All,
Is there a bulk loader in postgresql with which one can read in say
a tab delimited format text file. Before one does all one has to do is
create the table with text file column names as attributes, once it is
on DBMS world it will
Hrishikesh Deshmukh wrote:
What they have is for version 7.2 and i want for 7.4.7 only, i have
tried to follow instructions on how to make the pdf/ps version and all
i get is errors. If someone already has a pdf/ps and can email it,
will be a big help.
Thanks,
Hrishi
On 5/19/05, Richard Huxton
They have the comprehensive manual in US and A4 format, on the right
hand side. Is that what you want?
On Thu, 2005-05-19 at 14:44, Hrishikesh Deshmukh wrote:
What they have is for version 7.2 and i want for 7.4.7 only, i have
tried to follow instructions on how to make the pdf/ps version and
On Thu, 2005-05-19 at 15:10, Mark Harrison wrote:
Sadly, lots of people in positions of power still want scape goats,
rather than proven results.
No, it could be that the OP's organization is looking for some proof
of postgresql's results.
That's a bit out of context. The message I was
Berend Tober [EMAIL PROTECTED] writes:
On Thu, 2005-05-19 at 23:27 -0400, Tom Lane wrote:
OK, now I finally get the point: you are creating child tables in
different schemas than their parents live in.
The case in question was not one of the child table being in a different
partition (do
On Fri, May 20, 2005 at 08:19:58 -0400,
John D. Burger [EMAIL PROTECTED] wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
folks,
On Fri, 20 May 2005, John D. Burger wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
folks, Postgres gets used for more than business
Zlatko Matic wrote:
Hello.
When building ODBC connection string for PostgreSQL there are
constants beginning with A, B and C. Where can I find description of
each of these ?
There is a HowTo on the psqlODBC site that mentions those codes.
Keep in mind that those are MS-Access specific
Berend Tober [EMAIL PROTECTED] writes:
If the pg_dump output produced SET search_path statement with the
complete actual path required to find all objects in subsequent DDL
statements, my world would be at peace.
We're not doing that, because it's demonstrably impossible :-(.
You can't
On Fri, 2005-05-20 at 09:06, Stephan Szabo wrote:
On Fri, 20 May 2005, John D. Burger wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
[EMAIL PROTECTED] wrote:
Hi,
I made some tests of plsh with Postgresql 8.0.2 but it seems that it
doesn't work.
What's the easiest way to execute shell commands from a PostgreSQL
function (afraid not possible from pgsql function...).
Regards,
Patrick
Easiest way? No idea.
Another way to do
Has anyone bothered to actually look into the code?
regression=# select power(2::numeric,1000);
power
Scott Marlowe wrote:
I could be wrong, and would be unoffended to be proven so, but I don't
think I am. I think that argument is just hand waving.
2: How many people who DO work with large exponents and need arbitrary
precision have looked at postgresql, typed in select 3^100 got back
Is there a way to query for the IP address (or other attributes) of the
front-end process attached to a given backend? Perhaps something
similar to:
pg_stat_get_frontend_*( backendid )
-K
---(end of broadcast)---
TIP 9: the planner will ignore
hello,
I've been using postgresql for about a year now, and am pretty
comfortable with the basics, bu there has been something bugging me for
a while now:
I set the METHOD in pg_hba.conf to md5 so that a password is required
from all users, from all hosts.
The only problem is that if the
On Fri, 20 May 2005, Scott Marlowe wrote:
On Fri, 2005-05-20 at 09:06, Stephan Szabo wrote:
On Fri, 20 May 2005, John D. Burger wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for
This is not a PostgreSQL problem, it's the script you are using for
startup that has some problem. The pg_hba method is for connection
stablishment. PostgreSQL will start no matter what you put there.
Startup scripts are usually run as root, and postgresql script should su
to the postgresql user
On Fri, 20 May 2005, Tom Lane wrote:
Has anyone bothered to actually look into the code?
regression=# select power(2::numeric,1000);
power
I don't remember off the top of my head exactly how synonyms worked, but
I'm pretty sure PostgreSQL doesn't directly support them. You might be
able to emulate them with rules, though.
On Mon, May 16, 2005 at 08:35:34AM -0300, Jayme Jeffman Filho wrote:
Hi,
I would like to know if PostgreSQL
On Fri, 2005-05-20 at 10:37, Bruce Momjian wrote:
Scott Marlowe wrote:
I could be wrong, and would be unoffended to be proven so, but I don't
think I am. I think that argument is just hand waving.
2: How many people who DO work with large exponents and need arbitrary
precision have
On Fri, 2005-05-20 at 11:16, Stephan Szabo wrote:
On Fri, 20 May 2005, Scott Marlowe wrote:
2: How many people who DO work with large exponents and need arbitrary
precision have looked at postgresql, typed in select 3^100 got back
5.15377520732011e+47, and simply went to another piece
Simon Riggs [EMAIL PROTECTED] writes:
Doing anything to restrict dropping of inherited constraints seems like
wasted effort and potentially annoying anyhow.
Uh, why? Arguably the constraints are as much part of the parent table
definition as the columns themselves. If you had check (f1 0) in
That's because numerics default to 16 or something similar. If you want
more precision just explicitly cast it:
decibel=# select power(0.1::numeric(20,20),17);
0.1000
On Fri, May 20, 2005 at 09:30:16AM -0700, Stephan Szabo wrote:
On Fri, 20 May 2005, Tom Lane wrote:
Has
Stephan Szabo [EMAIL PROTECTED] writes:
It also doesn't seem to work terribly well:
It's not terribly bright about figuring out how many significant digits
it should try to calculate, nor about how many it's actually got in the
result. Feel free to fix that ;-) I believe the numeric exp() and
Why are we allowing implicit casts from numeric to floating point?
Doesn't that violate the principle of not doing any implicit casts that
would potentially drop precision? It seems that about half the arguments
here are related to getting unexpected or inaccurate results, presumably
from the
The BizGres project is also looking at adding materialized views.
On Thu, May 19, 2005 at 11:52:01PM -0700, Ben wrote:
A quick google search for materialized views on postgres brings up
this very helpful page that I've used before:
Jim C. Nasby [EMAIL PROTECTED] writes:
Why are we allowing implicit casts from numeric to floating point?
Because the SQL spec requires it.
2) If the data type of either operand of a dyadic arithmetic op-
erator is approximate numeric, then the data type of the re-
On Thu, 2005-05-19 at 04:35, Richard Huxton wrote:
Dinesh Pandey wrote:
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
You don't I'm afraid. It's not a feature that's supported yet. You have
Martijn van Oosterhout wrote:
On Thu, May 19, 2005 at 02:25:58PM -0700, Dann Corbit wrote:
Hmmm
I underestimated.
pow(9.9,9.9) =
Yeah, a number with x digits raised to the power with something y digits
long could have a length approximating:
x * (10^y) digits
So two numbers
17:28, venerdì 20 maggio 2005 - Tom Lane scrive:
| Has anyone bothered to actually look into the code?
|
| regression=# select power(2::numeric,1000);
|
| power
|
On Fri, May 20, 2005 at 01:03:08PM -0400, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Why are we allowing implicit casts from numeric to floating point?
Because the SQL spec requires it.
2) If the data type of either operand of a dyadic arithmetic op-
Stephan Szabo wrote:
On Fri, 20 May 2005, John D. Burger wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
folks, Postgres gets used for more
On Fri, 2005-05-20 at 12:03, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Why are we allowing implicit casts from numeric to floating point?
Because the SQL spec requires it.
2) If the data type of either operand of a dyadic arithmetic op-
erator is
I am using the default startup script that is supplied with the FreeBSD
port (/usr/local/etc/rc.d/010.pgsql.sh) and enabling it in /etc/rc.d
with -o -i flags so listens on TCP/IP
Also, I should mention that the password I mentioned is NOT the password
for the local (Unix) pgsql account, but
Scott Marlowe [EMAIL PROTECTED] writes:
Are you saying that the exponent operator will return inexact results?
For a fractional exponent, it generally has to, because there is no
finite exact result.
If you're quoting the 92 spec, it seems to say that multiplication
precision is also
On Fri, 2005-05-20 at 12:27, Florian G. Pflug wrote:
Stephan Szabo wrote:
On Fri, 20 May 2005, John D. Burger wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't
On Fri, 2005-05-20 at 11:51 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Doing anything to restrict dropping of inherited constraints seems like
wasted effort and potentially annoying anyhow.
Uh, why? Arguably the constraints are as much part of the parent table
Florian G. Pflug [EMAIL PROTECTED] writes:
It's not only useless, it's dangerous. As fas as I know, numeric
_guarantees_ the result of a operation to be correct to the last digit.
Nonsense ... see division. By your argument we should not implement
numeric / numeric.
Claudio Succa [EMAIL PROTECTED] writes:
With PostgreSQL 7.4.7 on Linux/Debian platform I had a different result so I
made the subtraction of your figure:
psql -h s1 -d rapp-test -c select power(2::numeric,1000) -
I don't know what you're getting there, but there is no power() function
at all
Simon Riggs [EMAIL PROTECTED] writes:
If you were going to fix that by adding a column that allows me to tell
the difference between inherited and non-inherited relations, that would
be a very useful piece of info for partition elimination.
Inherited and non-inherited constraints you mean?
mmmhhh, I have never installed postgresql from the ports. I don´t know
what the script is doing, probably it´s checking that Postgresql
directory is initialized.
Anyway, here is my homemade script, you could replace yours with it (check it first, but it´s quite simple).
My script does not tell
# set defaults
postgresql_enable=${postgresql_enable:-NO}
postgresql_flags=${postgresql_flags:--w -s -m fast}
Try it without the -w ... that's probably causing it to try to connect
with psql.
Alternatively, set up a ~/.pgpass file for the postgres user (which
might be a reasonable thing
yes , not in native form, but making few things
here a link about this
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
bys
2005/5/20, Himanshu Baweja [EMAIL PROTECTED]:
does postgres support materialized view.. if yes can somebody post any links
which might be useful
Tom Lane wrote:
...
I just ran into another inheritance-related oddness. Well maybe it is
not really an oddness -- you tell me.
The problem stems from the fact that I did not originally plan on using
inhertiance and so did not include the ONLY keyword in the FROM clause
of queries coded into
Just wondering if the Postgres hackers have done any performance
measurements on Postgres compiled with GCC 3.x against Postgres
compiled with GCC 4.0. I'm wondering whether or not the auto-
vectorization stuff in 4.0 provides any performance improvements to
Postgres 8.0.x.
-M@
Berend Tober [EMAIL PROTECTED] writes:
However, when I do a select from a view, which itself does a select from
a parent table, the query result does include the child table rows,
i.e., the SQL_INHERITANCE setting is ignored in this situation. Should
the SQL_INHERITANCE setting still
On May 20, 2005, at 3:00 PM, Tom Lane wrote:
Matthew Hixson [EMAIL PROTECTED] writes:
Just wondering if the Postgres hackers have done any performance
measurements on Postgres compiled with GCC 3.x against Postgres
compiled with GCC 4.0. I'm wondering whether or not the auto-
vectorization stuff
On Friday 20 May 2005 8:39 am, Kelly Burkhart wrote:
Is there a way to query for the IP address (or other attributes) of
the front-end process attached to a given backend? Perhaps
something similar to:
pg_stat_get_frontend_*( backendid )
See the developer todo list
74 matches
Mail list logo