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
rea
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 mat
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 d
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');
dblink_conne
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
--
Micha
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 messag
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
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
> t
Ü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
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 g
"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 fo
> >> 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'
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 attach
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,
"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?
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
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 clean
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.
>
>
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
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.
---
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 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_Sw
25 matches
Mail list logo
