[GENERAL] Displaying a wide column with psql

of using pg_dump, I couldn't see an interactive way of seeing the whole field. Is it possible? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] How do write schema independent install files for functions.

On 16/07/2012 20:44, Tom Lane wrote: > Philip Couling writes: >> I have a number of functions which I wish to wrap up in a SQL script >> (well technically DDL script). The functions reference one another and >> for safety it is necessary for them to ether set the searc

[GENERAL] How do write schema independent install files for functions.

Hi I have a number of functions which I wish to wrap up in a SQL script (well technically DDL script). The functions reference one another and for safety it is necessary for them to ether set the search_path or directly reference the schema for one another. I was wondering if there is good / rec

Re: [GENERAL] Feature discussion: Should syntax errors abort a transaction?

On 20/06/2012 08:24, Chris Travers wrote: > It seems to me there is one very simple reason not to change current > behavior which those in favor are glossing over. > > Most interactions with a database are not occurring over an interface > like psql with one person typing on one side and the db ex

Re: [GENERAL] || versus concat( ), diff behavior

On 02/03/12 20:58, david.sahag...@emc.com wrote: Can anybody please point me to where this "difference of behavior" is explained/documented ? Thanks, -dvs- -- version = 9.1.3 do $$ declare v_str char(10); begin v_str := 'abc' ; raise info '%', concat(v_str, v_str) ; raise info '%',

Re: [GENERAL] Easy form of "insert if it isn't already there"?

This must be a function or trigger to break one statement into two. You could of course simply use two separate statements in PHP as long as they are in the same transaction. If you're going to perform this action in two steps then putting both in a function or trigger is often preferable. Looki

Re: [GENERAL] last entry per person

On 03/02/2012 08:30, Chris Travers wrote: On Fri, Feb 3, 2012 at 12:26 AM, garry > wrote: I have a table which holds a user name and their results in exams. There can be multiple entries per user. I am trying to return the last entry for each user. I

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

tgreSQL 8.x - there were old (unused) versions of LedgerSMB - during the move from Fedora 14 to Fedora 16 (x86_64), the data was dumped out of PG 8.x and restored to PG 9.1P I haven't done any manual messing around with template1 as far as I know . . Regards, Phil. -- Philip Rh

Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

Devrim, On 2009-08-14 00:55, Devrim GÜNDÜZ wrote: On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote: It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Uh, I think it would consume more

[GENERAL] PostgreSQL for Firefox Bookmarks?

People, It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general

[GENERAL] How can I tell, in a trigger, if a value in a string is an integer.

(As of July 1, 2008): 3480 Preston Ridge Road Suite 450 Alpharetta, GA 30005 Philip W. Dalrymple III <[EMAIL PROTECTED]> MDT Software - The Change Management Company +1 678 297 1001 Fax +1 678 297 1003 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Varchar vs varchar(64)

ware Headquarters (As of July 1, 2008): 3480 Preston Ridge Road Suite 450 Alpharetta, GA 30005 Philip W. Dalrymple III <[EMAIL PROTECTED]> MDT Software - The Change Management Company +1 678 297 1001 Fax +1 678 297 1003 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Session variables (how do I pass session data to a function)

thanks for everyone's help on this. - Original Message - From: "Guy Rouillier" <[EMAIL PROTECTED]> To: "General Postgres Mailing List" Sent: Monday, October 20, 2008 7:22:22 PM GMT -05:00 US/Canada Eastern Subject: Re: [GENERAL] Session variables (how do I pa

[GENERAL] Session variables (how do I pass session data to a function)

: 3480 Preston Ridge Road Suite 450 Alpharetta, GA 30005 Philip W. Dalrymple III <[EMAIL PROTECTED]> MDT Software - The Change Management Company +1 678 297 1001 Fax +1 678 297 1003 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Help with query to return indexes (including functional ones!) on a given table

Hi all - I'm trying to add functional index support to Rails' Active Record and am getting stuck when it comes to a method Rails has to print out the indexes associated with a given table. The SQL being run is below: SELECT distinct i.relname, d.indisunique, a.attname FROM pg_class t, pg_class i

[GENERAL] plpythonu under OS X 10.4 -- a brief HOWTO

psql as a normal user and try out your function: > select * from show_python_version(); show_python_version ---- 2.5.1 (r251:54863, Nov 17 2007, 21:19:53) [GCC 4.0.1 (Apple Computer, Inc. build 5367)] (1 row) That's all! Enjoy Philip Semanch

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

except one. Not sure if this is typical of other systems or not, but it kind of sucks :/ There's other things too, but I don't remember what they are until I build something that works fine with a single mysql instance and then doesn't on the cluster... -philip --

Re: [GENERAL] Running OS-level programs from Postgres?

Maybe this is a well duh kind of question, or maybe there's no straightforward way to do it, but is there any way that I could have a pg function initiate a process on the host system? Specifically I'd like to script an email to send off on an insert trigger, but the ability to initiate system pr

Re: [GENERAL] pgsql and Mac OS X

That's not on my mac. Must be some bolt-on you installed. So how did you get it working? (I have no idea how this file got there. Wouldn't know where to begin) Coming in late so maybe someone already posted this, but I used this: http://www.postgresqlformac.com/ I wanted the server too, b

Re: [GENERAL] Nice, web-based SNMP-Frontend for pgsnmpd?

he partitions available. I just hooked it up with litespeed web server and it does the same thing letting me graph each of the configured virtual hosts. In both cases the scripts/templates were built by someone else so I don't can't tell you how to do it, but i

Re: [GENERAL] tsearch2 and pdf files

>> 1. Convert PDF to file with e.g xpdf >> 2. Insert parsed text to a table of your choice. >> 3. Make vectors from the text. > > Actually, if you're not going to use the headline() function, you cna > just store it directly in a vector, cutting down on the size > requirements. What size requiremen

Re: [GENERAL] tsearch2 and pdf files

12:21 > À : pgsql-general@postgresql.org > Objet : Re: [GENERAL] tsearch2 and pdf files > > You just need software that extracts the text from it. Search google for > pdf2txt and others. Printer drivers that try to get text from anything > are available as well. > > &g

[GENERAL] tsearch2 and pdf files

I'm using Postgresql 8.1.5 Tsearch2 is installed and runs well I'd like to use tsearch2 to index PDF files. Do someone has a detailed process to implement that?

Re: [GENERAL] Connection Pooling for Postgres

Is there any inbuilt facility in postgres for connection pooling .. ?? Not built in, but... http://pgpool.projects.postgresql.org/ Never used it myself... ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] postgresql rising

On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote: On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote: For a high level corp manager all they ever hear about is MS SQL Server, Oracle and DB2, and the more it costs the more they think it is what they need :-) I think that

Re: [GENERAL] postgresql rising

On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote: For a high level corp manager all they ever hear about is MS SQL Server, Oracle and DB2, and the more it costs the more they think it is what they need :-) I think that description is false. At a certain point in the management hiera

[GENERAL] using deferred initially deferred to solve foreign key checking issues

a time? If they are checked one at a time then transactions will no longer be waiting on each other to release locks because each transaction will only have 1 lock. Thanks Philip ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

That's a scary idea - being forced into Oracle or Sybase. Isn't Slashdot.org still running strongly off of MySQL? Depends on how you define strongly. Slashdot has a LOT of code in place to cache the content so it never has to hit the database directly. Basically, every X seconds, the data creat

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

read wants to write to a table, it must first get exclusive access. During the update, all other threads that want to access this particular table must wait until the update is done." It doesn't take very many writes before this *really* becomes a problem. We're implem

Re: [GENERAL] Replication & web apps

d... you lose in one area to gain in another -philip Jeff Amiel Leonardo Francalanci wrote: Hi, I still don't understand how replication can be used in web applications. Given this scenario: 1) user updates his profile -> update to the db (master) 2) web app redirects to the &qu

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

ersion of mysql had a lot to do with it as people could run IIS, php, and mysql locally on their desktop for their development server... -philip ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] How to find first non-vacation day

I have a table of vacations create table vacation ( id integer primary key, dstart date, dend date ); I need to find first non-vacation day before given date. This can be done using the following procedural vfp code function nonvacation( dbefore ) for i=dbefore to date(1960,1,1) step -1 se

Re: [GENERAL] How to find first non-vacation day

I have a table of vacations create table vacation ( id integer primary key, dstart date, dend date ); I need to find first non-vacation day before given date. This can be done using the following procedural vfp code function nonvacation( dbefore ) for i=dbefore to date(1960,1,1) step -1 se

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

27;t rely on any commercially licensed code the removal of which would adversely affect postgresql itself. Anyway, that's my little 2 cents... :) -philip ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

But no, Mark, I'm not worried by the FUD. It just means there's nothing real for them to throw at PostgreSQL. This just appeared on slashdot... MySQL To Be Ikea Of The Database Market http://developers.slashdot.org/article.pl?sid=05/10/07/1224213&from=rss From the linked article... http://w

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

http://sql-info.de/mysql/gotchas.html Of course, one should probably also look at the PostgreSQL Gotchas page (same guy) just to be fair :-) http://sql-info.de/postgresql/postgres-gotchas.html Now whether or not those are still valid or not I have no idea... -philip

Re: [GENERAL] Fetching column names for a table

I need to extract a SETOF column names for a table in plpgsql. How is this done? Start up psql with the -E option. Then type "\dt tablename". This will print out the SQL that psql runs to give you the column names. Maybe that will do what you want?

Re: [GENERAL] Slow search.. quite clueless

up" (the drink) and it would remove "up". Made it really hard to pull up 7 up in the results :) -philip Oleg On Tue, 20 Sep 2005, Yonatan Ben-Nes wrote: Hi all, Im building a site where the users can search for products with up to 4 diffrent keywords which all MUST mat

Re: [GENERAL] XlogFlus error message

e database from this morning and launch my synchronization with the master database. I think that the upgrade will be done next week Thanks > -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 14 septembre 2005 16:29 > À : philip johnson >

[GENERAL] XlogFlus error message

I've a problem with my postgresql database Version : 7.2.4 Os: Mandrake Linux release 8.2 Kernel 2.4.20 I get this king of error ERROR: XLogFlush: request 14D/F77EFE94 is not satisfied --- flushed only to 14D/F75CD1B0 ---(end of broadcast)--- TI

Re: [GENERAL] Postgresql Hosting

I'm sharing with 5 other small businesses a dedicated server with 60GB hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month. Where is this available? Not quite that package and I've never used them (thinking about it), but layeredtech.com has this as their cheapest: . Intel Ce

Re: [GENERAL] Formatting TimeStamp

Joshua, I know that i can format it explicitly, but instead of using a SELECT * FROM .. I have to name the columns which is not very convenient. Right now I have created views for each table just to re-format the output of the one timestamp field. Not sure it solves your problem, but you can

[GENERAL] Postgresql version

What version would you recommend to use for a new installation: 8.0.x or 7.4.x TIA ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] Installing soundex, metaphone, lenshtein

Where can I find instructions to install these functions in my 7.4 version? I am awaret hat they are in the contrib. folder but I have never installed functions from the contrib folder. Thanks in advance. From postgresql-7.4.2/contrib/README: Each subdirectory contains a README file with inf

Re: [GENERAL] chosing a database name

we are developing GNUmed, a medical practice management application running on PostgreSQL (you want your medical data to be hosted by something reliable, don't you ;-) We are putting out our first release sometime in the next two weeks. The idea is to name the production database "gnumed0.1" for

Re: [GENERAL] Limits of SQL

I've got the 2nd edition and while I haven't made it that far, Ch 30 is on graphs. -philip ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Subselects - recursion problem

Martijn, On Mon, 2005-05-30 at 21:08, Martijn van Oosterhout wrote: > On Mon, May 30, 2005 at 08:32:15PM +1000, Philip Rhoades wrote: > > Martijn, > > > > > > On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: > > > "recursion problem&quo

Re: [GENERAL] Subselects - recursion problem

Martijn, On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: > On Mon, May 30, 2005 at 07:33:04PM +1000, Philip Rhoades wrote: > > People, > > > > The following script works (I have confirmed it by doing two separate > > views and doing a select on them) -

[GENERAL] Subselects - recursion problem

t_diss = '0' AND c2.recon = 'N' AND c1.loc = c2.loc AND c1.lob = c2.lob AND c1.policy = c2.policy ) ORDER BY c1.loc, c1.lob, c1.policy ; -- Philip Rhoades Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252

Re: [GENERAL] Postgres in government

which is why he wants proof that others have found it worthy... Silly, but that's probably what's happening. -philip ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column

Re: [GENERAL] restarting after power outage

It is. We have been fooling with the postmaster startup logic to try to eliminate this gotcha, but it's only very recently (8.0.2) that I think we got it right. So, then it would be correct to change my init scripts to do the following: (if so, this patch can be applied to the 7.4 branch) I woul

[GENERAL] Reduce size of $PGDATA for "demo cdrom"?

ediately burn things to CD? Or if there are postgresql.conf options I can set to not keep WAL logs, etc around that would work too since this is just for tradeshows... Thanks all! -philip ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] tsearch2

http://www.google.com/search?q=tsearch2 The first link contains info and links to what I used... worked all right for me. good luck! On Sun, 17 Apr 2005, Tobias Heise wrote: HI Everybody! Could everyone give me a short instruction how to use tsearch2, please? Tobias ---(e

Re: [GENERAL] Database monitor (again)

graphing number of queries, average query length, queries per second that sort of stuff... -philip ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Postgresql driver

I am trying to develop an application to access postgresql DB using QT developer however when running the developer it cannot find the DB driver? How can I make the driver available to QT? Any Ideas would be helpful Philip ---(end of broadcast

[GENERAL] I need your advice thank you

Good day to all ... I hope any one can give me an advice ... to optimize my database... im having a problem when i'm backing up my DB and also using vacuum for my DB... my CPU load goes up and no one can use my DB... most of the transaction comes from web server.. I just need ur good advice

[GENERAL] I need your advice

Good day to all ... I hope any one can give me an advice ... to optimize my database... im having a problem when i'm backing up my DB and also using vacuum for my DB... my CPU load goes up and no one can use my DB... most of the transaction comes from web server.. I just need ur good advice ...

[GENERAL] pqAdmin3

When trying to connect to database via the pgAdmin3 GUI it asks for a password. I use the same passworrd as I did when I connect to the DB via command line but I get Ident error? how do I set, re-set the password so I can use both the commandline and pgAdmin to access edit by DB? Thanks -

Re: [GENERAL] Bug or stupidity

know I made an error in my query. It would just have been easier to find if PostgreSQL actually had told me so (I'm not getting those NOTICEs from PHP...). If it's wrong, it should be disallowed, not made worse by assuming a completely wrong thing. Thanks for your fast response a

[GENERAL] Bug or stupidity

, but I used the full table name. I know this is not really correct, but I'd still like to know why Postgres throws 4 results at me. If I use the correct column in the order by clause, I get the correctly joined result. Looking at my second query, I think the false "order by"

[GENERAL] pgTcl and Refcursors

resultset provided as a refcursor by a function? I am not very familiar with Tcl, and a scan of the PostgreSQL documentation's pgTcl section didn't seem to provide an answer (at least to me). Any help you provide would be appreciated. Thanks, -- Philip A. Chapman Application Develop

[GENERAL] pg_dump error

explode and infect my neighborhood? (Have I used too many question-marks?) Nothing else seem to be broken, just the error messages about pga_images.. Philip, a bit worry about my database... ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Bulk Insert / Update / Delete

be able to achieve such functionality by writing a Function ? Regards Phil - Original Message - From: Jason Godden <[EMAIL PROTECTED]> To: Philip Boonzaaier <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 10:07 AM Subject: Re: [GENERAL] Bu

[GENERAL] Bulk Insert / Update / Delete

I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums must be UPDATED, if not, they must be INSERTED. Logically then, I would like to SELECT * FROM WHERE

Re: [GENERAL] Why does it not use the index?

Well duh. Crap. I remember that NOW that I've read everyones comments (thanks by the way!). I do remember reading that, and have placed the 'vacumedb -z' command in crontabs on databases in the past. Just forgot all about that - I guess it is because most of the databases I've set up on postgres

Re: [GENERAL] Why does it not use the index?

inbox with the following: > On Mon, 21 Jul 2003, Philip Greer wrote: > > > dumps=# \d fal_profdel > >Table "fal_profdel" > > Attribute | Type | Modifier > > ---+--+-- > &g

[GENERAL] Why does it not use the index?

This one is irritating. Here's some psql output: dumps=# \d fal_profdel Table "fal_profdel" Attribute | Type | Modifier ---+--+-- sid

[GENERAL] Does Postgresql 7.1.x Still Have 8K Maximum Field Size?

Hello all. I will be creating one of my first web applications and would like to use Postgresql as the database on a Red Hat 6.2 or 7.1 system with Apache and either ColdFusion or PHP. Anyway, the application will have a text field where employees can update their progress on assigned tasks.

Re: [GENERAL] get certain # of recs

Take a look at the LIMIT part of the SELECT statement. in your case you'd do: select * from tablename limit 21; ALthough you'll want to use an ORDER BY otherwise you could get different results each time.. -philip On Thu, 13 Sep 2001, Mike S. Nowostawsky wrote: > How can one

[GENERAL] Questions about tuning on FreeBSD...

number of backends that can be run given a given amount of RAM? Also, if anyone has a FreeBSD box with 512 ram, what are your kernel settings? Thanks! -philip ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] LARGE db dump/restore for upgrade question

ss painful for very large databases be added to the ToDo list even if it isn't a high priority? Not that I am complaining, postgres seems to handle this data volume quite well, and it is certainly worth very dollar I didn't pay for it. :) Any suggestion on how to prepare for the next upgrade wo

[GENERAL] Re: PASSWORD() function for postgresql?

You could take the password hashing routine out of client/password.c (in the mysql source) and write your own C function... I know just enough C to think that it shouldn't be that hard, but not enough to do it :) -philip On Sun, 15 Jul 2001, Jason DiCioccio wrote: > I am looki

[GENERAL] Re: autoincrement???

Look at the SERIAL type and the CREATE SEQUENCE documentation. -philip On Thu, 12 Jul 2001, Markus Jais wrote: > hi > I have the following problem: > > I create the following table: > > CREATE TABLE address ( > address_id int PRIMARY KEY , >

Re: [GENERAL] vacuum and 24/7 uptime

be unnecessary. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?

'd set everything high and not worry about it. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] HUPing a database

On Fri, Jul 06, 2001 at 06:15:47PM +0200, Peter Eisentraut wrote: : Philip Molter writes: : : > I'm doing logging of PG information, and I'd like to rotate the logs. : > What's the proper way to HUP the server once the logs have been : > rotated? : : There isn't o

Re: [GENERAL] Changing optimizations

n. It would be good to look at EXPLAIN : VERBOSE output not just EXPLAIN output for the two plans, just to rule : that out. My brain hurts when I do that (literally thousands of lines of output). Thanks for the help, Philip * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL

Re: [GENERAL] Determining scan types

now, it's using less efficient joining methods where it would normally use sequential scans (not that I'm complaining too much; CPU performance has more than doubled since taking out sequential scans). * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED]

Re: [GENERAL] Determining scan types

On Tue, Jul 03, 2001 at 10:42:37AM -0400, Sam Tregar wrote: : On Tue, 3 Jul 2001, Philip Molter wrote: : : > What causes this and how can I fix it? : : Have you tried a VACUUM ANALYZE? For some reason Postgres isn't able to : use its indexes fully unless you VACUUM ANALYZE often

[GENERAL] Determining scan types

ve changed, but the just values, not the number of rows nor the indexing of the tables. It's baffling. All tables being joined (10) are being explicitly joined using INNER JOIN or LEFT JOIN in an order that should (at least it was) making optimal use of the indexing. * Philip Molter * DataFou

Re: [GENERAL] Re: Red Hat to support PostgreSQL

o 13%). Anyone know what causes that, and better yet, anyone know how to fix it? We see similar behavior under Solaris. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe

Re: [GENERAL] Re: Red Hat to support PostgreSQL

Linux box, things worked much better. Go figure. I'm sure that many people's attitudes about RH are the same way. Older versions of RedHat just felt really bloated and slow. RH7.1 feels much tighter, but if I had been turned off by older versions, I never would've tried it. *

Re: [GENERAL] Weird error

On Wed, Jun 27, 2001 at 11:30:54AM -0400, Tom Lane wrote: : Philip Molter <[EMAIL PROTECTED]> writes: : > I am using 7.1.2. : : Don't suppose you want to dig in there with a debugger when it happens? : You must be seeing some hard-to-replicate problem in VACUUM's : tuple

[GENERAL] Adding a NOT NULL column?

would do that like: ALTER TABLE ADD c NOT NULL ALTER TABLE ADD CONSTRAINT c NOT NULL each time it fails on the 'NOT'. How do I add that constraint? * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(e

[GENERAL] Re: aggregate function for median calculation

that anyway). -philip On Mon, 18 Jun 2001, Alex Pilosov wrote: > On Mon, 18 Jun 2001, Thalis A. Kalfigopoulos wrote: > > > Hippl, > > I'm interested in calculating the median of a set of numbers. > > The algorithm requires that all values are known in advance (i

[GENERAL] ERROR: Bad interval external representation '0'

Hi Is there a problem with averaging time intervals? I get this error with AVG( inserttime - last) ERROR: Bad interval external representation '0' but SUM( inserttime - last) / COUNT (inserttime) seems to work just fine. Details below, database version is 7.1. thanks, Philip

[GENERAL] Re: dumping strategy

where close to being able to make thsese changes, but it seems like it would be nice to have an option that says "dump all tables except the ones specified". Kind of like grep's -V option... maybe doing the two at the same time would be easier... -philip

Re: [GENERAL] defunct postmasters

Hi Once more, this time with feeling :) Sorry, not a regular user of gdb, but I figured out my error, does this help? Anything else before kill -9? thanks, PHilip # gdb postmaster 29214 GNU gdb 19991004 Copyright 1998 Free Software Foundation, Inc. GDB is free software, covered by the GNU

Re: [GENERAL] defunct postmasters

Hi Not sure if this is helpful, but... Am I doing this correctly, anything else to try before "pulling the plug"? thanks, PHilip # gdb postmaster 29214 GNU gdb 19991004 Copyright 1998 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, a

[GENERAL] Returning tuple(s) from C-Functions

Is this answer still correct? Is there a way to do it with 7.1? Can i write to a temporary table in this function and insert into the backend somehow? I'm not expecting too much people having this done, but if anyone did it, please reply... tia, Philip -- | | Philip Poten|\ \ | |

[GENERAL] Re: bitwise again

o file. The .c file has what I use for compilation (you'll need to tweak that as well). The only gotcha is that you can't remove the NOT operator (it's a bug in 7.0.3) using the DROP OPERATOR statement. -philip On Mon, 2 Apr 2001, Alexander Lohse wrote: > Hi, > > I am havi

RE: [GENERAL] MACADDR types NULL value (undocumented?)

| +--+ -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 16:05 To: Mayers, Philip J Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] MACADDR types NULL value (undocumented?) "Mayers, Philip J" <[EMAIL PROTECTED]> writes: > I

[GENERAL] pgdump, large objects and 7.0->7.1

them at present. 3) Do I need to preserve oid's when with pgdump using large objects? thanks, Philip PS It would be great if something about this could be added to the 7.1 docs. I would guess that others will have this same problem when 7.1 is released. --

RE: [GENERAL] FW: Optimisation of IN condition

+--+ | Phil Mayers, Network Support | | Centre for Computing Services| | Imperial College | +--+ -Original Message- From: Mayers, Philip J [mailto:[EMAIL PROTECTED]] Sent: 08 March 2001 12:18 To: '[EMAIL PROT

RE: [GENERAL] FW: Optimisation of IN condition

ntre for Computing Services| | Imperial College | +--+ -Original Message- From: Mayers, Philip J [mailto:[EMAIL PROTECTED]] Sent: 08 March 2001 11:22 To: '[EMAIL PROTECTED]' Subject: [GENERAL] FW: Optimisation of IN condition I'v

[GENERAL] FW: Optimisation of IN condition

I've got some tables: create table interface ( machineid text, mac macaddr, primary key(mac) ); create table arptable ( router text, interface int2, mac macaddr, ip inet ); They're big, 10k rows in interface, maybe 35k in arptable. I want to do this: hdb=> explain select * from

RE: [GENERAL] Re: Query never returns ...

What does: EXPLAIN SELECT tblSIDEDrugLink.DrugID, tblSIDEDrugLink.MedCondID, tblMedCond.PatientName AS MedCondPatientName, tblMedCond.ProfessionalName AS MedCondProfessionalName, tblSIDEDrugLink.Frequency, tblSIDEDrugLink.SeverityLevel FROM

RE: [GENERAL] Can you help a newbie?

Hmm... very suspicious... However, if you have root on that machine, try this: su - root su - postgres cd /var/lib/pgsql/data vi pg_hba.conf add: local databasename trust Restart postgres, Switch back to your user, then try: psql databasename postgres Bingo, you're in as the DB admin. GRANT

[GENERAL] Why is there so much MySQL bashing???

fathom the possibility that there might be good (or even better) alternatives out there. That can't be good for PostgreSQL, can it? -philip

Re: [HACKERS] RE: [GENERAL] pg_dump return status..

e looks like it does an exit(1) whenever there is an error. Is there a Unix/C/shell interaction that's not working for you? ---- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ -

  1   2   >