Re: [HACKERS] Sync Data

2001-06-01 Thread Gavin Sherry
Hi Paulo, It is unclear exactly what you want PostgreSQL to do but it seems to me that if you want to Sync data into a central database at some point or other during the day, you should design your application to take care of it, not rely on PostgreSQL to do anything special. That is, simply mov

Re: [HACKERS] Re: Support for %TYPE in CREATE FUNCTION

2001-06-01 Thread Michael Samuel
I've been thinking about this, and I think the smartest way to implement %TYPE would be to have it as a special-case data type. So, the C representation of it would be something like this: struct PercentType { int datatype; void *data; }; Note: I made the datatype field an int,

[HACKERS] bug in pg_dump with GRANT/REVOKE

2001-06-01 Thread Robert Forsman
I'm running postgres 6.5.3 and 7.0.3 and pg_dump gives me the following output: DROP TABLE "genrenametable"; CREATE TABLE "genrenametable" ( "genreid" int4, "name" character varying(128), "parentgenre" int4, "enabled" bool DEFAULT 'f' NOT NULL ); REVOKE ALL on "

[HACKERS] dump+reload?

2001-06-01 Thread gabriel
hello all How can i do dump and reload in all databases? thanks... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

Re: Fwd: Re: [HACKERS] Shared memory for RH Linux 7.1

2001-06-01 Thread Michael J Schout
On Thu, 24 May 2001, Ryan Mahoney wrote: > >This is true. You can adjust the value in the /proc/sys/kernel/shmmax > >file. If you change the value it will be reset when you reboot, so you > >will need to write a start-up script to always change this value if you > >want it to be permanent.

AW: [HACKERS] Access statistics

2001-06-01 Thread Zeugswetter Andreas SB
> One more feature for discussion :-) > > In the next couple of hours (at least tomorrow) I would be > ready to commit the backend changes for table-/index-access > statistics and current backend activity views. > > Should I apply the patches or provide a separate patch f

AW: [HACKERS] Re: Support for %TYPE in CREATE FUNCTION

2001-06-01 Thread Zeugswetter Andreas SB
> > AND expect it to do more than that. So a NOTICE at the > > actual usage, telling that x%TYPE for y got resolved to > > basetype z and will currently NOT follow later changes to x > > should do it. > > So if you could implement it like that, we will be VERY happ

Re: [HACKERS] ERROR: cache lookup for proc 43030134 failed

2001-06-01 Thread Tom Lane
Kovacs Zoltan <[EMAIL PROTECTED]> writes: >> I think not. The current implementation of LIMIT fetches one more row >> than is really needed, IIRC. > Tom, the real problem is that I get _different_ output for The point is that the problem is probably in the 23rd row of pg_class, not the 22nd.

Re: [HACKERS] Access statistics

2001-06-01 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > So outing myself not beeing a *real programmer*, this is what > I have so far: Hmm ... what is the performance of all this like? Seems like a lot of overhead. Can it be turned off? > * Backends call some collector functions at various plac

Re: [HACKERS] Access statistics

2001-06-01 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Have you removed the existing stats-gathering support >> (backend/access/heap/stats.c and so on)? That would buy back >> at least a few of the cycles involved ... > Not sure if we really should. Let's later decide if it's >

Re: [HACKERS] Re: Interesting Atricle

2001-06-01 Thread Ryan Mahoney
I think there is really something weird about the Zend site - I use the current IE on an NT machine, and every page loads, but then I have to wait about 10 additional seconds before IE "wakes up" and I can click any links or go to a different page. I think it may have something to do with the