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.
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
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 fail
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 5.
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
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
should be easy
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 stable;
What
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
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 starts,
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're going to
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
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
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
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 from
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 of
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
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
same lifespan
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
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
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 database with some
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
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 btree
(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
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
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
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 a
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 parameter.
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 more information on this
topic
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 ?
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
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
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
We have an
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 dump
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 :)
Well, in
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..
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
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 was
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 might
[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
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
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:
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 time.
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
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
production)
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 power, and even
-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
that
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 Fri, Jan
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:
Thanks
On Jan
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
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
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
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.com
-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, Pennsylvania is a haven
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 everyone knows,
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. Either a
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?
So why not
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 does
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
--- 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
makes you
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
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. As it
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®
[EMAIL
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 making it
[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 support!
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 do
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
wanted
to
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 -
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
[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
- checks
81 matches
Mail list logo
