Re: [PATCHES] Deferred RI trigger for non-key UPDATEs and subxacts

2007-07-16 Thread Stephan Szabo
On Sun, 15 Jul 2007, Tom Lane wrote: > "Affan Salman" <[EMAIL PROTECTED]> writes: > > With some time to spare, I thought I'd submit a quick-fix patch to the > > issue I reported here: > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00339.php > > I don't think this is right. If t

Re: [PATCHES] CREATE SYNONYM ...

2006-03-08 Thread Stephan Szabo
On Wed, 8 Mar 2006, Jonah H. Harris wrote: > On 3/8/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > What feature though? Part of the definition of a feature like synonym has > > to nail down things like how it interacts with search path > > > I've s

Re: [PATCHES] CREATE SYNONYM ...

2006-03-08 Thread Stephan Szabo
On Wed, 8 Mar 2006, Jonah H. Harris wrote: > On 3/8/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > Yes, however there are two slightly separate discussions going on and I > > think you're taking them as a single discussion. > > > I agree that th

Re: [PATCHES] CREATE SYNONYM ...

2006-03-08 Thread Stephan Szabo
On Wed, 8 Mar 2006, Jonah H. Harris wrote: > On 3/8/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > Doesn't that pretty much go against the (I thought) outstanding behavioral > > question of whether the synonyms are scoped and obey search path? If they > &

Re: [PATCHES] CREATE SYNONYM ...

2006-03-07 Thread Stephan Szabo
On Wed, 8 Mar 2006, [ISO-8859-1] Hans-Jürgen Schönig wrote: > Stephan Szabo wrote: > > On Tue, 7 Mar 2006, Jonah H. Harris wrote: > > > > > >>On 3/7/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > >> > >>>I'd personally be more inte

Re: [PATCHES] CREATE SYNONYM ...

2006-03-07 Thread Stephan Szabo
On Tue, 7 Mar 2006, Jim C. Nasby wrote: > On Tue, Mar 07, 2006 at 12:39:55PM -0800, Stephan Szabo wrote: > > > > On Tue, 7 Mar 2006, Jonah H. Harris wrote: > > > > > On 3/7/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > > > > >

Re: [PATCHES] CREATE SYNONYM ...

2006-03-07 Thread Stephan Szabo
On Tue, 7 Mar 2006, Jonah H. Harris wrote: > On 3/7/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > I'd personally be more interested in what the impact is on people not > > using synonyms. How free is any search for synonyms if you aren't using

Re: [PATCHES] CREATE SYNONYM ...

2006-03-07 Thread Stephan Szabo
On Tue, 7 Mar 2006, [ISO-8859-1] Hans-J?rgen Sch?nig wrote: > > The semantics of namespace search seem wrong; I would think that a > > synonym in schema A should mask a table in schema B if A precedes B > > on the search path, but this doesn't work that way. > > good point. > any other opionions

Re: [PATCHES] Work-in-progress referential action trigger timing

2005-09-01 Thread Stephan Szabo
On Tue, 23 Aug 2005, Stephan Szabo wrote: > Here's my current work in progress for 8.1 devel related to fixing the > timing issues with referential actions having their checks run on > intermediate states. I've only put in a simple test that failed against > 8.0 in th

[PATCHES] Work-in-progress referential action trigger timing patch

2005-08-23 Thread Stephan Szabo
Here's my current work in progress for 8.1 devel related to fixing the timing issues with referential actions having their checks run on intermediate states. I've only put in a simple test that failed against 8.0 in the regression patch and regression still passes for me. There's still an outsta

Re: [PATCHES] patch: garbage error strings in libpq

2005-07-09 Thread Stephan Szabo
On Sat, 9 Jul 2005 [EMAIL PROTECTED] wrote: > Tom Lane wrote: > > >> That would answer the big question here, but where does it say that? > > > > Also, if you really insist on an authoritative statement, try this text > > (from Annex D of the C99 draft standard, "Formal model of sequence > > poin

Re: [PATCHES] Casting INT4 to BOOL...

2004-10-11 Thread Stephan Szabo
On Mon, 11 Oct 2004, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Mon, 11 Oct 2004, Sean Chittenden wrote: > >> I would posit that this is the desired behavior as it's consistent with > >> every language I can think of. > > >

Re: [PATCHES] Casting INT4 to BOOL...

2004-10-11 Thread Stephan Szabo
On Mon, 11 Oct 2004, Sean Chittenden wrote: > > The patch treats any non-zero value as "true". Is that the behavior we > > want, or should we only allow "1" as an integer representation of > > "true"? (I'm not sure myself, I just don't think copying C here is > > necessarily the best guide.) > > I

Re: [PATCHES] added pkg-config script

2004-08-22 Thread Stephan Szabo
On Sun, 22 Aug 2004, Czuczy Gergely wrote: > On Sun, Aug 22, 2004 at 11:39:38AM -0700, Stephan Szabo wrote: > > > > On Sun, 22 Aug 2004, Czuczy Gergely wrote: > > > > > I've attached a corrected patch, the postgresql.pc.in was missing. > > > > &g

Re: [PATCHES] added pkg-config script

2004-08-22 Thread Stephan Szabo
On Sun, 22 Aug 2004, Czuczy Gergely wrote: > I've attached a corrected patch, the postgresql.pc.in was missing. > > On Sun, Aug 22, 2004 at 01:49:08PM -0400, Tom Lane wrote: > > [EMAIL PROTECTED] (Czuczy Gergely) writes: > > > I've added a pkg-config script. > > > The "diff -rc -x configure from

Re: [PATCHES] logfile subprocess and Fancy File Functions

2004-07-23 Thread Stephan Szabo
On Fri, 23 Jul 2004, Andreas Pflug wrote: > > What we probably want instead is a separate > > redirect_stderr_to_files boolean (I'm sure a better name could be > > thought of). > > > > Also, while I'm aware that a superuser can persuade the backend to write > > on anything, it doesn't follow that

Re: [PATCHES] Digital Mars C++ - Clients

2004-07-08 Thread Stephan Szabo
On Thu, 8 Jul 2004, Walter wrote: > > "Bruce Momjian" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Walter wrote: > > > > > > "Bruce Momjian" <[EMAIL PROTECTED]> wrote in message > > > news:[EMAIL PROTECTED] > > > > > > > > Uh, I have never heard of Digital Mars C++. I see it

Re: [PATCHES] hint infrastructure setup (v3)

2004-04-02 Thread Stephan Szabo
On Fri, 2 Apr 2004, Bruce Momjian wrote: > Fabien COELHO wrote: > > CREATE USER calvin WITH IN GROUP admin, CREATEDB; > > ERROR: group "admin" does not exist > > > > CREATE USER calvin WITH IN GROUP admin CREATEDB foo; > > ERROR: syntax error at or near "foo" at character 49 > > HINT: other us

Re: [PATCHES] notice about costly ri checks (2)

2004-03-05 Thread Stephan Szabo
On Fri, 5 Mar 2004, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'd suggest something along the lines of > >> > >> NOTICE: foreign key constraint "constrname" will require a cross-type conversion > >> DETAIL: key columns "fkcol" and "pkcol" are of different

Re: [PATCHES] Foreign key type checking patch

2004-03-01 Thread Stephan Szabo
On Mon, 1 Mar 2004, Fabien COELHO wrote: > > > Here is a proposed patch against 7.4.1 to check exact match > > > of foreign key types wrt the referenced keys, and to show > > > a warning if this is not the case. > > > > I think that this concern may be obsolete in CVS tip, > > I just get the curre

Re: [PATCHES] "sql_features" does not exist( Very Urgent)

2004-02-26 Thread Stephan Szabo
On Thu, 26 Feb 2004 [EMAIL PROTECTED] wrote: > I create a plpgsql function for grant rights for the postgres users. > The same function is working properly in the previous versions. But it > gives the following error message. You're not putting in the schema names in your grant statements so t

Re: [PATCHES] fix memcpy() overlap

2004-02-02 Thread Stephan Szabo
On Mon, 2 Feb 2004, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > I don't know of a memcpy() implementation that would actually bail out > > if called with two equal pointers, but perhaps there is one in > > existence somewhere. > > This isn't a bug, and I see no reason to clutter

[PATCHES] Small Doc Patch

2003-11-09 Thread Stephan Szabo
Here's a patch that adds some text mentioning that RESTRICT is not deferrable to the create table reference page.Index: doc/src/sgml/ref/create_table.sgml === RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/ref/create_table.sgml,

Re: [PATCHES] pg_id.c windows fix

2003-10-04 Thread Stephan Szabo
On Sun, 5 Oct 2003, Bruce Momjian wrote: > > Can you tell me what Win32 compile environment can't handle a sizeof() > as a function parameter? > > ! GetUserName(pw->pw_name, sizeof(pw->pw_name)-1); > > Does casting to DWORD help? > > ! GetUserName(pw->pw_name, &pwname_size); It looks

[PATCHES] An additional foreign key test for regression

2003-07-04 Thread Stephan Szabo
The deferred trigger queue pushing to disk patch pointed out that the regression tests for foreign keys didn't seem to test a deferred constraint that was not satisified by a later statement and was not made immediate by set constraints, so here's a simple added test with a single invalid insert a