[HACKERS] Something wrong after file system level backup

2005-10-17 Thread alex
The situation is like that: [19:24] Press_Enter Who can help with file system level backup? [19:24] KL Press_Enter: shut down postgres, tar the data dir [19:25] KL Press_Enter: apparently filesystem snapshots might work as well [19:25] KL Press_Enter: you're supposed to use pg_dumpall [19:25]

[HACKERS] DBD::PgSPI 0.02

2004-12-05 Thread alex
yours, more the merrier. -alex ---(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 the mailing list cleanly

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-05 Thread alex
. I'll remove it in next release, I suppose. -alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-05 Thread alex
definition) than just something that uses libpq... If I'm wrong, please correct me. -alex ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-05 Thread alex
by default. I'll add proper path to makefile for next release (sooner than 3 years this time ;) -alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
that it seems to work. I'll be grabbing the update to test soon. 'do' seems to work for me. What happens for you? I put a version of code with a bit more fixes from comments onlist to www.pilosoft.com/PgSPI/DBD-PgSPI-0.03pre.tar.gz Please download and try it. -alex ---(end

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
, making postgresql itself a middleware server. Make perl stored procedures take serialized objects and return serialized objects back. -alex ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
to reinvent it in a clean room fashion. Actually, its both GPL and Artistic license - identical to DBD::Pg (where most of the code is taken from). I don't think this needs to be in core distribution - much like DBD::Pg doesn't need to be there either... -alex ---(end

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
to the code. For quick access from trusted code, spi_exec should just do fine. -alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
is that they have to download DBI to get *anywhere* in the first place ;0 -alex ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
On Mon, 6 Dec 2004, Michael Fuhr wrote: On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote: For quick access from trusted code, spi_exec should just do fine. BTW, does stock PL/Perl have functions for escaping identifiers, strings, and binary strings? non-DBI? no. DBI?

Re: [HACKERS] DBD::PgSPI 0.02

2004-12-06 Thread alex
require starting with DBI::PurePerl (non-XS version) and adding a mode that would disable all unSafe activity (such as file operations etc etc)... -alex ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Explicit Transaction Priority

2005-03-05 Thread Alex
questions. 1) How portable is it ? 2) What implications does it have on the postgres backend ? This could be useful in some situations (like logtables , where I don't need instant inserts or updates..) Thanks Alex

Re: [HACKERS] Listen / Notify rewrite

2009-11-15 Thread Alex
the connection, which means that we'll be checking for a NOTIFY every time we have new data. That just doesn't make sense. -- Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Another review of URI for libpq, v7 submission

2012-03-15 Thread Alex
Daniel Farina dan...@heroku.com writes: Finally, attached is v8.  Hopefully I didn't mess things up too much. I'll give it another look-over. Do you have these in git somewhere? It will help me save time on some of the incremental changes. Yes, I've just pushed my dev branch to this fork of

Re: [HACKERS] Another review of URI for libpq, v7 submission

2012-03-20 Thread Alex
Marko Kreen mark...@gmail.com writes: On Thu, Mar 15, 2012 at 11:29:31PM +0200, Alex wrote: https://github.com/a1exsh/postgres/commits/uri The point of the patch is to have one string with all connection options, in standard format, yes? So why does not this work: db = PQconnectdb

Re: [HACKERS] Another review of URI for libpq, v7 submission

2012-03-22 Thread Alex
Alex a...@commandprompt.com writes: Marko Kreen mark...@gmail.com writes: On Thu, Mar 15, 2012 at 11:29:31PM +0200, Alex wrote: https://github.com/a1exsh/postgres/commits/uri The point of the patch is to have one string with all connection options, in standard format, yes? So why does

Re: [HACKERS] Another review of URI for libpq, v7 submission

2012-03-27 Thread Alex
Peter Eisentraut pete...@gmx.net writes: On tor, 2012-03-22 at 23:42 +0200, Alex wrote: Okay, at last here's v9, rebased against current master branch. Attached is a patch on top of your v9 with two small fixes: - Don't provide a check target in libpq/Makefile if it's not implemented

Re: [HACKERS] Another review of URI for libpq, v7 submission

2012-03-27 Thread Alex
Alex a...@commandprompt.com writes: Peter Eisentraut pete...@gmx.net writes: Attached is a patch on top of your v9 with two small fixes: - Don't provide a check target in libpq/Makefile if it's not implemented. - Use the configured port number for running the tests (otherwise it runs

Re: [HACKERS] Last gasp

2012-04-14 Thread Alex
. -- Regards, Alex [1] http://www.redmine.org/ [2] http://www.redmine.org/plugins [3] https://github.com/diasjorge/redmine-cli -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Last gasp

2012-04-14 Thread Alex
Greg Smith g...@2ndquadrant.com writes: On 04/14/2012 03:02 AM, Alex wrote: I didn't follow this whole thread, but have we considered Redmine[1]? It comes up every couple of years in contexts near this one, such as http://wiki.postgresql.org/wiki/TrackerDiscussion Oh, I see. I wonder

Re: [HACKERS] Last gasp

2012-04-14 Thread Alex
Alex a...@commandprompt.com writes: Greg Smith g...@2ndquadrant.com writes: On 04/14/2012 03:02 AM, Alex wrote: I didn't follow this whole thread, but have we considered Redmine[1]? It comes up every couple of years in contexts near this one, such as http://wiki.postgresql.org/wiki

Re: [HACKERS] Last gasp

2012-04-14 Thread Alex
Jay Levitt jay.lev...@gmail.com writes: Alex wrote: I didn't follow this whole thread, but have we considered Redmine[1]? As the resident Ruby is shiny, let's do everything in Rails on my MacBook guy, I'd like to make a statement against interest: I've tried Redmine a few times and it's

[HACKERS] Bug tracker tool we need (was: Last gasp)

2012-04-16 Thread Alex
bet is writing one from scratch. Or maybe there isn't really a need for a tracker? The core team have managed to live without one for so long after all... -- Regards, Alex [1] http://wiki.postgresql.org/wiki/TrackerDiscussion -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Bug tracker tool we need

2012-04-16 Thread Alex
backend, which would be a strange choice for a project like ours :) And makes many things harder... What stops us from writing a postgres backend for debbugs if it is so brilliant on handing email and stuff? -- Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Bug tracker tool we need

2012-04-16 Thread Alex
hackers, so there's always someone in the postgres community to fix it when it breaks, of course.) -- Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq URI and regression testing

2012-04-18 Thread Alex
it change that? -- Regards, Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq URI and regression testing

2012-04-18 Thread Alex
, adds $libpq_uri_regress project to Mkvcbuild.pm. I don't have access to a win32 box unfortunately, so if anyone who does could try this out that'd be great. -- Regards, Alex diff --git a/src/interfaces/libpq/test/Makefile b/src/interfaces/libpq/test/Makefile index b9023c3..f569fc2 100644 --- a/src

Re: [HACKERS] libpq URI and regression testing

2012-04-19 Thread Alex
Peter Eisentraut pete...@gmx.net writes: On tor, 2012-04-19 at 00:13 +0300, Alex wrote: +#!/usr/bin/env perl Don't do that. Call the script using $(PERL) from the makefile. Thank you for the suggestion. Attached v2 does just this (while keeping a more commonly found shebang line

Re: [HACKERS] libpq URL syntax vs SQLAlchemy

2012-05-10 Thread Alex
this another look and will get back with a proposal to fix this in form of a patch. -- Regards, Alex -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] libpq URL syntax vs SQLAlchemy

2012-05-14 Thread Alex
karave...@mail.bg writes: - Цитат от Alex Shulgin (a...@commandprompt.com), на 14.05.2012 в 18:16 - Alex a...@commandprompt.com writes: The host part in this case is empty (it is hidden between the // and the following /,) thus local socket connection is employed

Re: [HACKERS] libpq URL syntax vs SQLAlchemy

2012-05-25 Thread Alex
Alex Shulgin a...@commandprompt.com writes: Upon closer inspection of the issue I came to believe that the proper fix is to drop support for special treatment of host part starting with slash altogether. Attached is a patch to do that. Well, I understand I might be asking for too much

Re: [HACKERS] libpq URL syntax vs SQLAlchemy

2012-05-28 Thread Alex
Peter Eisentraut pete...@gmx.net writes: On mån, 2012-05-14 at 18:16 +0300, Alex Shulgin wrote: Upon closer inspection of the issue I came to believe that the proper fix is to drop support for special treatment of host part starting with slash altogether. Attached is a patch to do

Re: [HACKERS] Inconsistency in libpq connection parameters, and extension thereof

2012-06-11 Thread Alex
out on any extra parameters from JDBC or other existing URI implementations. The example of a possible typo in sslmode=require clearly demonstrates that this was not a well-thought decision. Anyway, I can see you've already sorted this out. -- Alex -- Sent via pgsql-hackers mailing list (pgsql

[HACKERS] Display output file name in psql prompt?

2013-03-12 Thread Alex
, unless stdout?) Something like this: \set PROMPT1 '%/:%o%R%# ' postgres:/path/to/output/file.txt= -- Regards, Alex PS: upon reading the docs more carefully, I guess I should have used \g instead of \o, but still this might be not a bad feature to have. -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Display output file name in psql prompt?

2013-03-13 Thread Alex
the plain \o and \g, but will set \a and \t automatically. I mean it must be quite often that you don't need all the decoration when you save query results to a file, so instead of doing \a, \t, \g (then setting \a and \t back) you can just do \G and move on. -- Alex -- Sent via pgsql-hackers

[HACKERS] problem building pg 7.3 beta 3 on solaris 8 -m64

2002-11-06 Thread alex avriette
currently subscribed to hackers. thanks alex ---(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 the mailing list

[HACKERS] problem building pg 7.3 beta 3 on solaris 8 -m64

2002-11-07 Thread alex avriette
Dave Miller ([EMAIL PROTECTED]) tells me this bug is fixed in gcc 3.2.1 (which does not appear to be distributed yet). FYI. alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
supported. SGI machines are awesome for database servers. Anyone needing a shell on the machine can feel free to ask. Alex -- alex avriette $^X is my programming language of choice. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
at this more, I see this: [goro:~/postgresql-7.3.1/src] alex% grep LD Makefile* | grep -- '-r' Makefile.global:LDREL = -r Can we just not append LDREL to LD if we're on Irix? alex -- alex avriette $^X is my programming language of choice. [EMAIL PROTECTED] ---(end

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-02 Thread alex avriette
When compiled with gcc, it does trap divide by zero. Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Irix 6.2, Postgres 7.3.1, some brokenness

2003-02-06 Thread alex avriette
Disregard previous. Using /bin/ld (with LDREL = -r) works fine as a linker. Call it force of habit. Is it worth warning the user that you cannot use gcc as ld on Irix? I used it because I figured I would need gnu ld (which I of course didn't have). Anyhow, 7.3.1 is successfully built. Alex

[HACKERS] Postgres and 'directio' on Solaris/UFS

2003-02-21 Thread alex avriette
. Additionally, I grepped through source only to realize that direction is used a lot. So I used the following find : [goro:~/postgresql-7.3.1] alex% find . -type f -exec egrep -il 'directio[^Nn]' {} \; And also didn't find anything. The manpage for directio (Solaris 9) is here: http://docs.sun.com/db

[HACKERS] code contribution

2002-05-07 Thread Alex Shevlakov
Hello, I'd like to contribute new code for Postgres geometry type 'path' operations (including line buffer). Where should I send this? --- Alex Shevlakov, Motivation Free Software consulting, Moscow, Russia --- http://motivation.ru msg16797/pgp0.pgp Description: PGP

[HACKERS] IRIX and large SMP: donations of shells c

2002-08-08 Thread Alex Avriette
, please let me know. I'd really like to see Postgres understand MIPSpro and irix out of the box. I understand there is some difficulty at present. I'd appreciate a Cc on the thread, if possible. Thanks, alex ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] strange performance anomalies

2002-08-10 Thread Alex Hayward
On 9 Aug 2002, Scott Shattuck wrote: Hi, We recently put up a new 7.2.1 installation on Solaris 8 that serves a 24x7 e-commerce site. The system seems to run pretty well most of the time but we see a consistent form of performance anomaly. Watching pg_stat_activity the system spends

[HACKERS] [BUG] views and functions on relations

2001-04-17 Thread Alex Pilosov
(21747 is table oid for foo) HOWEVER, 'select * from tv2' succeeds (sometimes). Sometimes it fails with the same error (cache lookup failed). I think the above should be enough to reproduce this bug. Any hints? -alex ---(end of broadcast

Re: [HACKERS] [BUG] views and functions on relations

2001-04-18 Thread Alex Pilosov
On Wed, 18 Apr 2001, Tom Lane wrote: The ruleutils.c bug cannot explain this however, since ruleutils won't even be invoked. Can you find a sequence to reproduce it? Sorry, I was mistaken. The error I get for select is this: ERROR: cache lookup for type 0 failed This is a far harder to

Re: [HACKERS] [BUG] views and functions on relations

2001-04-18 Thread Alex Pilosov
On Wed, 18 Apr 2001, Alex Pilosov wrote: This is a far harder to trigger bug, and actually, it doesn't happen in this simple case (oops), and the only test case I have involves 2 tables and 3 stored procedures. It is not related to views at all, just doing the underlying select causes

Re: [HACKERS] [BUG] views and functions on relations

2001-04-18 Thread Alex Pilosov
which improperly sets nattrs than me... Hoping for proper fix, -alex traceback: #0 elog (lev=-1, fmt=0x45d4b340 "cache lookup for type %u failed") at elog.c:119 #1 0x45d4693e in exec_cast_value (value=1791, valtype=0, reqtype=23, reqinput=0x82bfdb0, reqtypelem=0, reqtypmod=

[HACKERS] operators and indices?

2001-05-17 Thread Alex Pilosov
which match index types (such as btree for ,,=, etc and rtree for @, etc). Is there a better way than hardcoding support for inet types into index-selection code? -alex ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[HACKERS] force of last XID

2001-05-18 Thread Alex Pilosov
Hi, I managed to drop really important table. Fortunately, I had a backup of the table (raw file, not a ascii file). After putting that table into freshly initdb'd database, postgres doesn't see new transactions even though 'vacuum' sees the tuples alright. So, question. I'd like to force

RE: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-07 Thread Alex Pilosov
On Sat, 7 Jul 2001, David Bennett wrote: - In a nutshell you are recommending: - create table contact_type ( codeint2, typechar(16), PRIMARY KEY ( code ) ); create table contact ( numberserial, name char(32), type

Re: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-07 Thread Alex Pilosov
to implement enum. -alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] selecting from cursor

2001-07-07 Thread Alex Pilosov
On Mon, 2 Jul 2001, Alex Pilosov wrote: Erm, forgot to attach the patch. Here it is. (yow) don't even bother looking at this patch. mail server delayed this message by almost a week, and by now, the code is totally changed. I took Tom's suggestion and made RTE a union. So, the below is a new

RE: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-06 Thread Alex Pilosov
On Fri, 6 Jul 2001, David Bennett wrote: rest snipped In either model you would: update master_table set status='OPEN_PENDING_SOMETHING' where status='OPEN' This would not change, in fact, even in a normalized design you wouldn't change the lookup table (parent) key. Perhaps you

Re: [HACKERS] Rule recompilation

2001-07-12 Thread Alex Pilosov
I remember awhile ago, someone floated the idea of a dependency view which would list all objects and what OIDs they have in their plan. (i.e. what do they depend on). I'm definitely no expert in this, but to me, one possible implementation would be to enhance outfuncs to provide for creation

Re: [HACKERS] Rule recompilation

2001-07-12 Thread Alex Pilosov
on in pg_proc. (as in my above email). -alex ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Rule recompilation

2001-07-12 Thread Alex Pilosov
On Thu, 12 Jul 2001, Jan Wieck wrote: Alex Pilosov wrote: I remember awhile ago, someone floated the idea of a dependency view which would list all objects and what OIDs they have in their plan. (i.e. what do they depend on). I'm definitely no expert in this, but to me, one possible

[HACKERS] What I do with PostgreSQL

2001-07-16 Thread alex avriette
, thanks for your hard work guys/gals. alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] pg_depend

2001-07-16 Thread Alex Pilosov
On Tue, 17 Jul 2001, Peter Eisentraut wrote: Alex Pilosov writes: I'm not so convinced on that idea. Assume you're dropping object foo. You look at pg_depend and see that objects 145928, 264792, and 1893723 depend on it. Great, what do you do now? I believe someone else

Re: [HACKERS] pg_depend

2001-07-16 Thread Alex Pilosov
On Mon, 16 Jul 2001, Peter Eisentraut wrote: Bruce Momjian writes: I have found that many TODO items would benefit from a pg_depend table that tracks object dependencies. TODO updated. I'm not so convinced on that idea. Assume you're dropping object foo. You look at pg_depend and

Re: [HACKERS] Re: AW: Re: OID wraparound: summary and proposal

2001-08-06 Thread Alex Pilosov
On Mon, 6 Aug 2001, mlw wrote: Zeugswetter Andreas SB SD wrote: It seems to me, I guess and others too, that the OID mechanism should be on a per table basis. That way OIDs are much more likely to be unique, and TRUNCATE on a table should reset it's OID counter to zero.

Re: AW: [HACKERS] Re: OID wraparound: summary and proposal

2001-08-06 Thread Alex Pilosov
On Mon, 6 Aug 2001, mlw wrote: I think you are focusing too much on ROWID and not enough on OID. The issue at hand is OID. It is a PostgreSQL cluster wide limitation. As data storage decreases in price, the likelihood of people running into this limitation increases. I have run into OID

drop-in-ability (was: RE: [HACKERS] Re: [PATCHES] Select parser at runtime )

2001-08-13 Thread Alex Avriette
a real database (its free?!! how can it be free?!). They would never, (ever!) consider dropping in postgres. If you're intent on taking customers from Oracle, catch them where youll be able to convert them -- before Oracle is even installed. alex ---(end of broadcast

Re: [HACKERS] Toast,bytea, Text -blob all confusing

2001-08-27 Thread Alex Pilosov
On Thu, 23 Aug 2001 [EMAIL PROTECTED] wrote: THIS IS WHAT I CANT SEEM TO FIGURE OUT IN POSTGRESQL 1. I cant get a clear answer on what kind of data type to use for my large text string? TEXT, ???, ??? or something about TOAST I have seen in the e-mail archive but cant find any documentaion?

Re: [HACKERS] Upcoming events

2001-08-28 Thread Alex Pilosov
Aiiye. I'm sending a _large_ (60k) patch to add 'select * from cursor foo' tonight. I'm hoping that it could possibly get included... -alex On Mon, 27 Aug 2001, Tom Lane wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: Do we want ADD PRIMARY KEY? If you can get it done

Re: [HACKERS] [PATCH] tiny fix for plperlu

2001-08-29 Thread Alex Pilosov
Nevermind this patch then... On Wed, 29 Aug 2001, Peter Eisentraut wrote: Alex Pilosov writes: Attached patch fixes following problem: createlang.sh expects one handler for each PL. If a handler function for a new PL is found in pg_languages, PL won't be created. So you need to have

[HACKERS] [PATCH] [LARGE] select * from cursor foo

2001-08-29 Thread Alex Pilosov
would work by creating first a special kind of portal for selection from a function and then setting query source to be that portal. -alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Re: Toast,bytea, Text -blob all confusing

2001-08-29 Thread Alex Pilosov
parsing, hence double escaping. -- Alex Pilosov| http://www.acedsl.com/home.html CTO - Acecape, Inc. | AceDSL:The best ADSL in the world 325 W 38 St. Suite 1005 | (Stealth Marketing Works! :) New York, NY 10018 | ---(end of broadcast

[HACKERS] [PATCH] tiny fix for plperlu

2001-08-28 Thread Alex Pilosov
Attached patch fixes following problem: createlang.sh expects one handler for each PL. If a handler function for a new PL is found in pg_languages, PL won't be created. So you need to have plperl_call_handler and plperlu_call_handler. This patch just does that. -alex Index: src/bin/scripts

Re: [HACKERS] Escaping strings for inclusion into SQL queries

2001-08-30 Thread Alex Pilosov
It is. Application is responsible to call PGescapeString (included in the patch in question) to escape command that may possibly have user-specified data... This function isn't called automatically. On Thu, 30 Aug 2001, Mitch Vincent wrote: Perhaps I'm not thinking correctly but isn't it the

Re: [HACKERS] Beta timing

2001-09-11 Thread Alex Pilosov
(cough) Could someone look at my 'select from cursor foo' patch...? tnx On Tue, 11 Sep 2001, Marc G. Fournier wrote: Wait until everyone is ready/finished with their existing projects ... this past week has thrown alot of turmoil into several lives that wasn't entirely unexpected, but sad

CVS/CVSup problems (was Re: [HACKERS] [PATCH] [LARGE] )

2001-09-20 Thread Alex Pilosov
On Thu, 20 Sep 2001, Alex Pilosov wrote: CVS repository also seems broken right now, I'm unable to log in (cvs login: authorization failed: server cvs.postgresql.org rejected access to /home/projects/pgsql/cvsroot for user anoncvs) in both cvs.postgresql.org and anoncvs.postgresql.org

Re: [HACKERS] [PATCH] [LARGE] select * from cursor foo

2001-09-20 Thread Alex Pilosov
On Mon, 17 Sep 2001, Tom Lane wrote: Alex Pilosov [EMAIL PROTECTED] writes: Attached patch does the above. Alex, could we have this resubmitted in diff -c format? Plain diff format is way too risky to apply. Tom, postgresql.org cvsup repository is broken (and according to my records

Re: [HACKERS] [PATCH] [LARGE] select * from cursor foo

2001-09-21 Thread Alex Pilosov
On Fri, 21 Sep 2001, Tom Lane wrote: I've looked this over, and I think it's not mature enough to apply at this late stage of the 7.2 cycle; we'd better hold it over for more work during 7.3. Major problems: 1. Insufficient defense against queries that outlive the cursors they select

Re: [HACKERS] Spinlock performance improvement proposal

2001-09-26 Thread Alex Pilosov
the requirement was to integrate with CORBA. I believe that person posted some benchmarks which were essentially identical to non-threaded postgres... -alex ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Changing data types

2001-09-24 Thread Alex Pilosov
for compression) Option a) was implemented once, but kludgy, and had a few kinks, and it was removed. Option b) plain sucks :P) -alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [HACKERS] Changing data types

2001-09-24 Thread Alex Pilosov
On Mon, 24 Sep 2001, Rod Taylor wrote: Out of curiosity how was option a) implemented? I could envision supporting multiple versions of a tuple style to be found within a table (each described in pg_attribute). Gradually these would be upgraded through normal use. Check the archives (look

Re: [HACKERS] Spinlock performance improvement proposal

2001-09-26 Thread Alex Pilosov
to threads... -alex ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and 7.1.3

2001-10-05 Thread Alex Avriette
to find -twolevel_namespace in any of the Makefiles. This makes me think it is something external. Anyone have an idea as to what is causing this? This box is down until postgres comes back up. :-7 alex -- alex j. avriette perl hacker. [EMAIL PROTECTED] $dbh - do('unhose

Re: [HACKERS] RFD: access to remore databases: altername suggestion

2001-10-02 Thread Alex Pilosov
You are attacking here two things: a) schemas, which should be done in 7.3, thus multiple databases on same host would be unnecessary. b) connections to remote host' databases, which is partially implemented already (in a ugly way, but...) see contrib/dblink What you described is a syntactic

Re: [HACKERS] storing binary data

2001-10-23 Thread Alex Pilosov
Use bytea. Search archives. On Sun, 21 Oct 2001, Jason Orendorff wrote: Reply-To: sender Hi. I was surprised to discover today that postgres's character types don't support zero bytes. That is, Postgres isn't 8-bit clean. Why is that? More to the point, I need to store about 1k

Re: [HACKERS] cvsup trouble

2001-09-21 Thread Alex Pilosov
to be 64.1.1.1 with netmask 255.255.255.0, you will only lose connectivity to 64.1.1.*, not entire 64.*) -alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Changing data types

2001-09-24 Thread Alex Pilosov
This is not for -hackers. And the answer is no, you can't. Recreate the table with correct types and insert the old values into it. On Mon, 24 Sep 2001, Gowey, Geoffrey wrote: I posted this in my last message, but have not heard anything yet so I'm wondering if it was overlooked. I need to

Re: [HACKERS] [SQL] outer joins strangeness

2001-09-24 Thread Alex Pilosov
is different. Lets call the table that will always be included in a join a complete table. Then, joins should not impose join order on complete table. Of course, joins against 'incomplete' table must be done only after outer join is done. Anyone who can actually fix it? :) -alex

Re: [HACKERS] [SQL] outer joins strangeness

2001-09-23 Thread Alex Pilosov
On Sun, 23 Sep 2001, Stephan Szabo wrote: On Sun, 23 Sep 2001, Alex Pilosov wrote: It may be just me, or I am grossly misunderstanding syntax of outer joins, but I see that plans for my queries are different depending on how I place join conditions and sometimes even on order

Re: [HACKERS] Suitable Driver ?

2001-10-11 Thread Alex Pilosov
POSTGRES_LIB=/usr/local/pgsql/lib -alex ---(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 the mailing list cleanly

Re: [HACKERS] Feature Request - PL/PgSQL

2001-10-14 Thread Alex Pilosov
You already can return a cursor. Support for returning a record set is being worked on. -alex On Sun, 14 Oct 2001, Gavin Sherry wrote: Hi all, It would be very nice if PL/PgSQL could return a record set (ie, set of tuples). This could be done in two ways as far as I can imagine: either

[HACKERS] Get Object?

2002-03-20 Thread Alex Lau
) VALUES ( 'alexbaby' ); INSERT 12345 1; INSERT INTO man ( firstname, son ) VALUES ( 'alex', 12345::man ); INSERT 12346 1; SELECT * FROM man WHERE son = (SELECT oid FROM man WHERE firstname='alexbaby'); -- find a man his son's also is a man and his name is alexbaby; or CREATE UNIQUE INDEX

Re: [HACKERS] initdb dies during IpcSemaphoreCreate under BSD jail

2002-03-27 Thread Alex Hayward
On Wed, 27 Mar 2002, Tom Lane wrote: Joel Burton [EMAIL PROTECTED] writes: This will allow you to run a single postgres in a single jail only one user would have access to it. If you try to run more then one it will try to use the same shared memory and crash. Is this, in fact, the

Re: [HACKERS] RI triggers and schemas

2002-03-27 Thread Alex Hayward
On Tue, 26 Mar 2002, Stephan Szabo wrote: On Tue, 26 Mar 2002, Jan Wieck wrote: Tom Lane wrote: I think the existing scheme of generating the plan during first use in a particular backend is fine. At least as long as we're sticking with standard plans at all ... IIRC Stephan was

[HACKERS]

2002-04-02 Thread Alex Lau
CREATE TABLE mytesting ( dosnotmatter text ); CREATE INDEX myunique ON mytesting oid; will this help to make sure the oid is unique? and is that right? if in fact the oid roll over, and insertation fail. Will reinsert get an new oid or the same oid retry. Alex

[HACKERS] createdb failed

2004-11-30 Thread alex yap
ror: could not initialize database directory; delete failed as well detail : failing system command was : cp -r '/var/postgresql/data/base/1' '/var/postgresql/data/base/17147' please anyone 'master' here help , my deadline is near.. please. alex Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses.

Re: [HACKERS] What's happening with pgsql-committers?

2000-10-07 Thread Alex Pilosov
some file in /tmp... There's an attempt to do this at http://www.is.kiruna.se/~goran/ldap/arkiv/ but its very raw and not configurable. -alex

[HACKERS] bug: alter table/FK

2000-10-17 Thread Alex Pilosov
to be done: on alter table, update tgargs in pg_trigger table -alex

[HACKERS] time stops within transaction

2000-10-17 Thread Alex Pilosov
. Is there a way to declare functions 'not-cacheable-ever'? If there is, such should be applied to now(). -alex

[HACKERS] time stops/workaround

2000-10-17 Thread Alex Pilosov
Strangely, the same thing does not happen when I do timenow() instead of time(). This is very counter-intuitive, if this is the way it is supposed to work, at least docs should be saying that. Also, I checked, and its probably not the fmgr cache, since now() is set to be noncacheable... -alex

Re: [HACKERS] time stops within transaction

2000-10-18 Thread Alex Pilosov
statement, so advancing now() within the function would violate the spec constraint with respect to the outer statement. Postgres doesn't have an idea of what a 'top-level' statement is? I.E. statement as submitted by a client (libpq)? -alex

[HACKERS] relation ### modified while in use

2000-10-22 Thread Alex Pilosov
this? I'm having a feeling that it has to do with referential integrity (the table in question is referenced by almost every other table), and with [possibly] a leak of reference counts? This is all with pg7.0.2 on i386. -alex

  1   2   3   4   5   6   7   >