Thanks, It worked for me.
Regards,
Anuj Pankaj
Phone(O): 91-20-66041700, Ext.6477
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Friday, September 17, 2010 11:29 AM
To: Anuj Pankaj
Cc: Tom Lane; Devrim GÜNDÜZ; pgsql-admin@postgresql.org
Subject: Re: [ADMIN
Scott Marlowe wrote:
You do not need the packages to uninstall them. do this:
rpm -qa|grep -i postgres
and see what packages are listed.
Then
rpm -e packagename1 packagename2 ...
to remove them all.
Note that you may have issues removing the compat-postgresql-libs
packages, as things
2010/9/16 Anuj Pankaj :
> Can you help let me how to uninstall postgres, if I do not have packages at
> Linux box.
You do not need the packages to uninstall them. do this:
rpm -qa|grep -i postgres
and see what packages are listed.
Then
rpm -e packagename1 packagename2 ...
to remove them all
Can you help let me how to uninstall postgres, if I do not have packages at
Linux box.
Regards,
Anuj Pankaj
Phone(O): 91-20-66041700, Ext.6477
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, September 16, 2010 8:16 PM
To: Anuj Pankaj
Cc: Devrim GÜNDÜZ; pgsq
Craig James wrote:
> given what you have told us about your application, it is probably
> not very important if a few ORDER ID numbers are missing.
I'm not so sure. If these are considered accounting records which
may be audited by a CPA firm, I would definitely check with the
accountants bef
don...@caltech.edu writes:
> I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process
> running automatically to make temp files in pgsql_tmp folder, I don't do
> any query on my database. Anybody knows what's wrong with it? and how to
> find what the postmater process is for
Look in
Hi,
I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process
running automatically to make temp files in pgsql_tmp folder, I don't do
any query on my database. Anybody knows what's wrong with it? and how to
find what the postmater process is for
Thanks
Dong He
--
Sent via pgsq
On 9/16/10 4:17 PM, Aras Angelo wrote:
Daniel, Craig
The gaps are not really expected. It is set once only.
Its about printing packing slips for ecommerce orders. We have the ORDER ID
sequence, but so many different stations are accessing these orders, if my
station print the next 100 orders f
Dumb i am.. nextval() already issued the next one to the sequence.
I probably dont need a separate table.
On Thu, Sep 16, 2010 at 4:17 PM, Aras Angelo wrote:
> Daniel, Craig
>
> The gaps are not really expected. It is set once only.
> Its about printing packing slips for ecommerce orders. We hav
Daniel, Craig
The gaps are not really expected. It is set once only.
Its about printing packing slips for ecommerce orders. We have the ORDER ID
sequence, but so many different stations are accessing these orders, if my
station print the next 100 orders from the que, id like to give them values
st
On 9/16/10 3:54 PM, Aras Angelo wrote:
Hello All
I have a column in my table which is incrementally updated.
Try to give us more details...
Does the column need have contiguous values or are "gaps" ok? That is, does it
have to be 1,2,3,4,...,N-1,N or is it ok to have something like 1,3,4,7,
On 09/16/2010 10:54 PM, Aras Angelo wrote:
Hello All
I have a column in my table which is incrementally updated. I cant set
this field to be a SERIAL because the value is not assigned at the
time of the INSERT, it is assigned later by the system by an UPDATE.
Whats the best way to achieve thi
Hello All
I have a column in my table which is incrementally updated. I cant set this
field to be a SERIAL because the value is not assigned at the time of the
INSERT, it is assigned later by the system by an UPDATE.
Whats the best way to achieve this by means of performance? Should i set the
MAX
Alanoly Andrews writes:
> To expand on that question:
> Suppose I have a table with the following schema:
> tab1(col1 decimal(3,0), col2 char(3)).
> There is an index defined on it as : create index tab1ind1 on tab1(col1)
> Now, if I have a query as: "select * from tab1 order by col1", I
>
To expand on that question:
Suppose I have a table with the following schema:
tab1(col1 decimal(3,0), col2 char(3)).
There is an index defined on it as : create index tab1ind1 on tab1(col1)
Now, if I have a query as: "select * from tab1 order by col1", I expect the
Optimizer to use the ind
Alanoly Andrews writes:
> I'd like to know whether Postgres (8.4) supports bidirectional traversal of
> indexes.
If you defined exactly what you meant by that, you might get useful
answers. There are some features in there that might be what you mean,
or then again maybe not.
Anuj Pankaj writes:
> To install Postgres I created a folder Postgres and I kept all packages and I
> installed Postgres from these packages.
> To Uninstall Me suppose, I have to run rpm -e . Here
> mistakenly I removed all packages.I
I rather doubt that rpm would have let you remove "all" pac
Hello,
I'd like to know whether Postgres (8.4) supports bidirectional traversal of
indexes.
Thanks.
Alanoly.
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distributi
18 matches
Mail list logo