[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

[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

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 thomas.mu...@enterprisedb.com wrote: On Sat, Jun 6, 2015 at 1:25 PM, Alvaro Herrera

[HACKERS] could not truncate directory pg_subtrans: apparent wraparound

2015-06-05 Thread Dan Langille
/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 a.korot...@postgrespro.ru wrote: On Wed, May 27, 2015 at 7:00 PM, Dan Langille d...@langille.org mailto:d...@langille.org wrote: Have you been to PGCon before? Do you remember the hacker lounge? Do you remember going there to work

[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
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
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 http://langille.org/ -- Sent

[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
/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 subscription: http://www.postgresql.org

[HACKERS] PGCon 2015 call for papers

2015-01-05 Thread Dan Langille
://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
://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 Langille - http://langille.org

[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
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.postgresql.org

[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 changes to your

[HACKERS] PGCon 2012 Call for Papers - reminder

2012-01-26 Thread Dan Langille
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
is: 8 Jan 2012 Proposal acceptance begins 29 Jan 2012 Proposal acceptance ends 19 Feb 2012 Confirmation of accepted proposals See also 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

[HACKERS] PGCon 2011 Call for Papers - reminder

2011-01-11 Thread Dan Langille
: 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.jpgvia=tfrog - -- Dan Langille BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon.org

[HACKERS] postmaster in a tight loop

2008-02-12 Thread Dan Langille
[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.org/ BSDCan

Re: [HACKERS] PGCon 2007 Program Committee

2007-01-06 Thread Dan Langille
://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 Christopher Browne Josh Berkus Robert Treat Luke Lonergan Neil

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 I and Teodor would like to present new full text search, now

[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

[HACKERS] Undefined symbol elog

2004-01-31 Thread Dan Langille
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 3: if posting/reading through Usenet, please send

[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

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. New issue? Known bug? New one on me. Look

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 the new database. I found three of these messages in /var/log

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. Try EXTRACT(timezone_hour from now()); The timestamp I/O routines

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

2003-07-05 Thread Dan Langille
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-04 Thread Dan Langille
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
by the login shell ! [09:35] fede2 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

[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 the

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

2003-01-13 Thread Dan Langille
, 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)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

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 [EMAIL PROTECTED] writes: On Wed, Jan 08, 2003 at 10:53:51AM

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 PROTECTED] writes: On Wed, Jan 08, 2003 at 10:53:51AM +0100, Ian

Re: [HACKERS] psql and readline

2003-01-09 Thread Dan Langille
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-08 Thread Dan Langille
who want to use \e repeatedly? Will that be in the history buffer? -- 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] 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 this? I

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

2003-01-07 Thread Dan Langille
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] 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 Langille : http

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 (PASE),

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 anything ... do

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-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 team

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 releases in this project. Don't

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 releases in this project. Don't

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

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

[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] [GENERAL] Cast your vote ...

2003-01-02 Thread Dan Langille
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/ ---(end of broadcast

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 : http://www.langille.org

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 released,

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

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, 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-devel ?? I forgot one other possible answer

Re: [HACKERS] PostgreSQL article

2002-12-27 Thread Dan Langille
-- 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 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 just happen to have some equipment left over from

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 complete copy of the source CVS, I believe. It would be more

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, let me suggest http://www.freebsd.org/releng/charter.html

[HACKERS] Let's create a release team

2002-12-07 Thread Dan Langille
/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 send

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

2002-12-05 Thread Dan Langille
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 the initdb ran successfully. -- Dan

[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 you searched our list archives

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 foreign key It seems to work for me on my 7.3b2 system with alter table

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 foreign key It seems to work for me on my 7.3b2 system with alter table

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 foreign key. How about supporting alter table drop foreign key? - he

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, Dan Langille wrote: We support alter table add foreign key. How about

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 may have dangling triggers on the other table

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

2002-12-05 Thread Dan Langille
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: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 be why we're talking past each other here. Technically

Re: [HACKERS] contrib/ltree patches

2002-12-05 Thread Dan Langille
of the node name. In short, the code needs to allow for operators to be escaped if they are part of the node name. On 5 Dec 2002 at 0:54, Bruce Momjian wrote: Dan, is this ready to be applied to CVS? -- - Dan Langille wrote

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 referring to and delete the two triggers

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

2002-12-05 Thread Dan Langille
. 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
keys in this case. If you don't put in the CONSTRAINT blah clause, you get an automatically assigned constraint name. Regardless of what is documented, the following is valid and works: ALTER TABLE slave ADD FOREIGN KEY (master_id) REFERENCES master (id) ON DELETE CASCADE; -- Dan

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 table ADD CONSTRAINT const FOREIGN KEY That I know. That syntax is radically different from that proposed. So you're proposing we replace a SQL-spec-compliant syntax

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/ ---(end

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

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 changing delimiter? My tree represents

Re: [HACKERS] contrib/ltree patches

2002-11-27 Thread Dan Langille
. :) -- 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

[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

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? -- - Dan Langille wrote: And just

[HACKERS] GET DIAGNOSTICS SELECT PROCESSED INTO int4_variable

2001-01-17 Thread Dan Langille
PROTECTED] 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 UPDATEs. Is there a w