Laurent ROCHE wrote:
Hi,
Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, from a
recommandable place ?
I can not recommend my clients to use 8.2 if there's nobody supporting the
packages (so just compiling from the source code is not an option).
They are right at t
I'm trying to install pljava on postgresql on macintosh
I have postgres runing, but I have not got any manual for install
pljava on OSX
If someone have its pljava.so and other needed libraries compiled can
you copy me please??
I use a MacBook with OSX 10.4.8 and java 1.5.0, postgresql 8.2.
On Mar 2, 2007, at 8:47 PM, Jan Muszynski wrote:
On 2 Mar 2007 at 16:33, [EMAIL PROTECTED] wrote:
Quoting Bill Moran <[EMAIL PROTECTED]>:
In response to [EMAIL PROTECTED]:
"Your local 'Administrators' group contains 'Authenticated Users'.
This is a common configuration error that causes s
On 2 Mar 2007 at 16:33, [EMAIL PROTECTED] wrote:
> Quoting Bill Moran <[EMAIL PROTECTED]>:
>
> > In response to [EMAIL PROTECTED]:
> >> "Your local 'Administrators' group contains 'Authenticated Users'.
> >> This is a common configuration error that causes security issues. For this
> >> reason,
On Mar 2, 2007, at 5:01 PM, Bill Moran wrote:
In response to [EMAIL PROTECTED]:
Quoting Bill Moran <[EMAIL PROTECTED]>:
In response to [EMAIL PROTECTED]:
I've been using PostgreSQL on Mac OS X for a few years, but now I'm
trying to
install it on a WIndows computer so someone else can use i
You had me going on that one. :-)
---
Paul Lambert wrote:
> Thanks to all who have helped me over the last month or so with
> converting my system from M$ SQL server to Postgres.
>
> Unfortunately I've decided to scrap th
"Adam Rich" <[EMAIL PROTECTED]> writes:
> Any way to pull the value of a config variable
> into a pl/pgsql variable?
current_setting(), or select from the pg_settings view.
regards, tom lane
---(end of broadcast)---
TIP 1:
On Fri, 2007-03-02 at 16:39 -0500, Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > Isn't a REINDEX still needed in the case of monotonically increasing
> > keys, such as in a sequence or timestamp index? I also delete tuples, so
> > that results in a forward-shifting range of keys.
>
Jan Muszynski wrote:
> I found this thread (I'm posting here because I'm not subscribed to
> Hackers)
> http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html
>
> which seems to be talking about this issue. I'm just wondering what the
> current status on this is. Someone I know i
On Wed, Feb 28, 2007 at 16:19:02 -0800,
Omar Eljumaily <[EMAIL PROTECTED]> wrote:
> select max(amount), payee, id from checks group by payee;
>
> Why won't the above work? Is there another way to get the id for the
> record with the highest amount for each payee?
While the DISTINCT ON approac
In response to [EMAIL PROTECTED]:
> Quoting Bill Moran <[EMAIL PROTECTED]>:
>
> > In response to [EMAIL PROTECTED]:
> >
> >> I've been using PostgreSQL on Mac OS X for a few years, but now I'm
> >> trying to
> >> install it on a WIndows computer so someone else can use it, and I'm
> >> getting
Any way to pull the value of a config variable
into a pl/pgsql variable?
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 02, 2007 3:46 PM
> To: David Fetter
> Cc: Adam Rich; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Custom session vari
David Fetter <[EMAIL PROTECTED]> writes:
> On Fri, Mar 02, 2007 at 01:53:28PM -0600, Adam Rich wrote:
>> Is there any way to define custom variables per session scope?
> You can have them in PL/Perl(U), PL/Tcl(U) and PL/PythonU and other
> such PLs, and you can create SQL accessors for them.
Anot
David Fetter wrote:
> On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
>> Hello,
>>
>> Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
>> However I have spoken with a Alexey and Alvaro and Command Prompt has
>> decided to make WITH/RECURSIVE a priority for 8
Jeff Davis <[EMAIL PROTECTED]> writes:
> Isn't a REINDEX still needed in the case of monotonically increasing
> keys, such as in a sequence or timestamp index? I also delete tuples, so
> that results in a forward-shifting range of keys.
No, that shouldn't be a problem, if you're maintaining a cons
Casey Duncan <[EMAIL PROTECTED]> writes:
> I have some nightly statisics queries that runs against a view which
> unions several large tables. Recently one of these queries started
> running into out of memory errors. This is on postgresql 8.1.8
> running on 32-bit Debian Linux.
What have yo
Quoting Bill Moran <[EMAIL PROTECTED]>:
In response to [EMAIL PROTECTED]:
I've been using PostgreSQL on Mac OS X for a few years, but now I'm
trying to
install it on a WIndows computer so someone else can use it, and I'm getting
the following error message when I try to advance beyond the "Se
In response to Raymond O'Donnell <[EMAIL PROTECTED]>:
> On 02/03/2007 21:14, Joshua D. Drake wrote:
>
> > Don't install as an adminstrator :), that is the long and short of it.
>
> I didn't think there was any problem about installing as an
> Administrator - just having PG run as one.
The prob
On 02/03/2007 21:14, Joshua D. Drake wrote:
Don't install as an adminstrator :), that is the long and short of it.
I didn't think there was any problem about installing as an
Administrator - just having PG run as one.
Ray.
---
Ray
In response to [EMAIL PROTECTED]:
> I've been using PostgreSQL on Mac OS X for a few years, but now I'm trying to
> install it on a WIndows computer so someone else can use it, and I'm getting
> the following error message when I try to advance beyond the "Service
> Configuration" screen in the in
[EMAIL PROTECTED] wrote:
> I've been using PostgreSQL on Mac OS X for a few years, but now I'm trying to
> install it on a WIndows computer so someone else can use it, and I'm getting
> the following error message when I try to advance beyond the "Service
> Configuration" screen in the installer:
>
On Fri, Mar 02, 2007 at 01:53:28PM -0600, Adam Rich wrote:
>
> Is there any way to define custom variables per session scope?
You can have them in PL/Perl(U), PL/Tcl(U) and PL/PythonU and other
such PLs, and you can create SQL accessors for them.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> ht
I've been using PostgreSQL on Mac OS X for a few years, but now I'm trying to
install it on a WIndows computer so someone else can use it, and I'm getting
the following error message when I try to advance beyond the "Service
Configuration" screen in the installer:
"Your local 'Administrators' grou
On 2 Mar 2007 11:20:28 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi All Esteemed Developers,
I have a requirement to have dates like ddmmmyyy. ie: 03MAR07
I want to be able to have dates returned from a query in this format
so that I can use passthrough queries from Access. I know I c
On 3/3/07, Laurent ROCHE <[EMAIL PROTECTED]> wrote:
Hi,
Does anyone know if Ubuntu 6.10 (LTS) has packages for
PostgreSQL 8.2, from a recommandable place ?
http://www.google.com/linux?hl=en&q=ubuntu+postgres+8.2&btnG=Search&meta=
Cheers,
Andrej
---(end of broadcast)---
On Wed, 2007-02-28 at 09:17 -0800, Joshua D. Drake wrote:
> Bill, you are right but I believe Jim was speaking from a general
> perspective. Generally speaking you should not have to reindex, or if
> you do very rarely.
>
> I too have a couple of databases we manage that require a reindex more
> o
Adam Rich wrote:
Is there any way to define custom variables per session scope?
In oracle, we do this using package variables.
This would be so cool to have.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200 Cell: 631-379-0010
::
I have some nightly statisics queries that runs against a view which
unions several large tables. Recently one of these queries started
running into out of memory errors. This is on postgresql 8.1.8
running on 32-bit Debian Linux.
Here is the error in the log including the query (excluding
David Fetter wrote:
On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
Hello,
Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
However I have spoken with a Alexey and Alvaro and Command Prompt has
decided to make WITH/RECURSIVE a priority for 8.4.
Any cha
Is there any way to define custom variables per session scope?
In oracle, we do this using package variables.
Basically when a user logs into our application, it generates one-time
session information that we want to make available to all the procedures
and triggers, without passing it directly (
Hi All Esteemed Developers,
I have a requirement to have dates like ddmmmyyy. ie: 03MAR07
I want to be able to have dates returned from a query in this format
so that I can use passthrough queries from Access. I know I can use
to_char to format the date anyway I want, but this causes the column
t
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> OK, I take note of this.
> I assume it's because you consider that pg_dump has only one role (to produce
> files to be used by pg_restore) and not two as I said in my previous email.
I agree that pg_dump has usefulness for creating schema documentation.
On Fri, Mar 02, 2007 at 10:52:14AM -0800, Joshua D. Drake wrote:
> Hello,
>
> Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
> However I have spoken with a Alexey and Alvaro and Command Prompt has
> decided to make WITH/RECURSIVE a priority for 8.4.
Any chance we can get
Hi,
Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, from a
recommandable place ?
I can not recommend my clients to use 8.2 if there's nobody supporting the
packages (so just compiling from the source code is not an option).
Have fun,
[EMAIL PROTECTED]
The Computing Fro
OK, I take note of this.
I assume it's because you consider that pg_dump has only one role (to produce
files to be used by pg_restore) and not two as I said in my previous email.
extract from previous email
So to me, pg_dump has two missions:
- to create files to be used by
Hello,
Unfortunately we (the community) will not have WITH/RECURSIVE for 8.3.
However I have spoken with a Alexey and Alvaro and Command Prompt has
decided to make WITH/RECURSIVE a priority for 8.4.
Our current goals are to spend time over the next couple of months
determining a roadmap of h
Martijn van Oosterhout writes:
> I don't think you can acheive the effect you want with a FIFO.
I think Doug had it right: the trick is to have some process holding the
FIFO open for write throughout the procedure, so that the reader (psql)
doesn't see an EOF. This doesn't necessarily have to be
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> I have read the given links, and I understand the reasons.
> Still, I am a bit surprised to see no mention of this in the documentation of
> pg_dump. I would expect to see at least a line stating that the colum
> declared with SERIAL will transformed t
The final answer wound up being
ALTER TABLE current ALTER COLUMN orignum SET STATISTICS 100;
and then an ANALYZE current;
Then the queries started running like a champ (split seconds, not minutes).
Thanks Richard!
Rob
Richard Huxton wrote:
> Rob Schall wrote:
>> When I reanalyzed the anit
Hi Tom,
I have read the given links, and I understand the reasons.
Still, I am a bit surprised to see no mention of this in the documentation of
pg_dump. I would expect to see at least a line stating that the colum declared
with SERIAL will transformed to a SEQUENCE.
I understand the point tha
On Mar 1, 2007, at 7:30 PM, Paul Lambert wrote:
Thanks to all who have helped me over the last month or so with
converting my system from M$ SQL server to Postgres.
Unfortunately I've decided to scrap the project and continue
working with M$ SQL Server... PG just isn't doing what I want.
Rob Schall wrote:
I noticed the rows bit. I wasn't quite sure why it thought it would get
so many back. Even after doing a analyze. I will alter the table stats
and see if that helps.
As for the values in orignum, they are all 10 digit numbers
(nxx,npa,num). I probably could have stored them as
On Fri, Mar 02, 2007 at 05:26:03PM +0100, Vincenzo Romano wrote:
> > psql gets an EOF on the named pipe when the first shell command
> > exits. You need to batch all your commands and send them in one shell
> > command, so it keeps the pipe open until it's done.
> >
> > -Doug
>
> Using "echo -n"
On Thu, Mar 01, 2007 at 08:54:38PM -0400, eddy sanchez wrote:
> WEBMAIL Server: UDABOLnet, Universidad de Aquino Bolivia
>
>
> Can anyone help me???
>
> I work with plpgsql and I need to add items to a record variable, with a for
> statement, something like this:
Does it have to be a record v
On Friday 02 March 2007 17:07 Douglas McNaught wrote:
> Vincenzo Romano <[EMAIL PROTECTED]> writes:
> > Hi all.
> >
> > Under Linux I'm trying to communicate to an instance of the psql client
> > running in the background through a couple of named pipes.
> > I'd like to do something like this:
> >
> The portable (and correct) way to do it is to use the DEFAULT keyword
> like this:
>
> INSERT INTO some_table (id_field) VALUES (DEFAULT);
Alternatively, for columns for which you have no value, don't specify them
at all in the insert.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.co
Vincenzo Romano <[EMAIL PROTECTED]> writes:
> Hi all.
>
> Under Linux I'm trying to communicate to an instance of the psql client
> running in the background through a couple of named pipes.
> I'd like to do something like this:
>
> $ mkfifo /tmp/pg_ipipe /tmp/pg_opipe
> $ psql -d testdb -U testus
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> I understand (and I have read) that there have been changes and discussions
> about the way, pg_dump treats SERIAL columns in the latest versions(8.x).
> However, I have not been able to get a document explaining exactly what the
> changes are and what'
On Thu, 2007-03-01 at 18:09, Mariano Mara wrote:
> Shiva Sarna escribió:
> > Hi,
> >
> > I am working on a web application where the front end is struts
> > framework and back end is PgSQL 7.4.
> >
> > The client want us to support 2000 simultaneous users. My question
> > is will there be any pe
Hi all.
Under Linux I'm trying to communicate to an instance of the psql client
running in the background through a couple of named pipes.
I'd like to do something like this:
$ mkfifo /tmp/pg_ipipe /tmp/pg_opipe
$ psql -d testdb -U testuser < /tmp/pg_ipipe > /tmp/pg_opipe &
...
$ echo "\t" > /tmp
Rob Schall wrote:
When I reanalyzed the anitmp table with just the 4 entries (2 with
istf=true and 2 with istf=false), both queries then ran the same way/time.
So it would appear, if you want to do a join or a subselect (IN), then
the number of items if will be comparing it to must be less than a
When I reanalyzed the anitmp table with just the 4 entries (2 with
istf=true and 2 with istf=false), both queries then ran the same way/time.
So it would appear, if you want to do a join or a subselect (IN), then
the number of items if will be comparing it to must be less than a
certain number. In
Hi,
I understand (and I have read) that there have been changes and discussions
about the way, pg_dump treats SERIAL columns in the latest versions(8.x).
However, I have not been able to get a document explaining exactly what the
changes are and what's the reasoning behind it, not even in the do
In response to Tom Lane <[EMAIL PROTECTED]>:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Just an FYI ... I remembered what prompted the cron job.
>
> > We were seeing significant performance degradation. I never did actual
> > measurements, but it was on the order of "Bill, why is restoring tak
Paul Lambert wrote:
No... I jest, I've finally got the entire system up and running exactly
as I want it and I am ready to do my first customer install. That's
another 40 or 50 PG installs over the next few months :D
Haha! Just think of all the licencing fees we'll ... oh, damn!
--
Richar
hubert depesz lubaczewski wrote:
On 3/1/07, Kenneth Downs <[EMAIL PROTECTED]> wrote:
Better? I think perhaps different. There is materialized path, which
requires a very problematic unlimited-length column to hold the path,
and there is upper/lower bounds, which again requires client-side
row-
Hi!
This is a known problem on systems, where you try to install
PostgreSQL via remote Terminal Service Session. You can install server
without initiating database, and later run initdb under non privileged
user using cmd. You should specify the same datadir which postgresql
service wou
On 3/1/07, Kenneth Downs <[EMAIL PROTECTED]> wrote:
Better? I think perhaps different. There is materialized path, which
requires a very problematic unlimited-length column to hold the path,
and there is upper/lower bounds, which again requires client-side
row-by-row processing. Both have the
58 matches
Mail list logo
