iztech wrote:
On Jun 12, 6:31 am, iztech <[EMAIL PROTECTED]> wrote:
i have just switched to posgresql and installed for use with ruby.
i need to move my app and database to a new server. since i can shut
down the server i think it will be easier for me to do a file system
level back up.
pg_du
On Thu, 12 Jun 2008, Rowan wrote:
I would like to create a nested statement but am unsure of the correct
syntax. My statement shoudl read someting like
SELECT field1, field2 FROM table WHERE name ILIKE xxx AND ( street
ILIKE or street2 ILIKE )
so basically it needs to match name and e
On Thu, 12 Jun 2008, krishtpt wrote:
1. I am trying to disable constraints from a particular table in postgresql.
But I couldn't get the alter command for the same.
The documentation is generally pretty good, if you know what you're
looking for. At what point in reading
http://www.postgresq
i have just switched to posgresql and installed for use with ruby.
i need to move my app and database to a new server. since i can shut
down the server i think it will be easier for me to do a file system
level back up.
when i try to shut the server down i get this message
sudo -u postgres pg_c
Hi There,
I am new to Postgresql. I have few questions regarding the sql syntax in
Postgresql.
1. I am trying to disable constraints from a particular table in postgresql.
But I couldn't get the alter command for the same.
2. I am trying to fetch all the constraints from a specific table using a
I would like to create a nested statement but am unsure of the correct
syntax. My statement shoudl read someting like
SELECT field1, field2 FROM table WHERE name ILIKE xxx AND ( street
ILIKE or street2 ILIKE )
so basically it needs to match name and either street or street 2..
any hel
On Jun 12, 6:31 am, iztech <[EMAIL PROTECTED]> wrote:
> i have just switched to posgresql and installed for use with ruby.
>
> i need to move my app and database to a new server. since i can shut
> down the server i think it will be easier for me to do a file system
> level back up.
>
> when i try
Terry Yapt wrote:
> I did installed 8.3.1 on WinXP Prof. and all was ok. After that
> successful install I have tried to install 8.2.x without
> success several
> times on the same workstation.
>
> Today I have tried to install 8.3.3 and I have stuck on the
> same error:
>
> ===
On 12/06/2008 19:38, Terry Yapt wrote:
Answering to myself:
Version of PostgreSQL Database:
SELECT VERSION();
Heh - beat me to it. :-) Glad you're sorted.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on
> I'm a developer who is working on PostgreSQL API and i got stuck in
> Terminating session.
> I'm working on PostgreSQL 8.3.
>
> Please, help if anyone has ideas on how to kill PostgreSQL session.
>
> i found this code in misc.c
>
> #ifdef NOT_USED
>
> /* Disabled in 8.0 due to reliability con
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success several
times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on the same error:
Did you un
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success several
times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on the same error:
===
Service 'PostgreSQL Database Server
On Sat, 2008-06-07 at 08:59 -0500, Adam Rich wrote:
> what's faster on one dbms my be different than another. I've found
> that postgresql is usually slower than other databases for IN ()
> queries, but handles EXISTS and inner joins (a third way of writing
> your queries above) quite quickly.
D
On 12/06/2008 14:37, [EMAIL PROTECTED] wrote:
I need to create a sql script and launch it from pgadmin. In this script
some sql statements (INSERT) have to depend from the result of previous
statements (SELECT).
Is there a way to define a variable in SQL and set its value with the result
of a SE
Adam Dear wrote:
> Let me ask this question. Is there any other option for moving data
> from one server to another that doesn't involve pg_dump? If I can get
> the data out of this server, and onto my new one I don't care if the old
> server gets fixed. I just need the data. The new server alr
What is Slony? I have a super user account for the server and the database.
Joshua D. Drake wrote:
On Thu, 2008-06-12 at 11:33 -0500, Adam Dear wrote:
Let me ask this question. Is there any other option for moving data
from one server to another that doesn't involve pg_dump? If I can get
t
Adam Dear <[EMAIL PROTECTED]> writes:
> Let me ask this question. Is there any other option for moving data
> from one server to another that doesn't involve pg_dump? If I can get
> the data out of this server, and onto my new one I don't care if the old
> server gets fixed. I just need the d
Adam Dear wrote:
> Let me ask this question. Is there any other option for moving data
> from one server to another that doesn't involve pg_dump? If I can get
> the data out of this server, and onto my new one I don't care if the old
> server gets fixed. I just need the data. The new serv
On Thu, 2008-06-12 at 11:33 -0500, Adam Dear wrote:
> Let me ask this question. Is there any other option for moving data
> from one server to another that doesn't involve pg_dump? If I can get
> the data out of this server, and onto my new one I don't care if the old
> server gets fixed. I
Let me ask this question. Is there any other option for moving data
from one server to another that doesn't involve pg_dump? If I can get
the data out of this server, and onto my new one I don't care if the old
server gets fixed. I just need the data. The new server already has
the table st
Adam Dear <[EMAIL PROTECTED]> writes:
> If I restored the data directory again wouldn't that undo the Vacuum
> Freeze command that I did that has locked the database into the state
> that it is in now?
It'd undo the freeze, but that doesn't get you any closer to a solution.
What you need is to g
Zoltan Boszormenyi <[EMAIL PROTECTED]> writes:
> Tom Lane írta:
>> What that sounds like to me is a corrupt index (infinite loop of
>> right-links, perhaps). Have you tried REINDEXing the table?
> How can such an infinite loop sneak into an index?
> Hardware is from Sun, not a grocery store PC, s
I downloaded a hex editor, but honestly, I can't make heads or tails of
what I'm looking at. I'm not sure what needs changing.
Also, FYI, you mentioned that you thought I had deleted the record with
ctid=(0,2). I did delete that, but thats what caused the database to
not work. I restored a
On Thu, 2008-06-12 at 11:56 -0400, Andrew Sullivan wrote:
> On Thu, Jun 12, 2008 at 05:31:37PM +0200, Zoltan Boszormenyi wrote:
>
> > Hardware is from Sun, not a grocery store PC, so I don't suppose it to
> > be faulty.
>
> FWIW, I had a pair of E4500s in one job that I would _happily_ have
> t
On Thu, Jun 12, 2008 at 05:31:37PM +0200, Zoltan Boszormenyi wrote:
> Hardware is from Sun, not a grocery store PC, so I don't suppose it to
> be faulty.
FWIW, I had a pair of E4500s in one job that I would _happily_ have
traded for any beige box you care to mention. Heck, at the end I
mighta tr
Scott Marlowe wrote:
Yes there is. Use an indexed id field of some kind.
select * from table where idfield between 0 and 100;
select * from table where idfield between 100 and 1000100;
Will both be equally fast. Offset / limit syntax requires the db to
materialize + rows for the query. b
Tom Lane írta:
> Zoltan Boszormenyi <[EMAIL PROTECTED]> writes:
>
>> The realtime trace I captured from the hung INSERT shows that it
>> enters two functions repeatedly: _bt_relandgetbuf() and _bt_compare().
>> The pattern in which these functions entered match either _bt_moveright() or
>> _bt_i
"wenjing wu" <[EMAIL PROTECTED]> writes:
> Now , I am trying to vacuum the database companion in the standalone model:
> [EMAIL PROTECTED] /var/lib/pgsql/data/pg_log# su - postgres
> -bash-3.00$ postgres -D /var/lib/pgsql/data
This is defaulting to connecting to database postgres ...
>
Zoltan Boszormenyi <[EMAIL PROTECTED]> writes:
> The realtime trace I captured from the hung INSERT shows that it
> enters two functions repeatedly: _bt_relandgetbuf() and _bt_compare().
> The pattern in which these functions entered match either _bt_moveright() or
> _bt_insertonpg().
What that so
Adam Dear <[EMAIL PROTECTED]> writes:
> I'm comfortable enough with it that I can edit it if I can find exactly
> what to edit. Whats the best way to edit the file? I've opened it using:
> vim -b 1260
> Here is what is at the end of the block in the file. If you could point
> me in the right
I have two immutable Pl/PG funcs - func A takes a parameter X, looks up
related value Y from a table and passes Y to func B. Now, if I do something
like
select A(field_x) from bigtable
it will, of course call A for every single row since paramater is changing.
However, it also calls func B for ev
Zoltan Boszormenyi wrote:
> This is so embarrassing that the file and its only index used up only 3.3MB,
> at the time of my testing no one else used the database, shared_buffers is
> large enough to hold both the index and the table data totally:
I would be embarrased if this was on a recent rel
Adam Dear wrote:
> I'm comfortable enough with it that I can edit it if I can find exactly
> what to edit. Whats the best way to edit the file? I've opened it
> using:
>
> vim -b 1260
>
> Here is what is at the end of the block in the file. If you could point
> me in the right direction, I'
ponsor:
VOGLIA DI VACANZE ?
A Riccione i Family Hotels sono gli alberghi specializzati per le vacanze
dei bambini
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7983&d=20080612
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Here I would like to check:
IF param1 < 75 THEN region-in-$result-should-be-set-to-NULL
Not sure I get what all you're wanting to do from your message, but
could you use a case statement in sql to do this? Or put it in the
where clause?
I knew it too be a bit complicated to explain
Celso Pinto wrote:
> What, if any, would be the recommended options to improve this
> scenario? Not using intarray? :-)
Not using a broken design. Arrays are a poor fit in the relational model.
Avoid them.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreS
I'm comfortable enough with it that I can edit it if I can find exactly
what to edit. Whats the best way to edit the file? I've opened it using:
vim -b 1260
Here is what is at the end of the block in the file. If you could point
me in the right direction, I'd appreciate it.
@[EMAIL PROTEC
I think you could do overlapping CHECK constraints for the rules for a
very short period of time. Querying for just that time will hit both
partitions, so it won't be perfect from a performance standpoint, but it
would only do that for a very small timeframe.
And I can certainly agree it's not id
Gregory Stark írta:
> "Zoltan Boszormenyi" <[EMAIL PROTECTED]> writes:
>
>
>> Also, VACUUM FULL also takes too much time, on an otherwise idle database, I
>> worked on a copy of their live database. During VACUUM, _bt_getbuf() was
>> also called repeatedly with the block number jumping up and do
2008/6/10 Bojan <[EMAIL PROTECTED]>:
> How to invoke function which has arguments declared as type "date"?
>
>
>
> I want to make function which will return a list of all dates between
> starting and ending
>
> date which are two arguments of that function. I tried with:
>
>
>
> select * from foo(
On Thu, Jun 12, 2008 at 9:30 AM, Guillaume Lelarge
<[EMAIL PROTECTED]> wrote:
>
> They don't use the same algorithms.
>
Which, it should be noted, is intentional, so pgAdmin has a chance to
warn you if your autovac settings are screwy.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
-
Collin Peters a écrit :
Does anyone have *any* thoughts on this? This seems to be a fairly
common problem. Does anybody have any good links that they can
provide to find an answer?
My current test is that I have a table where all the rows were purged,
and then new ones inserted using a specifi
am Tue, dem 10.06.2008, um 18:02:01 +0100 mailte Bojan folgendes:
> How to invoke function which has arguments declared as type ?date??
>
>
>
> I want to make function which will return a list of all dates between starting
> and ending
>
> date which are two arguments of that function. I tri
On Thu, Jun 12, 2008 at 7:18 AM, Collin Peters <[EMAIL PROTECTED]> wrote:
> Bump
>
> Does anyone have *any* thoughts on this? This seems to be a fairly
> common problem. Does anybody have any good links that they can
> provide to find an answer?
>
> My current test is that I have a table where al
Hi all, I was looking into PostgreSQL’s full-text search but when
using the to_tsvector function with italian settings I get this error:
test=> select to_tsvector('italian','prova');
ERROR: invalid byte sequence for encoding "UTF8": 0xc3
HINT: This error can also happen if the byte sequence do
Tom,
I'm using 8.3.1. I did run EXPLAIN but have never familiarized myself
with how to read/use it beside simple comparing cost estimation and
whether there is any seq scan that can benefit from creating index.
Thanks for replying
On Jun 7, 11:19 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> askel <
How to invoke function which has arguments declared as type “date”?
I want to make function which will return a list of all dates between
starting and ending
date which are two arguments of that function. I tried with:
select * from foo(2008-06-01, 2008-06-09)
select * from foo(‘2008-06-
Hi,
Our site run into a pnfs server failure, because of the postgresql transaction
id wraparound problem,
Now , I am trying to vacuum the database companion in the standalone model:
[EMAIL PROTECTED] /var/lib/pgsql/data/pg_log# su - postgres
-bash-3.00$ postgres -D /var/lib/pgsql/data
Hi there,
I'm a developer who is working on PostgreSQL API and i got stuck in Terminating
session.
I'm working on PostgreSQL 8.3.
Please, help if anyone has ideas on how to kill PostgreSQL session.
i found this code in misc.c
#ifdef NOT_USED
/* Disabled in 8.0 due to reliability concer
51 matches
Mail list logo
