Hi Thomas,
No I actually need the product name (prod1, prod2) to become column
headings, which is effectively transposing the table.
Thanks.
NK
Thomas Burdairon wrote:
> if i understand well you need to have an history for your products.
> i would have a table B with
> date produ
I have some postgres cluster questions: I would like to have the ability to dynamically re-size a cluster of Postgres DB instances. 0. Can I create a Postgres cluster? - more than one instance of Postgres running on more than 1 cpu acting as a single instance of postgres to process work. i.e. 1
Michael Fuhr wrote:
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
Michael Fuhr wrote:
On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
Just toda
Hi all,
i have a script to stop and start
postmaster
However i have noticed this many a time sdnow. I
stop postmaster using that script
and then start using a script.
However if i try to do psql , it
gives me an error saying that the postmaster is not up.
Why is it that the postmaster went
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
> Michael Fuhr wrote:
> >On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> >>Just today i have noticed i have one ce
On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> Just today i have noticed i have one certain table that i cannot delete
> any records from
What happens when you try to delete? Do you get an error? Does
the delete succeed but report zero rows deleted? Something else?
What doe
Last I tried, a few years ago, Crystal 8.5 would not work at all with
PostgreSQL. Version 9 works but the later service packs handle it much
better.
Can you browse the table data through the database expert?
Mike
On Wed, 2006-07-12 at 10:23 -0300, Juan Ignacio Lalla wrote:
> Hello,
>
> I'm
Just today i have noticed i have one certain table that i cannot delete
any records from
1 have delete all Triggers, Vacuumed the tables removed all foreign keys
that linked to this table.
--
*Jamie Deppeler
*Database Administrator
*once:technologies pty ltd
*
*Do It Once!*
46 Roseneath Stre
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On 7/12/06, Timothy Perrigo <[EMAIL PROTECTED]> wrote:
>> Is there a way to get the names of the arguments to a function from
>> psql? /df and /df+ return the parameter types, but not their names.
> select oid::regprocedure from pg_proc where proname
On Wed, 12 Jul 2006, Tom Lane wrote:
It's probably worth pointing out here that the MySQL behavior they seem to
be expecting is considerably further from the spec than Postgres's
behavior. If I'm reading between the lines correctly, they are expecting
foo and Foo (both written without double-qu
Rich Shepard <[EMAIL PROTECTED]> writes:
>I'm trying to assist the XRMS developers port their application to
> postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling
> block is case for table and column (relation and attribute) names.
> Apparently MySQL allows for mixed ca
Looking into it ... server is quiet, and from the headers, the
anti-virus/spam stuff is causing neglible delay ... last time this
happened, it turned out to be a bad subscribe address in the list, so will
be searchign through that next ...
On Wed, 12 Jul 2006, Joshua D. Drake wrote:
Marc,
On Wed, 12 Jul 2006, Stephan Szabo wrote:
AFAIK, SQL says that an non-quoted identifier such as Foo is treated as
FOO (case-folded to upper). PostgreSQL currently treats it as foo
(case-folded to lower). Quoted identifiers are not case-folded and are
compared case-sensitive.
So, for example my
On Wed, 12 Jul 2006, Joshua D. Drake wrote:
Likley, not ever ;)...
Hi, Josh!
That's fine with me. As long as postgres works, I'm happy.
ERROR: relation "role_id" already exists
AHA! I see what is happening... you can't have an index name the same as a
table name. Tell them just to chang
On Wed, 12 Jul 2006, Rich Shepard wrote:
>I'm trying to assist the XRMS developers port their application to
> postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling
> block is case for table and column (relation and attribute) names.
> Apparently MySQL allows for mixed c
On Wednesday 12 July 2006 17:33, Rich Shepard wrote:
>I'm trying to assist the XRMS developers port their application to
> postgres (8.1.x on), and it's almost there. One (perhaps the only)
> stumbling block is case for table and column (relation and attribute)
> names. Apparently MySQL allows
I'm trying to assist the XRMS developers port their application to
postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling
block is case for table and column (relation and attribute) names.
Apparently MySQL allows for mixed case, while postgres wants only lower
case. One of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leif B. Kristensen wrote:
> On Wednesday 12. July 2006 21:03, Marco Bizzarri wrote:
>> Long term archival of electronic data is a BIG problem in the
>> archivist community. I remember, a few years ago, a paper
>> describing the problem of historical (
Scott Marlowe wrote:
On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote:
2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>:
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator doe
Joshua D. Drake wrote:
Secondly this sounds like a perfect time for you to consider upgrading to 8.1
and making use of table partitioning.
How does that work, exactly?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
NM I found the documentation.
Joseph Shraibman wrote:
Joshua D. Drake wrote:
Secondly this sounds like a perfect time for you to consider upgrading
to 8.1
and making use of table partitioning.
How does that work, exactly?
---(end of broadcast)-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tim Hart wrote:
> Wouldn't you run into driver problems if you tried to restore a
> 20 year old image? After all, you probably won't be using the
> same hardware in 20 years...
Scarily, the current PC architecture is just a set of add-ons and
extens
On Wednesday 12. July 2006 21:03, Marco Bizzarri wrote:
>
>Long term archival of electronic data is a BIG problem in the
>archivist community. I remember, a few years ago, a paper describing
>the problem of historical (20+ years old) data which were running the
>risk of being lost simply because of
Marc,
Mailing lists are showing an ungodly slowness. To the tune of 2 hours for
things to show up. What's up?
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive Postgr
On Wed, Jul 12, 2006 at 07:55:49 -0300,
Clodoaldo Pinto <[EMAIL PROTECTED]> wrote:
>
> I have already counted 6 very similar answers. Is there some problem
> with the list software that prevents people from noticing it has
> already been answered?
In my case, my mail server had been heavily loa
-- Forwarded message --
From: Marco Bizzarri <[EMAIL PROTECTED]>
Date: Jul 12, 2006 9:03 PM
Subject: Re: [GENERAL] Long term database archival
To: "Karl O. Pinc" <[EMAIL PROTECTED]>
Long term archival of electronic data is a BIG problem in the
archivist community. I remember, a f
On Wed, Jul 12, 2006 at 07:08:15 -0700,
[EMAIL PROTECTED] wrote:
>
> Thank you for the suggestions.
> I will try to describe the problem better.
> I have two problems to solve. First one is that I have to transpose a
> table.
> I have table A that looks like this:
> date product price
On 7/12/06, Timothy Perrigo <[EMAIL PROTECTED]> wrote:
Is there a way to get the names of the arguments to a function from
psql? /df and /df+ return the parameter types, but not their names.
select oid::regprocedure from pg_proc where proname like 'your name here';
merlin
--
On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote:
> 2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>:
> > Paul Tilles wrote:
> > > Version postgres 7.4.7:
> > >
> > > Following sql
> > >
> > > UPDATE tablename SET value = 0.0 where value!=-9.4;
> > >
> > > results in the error message
> > >
> > > ERROR
On Wed, 2006-07-12 at 07:32, Carl M. Nasal II wrote:
> I apologize for not including the server information in the last e-mail. I
> knew I would forget something. :)
>
> PostgreSQL 8.1.4 (compiled from source)
> Debian GNU/Linux 3.1
> Intel(R) Pentium(R) D CPU 3.00GHz
> 1GB RAM
>
> We have not
Jan Wieck <[EMAIL PROTECTED]> writes:
> I can't even find the same hardware I bought "last year". That's one of the
> reasons why I use VMware on my laptop. It has a hardware abstraction layer
> that
> presents default XVGA and Soundblaster cards etc. to the guest OS. When I buy
> a
> new lapto
Wouldn't you run into driver problems if you tried to restore a 20 year old
image? After all, you probably won't be using the same hardware in 20
years...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: Wednesday, July 12, 2006 9:26 AM
To:
On Wed, Jul 12, 2006 at 07:33:09AM -0700, Timothy Perrigo wrote:
> Is there a way to get the names of the arguments to a function from
> psql? /df and /df+ return the parameter types, but not their names.
One way would be to look at pg_proc.proargnames.
http://www.postgresql.org/docs/8.1/inter
On Wednesday 12 July 2006 08:37, Richard Broersma Jr wrote:
> > I think that that's the answer, put the whole OS and db on a
> > bootable cd or DVD. In 20 years they'll surely be no
> > problem running the whole thing from RAM so media access
> > speed should not be an issue.
>
> You are correct.
Hello, pgsql-general!
I originally posted this to pgsql-sql, but after not seing any
response for roughly a day and after re-reading the charters, I felt
that pgsql-general might be more appropriate.
What I've got here are a couple of ON INSERT rules for a view. The
second rule is what I'm conce
On 7/12/2006 12:18 PM, Tim Hart wrote:
Wouldn't you run into driver problems if you tried to restore a 20 year old
image? After all, you probably won't be using the same hardware in 20
years...
I can't even find the same hardware I bought "last year". That's one of
the reasons why I use VMwar
# [EMAIL PROTECTED] / 2006-07-11 12:04:07 -0400:
> On 6/30/2006 1:07 PM, Merlin Moncure wrote:
>
> >* mysql has a few features here and there which are nice...just to
> >name a few, flush tables with lock, multiple insert, etc
(...)
> The multiple insert stuff is not only non-standard, it al
On Mon, 2006-10-07 at 10:33 -0700, Karen Hill wrote:
> Hello,
>
> How would one go about creating a US telephone type in the format of
> "(555)-555-" ? I am at a loss on how it could be accomplished in
> the most correct way possible while not going into the various
> different country styles
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Karl O. Pinc wrote:
>
> On 07/12/2006 09:25:45 AM, Jan Wieck wrote:
>> On 7/6/2006 8:03 PM, Karl O. Pinc wrote:
>>
>>> On 07/06/2006 06:14:39 PM, Florian G. Pflug wrote:
Karl O. Pinc wrote:
> Hi,
>
> What is the best pg_dump format fo
> I think that that's the answer, put the whole OS and db on a
> bootable cd or DVD. In 20 years they'll surely be no
> problem running the whole thing from RAM so media access
> speed should not be an issue.
You are correct. I thought that CD only had a shelf life of 5 to 10 years.
This is t
On 7/12/06 3:32 AM, "Rafal Pietrak" <[EMAIL PROTECTED]> wrote:
> On Tue, 2006-07-11 at 15:24 -0500, Ron Johnson wrote:
>> Joshua D. Drake wrote:
>>> It is also something that users are clammoring for (and my customers). To
>>> the point that I have customers using unions to emulate the behavior
On Fri, 2006-07-07 at 22:41 +, [EMAIL PROTECTED] wrote:
> > [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver
> >
> > I guess the solution depends on what is a 'large amount of data'. The
> > most time consuming part is going to be converting the single data
> > elements at the top of eac
On 7/6/2006 8:03 PM, Karl O. Pinc wrote:
On 07/06/2006 06:14:39 PM, Florian G. Pflug wrote:
Karl O. Pinc wrote:
Hi,
What is the best pg_dump format for long-term database
archival? That is, what format is most likely to
be able to be restored into a future PostgreSQL
cluster.
Anyway, 20 y
if i understand well you need to have an history for your products.i would have a table B withdate products price1/1/2006 prod1 1.01/1/2006 prod2 3.0or replace prod_name py product_id, ... Thomas On Jul 12, 2006, at 16:08, [EMAIL PROTEC
On 07/12/2006 09:25:45 AM, Jan Wieck wrote:
On 7/6/2006 8:03 PM, Karl O. Pinc wrote:
On 07/06/2006 06:14:39 PM, Florian G. Pflug wrote:
Karl O. Pinc wrote:
Hi,
What is the best pg_dump format for long-term database
archival? That is, what format is most likely to
be able to be restored int
You should use varchar(20), which will not consume as much space as
char(20) IF the values inserted don't, themselves take the full 20
positions. In varchar, there will be no padding, thus saving on your disk
space.
For your question in particular, that depends on the block size of how PG
al
Is there a way to get the names of the arguments to a function from
psql? /df and /df+ return the parameter types, but not their names.
Thanks,
Tim
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tue, Jul 11, 2006 at 04:26:41PM -0400, Paul Tilles wrote:
> Yes. That works. I think that the parser should work properly either way.
You're mistaken. PostgreSQL by design makes it possible for you to
define a custom operator like !=- and use it.
>
> Paul
>
> Bruce Momjian wrote:
> >Paul
Bruno Wolff III wrote:
> On Tue, Jul 11, 2006 at 06:05:18 -0700,
> [EMAIL PROTECTED] wrote:
> > Hello,
> > I'm a pgsql novice and here is what I'm trying to do:
> > 1.I need to create a dynamic table with the column names fetched
> > from the database using a select statement from some other
I w'd like to know how the DB growth impacts the actual disk
space. For example, I have a table with one textfield,
char(20) and I insert 100 records. My DB size w'd
be approximately,
20+28(Overhead)=48*100=48MB. What is the actual
effect on the physical HDD. I w'd appreciate your
help.
Th
Hello,
I'm using Crystal
Reports 8.5 against PostgreSQL Database Server 8.1.
The thing is that
when I try to use an SQL _expression_ Field in Crystal, doesn't work (it does work
when I don't use it).
Returns the
following error:
Error in compiling
SQL _expression_:
Cannot find parser
t
I w'd like how the DB growth impacts the actual disk
space. For example, I have a table with one textfield,
char(20) and I insert 100 records. My DB size w'd
be approximately,
20+28(Overhead)=48*100=48MB. What is the actual
effect on the physical HDD. I w'd appreciate your
help.
Thanks,
Uma
On Jul 12, 2006, at 4:24 AM, zordax wrote:
What tool are you using to create users/passwords? If you are
using a GUI tool, have you tried to replicate the problem using psql?
After a while i think it might be a problem of tool. Because i can
login by psql. But i have this effect with ps
On 7/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Guido Neitzer wrote:
> On 11.07.2006, at 19:36 Uhr, Merlin Moncure wrote:
> It is not, as prepared statements have the problem that they are only
> optimized once and very generically and without actual knowledge of
> the parameter content, th
I apologize for not including the server information in the last e-mail. I
knew I would forget something. :)
PostgreSQL 8.1.4 (compiled from source)
Debian GNU/Linux 3.1
Intel(R) Pentium(R) D CPU 3.00GHz
1GB RAM
We have not be able to test the triggers anywhere else that has any load on
it.
Thanks for the tips. I will try to use the strict pragma as you suggested
and see if it helps.
The code runs fine most of the time. The issue is as time elapses, the
server ends up crashing. Generally, it will crash within a day of use
(with only 3 clients hitting it). The reason we believ
> We have PostgreSQL 8.1 running on Windows 2000 for a few
> weeks now, when we try to start the service, it could not
> start claiming no error returned. So, I go to the command
> prompt and run the following:
>
> "C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe" runservice
> -N "pgsql-8.1" -D
2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>:
Paul Tilles wrote:
> Version postgres 7.4.7:
>
> Following sql
>
> UPDATE tablename SET value = 0.0 where value!=-9.4;
>
> results in the error message
>
> ERROR: operator does not exist: smallint !=- integer
> HINT: No operator matches the given name
On Tue, 2006-07-11 at 21:11, Alvaro Herrera wrote:
> Maybe we could check the MCVs, and store those for which the plan would
> be A (say indexscan) and those for which it would be B (say bitmap
> indexscan), etc; so we'd save more than one plan and choose at execution
> time depending on the actual
On Tue, 2006-07-11 at 15:24 -0500, Ron Johnson wrote:
> Joshua D. Drake wrote:
> > It is also something that users are clammoring for (and my customers). To
> > the point that I have customers using unions to emulate the behavior. Why?
> > Because it is really, really fast.
>
> When inserting mult
Hi All,
I have a database where I give priviledges solely by user membership in
permitted roles (groups).
It works flowlessly, but when I tried to assign CREATEUSER priviledge to
an administrator ROLE (just one database administrator, not the
postmaster), I have to explicitly "SET ROLE ADMIN" bef
61 matches
Mail list logo
