Nageshwar Rao wrote:
Hi,
Psql -l gives names of databases in which it does not show test.
But same test I am still able to access through pgAdmin III utility.
You must be looking at two different installations. Check your
connection settings in pgadmin.
--
Richard Huxton
Archonet Ltd
On Sun, Mar 27, 2005 at 12:54:28AM -0600, Guy Rouillier wrote:
[]
The service_plane table is a reference table, i.e., a fixed set of
values used only to validate foreign keys. So the code doesn't have any
update statements on that table.
And idea that just came up around here that sounds like
Title: : [GENERAL] Postgres IX
Can someone please explain to me , the use of
snip
CONSTRAINT ix_tablename
/snip
Kind Regards,
Shaun Clements
Hi,
Documentation mentions that PGSQL 8 supports a version of PL/PERL with
composite return values. Is there a way to install this new version of
PL/PERL on an old 7.4 database, or is it absolutely necessary to
upgrade?
Thanks
Philippe Lang
---(end of
On 31 Mar 2005 21:22:12 -0600, Doug Quale [EMAIL PROTECTED] wrote:
I basically want to convert a a hexadecimal to a decimal.
Sure:
test= SELECT x'10'::integer;
int4
--
16
(1 row)
Oh, some time ago I was looking for such a function and somehow
Title: FW: [GENERAL] Help with order by into a RECORD
Hi
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
Kind Regards,
Shaun Clements
Shaun Clements wrote:
Or better yet.
Can anyone explain the use of indexing, effecting the performance of select
query, using INDEXED columns, and non indexed columns.
I.E.
Select from table where column1 = '' and column2 = 'x'
WHERE COLUMN1 is indexed, and COLUMN2 isnt.
Well, if PG
Title: FW: [GENERAL] Help with order by into a RECORD
Yes,
you can use ORDER BY on the table whiwh have an or several
index.
Index
allows to save time during execution of request.
-Message d'origine-De:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]De la part de Shaun
Shaun Clements wrote:
Hi Richard
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
You can ORDER BY any combination of columns/expressions, whether they
are indexed or not. An index may make things quicker (it isn't
guaranteed to do
Title: RE: : [GENERAL] Postgres order by into a RECORD, not ordering
Hi Again.
I hope you can explain this.
I have a stored procedure which does a query of a table using order by, into a RECORD.
The statement I mentioned earlier, is a FOR IN.
the data stored into the RECORD, is not ordered
Joseph M. Day wrote:
Just out of curiosity, what is the performance of this? In MSSQL the
only way to do something equivalent to this was to use a cursor. Cursors
are painfully slow, so they are to be used as a last resort.
On what do you base that cursors are slow?
--
Alban Hertroys
Title: RE: : [GENERAL] Postgres order by into a RECORD, not ordering
RESOLVED.
It must be a bug in 7.3
I resolved the problem, by changing the FOR IN statement to FOR IN EXECUTE.
By changing the Statement into a string, it accommodated for the ORDER BY.
Thanks for all your responses.
Hi,
I am working with inheritance in postgresql 7.4. If I create a table named A,
and another named B that inherits from A, if I perform a query such a
SELECT * FROM A (without ONLY clause),
how can I get the type (identifier from pg_type) of the returned records??
Thanks in advance.
--
Title: RE: : [GENERAL] Postgres order by into a RECORD, not ordering
Ignore last email.
must
have been delayed.
Kind Regards,Shaun
Clements
-Original Message-From: Shaun Clements
[mailto:[EMAIL PROTECTED]Sent: 01 April 2005 12:22
PMTo: 'Richard Huxton'Cc: PostgreSQL
Hi,
Is there any utility to trace the PostgreSQL backend activities like profiler in MS-SQL or any other related tool.
Thanking you
Regards,
R.Muralidharan
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
Mr Muralidharan Ramakrishnan wrote:
Hi,
Is there any utility to trace the PostgreSQL backend activities like
profiler in MS-SQL or any other related tool.
What information does MS-SQL profiler show?
--
Bruce Momjian| http://candle.pha.pa.us
-Forwarded Message-
From: Przymuszala Zsolt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [webmaster] in Search of free hosting with PostgreSQL
Date: 30 Mar 2005 09:45:59 +0200
Hello!
I'm from Hungary where the free webhosting servicers have only MySql.
Thats while I need
As an academic exercise it would be interesting to try and create the
*next* RDBMS query language. In a production environment I do think the
idea is crazy.
I've got a little experience with this. Interbase used to support a more
procedural query language called GDML (along with SQL). I used
Robert Treat wrote:
-Forwarded Message-
From: Przymuszala Zsolt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [webmaster] in Search of free hosting with PostgreSQL
Date: 30 Mar 2005 09:45:59 +0200
Hello!
I'm from Hungary where the free webhosting servicers have only MySql.
Thats while
On Fri, Apr 01, 2005 at 10:37:11 +0200,
[EMAIL PROTECTED] wrote:
And idea that just came up around here that sounds like a pretty neat
workaround, which we're gonna try, is to drop the foreign key
constraints, and just use a check constraint for the allowed values. If
the cardinality of
On Fri, Apr 01, 2005 at 11:42:35 +0200,
Shaun Clements [EMAIL PROTECTED] wrote:
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
Whether or not a table is indexed doesn't affect whether or not you can
use ORDER BY. It may
Philippe Lang [EMAIL PROTECTED] writes:
Documentation mentions that PGSQL 8 supports a version of PL/PERL with
composite return values. Is there a way to install this new version of
PL/PERL on an old 7.4 database,
No. The rest of it might work, but not that feature, at least not
without
Miguel Angel Tribaldos Hervas [EMAIL PROTECTED] writes:
I am working with inheritance in postgresql 7.4. If I create a table named A,
and another named B that inherits from A, if I perform a query such a
SELECT * FROM A (without ONLY clause),
how can I get the type (identifier from pg_type) of
On Fri, 2005-04-01 at 00:36, vinita bansal wrote:
Hi,
I have a 64 bit Linux box with 64GB RAM and 450GB HDD. I am running a
benchmark on database of size 40GB using the following settings:
- data=writeback
You might want to read this post about ext3 with writeback:
On Fri, Apr 01, 2005 at 12:42:19PM +0200, Miguel Angel Tribaldos Hervas wrote:
I am working with inheritance in postgresql 7.4. If I create a table named A,
and another named B that inherits from A, if I perform a query such a
SELECT * FROM A (without ONLY clause),
how can I get the type
Hi everyone,
I ran into a brick wall when I realized that inheritance in postgres isnt
really there...
Here's a description of the relevant part of my schema.
CREATE TABLE base (
id serial not null primary key,
some base columns
);
CREATE TABLE specialized (
some specialized columns
)
Hi,
Are there any best practices for optimizing triggers,
and, I suppose, stored procedures as well? I am now
starting on optimization and before I begin am
hoping to avoid re-inventing the wheel.
The problems I see are:
1) There is no way to profile where a problem lies.
When there are large
That's exactly what I am looking for. Thank you Dawid and everyone for
your help.
Regards
chandu
-Original Message-
From: Dawid Kuroczko [mailto:[EMAIL PROTECTED]
Sent: Friday, April 01, 2005 3:28 AM
To: Doug Quale
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help with
On Fri, 2005-04-01 at 04:32, Alban Hertroys wrote:
Joseph M. Day wrote:
Just out of curiosity, what is the performance of this? In MSSQL the
only way to do something equivalent to this was to use a cursor. Cursors
are painfully slow, so they are to be used as a last resort.
On what do
On Fri, Apr 01, 2005 at 12:36:53PM +0200, Shaun Clements wrote:
RESOLVED.
It must be a bug in 7.3
Before reaching that conclusion, let's see what you were doing.
I resolved the problem, by changing the FOR IN statement to FOR IN EXECUTE.
By changing the Statement into a string, it
Greetings worthymen.
I have a question regarding filesystem disk space usage.
We have a production database containing 5 years of sales data.
Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database
everynight (about 40min).
It's size, @SUM(pg_class.relpages) * 8192K, is ...
About 66
On Apr 1, 2005 9:21 AM, David Link [EMAIL PROTECTED] wrote:
Greetings worthymen.
I have a question regarding filesystem disk space usage.
We have a production database containing 5 years of sales data.
Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database
everynight (about
On 04/01/2005 10:19:55 AM, Karl O. Pinc wrote:
Hi,
Are there any best practices for optimizing triggers,
and, I suppose, stored procedures as well?
The solutions I see are to use:
SET client_min_messages DEBUG1;
SET debug_print_plan TRUE;
and maybe
SET log_executer_stats TRUE;
Ok, this strategy
On Fri, 2005-04-01 at 11:21, David Link wrote:
Greetings worthymen.
I have a question regarding filesystem disk space usage.
We have a production database containing 5 years of sales data.
Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database
everynight (about 40min).
It's
Hi,
I have not tried all the settings on the big database but yeah I have tried
most of the settings and I am not seeing any performance improvement. Rather
I would say that there was a performance degradation in my case when I used
some of the settings used for small database (like decreasing
David Fetter wrote:
== PostgreSQL Weekly News - April 01 2005 ==
As of today, the license of PostgreSQL, including all its libraries,
is changing from the unfashionable BSD license to the more popular
GPL.
Fine I can't see the difference, but have you not got to clear this
with every
Peter Childs [EMAIL PROTECTED] writes:
Either this message is a joke, Or you have all gone mad?
I see a postpostgres on the horizon.
What time zone are you in?
Think about the date.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
El Vie 01 Abr 2005 17:00, Peter Childs escribió:
David Fetter wrote:
== PostgreSQL Weekly News - April 01 2005 ==
As of today, the license of PostgreSQL, including all its libraries,
is changing from the unfashionable BSD license to the more popular
GPL.
Fine I can't see the
Is there a way to do a case sensitive group by.
Thanks.
Lewie
On Fri, Apr 01, 2005 at 09:00:15PM +0100, Peter Childs wrote:
David Fetter wrote:
== PostgreSQL Weekly News - April 01 2005 ==
As of today, the license of PostgreSQL, including all its libraries,
is changing from the unfashionable BSD license to the more popular
GPL.
Fine I
On Fri, Apr 01, 2005 at 14:00:40 -0700,
Krause, Lewis [EMAIL PROTECTED] wrote:
Is there a way to do a case sensitive group by.
It should be that way by default. If you want case insensitive, then
you can group by lower(whatever).
---(end of
Hi -
This has been covered elsewhere, but the typical answers seem to
involve using triggers, etc.
What's the best way to insert a row into a table providing it's not
already there? In my client (Python) program, I can do two separate
interactions with the server, the first a query:
select
Jim C. Nasby wrote:
On Fri, Apr 01, 2005 at 09:00:15PM +0100, Peter Childs wrote:
David Fetter wrote:
== PostgreSQL Weekly News - April 01 2005 ==
As of today, the license of PostgreSQL, including all its libraries,
is changing from the unfashionable BSD license to the more popular
On Apr 1, 2005, at 3:00 PM, Peter Childs wrote:
Either this message is a joke, Or you have all gone mad?
I see a postpostgres on the horizon.
no, dave broke tradition and posted an entirely factual newsletter on
april 1. I think he should lose his job for that. :-)
On Fri, Apr 01, 2005 at 04:20:01PM -0500, Vivek Khera wrote:
On Apr 1, 2005, at 3:00 PM, Peter Childs wrote:
Either this message is a joke, Or you have all gone mad?
I see a postpostgres on the horizon.
no, dave broke tradition and posted an entirely factual newsletter on
Hi Michael,
Thanks a lot for your response.
Basically I am selecting out one row from the database with multiple
columns (should have told you that earlier) so it seems that unfortunately
your elegant approach below might not work. Although some of the columns
are text and some numeric I was
Alvaro,
I suppose there must be reasons not to do this, but have you considered
using the slack space (empty space) in an ordinary table heap page
to store share-locks on the tuples in that page? (If not enough space
is available then you would still need to use the spilled-to-disk btree
On Sat, Apr 02, 2005 at 12:29:15PM +1200, Zitan Broth wrote:
Basically I am selecting out one row from the database with multiple
columns (should have told you that earlier) so it seems that unfortunately
your elegant approach below might not work. Although some of the columns
are text and
On Fri, Apr 01, 2005 at 07:41:54PM -0500, Paul Tillotson wrote:
Hi,
I suppose there must be reasons not to do this, but have you considered
using the slack space (empty space) in an ordinary table heap page
to store share-locks on the tuples in that page? (If not enough space
is
Hi Michael,
Good question :-)
I am writing a function that has a row of data passed into it as variables
and an ID. The function needs to pull out the appropriate row of data and
compare each data item which those passed in. For each found difference a
log row is written somewhere else and if
Tom Lane wrote:
Tatsuo Ishii [EMAIL PROTECTED] writes:
It seems HISTORY has not been updated yet. Is this intended?
Someone (probably Bruce or me) will do release notes before the
release. This is just a beta to find out if we broke anything ...
8.0.2 release notes are updated.
--
Hello,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed just like any other pl
language.
Are we interested in having plPHP in core?
Sincerely,
Joshua
I suppose there must be reasons not to do this, but have you considered
using the slack space (empty space) in an ordinary table heap page
to store share-locks on the tuples in that page? (If not enough space
is available then you would still need to use the spilled-to-disk btree
structure.)
Joshua D. Drake wrote:
Hello,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed just like any other pl
language.
Are we interested in
On Fri, Apr 01, 2005 at 10:14:07PM -0500, Paul Tillotson wrote:
Would it work for an updater, who finds that the locks list (currently
located in the middle of the empty space) is in the way of a new tuple
that he wants to insert, to take some kind of lock, move the whole list
up or down
On Fri, Apr 01, 2005 at 07:11:14PM -0800, Joshua D. Drake wrote:
Hi Joshua,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed just like any
Alvaro Herrera [EMAIL PROTECTED] writes:
On Fri, Apr 01, 2005 at 10:14:07PM -0500, Paul Tillotson wrote:
...
Well, at that point you need to take a lock in order to be able to
manage locks. Managing not to step on your own feet in that scenario
is complex, to say the least, if not downright
Tom Lane [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Fri, Apr 01, 2005 at 10:14:07PM -0500, Paul Tillotson wrote:
...
Well, at that point you need to take a lock in order to be able to
manage locks. Managing not to step on your own feet in that scenario
is
On Fri, 1 Apr 2005, Joshua D. Drake wrote:
Hello,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed just like any other pl
language.
Are we interested
Marc G. Fournier [EMAIL PROTECTED] writes:
On Fri, 1 Apr 2005, Joshua D. Drake wrote:
Are we interested in having plPHP in core?
Is there a reason why it can no longer operate as a standalone language
out of pgfoundry, like pl/java and pl/perl?
PLs are sufficiently tightly tied to the core
In other words it can be installed just like any other pl
language.
Are we interested in having plPHP in core?
Yes , it must come into the core as PHP developers would now get
tempted to write functions inside database this would cut out
adoption of Databases which do not have PHP type
Marc G. Fournier wrote:
On Fri, 1 Apr 2005, Joshua D. Drake wrote:
Hello,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed just like any other pl
Alvaro Herrera wrote:
On Fri, Apr 01, 2005 at 07:11:14PM -0800, Joshua D. Drake wrote:
Hi Joshua,
We at Command Prompt are in the process of completing
a new rev of plPHP. The new rev will not require the
PHP source. It will only require that PHP is installed.
In other words it can be installed
I'm thinking that a pl/PHP is much more interesting for the long term
than, say, pl/tcl (mind you, I am a Tcl partisan from way back, but
I see that many people are not so enlightened). Barring any licensing
problems I think this is something to pursue.
Per the license issue it is licensed
Tom Lane wrote:
PLs are sufficiently tightly tied to the core that it's probably
easier to maintain them as part of our core CVS than otherwise.
(Ask Joe Conway about PL/R.
As a matter of fact, let's ask him.
Thomas Hallgren is probably not that
happy about maintaining pl/java out of core,
Peter Eisentraut [EMAIL PROTECTED] writes:
I'm not convinced that PLs are more tied to the core than say OpenFTS,
and if we can't maintain that kind of thing externally, then this whole
extension thing sounds like a failure to me.
It's *possible* to do it. Whether it's a net savings of
On Sat, 2 Apr 2005, Peter Eisentraut wrote:
I'm not convinced that PLs are more tied to the core than say OpenFTS,
and if we can't maintain that kind of thing externally, then this whole
extension thing sounds like a failure to me.
As many times as Peter and I butt heads, on this I have to agree
Greg Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
I looked at Paul's first message and thought nah, that won't work
because ... because ... hmm ... hmmm ...
For what it's worth, this would be very similar to how Oracle handles such
locks.
[ slightly alarmed ] Do they
One key point to note here is Joshua already saying they wish, like
plPerl, to continue maintaining the core code outside of the core
distribution ... the way I read that is they just want to be 'in core' to
piggy back on the distribution, not to make development/maintenance any
easier ...
Marc G. Fournier [EMAIL PROTECTED] writes:
Also, since plPerlNG is maintained on PgFoundry, are the changes you are
making to core getting migrated back to the main project itself?
I don't know, and not being a maintainer of the pgfoundry project,
it is *definitely* not my problem. But I
70 matches
Mail list logo