[HACKERS] PGCon 2017 registration now open

2017-04-17 Thread Dan Langille
gistration is now open at http://www.pgcon.org/2017/registration.php <http://www.pgcon.org/2017/registration.php> -- Dan Langille - BSDCan / PGCon d...@langille.org <mailto:d...@langille.org>

[HACKERS] potential hardware donation

2017-01-27 Thread Dan Langille
If someone wanted to donate a SuperServer 6028TR-D72R (http://www.supermicro.com/products/system/2U/6028/SYS-6028TR-D72R.cfm) to the PostgreSQL project, would it be used? -- Dan Langille - BSDCan / PGCon d...@langille.org

[HACKERS] reminder: PGCon 2017 CFP

2017-01-17 Thread Dan Langille
7/papers.php>> Instructions for submitting a proposal to PGCon 2017 are available from: <http://www.pgcon.org/2017/submissions.php <http://www.pgcon.org/2017/submissions.php>> -- Dan Langille - BSDCan / PGCon d...@langille.org <mailto:d...@langille.org>

[HACKERS] PGCon 2016 CFP - one week left

2016-01-12 Thread Dan Langille
Hello There is one week left in the PGCon CFP. Details below. Please submit. Thanks. PGCon 2016 will be on 17-21 May 2016 at University of Ottawa. * 17-18 (Tue-Wed) tutorials * 19 & 20 (Thu-Fri) talks - the main part of the conference * 17 & 21 (Wed & Sat) The Developer Unconference & the Us

[HACKERS] PGCon 2016 call for papers

2016-01-03 Thread Dan Langille
In case you've overlooked it, you have about two weeks to submit your proposal. PGCon 2016 will be on 17-21 May 2016 at University of Ottawa. * 17-18 (Tue-Wed) tutorials * 19 & 20 (Thu-Fri) talks - the main part of the conference * 17 & 21 (Wed & Sat) The Developer Unconference & the User Unconfe

Re: [HACKERS] could not truncate directory "pg_subtrans": apparent wraparound

2015-06-08 Thread Dan Langille
If there's anything I can try on my servers to help diagnose the issues, please let me know. If desired, I can arrange access for debugging. On Sat, Jun 6, 2015 at 12:51 AM, Thomas Munro wrote: > On Sat, Jun 6, 2015 at 1:25 PM, Alvaro Herrera > wrote: > > Thomas Munro wrote: > > > >> My idea w

[HACKERS] could not truncate directory "pg_subtrans": apparent wraparound

2015-06-05 Thread Dan Langille
pgsql/data/pg_subtrans] # ls -l total 1 -rw--- 1 pgsql pgsql 8192 Jun 5 19:04 0032 This not not a high throughput server. — Dan Langille http://langille.org/ signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [HACKERS] PGCon hacker lounge

2015-05-28 Thread Dan Langille
> On May 27, 2015, at 12:06 PM, Alexander Korotkov > wrote: > > On Wed, May 27, 2015 at 7:00 PM, Dan Langille <mailto:d...@langille.org>> wrote: > Have you been to PGCon before? Do you remember the hacker lounge? Do you > remember going there to work on stuff? D

[HACKERS] PGCon hacker lounge

2015-05-27 Thread Dan Langille
Have you been to PGCon before? Do you remember the hacker lounge? Do you remember going there to work on stuff? Do you recall anything about it? — Dan Langille http://langille.org/ signature.asc Description: Message signed with OpenPGP using GPGMail

[HACKERS] PGCon 2015

2015-05-04 Thread Dan Langille
want to be there. Don't leave it much longer. — Dan Langille http://langille.org/ signature.asc Description: Message signed with OpenPGP using GPGMail

[HACKERS] HEADS UP: PGCon 2015 major schedule changes

2015-02-05 Thread Dan Langille
week, but we felt that our changes were already disruptive and wanted to minimize the effects this late change may have on people who have already booked travel / accommodation. To those affected, we apologize and hope that this new structure will benefit everyone. — Dan Langille ht

[HACKERS] PGCon 2015 - last day

2015-01-19 Thread Dan Langille
Today is your last day to submit your PGCon 2015 proposal. -- Dan Langille http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2015

2015-01-18 Thread Dan Langille
Is your PGCon 2015 submission going in today or tomorrow? -- Dan Langille http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2015 call for papers - reminder

2015-01-12 Thread Dan Langille
015/papers.php> Instructions for submitting a proposal to PGCon 2015 are available from: <http://www.pgcon.org/2015/submissions.php> — Dan Langille http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscr

[HACKERS] PGCon 2015 call for papers

2015-01-05 Thread Dan Langille
<http://www.pgcon.org/2015/submissions.php> — Dan Langille http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] HEADS UP: PGCon 2015 is in June

2014-09-27 Thread Dan Langille
HEADS UP. PGCon 2015 will be in June. That’s a few weeks later than in previous years. — Dan Langille signature.asc Description: Message signed with OpenPGP using GPGMail

[HACKERS] PGCon 2014 - last chance

2014-01-19 Thread Dan Langille
<http://www.pgcon.org/2014/submissions.php> -- Dan Langille - http://langille.org signature.asc Description: Message signed with OpenPGP using GPGMail

[HACKERS] PGCon 2014 call for papers

2013-12-12 Thread Dan Langille
will go out very close to the conference. Do not submit lightning talks proposals until then. See also <http://www.pgcon.org/2014/papers.php> Instructions for submitting a proposal to PGCon 2014 are available from: <http://www.pgcon.org/2014/submissions.php> -- Dan Lan

[HACKERS] PGCon 2013 - CFP & unconference day

2013-01-03 Thread Dan Langille
by developers and users of PostgreSQL. Be sure to submit your proposal soon because time is running out. -- Dan Langille - http://langille.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[HACKERS] PGCon 2013 - call for papers

2012-12-08 Thread Dan Langille
php> Instructions for submitting a proposal to PGCon 2013 are available from: <http://www.pgcon.org/2013/submissions.php> -- Dan Langille - http://langille.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.po

[HACKERS] PGCon 2012 Call for Papers - extension

2012-01-29 Thread Dan Langille
<http://www.pgcon.org/2012/papers.php> Instructions for submitting a proposal to PGCon 2012 are available from: <http://www.pgcon.org/2012/submissions.php> -- Dan Langille - http://langille.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make cha

[HACKERS] PGCon 2012 Call for Papers - reminder

2012-01-26 Thread Dan Langille
n 2012 are available from: <http://www.pgcon.org/2012/submissions.php> -- Dan Langille - http://langille.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2012 Call for Papers

2012-01-11 Thread Dan Langille
sions.php> -- Dan Langille - http://langille.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2011 Call for Papers - reminder

2011-01-11 Thread Dan Langille
e from: <http://www.pgcon.org/2011/submissions.php> -- Dan Langille - http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2010 - registered yet?

2010-04-23 Thread Dan Langille
. -- Dan Langille - http://langille.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PGCon 2009 t-shirt

2009-05-20 Thread Dan Langille
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wearing the PGCon 2009 t-shirt http://img199.imageshack.us/my.php?image=b9w.jpg&via=tfrog - -- Dan Langille BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon

[HACKERS] postmaster in a tight loop

2008-02-12 Thread Dan Langille
_XML=true WITH_TZDATA=true WITHOUT_DEBUG=true WITHOUT_INTDATE=true [EMAIL PROTECTED]:~] $ -- Dan Langille -- http://www.langille.org/ [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] PGCon 2008 - call for papers

2007-12-19 Thread Dan Langille
proposals 19 Apr 2008 Final papers/slides must arrive no later than this date See also <http://www.pgcon.org/2008/papers.php> Instructions for submitting a proposal to PGCon 2008 are available from: <http://www.pgcon.org/2008/submissions.php> -- Dan Langille - http://www.langille

Re: [HACKERS] [pgsql-advocacy] PGCon 2007 Program Committee

2007-01-06 Thread Dan Langille
On 7 Jan 2007 at 1:39, Oleg Bartunov wrote: > On Sat, 6 Jan 2007, Dan Langille wrote: > > > On 6 Jan 2007 at 12:09, Oleg Bartunov wrote: > > > >> What's about spronsoring ? > > > > Are you asking if your and Teodor can be sponsored? > > yes

Re: [HACKERS] PGCon 2007 Program Committee

2007-01-06 Thread Dan Langille
tion is available > http://mira.sai.msu.su/~megera/pgsql/ftsdoc/ Please submit a proposal at the URL below. :) > > Oleg > On Fri, 5 Jan 2007, Dan Langille wrote: > > > I have the pleasure of announcing your PGCon 2007 program committee. > > > > Bruce Momjian >

[HACKERS] PGCon 2007 Program Committee

2007-01-05 Thread Dan Langille
). -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php PGCon - The PostgreSQL Conference - http://www.pgcon.org/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Dan Langille
On 31 Jan 2004 at 11:56, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > >>> I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the > >>> schemas which existed in the original databases were not created in > >&

Re: [HACKERS] dump + restore didn't include schemas

2004-01-31 Thread Dan Langille
On 30 Jan 2004 at 23:34, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the > > schemas which existed in the original databases were not created in > > the new database. &g

[HACKERS] Undefined symbol "elog"

2004-01-31 Thread Dan Langille
My search was wrong. This is a known issue. Sorry for the post. -- Dan Langille : http://www.langille.org/ BSDCan - http://www.bsdcan.org/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] Undefined symbol "elog"

2004-01-31 Thread Dan Langille
rib/pgcrypto made the problem go away. I found no mention of this problem in the archives. FWIW: I was using the FreeBSD port on 4.9-STABLE. -- Dan Langille : http://www.langille.org/ BSDCan - http://www.bsdcan.org/ ---(end of broadcast)--- TIP

[HACKERS] dump + restore didn't include schemas

2004-01-30 Thread Dan Langille
bsddiary.org=# set search_path = phorum, public, pg_catalog; ERROR: schema "phorum" does not exist freebsddiary.org=# New issue? Known bug? -- Dan Langille : http://www.langille.org/ BSDCan - http://www.bsdcan.org/ ---(end of broadcast)---

Re: [HACKERS] [GENERAL] Are we backwards on the sign of timezones?

2003-07-05 Thread Dan Langille
rver, but it's in the process of upgrading PG.. -- Dan Langille : http://www.langille.org/ ---(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] [GENERAL] Are we backwards on the sign of timezones?

2003-07-05 Thread Dan Langille
On 4 Jul 2003 at 23:22, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > Now that my NZ server is up and running: > > template1=# select now(); > > 2003-07-05 12:47:15.444535+12 > > > That doesn't look backwards to me. &

Re: [HACKERS] [GENERAL] Are we backwards on the sign of timezones?

2003-07-04 Thread Dan Langille
appears to be consistent with the SQL99 spec. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] What goes into the security doc?

2003-01-24 Thread Dan Langille
that -c args is treated by the login shell ! [09:35] mmc_: Hmm.. true. That makes it a heavy enough reason. Thanks. [09:35] * fede2 departs -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] What goes into the security doc?

2003-01-19 Thread Dan Langille
With reference to my post to the "PostgreSQL Password Cracker" on 2003-01-02, I've promised to write a security document for the project. Here it is, Sunday night, and I can't sleep. What better way to get there than start this task... My plan is to write this in very simple HTML. I will post th

Re: [HACKERS] PostgreSQL site, put up or shut up?

2003-01-13 Thread Dan Langille
me period is this for? > > Any given day. It's disk space, not traffic. I think anyone thinking of putting up a mirror will want to know traffic volumes. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)-

Re: [HACKERS] psql and readline

2003-01-09 Thread Dan Langille
worked upon. > > Makese sense. However, it still has the shock factor of displaying a > huge query, which is usually what is involved when using the editor. Which is a good indicator that a way to turn it off is a good idea. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] psql and readline

2003-01-09 Thread Dan Langille
resent with my real mail address... On 9 Jan 2003 at 13:45, Peter Mount wrote: > On Wed, 8 Jan 2003, Dan Langille wrote: > > > On 8 Jan 2003 at 12:28, Bruce Momjian wrote: > > > > > Tom Lane wrote: > > > > "Alexander M. Pravking" <[EMAIL PROT

Re: [HACKERS] psql and readline

2003-01-09 Thread Dan Langille
On 9 Jan 2003 at 9:15, Robert Treat wrote: > On Thu, 2003-01-09 at 08:45, Peter Mount wrote: > > On Wed, 8 Jan 2003, Dan Langille wrote: > > > On 8 Jan 2003 at 12:28, Bruce Momjian wrote: > > > > Tom Lane wrote: > > > > > "Alexander M. Pravking&qu

Re: [HACKERS] psql and readline

2003-01-08 Thread Dan Langille
> > Hm, so it does. It seems like the edited query should go into > > history, at least when you execute it. Peter, is this fixable? > > Wow, that would be a nifty trick, though they really did type \e and > not the query the pulled in from the editor. What about those of us

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-07 Thread Dan Langille
Get off your own ass and do it. In short, put up or shut up. -- Dan Langille : http://www.langille.org/ ---(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] Have people taken a look at pgdiff yet?

2003-01-07 Thread Dan Langille
On Tue, 7 Jan 2003, Justin Clift wrote: > Hi everyone, > > Just found out that the "pgdiff" utility (the one for comparing two > different PostgreSQL database's) was released and uploaded to > SourceForge in November: > > http://sourceforge.net/projects/pgdiff > > Have people already looked at thi

Re: [HACKERS] OS/400 support?

2003-01-06 Thread Dan Langille
On Mon, 6 Jan 2003, Tom Lane wrote: > Justin Clift <[EMAIL PROTECTED]> writes: > > Info: > > http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html > > That page quoth > > OS/400 and its related software has added support for: > > The Portable Application Solutions Environment

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-06 Thread Dan Langille
On 6 Jan 2003 at 18:44, [EMAIL PROTECTED] wrote: > If the banner ads (as previously stated) do not bring in much revenue, > is there a reason to keep them? This has been mentioned more than once AFAIK. It is in "payment" to those who have provided mirror services. -- Dan

Re: [HACKERS] New Portal in Place, DNS switched ...

2003-01-05 Thread Dan Langille
On 5 Jan 2003, Neil Conway wrote: > Obviously, but it's VERY unprofessional for us to show ads to users on > our website. It goes without saying, but pretty much every other > non-trivial OSS project doesn't have ads on their main website. > Displaying ads makes us look more like a Geocities site

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2003-01-05 Thread Dan Langille
On Sat, 4 Jan 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > I never considered tag'ng for minor releases as having any importance, > > since the tarball's themselves provide the 'tag' ... branches give us the > > ability to back-patch, but tag's don't provide us anythi

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2003-01-04 Thread Dan Langille
msg resent because I incorrectly copied/pasted some addresses. Sorry. On 4 Jan 2003 at 11:08, Tom Lane wrote: > Dan Langille <[EMAIL PROTECTED]> writes: > > On Sat, 4 Jan 2003, Peter Eisentraut wrote: > >> There is a long tradition of systematically failing to tag relea

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2003-01-04 Thread Dan Langille
msg resent because I incorrectly copied/pasted some addresses. Sorry. On 4 Jan 2003 at 11:08, Tom Lane wrote: > Dan Langille <[EMAIL PROTECTED]> writes: > > On Sat, 4 Jan 2003, Peter Eisentraut wrote: > >> There is a long tradition of systematically failing to tag relea

Re: [GENERAL] [HACKERS] v7.3.1 Bundled and Released ...

2003-01-04 Thread Dan Langille
On Sat, 4 Jan 2003, Peter Eisentraut wrote: > Greg Copeland writes: > > > Just a reminder, there still doesn't appear to be a 7.3.1 tag. > > There is a long tradition of systematically failing to tag releases in > this project. Don't expect it to improve. It was I who suggested that a release te

Re: [HACKERS] Upgrading rant.

2003-01-03 Thread Dan Langille
On Fri, 3 Jan 2003, Bruce Momjian wrote: > Is pg_upgrade too hard to run? Is no one really interested in it? All of my boxes are still on 7.2.3. Does that represent a viable test base? ---(end of broadcast)--- TIP 6: Have you searched our list a

Re: [HACKERS] [GENERAL] Cast your vote ...

2003-01-02 Thread Dan Langille
On 2 Jan 2003 at 21:30, Jeroen T. Vermeulen wrote: > > Coincidentally, I've just started up a voting script project... see > > http://polls.unixathome.org/ > > Does it support hanging chads? Now is the time to decide that -- Dan Langille :

Re: [HACKERS] [GENERAL] Cast your vote ...

2003-01-02 Thread Dan Langille
an alot more than most technical folks want to > acknowledge. > > Please vote for your favorite database. Coincidentally, I've just started up a voting script project... see http://polls.unixathome.org/ -- Dan Langille : http://www.langille.org/ --

[HACKERS] new project - PostgresSQL based voting script

2003-01-02 Thread Dan Langille
See http://polls.unixathome.org/ Goal: create a voting script which uses PostgreSQL to store the data. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] PostgreSQL Password Cracker

2003-01-02 Thread Dan Langille
I'll do that. Justin: What's the URL for the .pgpass stuff? So far I see mention of using SSL. That's two items to cover. Anything else? On Wed, 1 Jan 2003, Bruce Momjian wrote: > > Yes, I have been feeling we should do that. Justin pointed out just > yesterday that .pgpass is only mentioned

Re: [HACKERS] why was libpq.so's version number bumped?

2002-12-30 Thread Dan Langille
On Mon, 30 Dec 2002, Palle Girgensohn wrote: > --On måndag, december 30, 2002 06.35.22 -0500 Dan Langille > <[EMAIL PROTECTED]> wrote: > > > On Mon, 30 Dec 2002, Christopher Kings-Lynne wrote: > > > >> ps. Why is Postgres 7.3 still in ports/databases/postgresql

Re: [HACKERS] why was libpq.so's version number bumped?

2002-12-30 Thread Dan Langille
On Mon, 30 Dec 2002, Christopher Kings-Lynne wrote: > ps. Why is Postgres 7.3 still in ports/databases/postgresql-devel ?? I forgot one other possible answer: perhaps the port maintainer is taking a well deserved holiday? ---(end of broadcast)---

Re: [HACKERS] why was libpq.so's version number bumped?

2002-12-30 Thread Dan Langille
On Mon, 30 Dec 2002, Christopher Kings-Lynne wrote: > Since going from 7.2 to 7.3 is a significant upgrade, the FreeBSD guys would > probablyu be right tho to refuse such a major upgrade... Still, it's a pity > though. Postgres 7.3 has been tested and works fine on FreeBSD 5. FreeBSD uses somet

Re: [HACKERS] why was libpq.so's version number bumped?

2002-12-30 Thread Dan Langille
On Mon, 30 Dec 2002, Palle Girgensohn wrote: > One of the reasons I ask is, if it is a good reason, like say "security", > maybe I can persuade the FreeBSD port responsible guys to bring the port > into the upcoming FreeBSD 5.0 release. The port freeze was introduced just > before pg-7.3 was relea

Re: [HACKERS] PostgreSQL article

2002-12-27 Thread Dan Langille
02-12/msg00203.php -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[HACKERS] http://www.postgresql.org/idocs/ is down

2002-12-11 Thread Dan Langille
http://www.postgresql.org/idocs/ is down Warning: Unable to connect to PostgreSQL server: The Data Base System is shutting down in /usr/local/www/www/idocs/opendb.php on line 3 Unable to access database -- Dan Langille : http://www.langille.org/ ---(end of broadcast

Re: [HACKERS] Let's create a release team

2002-12-10 Thread Dan Langille
On 10 Dec 2002 at 9:34, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > >> --- for example: Marc owns, runs, and pays for the > >> postgresql.org servers. > > > Is the cvs repo mirrored? > > Anyone running cvsup would have a com

Re: [HACKERS] Let's create a release team

2002-12-10 Thread Dan Langille
On 10 Dec 2002 at 0:56, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > Is the process documented? Any set procedure? Who knows how to do > > it? > > Er ... nope, nope, the core bunch ... Sounds like we need to do a brain dump then. I jus

Re: [HACKERS] Let's create a release team

2002-12-09 Thread Dan Langille
On 9 Dec 2002 at 11:38, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > Let's create a release team. This strategy is one well established > > in other projects and in industry. For lack of a better starting > > reference, le

[HACKERS] Let's create a release team

2002-12-07 Thread Dan Langille
eleng/index.html. This will also lighten the load on the core team allowing them to focus on development and such. cheers -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please se

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 15:36, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > >> You can do that now. > >> ALTER TABLE ADD CONSTRAINT FOREIGN KEY > > > That I know. That syntax is radically different from that proposed. > >

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
documented, the following is valid and works: ALTER TABLE slave ADD FOREIGN KEY (master_id) REFERENCES master (id) ON DELETE CASCADE; -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
clause > for all commands that add constraints. Except that one is ADD CONSTRAINT, the other is an ADD FOREIGN KEY. They are similar in nature but different overall. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 14:17, Fernando Nasser wrote: > Dan Langille wrote:> On 5 Dec 2002 at 11:47, Dan Langille wrote: > > > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; > > > > You should now go to the table this RI constraint was ref

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
EIGN KEY That I know. That syntax is radically different from that proposed. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 9:51, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > On 5 Dec 2002 at 9:31, Stephan Szabo wrote: > > > > > When we talk about ALTER TABLE ADD FOREIGN KEY we're being imprecise, so > > > I think that might

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
BLE ADD CONSTRAINT blah CHECK (foo!=0); > to make a named check constraint. Understood. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 9:02, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > Found the solution: > > > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; > > Actually there are three triggers for the constraint. You m

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 11:47, Dan Langille wrote: > On 5 Dec 2002 at 8:44, Stephan Szabo wrote: > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > > > > > > > > > > On Thu, 5 Dec 2002, D

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:44, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > > > > > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > > > We support "alter table add

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > We support "alter table add foreign key". How about supporting > > "alter table drop foreign key"? > > > > - he said as he went to drop a foreig

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > We support "alter table add foreign key". How about supporting > > "alter table drop foreign key"? > > > > - he said as he went to drop a foreig

[HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
We support "alter table add foreign key". How about supporting "alter table drop foreign key"? - he said as he went to drop a foreign key -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have y

[HACKERS] 7.4 - TODO : IpcSemaphoreCreate: No space left on device

2002-12-05 Thread Dan Langille
/usr/local/pgsql/data.old That's when I encountered the message mentioned in the subject. The solution involved: # mv /usr/local/pgsql/data.old /usr/local/pgsql/data # /usr/local/etc/rc.d/010.pgsql.sh stop # mv /usr/local/pgsql/data /usr/local/pgsql/data.old # su -l pgsql -c initdb Then

Re: [HACKERS] contrib/ltree patches

2002-12-05 Thread Dan Langille
se if (state == LQPRS_WAITEND) > > { > > - if (*ptr == NODE_DELIMITER) > > + if (*ptr == '.') > > { > > state = LQPRS_WAITLEVEL; > >

Re: PostgreSQL in Universities (Was: Re: [HACKERS] 7.4 Wishlist)

2002-12-03 Thread Dan Langille
On 3 Dec 2002 at 15:08, Vince Vielhaber wrote: > Where have you been? The lines of distinction between all of the > lists have gotten so blurred it hardly makes a difference. So consider this a wake up call. -- Dan Langille : http://www.langille.org/ ---(

Re: [HACKERS] 7.4 Wishlist

2002-11-30 Thread Dan Langille
Can you see this tying in with my recent hack of contrib/ltree to work with a wider range of node names? On Sat, 30 Nov 2002, Oleg Bartunov wrote: > Me and Teodor hope to work on contrib/ltree to add support for sort of > xml. Any ideas are welcome ! ---(end of broadcast

Re: [HACKERS] contrib/ltree patches

2002-11-27 Thread Dan Langille
at was not my goal. :) -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] contrib/ltree patches

2002-11-27 Thread Dan Langille
On 27 Nov 2002 at 12:16, Teodor Sigaev wrote: > Dan Langille wrote: > > I have been looking at contrib/ltree in the PostgreSQL repository. > > I've modified the code to allow / as a node delimiter instead of . > > which is the default. > What is the reason for

[HACKERS] contrib/ltree patches

2002-11-26 Thread Dan Langille
I have been looking at contrib/ltree in the PostgreSQL repository. I've modified the code to allow / as a node delimiter instead of . which is the default. Below are the patches to make this change. I have also moved the delimiter to a DEFINE so that other customizations are easily done. This i

Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-04 Thread Dan Langille
The original tester says "this is an anonymous procedure". On 30 Sep 2002 at 15:07, Bruce Momjian wrote: > > It is not clear to me; is this its own transaction or a function > call? > > ---------- > -

[HACKERS] GET DIAGNOSTICS SELECT PROCESSED INTO

2001-01-17 Thread Dan Langille
ROTECTED]> To: [EMAIL PROTECTED] Subject:Re: getting number of rows updated within a procedure On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote: > I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a > question: At various times, it does UPDAT