andy wrote:
Is there any chance there is an easier way to backup/restore? On one
hand, its not too bad, and it'll only be once (correct?). Now that fts
is in core future backup/restores will work, right? I think it's
analogous to telling someone they are updating from tsearch2 to
tsearch3,
On Fri, Oct 19, 2007 at 08:23:43AM -0300, Pedro Belmino wrote:
Hellow,
I continue to have problems using the debugger, can not achieve any
breakpoint that is outside the postmaster.c? Can anyone give me any hint?
Where do I mark a breakpoint so that I can follow the creation of an index
to
I am using linux.
1. Inicializei the postgres the console by running. / Postgres.
2. Joined in psql through console and simulated. / Psql
3. Pg_backend_pid swirled SELECT () to get the id of the process;
4. In ide tried to use that process to attach the debugger but gives the
following error
I know I haven't been very active for a while here, but I just got to
testing the October 3 version a bit prior to getting back to the Java
GSS client stuff I promised. There seem to be some funny things there.
The only serious issue is that the server doesn't require the realm
name to
Hi,
I think i have a initial Implementation. It has some bugs and i am working
on fixing it. But to show the advantages, I want to show the number of
Logical I/Os on the screen. In order to show that, i tried enabling the
log_statement option in PostgreSQL.conf. But it shows only the physical
Decibel! wrote:
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Seriously though, I can change it for 8.3, but is it really worth
back-patching?
I think it'd be worth changing for 8.3. While C forces you to worry
about memory, SQL does not, so I bet this is a surprise to most folks.
I
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-
used?
yes
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select dblink_connect('dbname=postgres');
BTW, I noticed while poking at this that the 2-arg form of ts_rewrite()
is labeled proretset = true in pg_proc.h. This must be a typo, since
a moment's glance at the code shows it cannot return a set. Good thing
we didn't ship beta2 yet ...
regards, tom lane
Excuse me,
My previous email, I had a problem formatting of my text. So it is not
understandable.
Correcting:
Pinged the following steps in the console:
1. Pinged the command postgres to start.
2. Joined in psql.
3. Typed the following command to get the id of the process:
SELECT pg_backend_pid();
On Thu, Oct 18, 2007 at 03:36:34PM -0400, Boergesson, Cheryl wrote:
Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL
8.1.10. I'm on WindowsXP and I'm compiling with Visual C++ 6.0.
...
Oddly, when I removed all comments, it worked fine.
Which comments?
Michael
--
Michael
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
True. I'll bet you don't like ts_stat() either.
It seems the right way interface here wouldn't be too different from what's
there. All we need is a SRF which takes a single tsvector and returns the set
of words from
Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander:
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Context
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
ERROR: items_pkey is an index
Context please?
Yeah, I had that one coming, didn't it... That's what I get for
Pedro Belmino [EMAIL PROTECTED] writes:
Hellow,
I continue to have problems using the debugger, can not achieve any
breakpoint that is outside the postmaster.c? Can anyone give me any hint?
Where do I mark a breakpoint so that I can follow the creation of an index
to file index.c for
Hmm, which locale do you use and what breakage do you see?
Swedish_Sweden.1252. Diffs attached. The reason is that in swedish sort
order, w and v are considered equal.
If that's all, I see no objection to adding a select_1.out expected
file that matches your results.
I've just assumed
PostgreSQL consists of multiple processes, launched by postmaster, make
sure you are debugging the right one. After connecting to a database
with your favorite client (i.e. psql) you can use ps (if you have a
unix-like system) or a task manager to determine a pid of postgres
process and then
Andy,
seems you're a right person for writing migration guide.
Oleg
On Wed, 10 Oct 2007, andy wrote:
andy wrote:
Andy Colson wrote:
Hi All,
You knew it was coming
I tried doing a pg_dump --schema-only and restoring just that, but still
got a bunch of errors (those above). If I
On 10/10/07, Marko Kreen [EMAIL PROTECTED] wrote:
On 10/10/07, Tom Lane [EMAIL PROTECTED] wrote:
* Why is txid_current_snapshot() excluding subtransaction XIDs? That
might be all right for the current uses in Slony/Skytools, but it seems
darn close to a bug for any other use.
In queue
Hellow,
I continue to have problems using the debugger, can not achieve any
breakpoint that is outside the postmaster.c? Can anyone give me any hint?
Where do I mark a breakpoint so that I can follow the creation of an index
to file index.c for example?
Thank,
--
Pedro Belmino.
Hellow,
I continue to have problems using the debugger, can not achieve any
breakpoint that is outside the postmaster.c? Can anyone give me any hint?
Where do I mark a breakpoint so that I can follow the creation of an index
to file index.c for example?
Thank,
--
Pedro Belmino.
Magnus Hagander [EMAIL PROTECTED] writes:
On Thu, Oct 18, 2007 at 10:45:29AM -0400, Tom Lane wrote:
Hmm, which locale do you use and what breakage do you see?
Swedish_Sweden.1252. Diffs attached. The reason is that in swedish sort
order, w and v are considered equal.
If that's all, I see no
Gregory Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
There doesn't seem to be any very nice way to fix this. There is
not any existing support mechanism (comparable to query_tree_walker)
for scanning whole plan trees, which means that searching a cached plan
for regclass Consts is going to
Oleg Bartunov wrote:
Andy,
seems you're a right person for writing migration guide.
Oleg
On Wed, 10 Oct 2007, andy wrote:
Where would be an easy place to find all the renamed functions?
My experience with fts is limited to one project, and I just used all
the default dictionaries, so I've
On Thu, Oct 18, 2007 at 10:45:29AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Bummer. There are lots of ways to break installcheck though - locale
being one I get biten by all the time...
Hmm, which locale do you use and what breakage do you see?
Swedish_Sweden.1252.
Pedro Belmino [EMAIL PROTECTED] writes:
I continue to have problems using the debugger, can not achieve any
breakpoint that is outside the postmaster.c? Can anyone give me any hint?
Where do I mark a breakpoint so that I can follow the creation of an index
to file index.c for example?
Sounds
25 matches
Mail list logo
