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
(http://www.postgres
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
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 in 4.0 provides any performance
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
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@
-
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 my
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 use
>> # 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
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 po
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?
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
"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.
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
>
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
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 imp
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 the
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
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, 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-
>
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
|> --
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 bot
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 ye
"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-
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:
>
> http://jonathangardner.net/PostgreSQL/materialized_vi
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 impli
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() an
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:
>
> > H
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 anothe
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
> > precis
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 PostgreSQ
On Fri, 20 May 2005, Tom Lane wrote:
> Has anyone bothered to actually look into the code?
>
> regression=# select power(2::numeric,1000);
>
> power
> ---
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 t
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
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 serve
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 >
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 you
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 bac
Has anyone bothered to actually look into the code?
regression=# select power(2::numeric,1000);
power
-
[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 i
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", bu
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
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 abrevatio
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 "busines
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,
> fol
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
>
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
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
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 wro
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
[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 Postgre
Hi there,
1. As I have installed the PostgreSQL
8.0.2 in 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 charac
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 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
command
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
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 use
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?
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
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
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 de
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
-
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,
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
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 pre
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_pat
Hi,
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. I’d like to use bytea instead so we could
use 16bytes, but are indexes used properly ? Does anyone have any other
suggestions on how t
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 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 |
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?
http
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 conncetio
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
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
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 some
72 matches
Mail list logo
