Hello
I've did pg_dumpall of a number of databases on 7.4.2 install of
PostgreSQL then imported that into another 7.4.2 install. This is on
Debian Sid, every 5 hours, there's a script
/usr/lib/postgresql/bin/do.maintenance which runs on the database,
VACUUMing it and such. The next time that
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is there any reason why the 'ON COMMIT' behaviour feature is not
available if you use CREATE TABLE AS ...?
Where exactly would you propose to stick it in the syntax? Can you do
it without introducing more fully-reserved words than we have
On Mon, 2004-04-19 at 02:16, Tom Lane wrote:
(Offhand I can't even find CREATE TABLE AS in SQL99...)
This is semi-OT, but CREATE TABLE AS is (new) in SQL2003. At few glance,
the spec's notion of the command is about the same as ours, except for a
few minor syntactic differences (e.g. the [ WITH
Where exactly would you propose to stick it in the syntax?
Good question, I don't know.
Can you do
it without introducing more fully-reserved words than we have already?
No idea.
Is there any spec or other-product precedent for it? (Offhand I can't
even find CREATE TABLE AS in SQL99...)
Weeell.
While it's a couple of weeks old, in case it hasn't been seen by those
who need it, the folllowing thread on linux kernel discusses the
fsync-and-IDE-writecache interactions. There is also a comment on MacOS
X - I have no idea if that was already known, but I thought it might be
worth pointing
- Begin Forwarded Message -
From To:[EMAIL PROTECTED] Mon Apr 19 11:08:57 2004
Date: Mon, 19 Apr 2004 11:08:57 METDST
To: [EMAIL PROTECTED] (Tom Lane)
Subject: Re: [HACKERS] executing prepared select, missing RowDescription info
In-Reply-To: [EMAIL PROTECTED]; from Tom
The proposed new sampling method
(http://archives.postgresql.org/pgsql-hackers/2004-04/msg00036.php and
http://archives.postgresql.org/pgsql-patches/2004-04/msg00045.php)
basically incorporates two independant changes:
(1) Two-stage sampling: Stage one collects a random sample of pages,
stage
Hi,
I might have some time left to spend on the item Allow external interfaces
to extend the GUC variable set
filed under Administration on the TODO list. I'm thinking of an approach
with the steps:
1) Increasing my own understanding of the GUC code
2) Suggest a solution on this newsgroup
3)
George Cristian Birzan [EMAIL PROTECTED] writes:
ERROR: xlog flush request 0/E25BA1C4 is not satisfied --- flushed only to =
0/841D994
CONTEXT: writing block 1 of relation 17143/370747
While the data is irrelevant (I can get that from the dump), this could
be a bug in PostgreSQL, or
Dear Thomas,
I might have some time left to spend on the item Allow external interfaces
to extend the GUC variable set
filed under Administration on the TODO list. I'm thinking of an approach
with the steps:
1) Increasing my own understanding of the GUC code
Well, I did that yesterday
On Mon, Apr 19, 2004 at 09:53:26AM -0400, Tom Lane wrote:
Run some hardware diagnostics. This looks like your disk drive dropped
some bits ...
That would be something, it would be the second disk in two weeks. It's
a brand new drive and I haven't had any other problems. (Heck, even the
other
Andrew Sullivan [EMAIL PROTECTED] writes:
On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
I can see from your trace that you are using the getaddrinfo code from
libc, but where is configure finding a header that declares struct
addrinfo?
Hrm, I can't seem to tell. I see this in
Fabien COELHO [EMAIL PROTECTED] writes:
. All guc variables are described in static structures initialized at
loadtime. if it is to be extendable, it means that you have break this,
No, you don't.
. There is also a dynamic sorted array that allows to find all variables
descriptions
Dear Tom,
. All guc variables are described in static structures initialized at
loadtime. if it is to be extendable, it means that you have break this,
No, you don't.
Well, sorry, I'm used to show my lack of imagination on the list;-)
. There is also a dynamic sorted array that allows
On Mon, Apr 19, 2004 at 11:18:07AM -0400, Tom Lane wrote:
A shortcut is just to grep through /usr/include and its subdirectories
for addrinfo. If you only find one definition, then you don't really
need to worry too much. But if there's more than one you need to
determine which is getting
Fabien COELHO [EMAIL PROTECTED] writes:
Ok. I understand that you suggest to Thomas that he should only touch
the search array to insert new pointers to guc description structures,
which may come from outside or be newly allocated, without touching the
existing static versions for internal guc
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
static int strategy_get_from;
Why are these per-backend? Shouldn't they be in shared state?
regards, tom lane
It seems to me that new 'begin isolation level ...' syntax does not work
with current cvs head:
#
# old syntax:
#
psql SELECT VERSION();
version
---
PostgreSQL 7.5devel on i686-pc-linux-gnu,
Tom Lane wrote:
Andrew Sullivan [EMAIL PROTECTED] writes:
On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
I can see from your trace that you are using the getaddrinfo code from
libc, but where is configure finding a header that declares struct
addrinfo?
Hrm, I can't seem to tell. I
Tom Lane wrote:
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
These two most definitely are per backend because they hold status
information about the blocks this backend specifically is mucking
As I was playing around with prelimiary stuff for regression testing the
CSV patch, I had a couple of ideas I thought I might float.
Context: many of the tests will write a table out and read it back into
a duplicate table and then perform a symmetric difference on the 2
tables. Making the
Tom Lane wrote:
Fabien COELHO [EMAIL PROTECTED] writes:
Ok. I understand that you suggest to Thomas that he should only touch
the search array to insert new pointers to guc description structures,
which may come from outside or be newly allocated, without touching the
existing static versions for
Bruce Momjian wrote:
Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
there two of them there now?
I am still waiting for an answer on this. Does no one know?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610)
The snapshots in ftp.postgresql.org/pub/dev/ (and mirrors) appears not
to have updated since Apr 5th. These are supposed to be generated
nightly, right? If so, they seem broken.
//Magnus
---(end of broadcast)---
TIP 9: the planner will ignore
Jan Wieck [EMAIL PROTECTED] writes:
Tom Lane wrote:
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
These two most definitely are per backend because they hold status
information about the blocks
On Mon, Apr 19, 2004 at 11:18:07AM -0400, Tom Lane wrote:
What you'd need to do is determine which system headers are being
#include'd by that config test, and then look through them to find
struct addrinfo.
Well, I have this in /usr/include/netdb.h:
struct addrinfo {
int
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
Tom Lane wrote:
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
These two most definitely are per backend because they hold status
information
Jan Wieck [EMAIL PROTECTED] writes:
Tom Lane wrote:
Why do we have it at all? Seems like it would be at least as good to
make the T1-or-T2 decision in StrategyGetBuffer, rather than earlier.
If it'd be possible. The problem is that it can get called multiple
times during one logical buffer
for the second part, yes, there are 2 on gborg: pgtcl
and pgtclng
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Bruce Momjian wrote:
Why is libpgtcl still in /src/interfaces? Isn't
it now on gborg? Are
there two of them there now?
I am still waiting for an answer on this. Does no
one
Shachar,
I have a bunch of perl scripts, as well as one user-defined type, for
porting from SQL Server. Where should I place these?
Give us a few days. We'll be announcing the opening of the new projects site
soon (like, wednesday).
Regrettably, the perfect feature for this sort of thing,
Andrew Dunstan wrote:
Jan Wieck wrote:
Christopher Kings-Lynne wrote:
... on projects.postgresql.org, or similar.They really aren't
doing any good in /contrib.
I've already set up a category conversion tools on pgFoundry, and
my idea was one project per target system.
I reckon that by
I tracked the problem down to the penalty function used to build the
tree. Basically, it compares the area of the bounding boxes.
There wasnt enough precision in the area calculations - instead of
giving 0.0 it would give numbers in the[+-]10^-6 range. This really
screwed up how the tree
Brett Schwarz wrote:
for the second part, yes, there are 2 on gborg: pgtcl
and pgtclng
My question is whether they have all the CVS history and fixes in
libpgtcl so we can remove it from CVS.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Hello!
Here is a temp fix for the locale issues on win32. It passes regression
tests, but is *NOT* ready to be applied (if nothing else, it at least
needs more error checking).
The issue is that locale settings were not inherited by the postgres
backends when they were execed... Instead, the
Please ignore the 'bjm' debug code that was part of the patch. It has
been removed from CVS.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your
Fabien COELHO wrote:
#
# new syntax?
#
psql BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN
psql SHOW TRANSACTION ISOLATION LEVEL;
transaction_isolation
---
read committed
OK, fixed:
test= BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Bruce Momjian wrote:
Bruce Momjian wrote:
Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
there two of them there now?
I am still waiting for an answer on this. Does no one know?
I replied right away - to you and the lists you posted to.
Never got it? It's in the
L J Bayuk wrote:
Bruce Momjian wrote:
Bruce Momjian wrote:
Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
there two of them there now?
I am still waiting for an answer on this. Does no one know?
I replied right away - to you and the lists you posted to.
With initdb written now in C, we don't need a pg_encoding binary
anymore.
I have removed it from CVS. There were no mentions of it in the docs.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard
Bruce Momjian wrote:
L J Bayuk wrote:
Bruce Momjian wrote:
Bruce Momjian wrote:
Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
there two of them there now?
I am still waiting for an answer on this. Does no one know?
I replied right away - to
Christopher Kings-Lynne wrote:
char *argstring = flatten_set_variable_args(name, args);
+ printf(bjm: %s %s\n, name, argstring);
+ fflush(stdout);
Did you really mean to include that? :)
Nope, posted a followup that it was removed in a later commit.
--
Bruce Momjian
char *argstring = flatten_set_variable_args(name, args);
+ printf(bjm: %s %s\n, name, argstring);
+ fflush(stdout);
Did you really mean to include that? :)
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Magnus Hagander [EMAIL PROTECTED] writes:
* Is it enough to explicitly store/save LC_COLLATE and LC_CTYPE, or does
more of the locale stuff need to be stored?
The other LC_xxx settings will get fixed by GUC *only* if there are
explicit settings in postgresql.conf ... I don't think you can
Dear Hackers
I apologize in advance if this posting is construed as spam.
As many of you are aware, the database research group at UC Berkeley
is building TelegraphCQ, a system for processing continuous queries
over data streams. TelegraphCQ was built with the PostgreSQL source
base.
We are
Bruce Momjian wrote:
...
OK, Marc has removed libpgtcl. I just removed the docs for them.
Can someone comment on pgtclsh? The README says:
...
Do we need to move that over to gborg? If so, you can pull it out of
7.4 CVS.
Anyone?
Already discussed:
L J Bayuk wrote:
Bruce Momjian wrote:
...
OK, Marc has removed libpgtcl. I just removed the docs for them.
Can someone comment on pgtclsh? The README says:
...
Do we need to move that over to gborg? If so, you can pull it out of
7.4 CVS.
Anyone?
Already discussed:
Not sure if anyone reported to you but we fixed these in current CVS and
will have the fix in 7.4.3.
---
Cott Lang wrote:
On Wed, 2004-02-11 at 16:25, Bruce Momjian wrote:
Sure, shoot them over to hackers or patches.
should be fixed now ... let me know if there are any other problems ...
On Mon, 19 Apr 2004, Magnus Hagander wrote:
The snapshots in ftp.postgresql.org/pub/dev/ (and mirrors) appears not
to have updated since Apr 5th. These are supposed to be generated
nightly, right? If so, they seem
48 matches
Mail list logo