[GENERAL] libpq Windows 7 64

2012-05-31 Thread Bret Stern
Got a new fancy pants Dell T3500 Windows 7 Ultimate 64 bit machine. PostgreSql 9.1 Trying to port a 32-bit XP libpq console app with Codeblocks. Seems like the libpq.lib isn't linking quite right as the PQ_Connectdb, PQstatus etc lib functions are reported as undefined. Anyone out there get Win

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Chris Travers
Minor correction On Thu, May 31, 2012 at 1:57 PM, John Townsend wrote: > Fortran was the first computer language for me. (I guess that reveals my age > :-) ) Fortran was my second computer language, but I hated it. > > PL/pgSQL is easy to learn for me since it is pascal like. It appears this is

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Chris Travers
On Thu, May 31, 2012 at 7:36 AM, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. > > Which ones do you use and why? Virtually all the time I use PL/PGSQL. The reason is that I think that the primary

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Joshua Tolley
On Fri, Jun 01, 2012 at 08:13:28AM +1200, Mike Toews wrote: > On 1 June 2012 02:36, John Townsend wrote: > > There are least 10 Procedural Languages available for PostGreSQL. The one > > that comes with the installation is PL/pgSQL. > > The count looks closer to 18 > http://en.wikipedia.org/wiki/

[GENERAL] autovacuum running for a long time on a new table with 1 row

2012-05-31 Thread Lonni J Friedman
Running 9.1.3 on Linux-x86_64. I'm seeing autovacuum running for the past 6 hours on a newly created table that only has 1 row of data in it. This table did exist previously, but was dropped & recreated. I'm not sure if that might explain this behavior. When I strace the autovacuum process, I se

Re: [GENERAL] PostgreSQL 9.0.4 crashing

2012-05-31 Thread John R Pierce
On 05/31/12 2:57 AM, R, Abhilash (HP Software) wrote: 2012-05-31 03:15:54 IST LOG: server process (PID 49972) was terminated by exception 0xC12D Out of virtual memory Error exception 0xC12D Your system is low on virtual memory. To ensure that Windows runs correctly, increase the

Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index

2012-05-31 Thread Jeff Davis
On Thu, 2012-05-31 at 15:55 -0500, Bryan Murphy wrote: > I'm having a problem upgrading a cluster from 9.0.7 to 9.1.3. Here's > the error: Please send /srv/pg_upgrade_dump_globals.sql Also, can you restart the old system (by removing the ".old" suffix, as the message suggests), and then do a "SE

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Jeff Davis
On Thu, 2012-05-31 at 11:23 -0700, Darren Duncan wrote: > Michael Nolan wrote: > > PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily > > to launch shell scripts from triggers, for example to update an external > > website when a row in a table has been inserted, deleted or

Re: [GENERAL] PostgreSQL 9.0.4 crashing

2012-05-31 Thread Merlin Moncure
On Thu, May 31, 2012 at 4:57 AM, R, Abhilash (HP Software) wrote: > PostgreSQL 9.0.4 is crashing intermittently in Windows 2008 R2 environment > with following error in log file. > > > > 2012-05-31 03:15:54 IST LOG:  server process (PID 49972) was terminated by > exception 0xC12D > > 2012-05-3

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Scott Marlowe
On Thu, May 31, 2012 at 2:13 PM, Mike Toews wrote: > On 1 June 2012 02:36, John Townsend wrote: >> There are least 10 Procedural Languages available for PostGreSQL. The one >> that comes with the installation is PL/pgSQL. > > The count looks closer to 18 > http://en.wikipedia.org/wiki/PostgreSQL#

Re: [GENERAL] Procedural Languages

2012-05-31 Thread John Townsend
On 5/31/2012 3:13 PM, Mike Toews wrote: On 1 June 2012 02:36, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. The count looks closer to 18 http://en.wikipedia.org/wiki/PostgreSQL#Procedural_languages b

[GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index

2012-05-31 Thread Bryan Murphy
I'm having a problem upgrading a cluster from 9.0.7 to 9.1.3. Here's the error: psql:/srv/pg_upgrade_dump_globals.sql:54: ERROR: duplicate key value violates unique constraint "pg_authid_oid_index" DETAIL: Key (oid)=(10) already exists. Any ideas what I'm doing wrong? Here's the verbose outpu

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Mike Toews
On 1 June 2012 02:36, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. The count looks closer to 18 http://en.wikipedia.org/wiki/PostgreSQL#Procedural_languages but I doubt some get much use (PL/LOLCOD

Re: Fwd: [GENERAL] Procedural Languages

2012-05-31 Thread Darren Duncan
Michael Nolan wrote: On Thu, May 31, 2012 at 2:23 PM, Darren Duncan wrote: Michael Nolan wrote: PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily to launch shell scripts from triggers, for example to update an external website when a row in a t

Fwd: [GENERAL] Procedural Languages

2012-05-31 Thread Michael Nolan
-- Forwarded message -- From: Michael Nolan Date: Thu, May 31, 2012 at 2:49 PM Subject: Re: [GENERAL] Procedural Languages To: Darren Duncan On Thu, May 31, 2012 at 2:23 PM, Darren Duncan wrote: > Michael Nolan wrote: > >> PL/pgSQL and PL/perlu are the only ones I use. I use

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Jeff Davis
On Thu, 2012-05-31 at 11:52 -0600, David Salisbury wrote: > I've often wondered how these "external" languages perform, figuring > that using a native language would perform better. One language isn't more "native" than another, really. SQL is a bit more native in the sense that it might be inline

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Darren Duncan
Michael Nolan wrote: PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily to launch shell scripts from triggers, for example to update an external website when a row in a table has been inserted, deleted or updated. There is also another way to do what you describe that mig

Re: [GENERAL] Procedural Languages

2012-05-31 Thread David Salisbury
On 5/31/12 8:36 AM, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? I've often wondered how these "external" languages perfor

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Michael Nolan
On Thu, May 31, 2012 at 10:36 AM, John Townsend < jtowns...@advancedformulas.com> wrote: > There are least 10 Procedural > Languagesavailable for PostGreSQL. The > one that comes with the installation is > PL/pgSQL. > > Which ones do you use and why? > > T

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Leif Biberg Kristensen
Torsdag 31. mai 2012 17.07.19 skrev Merlin Moncure : > pl/pgsql is unique in that it has 'first class queries' -- sql is > intermixed freely with procedural code and it uses the same type > system and error handling mechanisms (although the syntax is > different). this directly translates into

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Merlin Moncure
On Thu, May 31, 2012 at 9:36 AM, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. > > Which ones do you use and why? pl/pgsql is unique in that it has 'first class queries' -- sql is intermixed freely

[GENERAL] PostgreSQL 9.0.4 crashing

2012-05-31 Thread R, Abhilash (HP Software)
PostgreSQL 9.0.4 is crashing intermittently in Windows 2008 R2 environment with following error in log file. 2012-05-31 03:15:54 IST LOG: server process (PID 49972) was terminated by exception 0xC12D 2012-05-31 03:15:54 IST HINT: See C include file "ntstatus.h" for a description of the he

[GENERAL] Procedural Languages

2012-05-31 Thread John Townsend
There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? Thanks, John Townsend

Re: [GENERAL] Change request - log line prefix

2012-05-31 Thread Stuart Bishop
On Thu, May 31, 2012 at 12:19 PM, Chris Angelico wrote: > On Thu, May 31, 2012 at 2:05 PM, Evan Rempel wrote: >> Even when the wrap column is set to a very large value (32k) STATEMENT lines >> still wrap according to the line breaks in >> the original SQL statement. > > The problem isn't so much

Re: [GENERAL] Postgres no longer starts

2012-05-31 Thread Adrian Klaver
On 05/31/2012 12:45 AM, Bart Lateur wrote: Alan Hodgson writes: On Wednesday, May 30, 2012 08:22:58 PM Bart Lateur wrote: Luckily this is a development machine, but as we don't know what causes the problem we fear we might one day face the exact same problem where it does matter: on a producti

Re: [GENERAL] problem with restoring on an other server

2012-05-31 Thread Adrian Klaver
On 05/31/2012 06:33 AM, J.H. TREEP wrote: Machine: SuSe linux 64 Postgres 9.0 Postgis 1-5 pg_restore: [archiver (db)] could not execute query: ERROR: could not access file "$libdir/postgis-1.5": No such file or directory Either the user running the pg_restore does not have permissions for th

[GENERAL] problem with restoring on an other server

2012-05-31 Thread J.H. TREEP
Machine: SuSe linux 64Postgres 9.0Postgis 1-5pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/postgis-1.5": No such file or directoryDoes someone knows how to solve this issue?Johan.

Re: [GENERAL] Change request - log line prefix

2012-05-31 Thread hubert depesz lubaczewski
On Wed, May 30, 2012 at 09:05:23PM -0700, Evan Rempel wrote: > I am part of a team that fills an operational roll administering 1000+ > servers and > 100's of applications. Of course we need to "read" all of our logs, and must > use computers to > help us. In filtering postgreSQL logs there is on

Re: [GENERAL] Postgres no longer starts

2012-05-31 Thread Bart Lateur
> Alan Hodgson writes: > > On Wednesday, May 30, 2012 08:22:58 PM Bart Lateur wrote: > >> Luckily this is a development machine, but as we don't know what > >> causes the problem we fear we might one day face the exact same > >> problem where it does matter: on a production machine. So we'd like