Trying to connect to it throught perl code.
Just wondering if DBI would be the best tool to use to
accomplish this task.
Which version of DBI should I be using.
I mean if any one of you could give me exact pointers to it,
would be highly appreciated.
Yes, perl(DBI) is the canonical way
I have a connection that I am unable to kill with a sigint.
ps auxww for the process in question:
postgres 3578 0.3 3.6 6526396 1213344 ? SDec01 0:32
postgres: postgres ssprod 192.168.0.52(49333) SELECT
and gdb shows:
(gdb) bt
#0 0x2ba62c18f085 in send () from
Hello All,
I'm trying to configure my PostgreSQL 8.1.x (on FreeBSD 6-STABLE) to log
through syslog, yet somehow my logging doesn't end up in the specified
log files.
I'm kind of at a loss as to where i messed up. I'm hoping someone can
help me fix it.
Below are uncommented lines in my
surabhi.ahuja wrote:
after my update
I had my entire data drectory PGDATA removed,
i had done initdb again
and did lot of inserts (the inserts have given the similar performance)
So you _didn't_ vacuum analyze. You need one right at this point, or the
database is optimizing your queries using
[EMAIL PROTECTED] wrote:
=
6. thinking it might be the prepared stmt causing the problem I
tried a direct call to the stored proc, to no avail:
pg SELECT silly_insert('','va',999) ;
ERROR: inserts only allowed into silly partition tables (state was
Mark Morgan Lloyd wrote:
If there's a risk that multiple clients will try to execute a 'create or replace
function' simultaneously, what's the recommended practice for putting it in a
transaction and/or locking it? If a lock's incolved what should this be applied
to- the table that the function
tam wei wrote:
Dear all,
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
extracting
You can also give a try to DBD::PgPP !
TSHIMANGA Minkoka
VAS Administrator
Mobile: +243 814443113
Office: +243 813131347
Fax:+243 813010373
Email: [EMAIL PROTECTED]
VODACOM CONGO (DRC) s.p.r.l.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Albe
Richard Huxton wrote:
Mark Morgan Lloyd wrote:
If there's a risk that multiple clients will try to execute a 'create or
replace function' simultaneously, what's the recommended practice for
putting it in a transaction and/or locking it? If a lock's incolved what
should this be applied
Hello Tam Wei,
tam wei wrote:
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
Hello,
we just released fix for 8.2 release, which updates Snowball API.
Patch is available from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82.gz
It's too late to apply fix to 8.2 release, sorry.
Oleg
On Fri, 1 Dec 2006, Luiz Claudio da Silva Le?o wrote:
Hi,
Mark Morgan Lloyd wrote:
Richard Huxton wrote:
Mark Morgan Lloyd wrote:
If there's a risk that multiple clients will try to execute a 'create or
replace function' simultaneously, what's the recommended practice for
putting it in a transaction and/or locking it? If a lock's incolved what
should
On Mon, 4 Dec 2006 00:28:52 +0800
[EMAIL PROTECTED] (tam wei) wrote:
Dear all,
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the
Hello,
we just updated patch for 8.1 release, which introduced
GiN (Generalized Inverted Index) with tsearch2 support and
full multibyte support (UTF-8 as well). It contains VACUUM fix
in GiN code. Patch is available from Tsearch2 page
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
On 4-Dec-06, at 1:43 AM, Albe Laurenz wrote:
lsof on the client machine (192.168.0.52) shows no connections on
port 49333, so it doesn't appear to be a simple matter of killing the
client connection. If I have to, I can reboot the client machine, but
this seems like overkill and I'm not
Richard Huxton wrote:
Was it tuple concurrently updated? You can reproduce this fairly
simply by issuing BEGIN...CREATE OR REPLACE FUNCTION f... in two
different psql sessions and delaying COMMIT appropriately. AFAIK it's
harmless, but does abort your transaction.
I /think/ so, but it was
Mark Morgan Lloyd wrote:
If I might ask a related question- assuming that a client has grabbed a
restrictive lock during a transaction that e.g. is create/replacing functions,
what happens to other sessions that attempt to run a select or update- will they
fail (i.e. an implicit NOWAIT) or will
Hi when I do the following function it fills 2 dates per day from 1970
to 2050, except that some months (typical 2 months per year) have 4
dates for one day. this is totally freaky.. I wonder if postgresql is
tripping over itself making a double entry every now and again.
for instance I
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
wheel wrote:
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
wheel wrote:
Can a pgsql 8.1 database be restored from the raw file? For one database
I have only the files found in the base folder, example C:\PostgreSQL
Richard Huxton wrote:
Mark Morgan Lloyd wrote:
If I might ask a related question- assuming that a client has grabbed a
restrictive lock during a transaction that e.g. is create/replacing
functions,
what happens to other sessions that attempt to run a select or update- will
they
On Mon, Dec 04, 2006 at 06:52:19AM -0800, Ronin wrote:
Hi when I do the following function it fills 2 dates per day from 1970
to 2050, except that some months (typical 2 months per year) have 4
dates for one day. this is totally freaky.. I wonder if postgresql is
tripping over itself making a
I have copied the folders back to the base dir (like C:\PostgreSQL
\data
\base\16404) if that's step one but what after that?
Just start Postgres. If the data dir is ok, it should run fine.
It's unclear from your description whether the raw DB files were
moved from another installation -
FOR daycnt IN 1..31 LOOP
How about months with less than 31 days ? What do you get for those if
the day is 31 ?
Cheers,
Csaba.
---(end of broadcast)---
TIP 6: explain analyze is your friend
I'm the OP, ran into this today and thought I'd give it some exposure
http://spyced.blogspot.com/2006/12/benchmark-postgresql-beats-stuffing.html
From the article
Benchmark: PostgreSQL beats the stuffing out of MySQL
This is interesting, because the conventional wisdom of idiots on slashdot
On Mon, 2006-12-04 at 07:18 -0800, Timasmith wrote:
I cant seem to find the right query to retreive the discrete columns,
column position, for a specified index.
This is towards the purpose of identifying the schema differences
between two databases and creating the changes needed.
Note:
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 .
These versions have a sequential column, that is not part of the table,
identifying the rows.
Is there any method of accessing those numbers and identifying them with
elements within the table??
Bob Pawley
Bob Pawley wrote:
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 .
These versions have a sequential column, that is not part of the
table, identifying the rows.
Is there any method of accessing those numbers and identifying them
with elements within the table??
Are you sure it's not just
That's what they are doing.
That is also what I am looking for, if it is accessable. If so, I can use
that information to add a sequential numerical element to my information
that doesn't have the restrictions of a serial column.
Bob
- Original Message -
From: Richard Huxton
nicky wrote:
Hello All,
I'm trying to configure my PostgreSQL 8.1.x (on FreeBSD 6-STABLE) to log
through syslog, yet somehow my logging doesn't end up in the specified
log files.
I'm kind of at a loss as to where i messed up. I'm hoping someone can
help me fix it.
Below are uncommented
On 11/13/06, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, 2006-11-13 at 15:36, novnov wrote:
OK, thanks everyone, I gather from the responses that postgres performance
won't be an issue for me then. If MS SQL Server and Postgres are in the same
ballpark performance-wise, which seems to be
Sorry if this is a double post, I realized I was't subscribed when I sent
the first email.
Hoping Someone can give me a hand.
I had a developer who integrated the postgres msi into an installshield 10
installer. Somehow the uninstaller seemed to have half uninstalled it. All
the files are off
Bob Pawley wrote:
That's what they are doing.
That is also what I am looking for, if it is accessable. If so, I can
use that information to add a sequential numerical element to my
information that doesn't have the restrictions of a serial column.
Bob
Hi Bob,
Well, if you create your
A bunch of people have asked me about it, and I finally have a Windows
machine sitting around with QT, so I built a Windows binary for
pgDesigner that you can get here:
http://www.hardgeus.com/projects/pgdesigner/pgdesigner_win_0.8.zip
It's a pretty useful little tool for visualizing existing
Hi,
I am just starting at a company and we are inheriting a previously
built solution. It looks pretty good but my previous experience with
pg is seriously small-time compared with this...
I am very new at the job, and don't know what hd config we have but it
will be RAID-something I imagine (hey
Unless you can separate PGDATA and the WAL destination to be on wholly
independent physical disks and not just different partitions of the same
hardware array, the physical limitations will still be present.
I believe the recommended method is to use RAID 5 or RAID 10 data
partitions and then use
Hi :
I have some problems working with date and times, in my web page.
I have table with tasks.
This table has :
Inicial date
Inicial hour
Duration
Final Date
Final time
Final Date and Final time are calculate based in Inicial date, Inicial hour,
Duration.
In my test:
Inicial date
On 4 Dec 2006 at 20:13, Alejandro Michelin Salomon ( Adinet ) wrote:
But i only need 2006-12-05 from the resulting timestamp.
How to cut only the date from this timestamp?
Use date_trunc() just to lop off the time part of the timestamp:
http://www.postgresql.org/docs/8.2/static/functions-
On Dec 5, 2006, at 8:13 , Alejandro Michelin Salomon (( Adinet )) wrote:
This table has :
Inicial date
Inicial hour
Duration
Final Date
Final time
Final Date and Final time are calculate based in Inicial date,
Inicial hour, Duration.
snip /
But i only need 2006-12-05 from the resulting
On Mon, 2006-12-04 at 15:11, Anton Melser wrote:
Hi,
I am just starting at a company and we are inheriting a previously
built solution. It looks pretty good but my previous experience with
pg is seriously small-time compared with this...
OK, how you set up RAID depends largely on how you'll
On Dec 4, 2006, at 1:11 PM, Anton Melser wrote:
Hi,
I am just starting at a company and we are inheriting a previously
built solution. It looks pretty good but my previous experience with
pg is seriously small-time compared with this...
I am very new at the job, and don't know what hd config we
On Dec 4, 2006, at 23:52 , Ronin wrote:
Hi when I do the following function it fills 2 dates per day from 1970
to 2050, except that some months (typical 2 months per year) have 4
dates for one day. this is totally freaky.. I wonder if postgresql is
tripping over itself making a double entry
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 10:43 AM
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
This is an issue which has come up at various times on this list in
the past - it may be worth having a look through the archives.
Hoping Someone can give me a hand.
I had a developer who integrated the postgres msi into an installshield 10
installer. Somehow the uninstaller seemed to have half uninstalled it. All
the files are off the harddrive. When I go to add/remove programs it says no
installer package can be found.
Incase anyone else has this problem i solved it by searching the registry
for Postgresql and deleting everything and then going to command prompt and
using the SC commnd to remove the service manually.
_
From: Andrew Raia [mailto:[EMAIL PROTECTED]
Sent: Monday, December 04, 2006 1:18
On Mon, 2006-12-04 at 17:53, Raymond O'Donnell wrote:
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
This is an issue which has come up at various times on this list in
the
I'm doing something similar - using a control table, dropping and creating
the serial column and updating in a manner that does the job.
It works - barely. I am seeking a more elegent and stable method. Having a
simple update recognizing the row numbers (in version 1.6.1) would be
better -
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be sequential.
If the user deletes a device the numbers need to regenerate to again become
sequential and gapless.
Bob
- Original Message -
On Dec 4, 2006, at 3:53 PM, Raymond O'Donnell wrote:
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
This is an issue which has come up at various times on this list in
the past -
Perhaps - but they aren't necessarily meaningless as pure information.
Bob
- Original Message -
From: Steve Atkins [EMAIL PROTECTED]
To: PgSQL General pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
On Dec 4, 2006, at 3:53 PM,
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be sequential.
If the user deletes a device the numbers need to regenerate to again become
sequential and gapless.
Is it a bill of material line
Hi all,
I was wondering if anyone has unac.c which is the lib used in
Text::Unaccent built and wrap as a plpgsql stored procedure not using
plperl. Or maybe there is another general solution that I am no aware of.
Thanks,
-Steve
---(end of
Bob Pawley wrote:
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be
sequential. If the user deletes a device the numbers need to
regenerate to again become sequential and gapless.
Could you explain
On Monday 04 December 2006 04:17 pm, Bob Pawley wrote:
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be sequential.
If the user deletes a device the numbers need to regenerate to again become
I am talking about designing the control system.
No one makes a perfect design at first go. Devices are deleted and others
added. Until the end of the design stage the numbers need to be sequential
with no gaps. After the design the numbers of each device are static and new
devices are added
- Original Message -
From: Berend Tober [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 7:15 PM
Subject: Re: [GENERAL] PG Admin
Bob Pawley wrote:
Your missing the point.
I am creating a design
On Dec 5, 2006, at 13:08 , Bob Pawley wrote:
The physical devices don't get numbered until the design is
established and stable. This is known as the construction stage.
I guess I would set up a couple of tables to track this ordering
independently of the devices themselves. Rough schema:
Bob Pawley wrote:
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be
sequential. If the user deletes a device the numbers need to regenerate
to again become sequential and gapless.
How many control
brian wrote:
nicky wrote:
Hello All,
I'm trying to configure my PostgreSQL 8.1.x (on FreeBSD 6-STABLE) to
log through syslog, yet somehow my logging doesn't end up in the
specified log files.
I'm kind of at a loss as to where i messed up. I'm hoping someone can
help me fix it.
Below are
59 matches
Mail list logo