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
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 de
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:
The physical devices don't get numbered until the design is established and
stable. This is known as the construction stage.
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Scott Marlowe"
<[EMAIL PROTECTED]>; "Raymond O'
This is basically what I have done. However it is not particularly stable
and is inelegant.
The serial number is close to what I need except it becomes tied to the
information.
The row numbering on the PG Admin version 1.6.1 performs the same operation
that I am looking for. Is there some w
>
> - Original Message -
> From: "Berend Tober" <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROTECTED]>
> Cc: "pgsql general"
> 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
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 t
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
>
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 wha
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 broadcast)
> 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 nu
Perhaps - but they aren't necessarily meaningless as pure information.
Bob
- Original Message -
From: "Steve Atkins" <[EMAIL PROTECTED]>
To: "PgSQL General"
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
On Dec 4, 2006, at 3:53 PM, Raymond O'Donnell wrote
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 -
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 -
From
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 - per
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
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 PM
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. Whe
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. He
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]>;
Sent: Monday, December 04, 2006 10:43 AM
Subject: Re: [GENERAL] P
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 ev
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 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'l
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.
But i only need 2006-12-05 from the resulting timest
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-
da
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 2000-
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 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
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
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 tabl
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 t
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
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 line
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"
To:
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
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
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.
>
N
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
c
> 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 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 - no
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 makin
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
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
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 constantl
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
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 w
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 cer
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 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(t
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
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,
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
extractin
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
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 La
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 the
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 i
[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 v
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 us
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 postgr
> 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 () fro
> 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
61 matches
Mail list logo
