On Sun, 2004-06-27 at 21:05, Jay wrote:
> hi people
> i am trying to connect to ppstgresql on a debian system using perl . i
> am getting the following error .can any one please suggest what has to
> be done
>
>
> install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC
> contains: /etc
hi people
i am trying to connect to ppstgresql on a debian system using perl . i
am getting the following error .can any one please suggest what has to
be done
install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC
contains: /etc/perl /usr/local/lib/perl/5.8.3
/usr/local/share/perl/5.
"Jonathan Raemdonck" <[EMAIL PROTECTED]> writes:
> These are the steps I take now:
> 1 'draw' a box around the lat/lon position we have as input
> 2 search the DB for all the points in this box
> 3 measure the distance to each point in the box
Right. All you need is an index amenable to step 2.
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote:
>> STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
>> ERROR: tables can have at most 1600 columns
>> STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID INTEGER;
>> E
[EMAIL PROTECTED] (Thomas F. O'Connell) writes:
> Now I'm curious: why does pg_dump require that
> max_connections * max_shared_locks_per_transaction be greater than the
> number of objects in the database?
Not objects, just tables. pg_dump takes AccessShareLock (the weakest
kind of lock) on each
I have the following situation:
I'm developing an reverse geocoder, so input is lat/lon coordinate and
output is the nearest textual location.
I have a database of +- 2 000 000 records that contains lat/lon and full
name of the location.
These are the steps I take now:
1 'draw' a box around the
=?iso-8859-1?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes:
> It is strange that the laptop substantially faster then the server. The
> get_stock* functions are executed 2-3 times faster.
So what do those stored procedures do exactly?
What it smells like to me is a bad plan for a query executed in
Jay <[EMAIL PROTECTED]> writes:
> i tried the following command but nothing seems to work
> psql -U root -d root
> psql: FATAL: IDENT authentication failed for user "root"
You basically cannot use the -U switch when using IDENT authorization;
that auth mode requires that your presented Postgres u
1)from root su postgres
2)createuser the username
3)exit
4)su the user
5)createdb
psql the database
Jay wrote:
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user "root"
any suggestions
thanks
jay
Oliver Elphick w
hmmm, not sure that this is the best way.
under linux runing "./configure --help" will show you the default instlation
paths. go to each one of them and delete.
On future instelation you can consider
using --prefix=/usr/local/priv_dir_pg_what_ever_ver
dont forget to update PATH and ld.conf
chee
On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote:
> I found this error in /var/log/messages yesterday after a cron job
> wouldn't complete:
> STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
> ERROR: tables can have at most 1600 columns
> STATEMENT: ALTER TABLE v
Thanks Grega your explanation will go a far way, Thanks again
-- Adam --
Grega Bremec wrote:
...and on Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith used the keyboard:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that t
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness
I am attempting an install of 7.4.3 on
[EMAIL PROTECTED] (Thomas F. O'Connell) wrote in message news:
> postgresql.conf just has the default of 1000 shared_buffers. The
> database itself has thousands of tables, some of which have rows
> numbering in the millions. Am I correct in thinking that, despite the
> hint, it's more likely that
I found this error in /var/log/messages yesterday after a cron job
wouldn't complete:
STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
ERROR: tables can have at most 1600 columns
STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID INTEGER;
ERROR: tables can have at
Hi,
yes it is vacuumed regulary once a day. And vacuum full is done once a week.
The reasons of the slow seq scan are those two stored procedures in the
field list (get_stock and get_stock_getup). These take 13-20 ms every time
thay executed. Multiplying with the nr of rows we get 11-18 sec.
It i
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user "root"
any suggestions
thanks
jay
Oliver Elphick wrote:
On Sun, 2004-06-27 at 00:36, Jay wrote:
Hi group,
I am trying to get pgsql working on my debian system
On Sun, 2004-06-27 at 00:36, Jay wrote:
> Hi group,
> I am trying to get pgsql working on my debian system. I installed pgsql
> using apt-get. but then i cant connect to it . i am using the following
> command
> psql -U jay -d jaydb
>
> earlier i used create su postgres 'createdb root' jaydb.
hello,
Excuze me,
If I want to add localization support in my language Except the messages
in postgres, what parts, must be done in Glibc? and what parts must be
done in postgres?
LC_COLLATE,LC_CTYPE,LC_MONETARY,LC_NUMERIC,LC_TIME
I found that the collation order must be done in glibc.
What about F
Yes, yes you are right. :)
I had already modified that (using TG_OP variable) before I posted the
letter just didn't mentioned.
By the way the trigger does its task. Rally. :)
Thanks,
-- Csaba
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Harald Fu
In article <[EMAIL PROTECTED]>,
Együd Csaba <[EMAIL PROTECTED]> writes:
> Hi Stephan,
> it was the problem, but not realy understand the reason. The documentetion
> sais that perform doesn't porvide the return value and I thought I do not
> need that. But I read absently, and didn't realized that
Hi Stephan,
it was the problem, but not realy understand the reason. The documentetion
sais that perform doesn't porvide the return value and I thought I do not
need that. But I read absently, and didn't realized that the query to
perform must be a SELECT.
Thank you for opening my eyes. :) Now the
22 matches
Mail list logo
