Erik Jones wrote:
On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote:
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
For what it's worth, I've run into a situation similar to this with a
client a couple time in the last week or two (I can't say identical a
Hi,
in my special case I'd like to check if a XML[] is empty, because postgres
doesn't implement any equality operators, this is not a 'simple' task.
My current solution is:
SELECT * FROM sometable WHERE XMLSERIALIZE(CONTENT ((XPATH('/a:bar,
somexmlcolumn, ARRAY[ARRAY['a', 'http://foo]]
On Tue, 9 Sep 2008, Artacus wrote:
Can psql access environmental variables or command line params?
$ cat test.sql
select :TEST as "input";
$ psql -v TEST=16 -f test.sql
input
---
16
(1 row)
You can find out more about what you can do with variable substitution at
http://www.postgres
I expected that to generate an error: column foo.text does not exist.
Instead it treats "foo.text" as "foo.*::text AS text":
Is this a feature or a bug?
Hmm. It's a feature, but maybe a dangerous one. The expression is
being treated as text(foo), which is intentional in order to allow
use of f
If I want to pass in a text[] argument to a plpgsql function, at what
array size am I asking for problems? 100? 10,000? 100,000?
What severity of problems might I encounter? Bad performance? Postgres
refusing to run my query? A crashed backend?
Yeah, like you I was pretty worried about how
What's the best open-source front-end for rapid GUI query and report
generation using postgres?
Is it possible to use MS access as a front-end to postgres for rapid
prototyping? Can that be done through ODBC?
This question was asked about a week ago. I don't recall all of the
answers but I
On Wed, Sep 10, 2008 at 10:14 PM, Artacus <[EMAIL PROTECTED]> wrote:
>> This sounds a lot like what I did in my last job using bash for most
>> things, and php for the more complicated stuff. Wrote a simple oracle
>> to pgsql table replicator in php that worked pretty well.
>
> Well we do this stu
What's the best open-source front-end for rapid GUI query and report
generation using postgres?
Is it possible to use MS access as a front-end to postgres for rapid
prototyping? Can that be done through ODBC?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
This sounds a lot like what I did in my last job using bash for most
things, and php for the more complicated stuff. Wrote a simple oracle
to pgsql table replicator in php that worked pretty well.
Well we do this stuff all the time with Oracle and sql*plus. And I've
heard people hear say about
On Linux if you install postgres via RPM's and the postgres user
account does not exist then the RPM install creates it for you and
sets the home dir to the root for the postgres binaries (i.e. /var/lib/
pgsql)
Maybe the same thing happens on a Mac install ?
On Sep 10, 2008, at 5:14 PM, Da
Hi List;
Can I create an insert/update trigger based on a table that contains
lo_* style BLOB's ?
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am getting this error with initdb while creating shared segment -
"memory segment exceeded available memory or swap space. To reduce the
request size (currently 1785856 bytes), reduce PostgreSQL's shared_buffers
parameter (currently 50)) and/or its max_connections parameter (currently
13)."
Tota
Tom Lane wrote:
"Darren Weber" <[EMAIL PROTECTED]> writes:
There is a postgres user account on my OSX system. I'm not clear
about how it was created. I've installed a binary version of 8.3 in
/Library/PostgreSQL/8.3/ and built another version from source into
/usr/local/pgsql/. When I login a
Thanks, it was a freebsd ports problem. Sorry for sending it on this list.
On Wed, Sep 10, 2008 at 6:01 AM, Bill Moran
<[EMAIL PROTECTED]>wrote:
> In response to "Artis Caune" <[EMAIL PROTECTED]>:
>
> > On Tue, Sep 9, 2008 at 9:21 AM, Mohd Fahadullah <[EMAIL PROTECTED]>
> wrote:
> > > Hi,
> > >
>
On Wed, Sep 10, 2008 at 4:03 PM, Ben <[EMAIL PROTECTED]> wrote:
> If I want to pass in a text[] argument to a plpgsql function, at what array
> size am I asking for problems? 100? 10,000? 100,000?
>
> What severity of problems might I encounter? Bad performance? Postgres
> refusing to run my query?
"Darren Weber" <[EMAIL PROTECTED]> writes:
> There is a postgres user account on my OSX system. I'm not clear
> about how it was created. I've installed a binary version of 8.3 in
> /Library/PostgreSQL/8.3/ and built another version from source into
> /usr/local/pgsql/. When I login as root and
There is a postgres user account on my OSX system. I'm not clear
about how it was created. I've installed a binary version of 8.3 in
/Library/PostgreSQL/8.3/ and built another version from source into
/usr/local/pgsql/. When I login as root and then 'su - postgres' it
takes me to the postgres ac
On Wed, Sep 10, 2008 at 3:31 PM, Bayless Kirtley <[EMAIL PROTECTED]> wrote:
> Early Friday morning a bad record caused me to reload the Thursday night
> pgdump backup. I performed a pgdump first to study later. In the backup I
> found several incomplete transactions all done at the end of the day.
On Wed, 2008-09-10 at 00:02 -0600, Scott Marlowe wrote:
> Unless you have either a small data set or a very powerful RAID array,
> most the time you won't be CPU bound anyway. But it would be nice to
> see some work come out to parallelize some of the work done in the
> back end.
I would have a
Early Friday morning a bad record caused me to reload the Thursday night pgdump
backup. I performed a pgdump first to study later. In the backup I found
several incomplete transactions all done at the end of the day. Investigating
later I found the original bad record from the Friday dump and fi
[EMAIL PROTECTED] ("Amber") writes:
>We know PostgreSQL uses one dedicated server process to serve one
> client connection, what we want to know is whether PostgreSQL use
> multiple threads inside agents processes to take advantage of
> multiple CPUs. In our site we have only a few concurren
From: "Markova, Nina" <[EMAIL PROTECTED]>
I also plan to try to export data in XML format (from Ingres) and import
it to Postgres.
I didn't find any utility for importing XML data into Postgres.
You can possibly use perl's XML::Xpath for XML import (DBIx::XML_RDB for
export), assuming the tab
Please configure your MTA to either just drop email from people you
don't know or let it through. Sending off an error message saying my
email's rejected for policy is kinda rude on a public mailing list.
If everyone did it my email box would double in size.
On Wed, Sep 10, 2008 at 2:04 PM, Ricar
On Wed, Sep 10, 2008 at 2:04 PM, Ricardo Antonio Yepez Jimenez
<[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise
> edition, I need to know the steps to configure, if someone owns a manual.
xml support is built in now isn't it? And
Hi,
As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1
enterprise edition, I need to know the steps to configure, if someone
owns a manual.
Thank you.
.
If I want to pass in a text[] argument to a plpgsql function, at what
array size am I asking for problems? 100? 10,000? 100,000?
What severity of problems might I encounter? Bad performance? Postgres
refusing to run my query? A crashed backend?
--
Sent via pgsql-general mailing list (pgsql-ge
On Wed, Sep 10, 2008 at 12:46 AM, Artacus <[EMAIL PROTECTED]> wrote:
> Artacus wrote:
>>
>> I'd like to learn a little more about writing psql scripts does anyone
>> know of any resources outside of the manual?
>
> Ok then. Does anyone have any tips or best practices for scripting psql?
>
> I'll pr
Randal T. Rioux napsal(a):
On Mon, September 8, 2008 9:38 am, Randal T. Rioux wrote:
Found a kludgy fix!
cp /usr/local/lib/sparcv9/libgcc_s.so.1 /usr/sfw/lib/sparcv9/
Now, both OpenSSL and PostgreSQL work great. In 64-bit mode.
If anyone has a less hack-ish solution, please share.
try to
Randal T. Rioux napsal(a):
On Wed, September 10, 2008 10:54 am, Zdenek Kotala wrote:
I just don't like the Solaris package system in general. It is, dare I
say, worse than RPM. But this is a PostgreSQL list, so I'll save the rant!
Community solaris "package" on postgresql download website i
Dean Rasheed <[EMAIL PROTECTED]> writes:
> CREATE TABLE foo(a int, b int);
> INSERT INTO foo VALUES(1,2);
> SELECT foo.text FROM foo;
> I expected that to generate an error: column foo.text does not exist.
> Instead it treats "foo.text" as "foo.*::text AS text":
> Is this a feature or a bug?
Hmm.
Adrian,
The trick seems to work. Thanks!
Nina
-Original Message-
From: Adrian Klaver [mailto:[EMAIL PROTECTED]
Sent: September 10, 2008 11:58
To: Markova, Nina
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Subject: RE: [GENERAL] FW: How to upload data to postgres
--- Or
Jeff Davis wrote:
On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote:
select
ts_date as "Transcript Date",
ts_expiration_date as "Current Expiration Date",
expiration_value as "Expiration Interval"
from transcript, training_expiration_value where
ts_t
I've just spent a couple of hours tracking down a bug which turned out
to be a typo in my code. What surprises me is that the SQL in question
didn't immediately produce an error. Here's a simplified example:
CREATE TABLE foo(a int, b int);
INSERT INTO foo VALUES(1,2);
SELECT foo.text FROM foo;
I
Randal T. Rioux wrote:
Found a kludgy fix!
cp /usr/local/lib/sparcv9/libgcc_s.so.1 /usr/sfw/lib/sparcv9/
Now, both OpenSSL and PostgreSQL work great. In 64-bit mode.
If anyone has a less hack-ish solution, please share.
Thanks!
Randy
Not sure if this'll make it to the list or not, I'm not
On Wed, 10 Sep 2008 23:33:44 +0800
"Amber" <[EMAIL PROTECTED]> wrote:
> Yes, we know both Greenplum and Netezza are PostgreSQL based MPP
> solutions, but they are commercial packages. I'd like to know are
> there open source ones, and I would suggest the PostgreSQL Team to
> start a MPP version o
--- Original message --
From: "Markova, Nina" <[EMAIL PROTECTED]>
>
> I also plan to try to export data in XML format (from Ingres) and import
> it to Postgres.
>
> I didn't find any utility for importing XML data into Postgres. Or just
> looking at the wrong documen
On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote:
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
Looks like part of your query results being sent. Is it hung in
that one
system-call?
Yes, I left it there for about ~1 hour, and that was all that ever
cam
On Wed, 2008-09-10 at 08:57 -0430, Ricardo Antonio Yepez Jimenez wrote:
> As I compile postgresql 8.3.2
If this is not a typo, please use 8.3.3 .
> to support sql / xml, Red hat 5.1
> enterprise edition, I need to know the steps to comfigurarlo
Why don't you use precompiled packages for RHEL +
On Wed, September 10, 2008 10:54 am, Zdenek Kotala wrote:
>>> Three questions (yeah, you forbided ask, but ...)
>>
>> grumble grumble grumble...
>>
>>> 1) Why 64
>>>
>>> 64bit code on SPARC is slower, because SPARC uses 4byte instructions
>>> and processing 64bit data needs more instructions. It is
Yes, we know both Greenplum and Netezza are PostgreSQL based MPP solutions,
but they are commercial packages.
I'd like to know are there open source ones, and I would suggest the PostgreSQL
Team to start a MPP version of PostgreSQL.
--
From: "Josh
I also plan to try to export data in XML format (from Ingres) and import
it to Postgres.
I didn't find any utility for importing XML data into Postgres. Or just
looking at the wrong document?
I run Postgres 8.2.4
Thanks,
Nina
-Original Message-
From: Adrian Klaver [mailto:[EMAIL PROTEC
On Wed, 10 Sep 2008 23:17:40 +0800
"Amber" <[EMAIL PROTECTED]> wrote:
>
> 1. Some kind of MPP.
> 2. No single point of failure.
> 3. Convenient and multiple access interfaces.
>
> And following the is the solutions we have examined:
http://www.greenplum.com/
Joshua D. Drake
--
The PostgreSQL
> Yahoo has a 2PB Postgres single instance Postgres database (modified
> engine), but the biggest pure Pg single instance I've heard of is 4TB.
> The 4TB database has the additional interesting property in that they've
> done none of the standard "scalable" architecture changes (such as
> partition
> 8. We have a master and a replica. We have plans to move to a
> cluster/grid Soon(TM). It's not an emergency and Postgres can easily
> handle and scale to a 3TB database on reasonable hardware (<$30k).
>
I'd like to know what's your progress of choosing the cluster/grid solution, we
are also
Artis Caune escribió:
> Ops, forget to mention that this function is not so simple and use
> some plpgsql features.
Ah, right, you only forgot to mention that other 99% of the
requirements.
What's wrong with your first example?
--
Alvaro Herrerahttp://www.Comman
Randal T. Rioux napsal(a):
On Tue, September 9, 2008 5:25 am, Zdenek Kotala wrote:
Randal T. Rioux napsal(a):
I've battled this for a while. I'm finally breaking down and asking for
help.
If you're answer to this is "why 64-bit" then don't answer. You wouldn't
understand. Same if you say "why
Martijn van Oosterhout wrote:
On Wed, Sep 10, 2008 at 09:45:04AM -0400, Jack Orenstein wrote:
Am I on the right track -- does autocommit = false for the BIG scan force
versions of TINY to accumulate? I played around with a JDBC test program,
and so far cannot see how the autocommit mode causes
2008/9/10 Artis Caune <[EMAIL PROTECTED]>:
> Hi,
>
> What is the correct way of writing plpgsql function which needs return
> columns from multiple tables?
>
> e.x.:
> SELECT email FROM emails WHERE id = 1
> SELECT backend FROM backends WHERE id = 1
>
> I need plpgsql function return both email and
On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote:
> Thanks Adrian.
>
> I have read the Postgres 'copy' - the problem is that Postgres doesn't
> understand Ingres format. This is I think where the failure comes from.
> If I don't find a tool, I have to write scripts to convert data to
>
On Wed, Sep 10, 2008 at 5:26 PM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Hmm, maybe
>
> select email, backend from emails, backends where email.id = 1 and
> backend.id = 1;
> ?
>
> You don't need a plpgsql function for this ...
Ops, forget to mention that this function is not so simple and use
Artis Caune escribió:
> Hi,
>
> What is the correct way of writing plpgsql function which needs return
> columns from multiple tables?
>
> e.x.:
> SELECT email FROM emails WHERE id = 1
> SELECT backend FROM backends WHERE id = 1
>
> I need plpgsql function return both email and backend in one li
2008/9/10 Ricardo Antonio Yepez Jimenez <[EMAIL PROTECTED]>:
>
>
> Hi,
>
> As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1 enterprise
> edition, I need to know the steps to comfigurarlo, if someone owns a manual.
nothing fancy; just install libxml2 (on Debian I needed libxml2-dev,
Martijn van Oosterhout wrote:
> Vacuum can only clean up stuff older than the oldest open transaction.
> So if you have a transaction which is open for hours then stuff made
> since then it can't be vacuumed. The solution is: don't do that.
Actually it's worse than that: older than the oldest tra
Hi,
What is the correct way of writing plpgsql function which needs return
columns from multiple tables?
e.x.:
SELECT email FROM emails WHERE id = 1
SELECT backend FROM backends WHERE id = 1
I need plpgsql function return both email and backend in one line, like:
SELECT email, backend FROM ...
Thanks Adrian.
I have read the Postgres 'copy' - the problem is that Postgres doesn't
understand Ingres format. This is I think where the failure comes from.
If I don't find a tool, I have to write scripts to convert data to
something postgres understand.
In the Ingres file with data for each v
On Tue, Sep 09, 2008 at 05:42:50PM -0400, Greg Smith wrote:
>
> While some of the MonetDB bashing in this thread was unwarranted,
What bashing? I didn't see any bashing of them.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-gene
On Wed, Sep 10, 2008 at 09:45:04AM -0400, Jack Orenstein wrote:
> Am I on the right track -- does autocommit = false for the BIG scan force
> versions of TINY to accumulate? I played around with a JDBC test program,
> and so far cannot see how the autocommit mode causes variations in what is
> s
I'm trying to understand the effect of autocommit on vacuum behavior (postgres
8.3, if it matters). Let's suppose you have two tables, BIG and TINY in a
database accessed through JDBC. BIG has lots of rows. There are inserts,
updates, and every so often there is a scan of the entire table. The
Hi,
As I compile postgresql 8.3.2 to support sql / xml, Red hat 5.1
enterprise edition, I need to know the steps to comfigurarlo, if someone
owns a manual.
Thank you.
.
In response to "Artis Caune" <[EMAIL PROTECTED]>:
> On Tue, Sep 9, 2008 at 9:21 AM, Mohd Fahadullah <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > This might be a very small problem but I am stuck. When I try to install
> > postgresql server 8.3.3 on freebsd using ports, I am getting -
> > "postgresq
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
Looks like part of your query results being sent. Is it hung in that one
system-call?
Yes, I left it there for about ~1 hour, and that was all that ever came.
Seems like you have got a network issue. What doe
On Sep 10, 2008, at 2:46 AM, Artacus wrote:
Who else is doing something like this? Can psql access environmental
variables or command line params? Or do I have to have my bash
script write a psql script every time?
The psql \! command can execute shell commands. You can also use ``,
e.g
Tommy Gildseth <[EMAIL PROTECTED]> writes:
> Richard Huxton wrote:
>> Looks like part of your query results being sent. Is it hung in that one
>> system-call?
> Yes, I left it there for about ~1 hour, and that was all that ever came.
Seems like you have got a network issue. What does netstat sho
Willy-Bas Loos wrote:
> Hi,
>
> Tablespaces are implemented as some sort of a hard link on windows, so
> that the data seem to be in the program files, but they're not.
No, they are implemented using softlinks, AKA NTFS Junctions.
> When i look at my C drive with spacemonger though, it tells me
Richard Huxton wrote:
Tommy Gildseth wrote:
SELECT pg_cancel_backend(17504) has no effect, neither does kill 17504
from the shell.
Strange.
I tried "strace -p17504", and this gave me just the following output:
sendto(7, "\7\0\0\0\003771\0\0\0\00224\0\0\0\017127.120.213.18"..., 968,
0, NULL,
Hi,
Tablespaces are implemented as some sort of a hard link on windows, so that
the data seem to be in the program files, but they're not.
When i look at my C drive with spacemonger though, it tells me that the data
in the tablespace IS in the program files folder - it is "fooled" by the
hard link
Hello,
What is the reason for
select pg_start_backup('label');
taking 10 minutes on not so loaded system even right after manual checkpoint?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
I have a query on a database that has been running for nearly 24 hours
at the moment. The query itself doesn't seem like it should take very
long to run, so it seems like there's something else going on here.
The output from pg_stat_activity looks like this:
SELECT procpid, waiting, current_que
On Tue, 2008-09-09 at 16:26 -0400, Tom Lane wrote:
> That's probably not good because it *looks* like we support the syntax,
> but in fact produce non-spec-compliant results. I think it might be
> better if we threw an error.
Definitely. If we accept SQL Standard syntax like this but then not d
Frederik Ramm wrote:
Dear
PostgreSQL community,
I hope you can help me with a problem I'm having - I'm stuck and
don't know how to debug this further.
I have a rather large nightly process that imports a lot of data from
the OpenStreetMap project into a PostGIS database, then proceeds d
70 matches
Mail list logo
