T.J. Adami wrote:
On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote:
It's quite simple to have problems with pgAdmin's backup procedure.
Hmm - shouldn't be, and if so then please let the pgAdmin people know!
They're always working to improve the package and it's
I think the same. We
Chris Browne wrote:
The only idea that comes to mind to follow that is to look into
tsearch. On PostgreSQL 8.3, it's built in; on 8.2 and earlier, it's a
"contrib" module. It allows indexing on words inside columns, which
would seem to fit your requirement.
You might want to google for "postg
On 16/01/2008, Richard Huxton <[EMAIL PROTECTED]> wrote:
> T.J. Adami wrote:
> What puzzles me is that as far as I know, pgAdmin *uses* pg_dump and
> pg_restore to handle its backup needs.
It does. Make sure it's using the correct version for your server
though - that's the only reason it might fa
2008/1/16, Tom Lane <[EMAIL PROTECTED]>:
> I went through this thread again, and noticed something that no one
> seems to have remarked on at the time: the vmstat numbers near the
> bottom of this post
>
> http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php
This post is from january
Hi all.
I have two table like these:
create table compo (
t text,
i int
);
create table tab (
x int,
c compo
);
Then I have a function like this:
create or replace function f_compo()
returns setof compo as $body$
...
$body$ language sql stable;
What I'd need to do is to insert the re
2008/1/16, Joshua D. Drake <[EMAIL PROTECTED]>:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wed, 16 Jan 2008 00:29:16 -0500
> Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > > If we are sure that this issue is apparent actual row insertion it
Reg Me Please wrote:
> I have two table like these:
>
> create table compo (
> t text,
> i int
> );
>
> create table tab (
> x int,
> c compo
> );
>
> Then I have a function like this:
>
> create or replace function f_compo()
> returns setof compo as $body$
> ...
> $body$ language sql s
Reg Me Please wrote:
What I'd need to do is to insert the results from f_compo() into
the table TAB along with a value x.
I expected somthing like this to work:
insert into tab
select 42,row( c.* ) from f_compo() c;
But I get
ERROR: cannot cast type record to compo
You need to add an exp
Ok, did what you said: stopping server, deleting "newly" created
"data" directory, re-running initdb, starting the server, stopping
the
server.
Renamed "empty" data directory.
Restarting server: NOT COMPLAINING "you need to run initdb" or
something else Although it's saying that it
>> Hi there,
>>
>> I want to know how many connections is created simultaneously in data
base
>> per day.
>
>Do you want to know the max simo connections at any given time, or the
>total connections in a given day? Assuming you want to know the max
>simo connections at any given time, I think you'
Hello,
I would appreciate if someone explained me how exactly prepared parametrized
statements are planned, i.e. what kind of assumptions planner makes on param
values, selectivity, expected row count etc. that affect in particular
whether indexes will be used or not. For instance consider the fol
I am prototyping a system migration that is to employ Ruby, Rails and
PostgreSQL. Rails has the convention that the primary key of a row is an
arbitrary integer value assigned by the database manager through a
sequence. As it turns out, the legacy application employs essentially the
same conventi
Lew wrote:
Tom Lane wrote:
Before you get into that, try reducing these parameters:
maintenance_work_mem = 1572864
work_mem = 1048576
They are way too high, especially the second one.
So if 1.5 MB maintenance_work_mem and 1 MB work_mem are "way too high",
why are the default values in t
Hello,
i want know how can i get the schema name that execute a trigger.
for example, if a have a schema "myschema" and a table "mytable" and
it have a trigger procedure, i want know inside the trigger procedure,
with plpgsql, the shcema name "myschema"..
thanks,
pd. sorry for my english, i'm f
http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
What does this mean for Sun's support of Postgres?
--
Russ.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Jan 4, 11:48 am, [EMAIL PROTECTED] (Gregory Stark) wrote:
> <[EMAIL PROTECTED]> writes:
> > I've just spent a few hours searching and reading about the postgres
> > way of selecting distinct records. I understand the points made about
> > the ORDER BY limitation of DISTINCT ON, and the abiguity
Having recently jumped ship from MSSQL to Postgres I'm finding it a
little difficult getting onto the 'correct path.' Basically I have a
live database and I want to take a copy of that and then restore it
onto a backup server.
Firstly I'm using Postgres 8.2 and pgAdmin 1.6.3
Within the pgAdmin i
Am Sonntag 13 Januar 2008 00:46:50 schrieb Tom Lane:
> Kris Jurka <[EMAIL PROTECTED]> writes:
> > On Thu, 10 Jan 2008, [EMAIL PROTECTED] wrote:
> >> What do you mean with "longer lifespan"? Doesn't the JDBC driver uses
> >> the PREPARE Sql Statement and therefore the prepared Statement has the
> >>
Hello, I'm new to libpq and I'm trying to discover a
means of updating resultset columns.
I can see there's a "get" PQgetvalue but no "set"
equivalent PQsetvalue.
I've read the documentation and checked out the
examples, but neither seem to indicate that this is
possible?
I'd appreciate some dir
Tom Lane wrote:
Before you get into that, try reducing these parameters:
maintenance_work_mem = 1572864
work_mem = 1048576
They are way too high, especially the second one.
So if 1.5 MB maintenance_work_mem and 1 MB work_mem are "way too high", why
are the default values in the postgresq
On Friday 11 January 2008 13:44, Josh Harrison wrote:
> On Jan 11, 2008 1:22 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
> > On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
> > > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > >> Hi
> > >> We have an Oracle production databa
I did try it but always get "public".
i want get the schema that execute the trigger, because i have a
function that is used by diferents tables in diferents schemas.
thanks for your help,
Danilo
---(end of broadcast)---
TIP 3: Have you checked o
Hi all.
I have a database with 62 million registers and I have to make a
SELECT using LIKE.
This is my select:
SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%' AND city = 'SAO
PAULO' AND state = 'SP'
I have an index created like this:
CREATE INDEX "telefones_idx2" ON "public"."phone"
USING
(attribution restored)
Clodoaldo wrote:
> I don't know if the plan would be the same but this is a bit clearer:
>
> WHERE COALESCE(b.quantity, 0) > COALESCE(b.deliveredsum, 0)
Sim Zacks wrote:
That should be true, but sometimes we get deliveries of greater quantity
then we ordered.
I just
create temp table test (col char);
select count(col) from test order by col;
causes
ERROR: column "test.col" must appear in the GROUP BY clause or be used in
an aggregate function
SQL state: 42803
How to fix this ?
This statement is generated by DbLinq driver and it is difficult to re-qrite
Hi there,
I have a table with a single column, pk of varchar type
The table contains few names, say:
A
C
B
In the first two records there is a between the and the following letter
A and C while, the third one has a B immediately following the (without
blanks).
In post
On Mittwoch, 16. Januar 2008, Stefan Schwarzer wrote:
| The logfile is telling me this when I try to start the server with my
| "old" data folder:
|
| FATAL: database files are incompatible with server
| DETAIL: The database cluster was initialized with PG_CONTROL_VERSION
| 738394112, but the
Fixes are committed to CVS, hope, they will help you.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
TIP 9: In versi
I think the function-trigger approach will be useful to me to bypass this
problem.
Thanks to all again for your suggestions!
--
Free pop3 email with a spam filter.
http://www.bluebottle.com/tag/5
---(en
On Fri, Jan 11, 2008 at 11:43:54AM -0500, James B. Byrne wrote:
> My question is this: Can one assign an id number to a sequenced key column
> on create and override the sequencer? If one does this then can and, if
> so, how does the sequencer in Postgresql handle the eventuality of running
> into
On Tue, 2008-01-15 at 16:32 +0100, Luca Arzeni wrote:
> In all cases I'm using locale LATIN9 during DB creation, but I tested also
> with ASCII, UTF8 and LATIN1 encoding.
I guess this has nothing to do with the encoding, but with the collation
rules used, which is governed by "lc_collate" paramet
On Sun, Jan 13, 2008 at 09:55:08PM +1100, Tristen Ennemuist wrote:
> Hello, I'm new to libpq and I'm trying to discover a
> means of updating resultset columns.
>
> I can see there's a "get" PQgetvalue but no "set"
> equivalent PQsetvalue.
Libpq doesn't do this.
Have a nice day,
--
Martijn van
| The logfile is telling me this when I try to start the server with
my
| "old" data folder:
|
| FATAL: database files are incompatible with server
| DETAIL: The database cluster was initialized with
PG_CONTROL_VERSION
| 738394112, but the server was compiled with PG_CONTROL_VERSION 812.
|
>
>
> > > >> We have an Oracle production database with some terbytes of data.
> > > >> We wanted
> > > >> to migrate that to Postgresql (rigt now...a test database and not
> > > >> production) database.
> > > >> What are the good options to do that?
> > > >> Please advise me on where to look for m
On Mon, Jan 14, 2008 at 09:02:46PM +0200, Andrus wrote:
> create temp table test (col char);
> select count(col) from test order by col;
>
> causes
>
> ERROR: column "test.col" must appear in the GROUP BY clause or be used in
> an aggregate function
> SQL state: 42803
>
>
> How to fix this ?
Good morning everyone!
As you may have guessed from previous posts, i just recently migrated my
main database server from 7.4.x to 8.1.11. This part went pretty smoothly.
:)
One of the client machines in my architecture is a Fedora Core 4 box. I
unfortunately cannot change this so I had to buil
Russ Brown wrote:
http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
What does this mean for Sun's support of Postgres?
Does it matter? :) I am sure OmniTI and Command Prompt will be
happy to help any disgruntled customer :)
Sincerely,
Joshua D. Drake
---(end of b
On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> > Thanks
> >
> > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote:
> >
> > > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote:
> > > > Hi
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
>> This looks like an endianess mismatch; did you already mention on what
>> architecture you are on?
> MacPro, Leopard
Did you just move from a PPC-based Mac to an Intel-based one?
If so, you're out of luck --- you need to go back to the PPC
to make a
Joshua Drake shaped the electrons to say:
>
> Russ Brown wrote:
> > http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
> >
> > What does this mean for Sun's support of Postgres?
> >
>
> Does it matter? :) I am sure OmniTI and Command Prompt will be
> happy to help any disgruntled customer :)
danilo.juvinao wrote:
> i want know how can i get the schema name that execute a trigger.
>
> for example, if a have a schema "myschema" and a table "mytable" and
> it have a trigger procedure, i want know inside the trigger procedure,
> with plpgsql, the shcema name "myschema"..
http://www.postg
On Wed, 16 Jan 2008, [EMAIL PROTECTED] wrote:
it has been suggested that perhaps FC4 is not capable of being
thread safe.
FC4 deprecated use of Linux Threads in preference to the Native POSIX
Thread Library, and I wouldn't be surprised to find that transition wasn't
perfect (welcome to 2005'
Russ Brown wrote:
> http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
>
> What does this mean for Sun's support of Postgres?
>
Speaking from pure opinion here :)
Oracle for example is buying out the little techs that MySQL relies on -
BDB and InnoDB.
The main company, MySQL AB was all that w
On Jan 16, 2008 7:19 AM, Russ Brown <[EMAIL PROTECTED]> wrote:
> http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
>
> What does this mean for Sun's support of Postgres?
I don't see why it should change really, they kind of swim in different waters.
What I do think is interesting is that Sun mi
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> One of the client machines in my architecture is a Fedora Core 4 box. I
> unfortunately cannot change this so I had to build 8.1.11 packages. When I
> was building the packages it would fail unless I passed 'pgfts 0'.
Fail how? I've never had to
How much does Sun currently contribute to the project? Do they have
designated coders?
--
View this message in context:
http://www.nabble.com/Sun-acquires-MySQL-tp14881966p14884994.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of b
Scott Marlowe wrote:
On Jan 16, 2008 7:19 AM, Russ Brown <[EMAIL PROTECTED]> wrote:
http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
What does this mean for Sun's support of Postgres?
I don't see why it should change really, they kind of swim in different waters.
What I do think is intere
dvanatta wrote:
How much does Sun currently contribute to the project? Do they have
designated coders?
They employ a core member who is not a hacker.
They provide some machines etc..
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 1: i
Joshua D. Drake wrote:
> dvanatta wrote:
>> How much does Sun currently contribute to the project? Do they have
>> designated coders?
>
> They employ a core member who is not a hacker.
> They provide some machines etc..
They contributed a DTrace patch and the Sun hackers can be seen from
time to
Alvaro Herrera wrote:
Joshua D. Drake wrote:
dvanatta wrote:
How much does Sun currently contribute to the project? Do they have
designated coders?
They employ a core member who is not a hacker.
They provide some machines etc..
They contributed a DTrace patch and the Sun hackers can be seen
If MySQL goes the way of Java, maybe there isn't too much to worry
about.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Weslee Bilodeau
Sent: Wednesday, January 16, 2008 10:56 AM
To: Russ Brown
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sun
The main company, MySQL AB was all that was left to effectively give
them control of MySQL.
PostgreSQL obviously doesn't have this risk - No one company holds that
much power, and even the -core team is split between the various
supporting companies around PostgreSQL.
Is this up to date?
On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > Hi
> > We have an Oracle production database with some terbytes of data. We wanted
> > to migrate that to Postgresql (rigt now...a test database and not
> > p
2 out of 7 - which would be Bruce & I.
Regards, Dave
On 1/16/08, Dirk Riehle <[EMAIL PROTECTED]> wrote:
>
> > The main company, MySQL AB was all that was left to effectively give
> > them control of MySQL.
> >
> > PostgreSQL obviously doesn't have this risk - No one company holds that
> > much po
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 10:25:45 -0800
Dirk Riehle <[EMAIL PROTECTED]> wrote:
>
> > The main company, MySQL AB was all that was left to effectively give
> > them control of MySQL.
> >
> > PostgreSQL obviously doesn't have this risk - No one company holds
On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
>
> On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
>
> > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> > > Thanks
> > >
> > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote:
>
On Jan 16, 2008 1:43 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
>
> On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
> >
> >
> > On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> >
> > > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> > > >
In another thread, someone mentioned writing hooks for Subversion that
would grab function definitions and DDL statements from the current
database and push them into the repository?
Does anyone have a few scripts/ cookbook examples for this? Is there
a cookbook section on the postgres wiki wher
Hi, I am trying to write a PL/pgsql function that will take a CUBE
variable (which will be a 1D point) and a double precision variable.
If the input CUBE is defined as
'(x,y,z)'::cube
the function would then return a CUBE value of the form
'(x+R,y+R,z+R),(x-R,y-R,z-R)'::cube
where R is the
Rajarshi Guha wrote:
Hi, I am trying to write a PL/pgsql function that will take a CUBE
variable (which will be a 1D point) and a double precision variable.
If the input CUBE is defined as
'(x,y,z)'::cube
the function would then return a CUBE value of the form
'(x+R,y+R,z+R),(x-R,y-R,z-R)'::
On Jan 16, 2008, at 3:41 PM, Colin Wetherbee wrote:
Rajarshi Guha wrote:
Hi, I am trying to write a PL/pgsql function that will take a CUBE
variable (which will be a 1D point) and a double precision variable.
If the input CUBE is defined as
'(x,y,z)'::cube
the function would then return a CU
What's up with 3 of the 7 being from Pennsylvania? What's the connection?
Dave Page-3 wrote:
>
> 2 out of 7 - which would be Bruce & I.
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 13:23:35 -0800 (PST)
dvanatta <[EMAIL PROTECTED]> wrote:
>
> What's up with 3 of the 7 being from Pennsylvania? What's the
> connection?
Its the closest the cult of the elephant will get to jersey.
Joshua D. Drake
- --
The
In response to dvanatta <[EMAIL PROTECTED]>:
>
> What's up with 3 of the 7 being from Pennsylvania? What's the connection?
Well, as everyone knows, Pennsylvania is a haven for brilliant
people. In fact, simply living in Pennsylvania makes you smarter.
--
Bill Moran
http://www.potentialtech.c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 16:29:01 -0500
Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to dvanatta <[EMAIL PROTECTED]>:
>
> >
> > What's up with 3 of the 7 being from Pennsylvania? What's the
> > connection?
>
> Well, as everyone knows, Pennsylvan
And this is why I live in pa, but make the trek in to the netherworld
known as new jersey. :D
On 1/16/08, Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to dvanatta <[EMAIL PROTECTED]>:
>
> >
> > What's up with 3 of the 7 being from Pennsylvania? What's the connection?
>
> Well, as every
> Russ Brown wrote:
> > http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
> >
> > What does this mean for Sun's support of Postgres?
> >
So why not go directly to the "source", Sun itself, and ask them?
Someone like Bruce should just knock on the door and ask.
Then you can evaluate the answer.
Sounds reasonable, but what one manager answers today is subject to be
changed by another tomorrow.
On 1/16/08, Otto Hirr <[EMAIL PROTECTED]> wrote:
> > Russ Brown wrote:
> > > http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
> > >
> > > What does this mean for Sun's support of Postgres?
> >
> From: Geoffrey Gowey
> Sounds reasonable, but what one manager answers today is subject to be
> changed by another tomorrow.
The intent is to get out in the open their "official" statement. That in turn
may create a discussion inside Sun that may not have taken place.
If postgres community doe
Joshua D. Drake wrote:
dvanatta <[EMAIL PROTECTED]> wrote:
What's up with 3 of the 7 being from Pennsylvania? What's the
connection?
Its the closest the cult of the elephant will get to jersey.
Whoa now, them's fightin' words. Come on over and you me, Tony, Paulie
and Silvio will have a l
--- Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to dvanatta <[EMAIL PROTECTED]>:
>
> >
> > What's up with 3 of the 7 being from Pennsylvania?
> What's the connection?
>
> Well, as everyone knows, Pennsylvania is a haven for
> brilliant
> people. In fact, simply living in Pennsylvania
On 16/01/2008 23:10, Ted Byers wrote:
Does it count if I lived there for a year many many
years ago? ;-)
...or if I visited for a day or two in 1986? ;-)
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMA
On Jan 11, 2008 10:43 AM, James B. Byrne <[EMAIL PROTECTED]> wrote:
> I am prototyping a system migration that is to employ Ruby, Rails and
> PostgreSQL. Rails has the convention that the primary key of a row is an
> arbitrary integer value assigned by the database manager through a
> sequence. A
On Jan 16, 2008, at 4:02 PM, Otto Hirr wrote:
Postgres needs to have an "official spokesman" make a request at a
"very important top official" that is responsible for the
acquisition.
..Otto
Given that Josh Berkus works for Sun, I'd say we already have that.
Erik Jones
DBA | Emma®
[EMA
Otto Hirr wrote:
> Postgres needs to have an "official spokesman" make a request at a "very
> important top official" that is responsible for the acquisition.
Postgres doesn't need to do anything, because the matter at hand does not
concern Postgres, and I think we shouldn't spend our energy maki
<[EMAIL PROTECTED]> writes:
> On Jan 4, 11:48 am, [EMAIL PROTECTED] (Gregory Stark) wrote:
>
>> And what does the plan look like?
>
> It looks great in mysql!
Like what?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication sup
Vyacheslav Kalinin wrote:
Hello,
I would appreciate if someone explained me how exactly prepared
parametrized statements are planned
http://www.postgresql.org/docs/8.2/static/sql-prepare.html
Under the "Notes" it explains it can't use an index and has to basically
guess what it's going to d
On Jan 16, 2008 1:31 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > > Hi
> > > We have an Oracle production database with some terbytes of data. We
> w
as the tile, it's a database? or what is it?
can i use "select" command to query the data of template0?
how should i explain the template0?
--
View this message in context:
http://www.nabble.com/template0%28or-template1%29-is--a-database--tp14906094p14906094.html
Sent from the PostgreSQL - ge
ivan.hou wrote:
as the tile, it's a database? or what is it?
http://www.postgresql.org/docs/8.2/static/manage-ag-templatedbs.html
--
Postgresql & php tutorials
http://www.designmagick.com/
---(end of broadcast)---
TIP 3: Have you checked our ext
[EMAIL PROTECTED] (Mischa Sandberg) writes:
>Unfortunately, with multiple jails running PG servers and (due to app
>limitations) all servers having same PGPORT, you get the situation that
>when jail#2 (,jail#3,...) server comes up, it:
>- detects that there is a shm seg with ipc key 5432001
>- che
81 matches
Mail list logo
