Re: [GENERAL] Postgresql won't run after upgrade to fc5

I copied over the missing libs from one of my other fc4 systems and postgresql seems happy and I have not experienced any other problems so far... Jerry On Mar 21, 2006, at 11:46 PM, Bruno Wolff III wrote: On Wed, Mar 22, 2006 at 00:10:53 +0200, Devrim GUNDUZ <[EMAIL PROTECTED]> wrot

[GENERAL] MediaWiki and Postgresql?

The propaganda at MediaWiki is sorta vague on Postgresql support. Has anyone put MediaWiki up using the current version of Postgresql? Jerry ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: [GENERAL] "save history" problem

right status code. I got rid of the error message by changing the source to ignore the return code... Currently I simply ignore the error message :) and use tools that have reduced my usage of psql to a bare minimum. ( http://homepage.mac.com/levanj ) Jerry ---(end of

Re: [GENERAL] Checking for Foreign Keys constraining a record?

actually if the FK linkage is shallow.) Add a statement to prevent the nuisance error message to the trans. begin; set log_min_messages to log; do trial delete; rollback; HTH -- --- Jerry Sievers 305 854-3001

Re: [GENERAL] Checking for Foreign Keys constraining a record?

Forgot to add; another option is to use a PL function with an exception handler. This may be a bit more elegant approach but not necessarily easier. FYI Jerry Sievers <[EMAIL PROTECTED]> writes: > Benjamin Smith <[EMAIL PROTECTED]> writes: > > > I want to be able

Re: [GENERAL] convert LO to BYTEA

Markus, PgBrowse 1.7a allows saving Large Objects into a file and the PgBrowse editor also allows inserting Bytea Fields from a file. See http://homepage.mac.com/levanj/TclTk Jerry ---(end of broadcast)--- TIP 4: Have you searched our list

[GENERAL] Mac Problem with Tunneling...

Hi, On my linux box I can issue the command ssh -L :macjerry:5432 -l jerry macjerry This will create a "tunnel" to connect to my mac named "macjerrry". I can connect to databases on macjerry via psql by specifying port on my linux box and other postgresql fron

Re: [GENERAL] Mac Problem with Tunneling...

On May 13, 2006, at 6:18 PM, Tom Lane wrote: Jerry LeVan <[EMAIL PROTECTED]> writes: How ever if I turn it around, and on the mac issue the command ssh -L :linuxbox:5432 -l jerry linuxbox Then I am not able to connect to the linux box via psql or any Gui front ends. [ tr

[GENERAL] psql \echo strangeness with :variables

es the :variables. FYI -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archive

[GENERAL] psql for winxp?

t on XP is restricted to scripting languages ( tcl and python ). Any candidates/suggestions? Jerry ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] psql for winxp?

Hi John, Is it possible to have the installer only emplace psql and the necessary support libs? Jerry On Jun 19, 2006, at 8:36 PM, John DeSoi wrote: Hi Jerry, You can use psql directly and communicate with it using a pipe stream. On Windows I believe this is equivalent to calling

[GENERAL] Ann: PyPgExplorer-0.8

://homepage.mac.com/levanj This is by no means a PGAdmin replacement :) Thanks Jerry ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes d

[GENERAL] ANN: BiggerSQL-.12.2 a Mac Postgresql Browser/Editor

in the Scripts menu is "Open Script Folder". Choosing this item will cause the scripts folder located in the users Library directory to be opened by the Finder and made the front most window. The user could then drag files from this window onto the editor window. --Jerry

[GENERAL] Problem with Java during make install 7.4.1 and 7.4.2

On MacOS X 10.3.2 and latest everything I get the following error during make install. On 7.4.1 my fix was make and make install without java, then rebuild and install on the java stuff. Looks like I have to do the same again with 7.4.2 --Jerry mkdir /usr/local/pgsql/share/java /usr/local

[GENERAL] Where are PL/pgsql definitions kept?

definition of my PL/PGsql function. Is it possible to recover the text of a function definition from within postgresql? Thanks, Jerry ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Where are PL/pgsql definitions kept?

he rest of the definition ;(. Thank you :) Jerry On Mar 12, 2004, at 3:47 PM, Richard Huxton wrote: On Friday 12 March 2004 20:12, Jerry LeVan wrote: Is it possible to recover the text of a function definition from within postgresql? In psql: \df+ my_func_name To see how that works, start ps

Re: [GENERAL] Shared memory errors during initdb in Mac OS X

Semaphores: T ID KEYMODE OWNERGROUP NSEMS You might want to increase shmmax in /etc/rc ==Jerry On Mar 22, 2004, at 4:02 PM, Tom Lane wrote: John Siracusa <[EMAIL PROTECTED]> writes: and then restarted. Now it works, but I'm not sure if it was the change in sett

[GENERAL] Question

.  Generally this does not get displayed, however, today it is.  Can you help?   Thanks,   Jerry Robertson

[GENERAL] pg_temp_N temp schema buildup

cally after use? Thanks. -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broa

[GENERAL] Running Totals and other stuff....

lumn of ascending integers so the running total sql statement will function properly? Jerry

[GENERAL] [ANN] BiggerSQL-1.2.5 released

d again by the user. BiggerSQL can be found at http://homepage.mac.com/levanj/Cocoa Source code is included. Enjoy Jerry ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEm

[GENERAL] [ANN]: BiggerSQL-1.3 released

adds an interface to psql. If psql is available on the running system, meta commands can be sent to psql in a transparent fashion. o Source code included. For more details goto http://homepage.mac.com/levanj/Cocoa Enjoy Jerry ---(end of broadcast

Re: [GENERAL] Rendezvous Name?

for my computer. Is the rendezvous name hard coded? Jerry Sigh, someone else was logged in to the DB via psql after they logged out the name changed. Jerry ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] Simplfied Bytea input/output?

text, raster bytea ); INSERT INTO image (name, raster) VALUES ('beautiful image', bytea_import('/etc/motd')); SELECT bytea_export(image.raster, '/tmp/motd') FROM image WHERE name = 'beautiful image'; Jerry

[GENERAL] PQunescapeBytea Question

byte? Sigh, I expect the latter... Jerry ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Types and SRF's

e. Any suggestions as to how I can remember the rowtype? or (embed the definiton of the type in the definition of the function without having to create an explicit type? Jerry ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Types and SRF's

Doh, I was using \dT and \dT+ Thanks Jerry On Aug 31, 2004, at 3:14 PM, Tom Lane wrote: Jerry LeVan <[EMAIL PROTECTED]> writes: I would feel a bit more comfortable if I could recover the definition of the type at a later time, Try "\d annual_report_ty

[GENERAL] Python Postgresql support?

Is it possible to build the python postgresql support library on Mac OSX 10.3.5 with the default python install? Adding "--with-python" gets an error message about libpython not being a shared library when attempting to build postgresql. (pg 7.4.5) Thanks for any point

Re: [GENERAL] Types and SRF's

the table to have a column for each month ( and a grand total as the last column). I have not used arrays and aggregates, I will take a look Jerry On Sep 1, 2004, at 3:03 AM, Pierre-Frédéric Caillaud wrote: Your query looks suspiciously complicated... Why not process all 12 months in

[GENERAL] Selecting columns by position?

Hi, Is there any generic to select columns by position ie select the first, third, and fifth columns from I can't see anything in SQL...not to sure about PL/PgSQL... Thanks Jerry ---(end of broadcast)--- TIP 6: Have you searched our

[GENERAL] Building plpython on Mac OSX...

ile.global) python_libspec = -framework Python and then comment out the tests for a shared library in src/pl/plpython/Makefile Has this been fixed in version 8? Thanks Jerry ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] Building plpython on Mac OSX...

I was able to get it to build with the framework change and commenting out the shared library test on 7.4.5. The patch looks a bit cleaner... Jerry On Sep 24, 2004, at 4:14 PM, Tom Lane wrote: Jerry LeVan <[EMAIL PROTECTED]> writes: Have any configure experts looked at building plpython.so

[GENERAL] Message-ID as unique key?

lly unique identifer? I eventually want to have a cron job process my inbox and don't want successive cron tasks to keep re-entering the same email :) Jerry ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropri

Re: [GENERAL] Message-ID as unique key?

Well, this is for my personal mail...I think I will probably give it a try. The program can log errors so in the few cases that might occur I think I can "manufacture" my own message id. I guess that the bottom line is that if it exists it is unique... Jerry On Oct 12, 2004, at 11:2

[GENERAL] Any Show Stoppers for v8 libpq talking to v7.x db?

Hi, I am getting ready to release a new version of my postgresql browser and regrettably no longer have access to any version 7 of postgresql. I have a static link against the 8.0.0b3 version of libpq should this still work when accessing a version 7 database? Thanks Jerry

[GENERAL] Controlling order of evaluation?

orce the last select to appear last? Jerry ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?

make make check make install I am worried that the make check may have done an initdb. Would initdb wipe out my existing databases? How do I get my existing databases to be reentered into the system catalog? Thank you, Jerry Asher =====

Re: [GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my

opts postmaster.pid How do I tell postgres where to find my databases? Thanks, Jerry = Jerry Asher [EMAIL PROTECTED] 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980 Berkeley, CA 94709Fax: (877) 311-8688

[GENERAL] recovering a control file from a shutdown database....

initialized with BLCKSZ 16384, but the backend was compiled with BLCKSZ 8192. looks like you need an initdb. Bleh! I would prefer to not waste my db, and I assume initdb will do just that. Can anything be done to recover the pg_control file? Thanks, Jerry

[GENERAL] Postmaster won't -HUP

chine has two 500mHz processors with 256 MB ram. I have a hard time believing that one small query can bring that machine to its knees, but it has, twice. The queries were run through a hard coded php front end (for testing purposes). Any insight on these two problems would be appreciated greatl

Re: [GENERAL] Postmaster won't -HUP

At 12:11 PM 6/1/00 -0500, Ed Loehr wrote: >Jerry Lynde wrote: > > > > As for the query I'm running, it was simply select * from > bigtable (about > > 2-300k lines) where > >

Re: [GENERAL] Postmaster won't -HUP

At 01:21 PM 6/1/00 -0400, Tom Lane wrote: >Ed Loehr <[EMAIL PROTECTED]> writes: > > Jerry Lynde wrote: > >> > >> As for the query I'm running, it was simply select * from bigtable (about > >> 2-300k lines) where > >> firstname= and > &

Re: [GENERAL] Postmaster won't -HUP

At 05:19 PM 6/1/00 -0400, Joseph Shraibman wrote: >Jerry Lynde wrote: > > > > At 12:11 PM 6/1/00 -0500, Ed Loehr wrote: > > >Jerry Lynde wrote: > > > > > > > > As for the query I'm running, it was simply select * f

Re: [GENERAL] Postmaster won't -HUP

At 05:58 PM 6/1/00 -0400, you wrote: Jerry Lynde <[EMAIL PROTECTED]> writes: >>>> They are all indexed, the DOB index is actually DOBYear DOBDay and >>>> DOBMonth and all 5 fields are indexed >> >> Do you have 5 indexes or do you have an index tha

<    1   2   3   4