On Mon, 27 Feb 2006, S.Thanga Prakash wrote:
Dear sir,
We are already in the process of migrating toward 8.1 .
For existing support, we like to support with 7.1.3 .
Along with 7.1.3 release, contrib/array has been given for array iterator
support for int4 type array. It is working fine
Dear sir,
We are already in the process of migrating toward 8.1 .
For existing support, we like to support with 7.1.3 .
Along with 7.1.3 release, contrib/array has been given for array iterator
support for int4 type array. It is working fine.
We changed it similarly, for int8 type array.
On Fri, Feb 24, 2006 at 03:04:27PM -0800, Steve Oualline wrote:
> Question: How can I tell how much free space is in the database itself?
contrib/pgstattuple shows dead tuple and free space statistics for
individual tables. Will that work?
> Background: We want to keep as many records as possibl
On Mon, Feb 27, 2006 at 00:25:57 +0300,
Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
> On 2/26/06, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
>
> past'. Yes, standard is 'talkative', but I prefer only standard
> things, because it helps me to understand other databases and
> 'academical things
Tom ~
Thanks ever so much for - again - helping me get unstuck. See comments and
results inserted below.
~ Ken
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 26, 2006 1:47 PM
> To: [EMAIL PROTECTED]
> Cc: PostgreSQL pg-general List
> Subject: Re
Chris Velevitch wrote:
On 2/27/06, Russell Smith <[EMAIL PROTECTED]> wrote:
Not necessarily. How many rows are there in the table at the moment.
If pg uses and index, it first has to get the index page, then get the
heap page. So if you have a small number of blocks in the heap it's
actually
On 2/27/06, Russell Smith <[EMAIL PROTECTED]> wrote:
> Not necessarily. How many rows are there in the table at the moment.
> If pg uses and index, it first has to get the index page, then get the
> heap page. So if you have a small number of blocks in the heap it's
> actually cheaper to just sca
Russell Smith <[EMAIL PROTECTED]> writes:
> Chris Velevitch wrote:
>> If I'm reading this right, it's telling me that is NOT using any indexes.
>> Clearly, this is wrong.
> Not necessarily.
> ...
> If you post "explain analyze" instead of "explain" and possibly the
> number row in that table, we
Tom Lane wrote:
> Bruce Momjian writes:
> > Currently we output the ctid as a string:
> > snprintf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);
> > Perhaps someday we should consider outputting that as an array or a
> > result set:
>
> It's not an array, because the two components
Chris Velevitch wrote:
In pg v7.4.5, I have this query:-
select *
from activities
where activity_user_id = 2 and activity_type = 1 and activity_ts < now()
order by activity_ts desc
limit 1;
where activity_user_id is a non-unique index and activity_ts is a
non-unique index.
When I explain it, I
In pg v7.4.5, I have this query:-
select *
from activities
where activity_user_id = 2 and activity_type = 1 and activity_ts < now()
order by activity_ts desc
limit 1;
where activity_user_id is a non-unique index and activity_ts is a
non-unique index.
When I explain it, I get:-
Limit (cost=46.3
Nikolay Samokhvalov wrote:
On 2/26/06, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
Please help.
how?
1. Pick an item on the list.
2. Join the -hackers list and ask for info on where to start and discuss
what you want to change.
3. Start coding.
--
Postgresql & php tutorials
http://www.de
'k, I just checked all the lists you listed, and you are subscribed to
each of them ... are you not receiving messages?
On Sun, 26 Feb 2006, Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-02-26 14:36:47 -0400:
On Sun, 26 Feb 2006, Roman Neuhauser wrote:
Hello,
I've been waiting five
On 2/26/06, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> Please help.
how?
is there any place where postgres' SQL:2003 incompatibilities are
being discussed?
I really want to have standard-compatible PostgreSQL and some option
in postgresql.conf that would allow me to restrict Postgres' SQL
synta
It is certainly capable of running an ERP system from a technical standpoint,
just that the major commercial vendors don't support it in their
applications. If you were writing your own system though (or if you wanted
to port one), you should be fine.
On Sunday 26 February 2006 14:19, Farhad
On Sun, 2006-02-26 at 12:08 -0500, Tom Lane wrote:
> We'd consider removing these features if they were actually blocking
> support of some spec-required behavior ... but since they don't, it's
> quite unlikely they'll ever be removed.
Right; there are plenty of places in which PostgreSQL extends
Tino Wildenhain <[EMAIL PROTECTED]> writes:
> Hanan Bentaleb schrieb:
>> It has been reported to me that the main problem encountered with former
>> postgresql versions is that when a process performs an update (of a
>> record in any table), the whole database was locked
> I wonder how they manage
On 2/26/06 12:12 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> That just indicates that the data was sent to the backend without error.
> You forgot to check the copy command result afterward.
Ok, after re-reading the docs for the 10th time, I see I missed that I need
to paragraph about calling 'PQ
# [EMAIL PROTECTED] / 2006-02-26 20:15:20 +0100:
> # [EMAIL PROTECTED] / 2006-02-26 14:36:47 -0400:
> > On Sun, 26 Feb 2006, Roman Neuhauser wrote:
> >
> > >Hello,
> > >
> > >I've been waiting five months for the majordomo moderators to approve
> > >my subscription requests to several @postgresql.
[EMAIL PROTECTED] (Farhad) wrote:
> I'm looking for any experience on runing an ERP software (Oracle
> application, SAP, PeopleSoft, ...) on top of a postgre data base.
You won't find it, for two reasons:
1. There's no such thing as "postgre"
The proper name is PostgreSQL, though people are oft
Hanan Bentaleb schrieb:
> Hi Tino,
>
> Thanks for your response! I did not provide more specific technical
> details because I just came in to the project. So, I will try to provide
> as much information as I can.
>
> Former versions of postgresql used in this project are postgresql
> (starting a
Hi Tino,
Thanks for your response! I did not provide more specific technical
details because I just came in to the project. So, I will try to provide
as much information as I can.
Former versions of postgresql used in this project are postgresql
(starting at 6). I will try to find out the exact r
Hi, Thanks for the link. More exactly I wanted to know how far PostgreSql is from the Oracle or DB2 regard the following point: Performances, Data volume management, Could PostgreSql handle the giga data? Backup and restore functionality. Thanks
Farhad"Jim C. Nasby" <[EMAIL PROTECTED]> w
# [EMAIL PROTECTED] / 2006-02-26 14:36:47 -0400:
> On Sun, 26 Feb 2006, Roman Neuhauser wrote:
>
> >Hello,
> >
> >I've been waiting five months for the majordomo moderators to approve
> >my subscription requests to several @postgresql.org mailing lists.
>
> the majordomo moderators don't have to
"Ken Winter" <[EMAIL PROTECTED]> writes:
> After trying about a million things, I'm wondering about the meaning of
> "OLD." as the actions in a rule are successively executed. What I have done
> assumes that:
> ...
> (b) The "OLD." values that appear in the second (INSERT) action in the rule
> ar
On Sun, 26 Feb 2006, Roman Neuhauser wrote:
Hello,
I've been waiting five months for the majordomo moderators to approve
my subscription requests to several @postgresql.org mailing lists.
the majordomo moderators don't have to approve subscribe requests, you
will auto-receive an email messag
Hello,
I've been waiting five months for the majordomo moderators to approve
my subscription requests to several @postgresql.org mailing lists.
I sent an email to [EMAIL PROTECTED] more than two months ago,
also without any reaction.
What should I do to spark someone's interest?
Pls cc me on re
Bruce Momjian writes:
> Currently we output the ctid as a string:
> snprintf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);
> Perhaps someday we should consider outputting that as an array or a
> result set:
It's not an array, because the two components are not of the same data
ty
Wes <[EMAIL PROTECTED]> writes:
> I sent the column headers as the first line of the input. While this I now
> know this is wrong, the problem here is that I got no error response back.
> ...
> However, every call to PQputCopyData, as well as PQputCopyEnd returned a
> result of 1.
That just indic
Clodoaldo Pinto wrote:
As part of a migration from 8.0 to 8.1 i want to convert the data from
ASCII to UTF-8.
I dumped the database with pg_dump (8.0) and tried to convert it with
iconv, but it shows an error:
$ iconv -t ASCII -t UTF-8 fahstats_data.dump -o fahstats_data_utf-8.dump
iconv: illeg
Hanan Bentaleb schrieb:
> Hi all,
>
>
>
> I am working on an application that involves multiple processes
> accessing and updating different databases: tables are split into 3
> different databases that are accessed by 3 different processes. This
> architectural decision was made in the past be
Hi all,
I am working on an application that involves multiple processes
accessing and updating different databases: tables are split into 3 different
databases that are accessed by 3 different processes. This architectural
decision was made in the past because it has been noticed that f
"chris smith" <[EMAIL PROTECTED]> writes:
> On 2/26/06, Jebus <[EMAIL PROTECTED]> wrote:
>> Is it possible to give a group the the createuser permission ? This
>> way if a user in the group they can create users.
> Version 8.1.x does..
Note that even in 8.1, the special privileges like CREATEROLE
On Sun, Feb 26, 2006 at 10:36:23AM +0200, Andrus Moor wrote:
> It is difficult to write standard-compliant code in Postgres.
> There are a lot of constructs which have SQL equivalents but are still used
> widely, even in samples in docs!
>
> For example, there are suggestions using
...
> Bruce
"Andrus Moor" <[EMAIL PROTECTED]> writes:
> For example, there are suggestions using
> now()::CHAR!=foo
> while the correct way is
> CAST(CURRENT_DATE AS CHAR)<>foo
> now() function, :: and != operators should be removed from language.
Your second example requires twice as much typing as your
On Sun, Feb 26, 2006 at 04:55:21AM -0800, Farhad wrote:
> Hi All,
> I'm looking for any experience on runing an ERP software (Oracle
> application, SAP, PeopleSoft, ...) on top of a postgre data base.
The database is called PostgreSQL or Postgres, not Postgre.
Search for ERP and Postgres on h
-Original Message-
From: "Mark Morgan Lloyd"<[EMAIL PROTECTED]>
Sent: 26/02/06 14:33:55
To: "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] psql client binary
> Thanks Bruce. So in general NT4 is out as a > client and I might not even be
> able
> to install pgAdmin as a binary.
> > > Hopefully not to grievous an FAQ: can anybody point me at a
> > > precompiled binary of the psql terminal-based front-end
> to run on NT
> > > hopefully not requiring Cygwin, or has this been
> effectively replaced by pgAdmin?
> >
> > pginstaller has such a psql binary that should work o
Bruce Momjian wrote:
>
> Mark Morgan Lloyd wrote:
> > Hopefully not to grievous an FAQ: can anybody point me at a precompiled
> > binary of the psql terminal-based front-end to run on NT hopefully not
> > requiring Cygwin, or has this been effectively replaced by pgAdmin?
>
> pginstaller has such
On 2/26/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Stuart Grimshaw <[EMAIL PROTECTED]> schrieb:
>
> > I'm writing a script to clean up some data in a table, the data I'm
> > using as the source is held in emails, so I've written a perl script
> > to extract the info. Unfortunatly this emai
Stuart Grimshaw <[EMAIL PROTECTED]> schrieb:
> I'm writing a script to clean up some data in a table, the data I'm
> using as the source is held in emails, so I've written a perl script
> to extract the info. Unfortunatly this email doesn't contain the
> client id, so I've written a stored procedu
Stuart Grimshaw <[EMAIL PROTECTED]> schrieb:
> I'm writing a script to clean up some data in a table, the data I'm
> using as the source is held in emails, so I've written a perl script
> to extract the info. Unfortunatly this email doesn't contain the
> client id, so I've written a stored procedu
> > Yes, it's still an open report. Sorry, about that and all the other open
> > bug reports/feature requests. I do not have the time at the moment to
> > even reproduce bugs. Hopefully this will become better in the near
> > future.
>
> Should we add this to TODO? Anything else?
Yes, please add
I'm writing a script to clean up some data in a table, the data I'm
using as the source is held in emails, so I've written a perl script
to extract the info. Unfortunatly this email doesn't contain the
client id, so I've written a stored procedure to extract it.
create or replace function get_clie
Hi All, I'm looking for any experience on runing an ERP software (Oracle application, SAP, PeopleSoft, ...) on top of a postgre data base. Best Retards
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
Mark Morgan Lloyd wrote:
> Hopefully not to grievous an FAQ: can anybody point me at a precompiled binary
> of the psql terminal-based front-end to run on NT hopefully not requiring
> Cygwin, or has this been effectively replaced by pgAdmin?
pginstaller has such a psql binary that should work on N
Hopefully not to grievous an FAQ: can anybody point me at a precompiled binary
of the psql terminal-based front-end to run on NT hopefully not requiring
Cygwin, or has this been effectively replaced by pgAdmin?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the autho
> Hello, I am very new to postgreSQL I am using the win32
> platform is there a website URL that has Sample Client Apps
> written for win32?
>
> I need Samples of very basic things like:
>
> Connect to a db on a remote server
> create new db
> create table
> add records
> drop records
>
> ect.
As long as the SQL standard is supported, support for the "ancient" syntax
shouldn't be removed - at least not without a very long period of transition.
Do you have any idea how many applications the removal of something simple
like the cast operator :: will break?
It's not difficult to write sta
On Thu, 2006-02-23 at 17:12 -0300, Carlos Henrique Reimer wrote:
> When the pg_locks view is used the internal lock manager data
> structures are momentarily locked and that is why I would like to know
> if some application is reading the pg_locks view and how many times.
>
> Is there a way to di
It is difficult to write standard-compliant code in Postgres.
There are a lot of constructs which have SQL equivalents but are still used
widely, even in samples in docs!
For example, there are suggestions using
now()::CHAR!=foo
while the correct way is
CAST(CURRENT_DATE AS CHAR)<>foo
now() fu
51 matches
Mail list logo
