Dear Ashok ,
hi
i am a new user in postgresql.
If you are from Kalculate team which
developed first Financial software in India with QT and PostgreSQL as
back end then
for me this is a prank that a member of Kalculate team addresses
himself to be new to PostgreSQL.
Chauhan saab give us s
Dear Ashok,
Hope you are not using
Postgresql 7.4
if this is the case I think some insert /update statements are waiting
for commit command
Regards,
V Kashyap
hi
i am a new user in postgresql.
problem:- in postgresql there is any command to see history (previous
day queries) like as history com
Dear Jim Cochrane,
I'm looking for help restoring old postgres databases on a linux system
after a reinstall of Redhat (including posgresql). It's the same version
of redhat and of postgres I was using before the resinstall, but I've not
been able to get the database server to see the old databas
Dear Ramesh PAtel ,
Will you like to tell us what version are you using
i have three database on one server. when i backup is done complete.
but after backup my pc's speed is very slow. it is requery to restart PC.
try doing vaccumdb
Regards,
V kashyap
---(end o
Dear all ,
Permit me to gain some of your most valuable knowledge ...
Our intrAnet server has the following spec
1. RH 9.0
2. Postgresql 7.3.4
3. PHP 4.3.3
4. GCC 3.2.2
Till date my front end language (PHP) use to simply pass the data to
postgresql in case of insert and
update we were
Dear Robert Treat ,
First of all accept gratitude for answering the question
phppgadmin=# set autocommit = off;
ERROR: SET AUTOCOMMIT TO OFF is no longer supported
phppgadmin=#
Now does this mean that their must exist some PHP.INI file option that
will make client side auto commit on
Bu
Dear Anjan Dave ,
Upgrading from 7.2.4 (RH 8) to 7.4 (RH9)
I would like to start planning on
upgrading a few servers from RH8 to RH9, essentially, also upgrading
Postgres from 7.3.2 to 7.4 from the OS.
There's also a box with RH7.3
(postgres 7.2.1) that could be upgraded to RH9 an
Dear all,
Please vote for this
http://bugs.php.net/26592
So that in next release of PHP we can set autocommit = off from with in
PHP.ini
Regards,
V Kashyap
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://a
Dear all ,
I have created my tables without OIDS now my doubts are :
1. Will this speed up the data insertion process
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave internally differently
2. Will my appli
Dear all ,
I have created my tables without OIDS now my doubts are :
1. Will this speed up the data insertion process
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave internally differently
2. Will my applica
Hello Neil Conway,
We are doing some test on our applications and will let know the
community if without OIDS we could gain
more speed .
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave internally
Hello all ,
I am a OpenSource S/W developer and my clients are from remote part of
Himachal Pradesh India.
I am providing my clients,
software
Build on PostgreSQL 7.3.x as backed
and yes , they (clients) ought to save a lot while using my software as
it runs on Linux
But theirs one Prick Our
Dear all ,
This may be considered an information :
If you have created your table as
WITHOUT OIDS;
Then your data would not be retrieved into
1. OOo 1.1 < versions SpreadSheet
2. StarOffice 7.0 < version SpreadSheet
3. Excel Office XP
Yes pgsqlODBC is used for interface .
For full details please
Dear Van L. Loggins ,
What methods are available to easily backup the contents of a PostgreSQL database?
PostgreSQL both file system backup option and SQL data in form of
insert statement :
Note: I have done this thing with > PostgreSQL 7.3
This is what I do
1. Take a file system backup of
I forgot to add one thing :
For file system backup and restore PostgreSQL must be stoped
Regards
V Kashyap
Dear Van L. Loggins ,
What methods are available to easily backup the contents of a
PostgreSQL database?
PostgreSQL both file system backup option and SQL data in form of
insert statem
Dear all,
Before reading all this let me assure you nothing is out of control just
DONT PANIC
I was just going through the pages of http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to
Fri Dec 13 20:45:52 1901
after
Tue Jan 19 03:14:07 2038
Now thi
Hello ,
Hmmm
This concernes me to does anyone has answers for this please .
and Oli if you get this answer from some other posts please forward it
here also.
Regards,
Vishal Kashyap
Hello
I have heard that UNIX I/O buffer sometimes causes problems during
system crash because it keeps files
Dear all ,
In one of our project I require to calculate antilog of (3.3234)
But I could not find any functions in Documentation for the same.
In mathematics I would have written it something like
A = antilog (3·3234) = 2144
Any suggestions or links are most welcome .
Regards,
Vishal Kashyap.
Dear Martin Marques ,
In mathematics I would have written it something like
A = antilog (3·3234) = 2144
As I can understand, this is a 10 base log, so that what you want is
10^(3.3234)?
For that you have the exponential operator ^.
Nope
select exp(3.3234) as a2144
Gives me
27.7545558085
Dear Martin Marques and other kind people out their ,
In mathematics I would have written it something like
A = antilog (3·3234) = 2144
As I can understand, this is a 10 base log, so that what you want is
10^(3.3234)?
Though antilog did not solve my problem the link below helped me to
p
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
Also I would like to learn how professional users of PostgreSQL work
with rounding of monetary terms .
If you would like to know whats IEEE 754 read this
http://docs.sun
Dear Alexey Bobkov ,
Then a try to restore my data:
pg_restore /path_to_database/backup/db_backup.file
and get next error
pg_restore: [archiver] input file does not appear to be a valid archive
Use psql instead with command
psql -U username databasename -f yourdb_file.sql
Yes you will have to edi
Dear Jan Wieck ,
Floating point math itself is not precise, but rather an approximation,
usually of 8 or 14 digits. You can't approximate money. This isn't a
PostgreSQL issue but rather a general programming issue.
Thanks, Bruce. I assume the arbitrary precision arithmetic Jan
mentioned which
Dear Jan Wieck ,
Yes I agree with you Jan , most of the time we round the amount and
this is done by truncating greater than 3 decimal digits and
rounding the 3 digit to 2 in other words :
select trunc(1000.236897,3);
then
selecr round(1000.236,2);
This takes care of the rounding factor in m
Dear all ,
I know this is a wrong list to for this post
Anyways
We use bash script for database maintainace and implimenting new
schema in the production database
the script goes as
#!/bin/sh
until [ "$uname" ]
do
read -s uname
done
until [ "$pass" ]
do
read -s pass
done
psql -U $uname myda
Dear Peter Eisentraut
and my database migration would go smothly
That would be a security hole because then other users can read the
password using 'ps'.
Also would not like to set ~/.pgpass
Why not? That's what it's for.
Agreed and now we decided to use it but will ~/.pgpass work fo
Dear Ed Murphy ,
and all the PostgreSQL files. My question is if I restore this
snapshot will PostgreSQL work? I know if doing a typical file system
backup of PostgreSQL I must first stop the postmaster or the backup
will not produce a useable PostgreSQL system. Is it necessary to stop
the
Dear Peter Eisentraut ,
Loads of thanks for you kind and much needed help.
Best Regards,
Vishal Kashyap
Agreed and now we decided to use it but will ~/.pgpass work for
pg_dump
pg_restore
Yes, it works for all libpq programs.
---(end of broadcast)---
Dear Rajesh ,
> The release notes of upgrades usually indicate whether initdb
> is required or not. Generally when the last digit of a version
> change it does not require a dump and reload. In this case
> the release notes say:
>
> http://www.postgresql.org/docs/7.4/static/release.html#RELEAS
> However:
> <>http://www.postgresql.org/docs/7.4/static/release-7-4-2.html
> does say that dump/initdb/reload is an option to fix 2 errors.
> These two errors can also be fixed manually without dump / reload
> which is described in same URL.
>
Opps !! I was wrong and was in the impression
Hi
> I thought, that pg_restore will organize the restore-prozess in an optimal
> order. This seems not work correct!!?? I would be grateful to hear any
> hints.
pg_restore does not priortize till now idealy it must be like
restoring the functions >> tables >> views >> seqences so on...
This
Do you have sufficient space and is your file system NTFS
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Dear nilesh Ghone ,
I want to install PostgreSQL on my PC, (Operating System - Windows
2000 professional). I am following FAQ_mswin provieded by PostgreSQL
documentation.I have installed cygwin. While installation error
message occours - "cygcrypt-0.dll
We need some details as follows :
1. Tel
Dear all ,
Would like to receive your kind attention and enormous knowledge on the
following
I have a function
sai_func_a()
Which does as follows and in the same order:
1. Retrieves the latest record from the table test_sai
(By latest I mean the record corresponding to max primary key of t
Would like to receive your kind attention and enormous knowledge on
the following
This tickles me
I have a function
So what ?
sai_func_a()
Which does as follows and in the same order:
1. Retrieves the latest record from the table test_sai
(By latest I mean the record corresponding to max pri
Dear Oliver Elphick ,
If I am not wrong PostgreSQL select statements works on committed data
thus the new
inserted data at #3 must not be available to sai_func_b() till #5
No. All operations by a single transaction are visible inside the
transaction. Therefore an encapsulat
this helps
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: [EMAIL PROTECTED]
ICQ : 264360076
---
You Guys start coding I will take care of what
this customer
-a -d access backups/access/data.pg
I am
dumping from 7.2.4 (RH8 - RAID5 set) to 7.4.0 (RH9).
use -i switch for restore of data
Kindly shootback it this helps
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http
) 1.875
2. gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
3. Kernel 2.4.20-24.9
4. RH 9.0
What am I doing wrong ?
Thanks in advance.
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: [EMAIL PROTECTED]
I
take the Regression test failures seriously ?
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: [EMAIL PROTECTED]
ICQ : 264360076
Yahoo IM: [EMAIL PROTECTED
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap[ a t ]jabber.org
ICQ : 264360076
Yahoo IM: mailforvishal[ a t ]yahoo.com
---
You yoursel
postgres is the super user
you may login as
psql -U postgres template1
--
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap[ a t ]jabber.org
ICQ : 264360076
Yahoo
me if I had 500,000 rows, or a million, but 24,000?
For similar post someone suggested to do a count like
select count(*) from table where any = any limit 1 ;
Try this look if thiers any performance increase.
--
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control
Hope this helps
--
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Yahoo IM: mailforvishal[ a t ]yahoo.com
---(end of broadcast)---
TIP 6: Have you searched our list
iggies like tom etc.
--
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Yahoo IM: mailforvishal[ a t ]yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com [Soon http://www.saihertz.com]
Yahoo IM: coeb_college[ a t ]yahoo.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
46 matches
Mail list logo
