Re: [GENERAL] Rules WHERE condition

2004-11-17 Thread Robert Fitzpatrick
On Wed, 2004-11-17 at 12:49, Robert Fitzpatrick wrote: > On Wed, 2004-11-17 at 11:49, Michael Fuhr wrote: > > On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote: > > > > > I have a view that used union all to merge three tables together. I was > >

Re: [GENERAL] Certifications in military environment

2004-11-18 Thread Robert Treat
might want to contact is http://www.devis.com who has done a number of different projects with the government. Hope this helps, and if you do get a definitive answer, please post your finding to the -advocacy group. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL -

[GENERAL] Posting COPY data with shared sequences

2004-11-19 Thread Robert Fitzpatrick
data into separate incoming COPY commands? Anyone have suggestions on how I would best achieve what I'm looking to do. Thanks, -- Robert ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (s

[GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Robert Soeding
ï Hi, this is my first question here, and also, it's somewhat delicate. So please be patient.   My question is, CAN PostGreSQL perform in the SQL Server area when it comes to speed? In other words, are there explanations for the results I found (see below)?   Thanks, R

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Robert Soeding
mailto:[EMAIL PROTECTED] Sent: Thursday, November 25, 2004 12:34 PM To: Robert Soeding Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server Robert Soeding wrote: > Hi, this is my first question here, and also, it's somewhat delicate. > So please be

Re: [GENERAL] RSS date still broken

2004-11-29 Thread Robert Treat
he feeds with the problem to [EMAIL PROTECTED] ? -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Dropping sequences

2004-11-30 Thread Robert Fitzpatrick
could be using the old sequence still even though it seems all is coming from the new sequence. -- Robert ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-04 Thread Robert McClenon
On 3 Dec 2004 20:34:36 GMT, Woodchuck Bill <[EMAIL PROTECTED]> wrote: >David Harmon <[EMAIL PROTECTED]> wrote in >news:[EMAIL PROTECTED]: > >> On Fri, 3 Dec 2004 00:29:40 + (UTC) in news.groups, Marc G. >> Fournier From: <[EMAIL PROTECTED]> wrote, >>>The pgsql.* hierarchy is a not a private

Re: [GENERAL] pgFoundary?

2004-12-06 Thread Robert Treat
Probably just an oversight, but will be linked when we roll the new website layout with 8.0 (crosses fingers) Robert Treat On Fri, 2004-12-03 at 02:07, Jim C. Nasby wrote: > Then I guess my next question is: why isn't it linked to from > http://postgresql.org ? > > On Fri, Dec

Re: [GENERAL] Best practice in postgres

2004-12-13 Thread Robert Treat
mbersome than querying across schemas. If you are not doing any cross schema work, then it probably doesn't matter as much. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: Have

[GENERAL] Problem with pl/perl in postgresql 8.0rc1

2004-12-17 Thread Robert Boone
me results. If anyone could tell me what I'm doing wrong that would be great. Thanks, Robert Boone ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] disabling OIDs?

2005-01-06 Thread Robert Treat
irst, then a unique index, then look for an oid. Furthermore the really clueful ones will check # of affected rows = 1 when modifying by oid, so its pretty safe. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] question about "delete performance"

2005-01-23 Thread Robert Creager
When grilled further on (Mon, 24 Jan 2005 12:29:12 +0800), Öܵ½¾© <[EMAIL PROTECTED]> confessed: > I have a table with 500,000 records which has some invalid records, I had > wrote a program to check it, by the program I get all OIDs of the redundant > records, so I use "delete from tableXXX wher

Re: [GENERAL] [pgsql-advocacy] OLS BOF for linux & postgresql

2005-01-28 Thread Robert Bernier
On January 28, 2005 05:06 pm, Mark Wong wrote: > I wanted to bounce the idea of a BOF at the Linux Symposium in > Ottawa and see if anyone would like to attend. The deadline to > proposal is Feb 1st, sort of short notice... I thought the dicussion > could revolved around these two topics: > > Lin

Re: [GENERAL] Pg database, need a solution to a problem

2005-01-30 Thread Robert Treat
un replication for just the tables you need. > Check out www.slony.info or www.commandprompt.com > Since you may not want to have real time replication going (don't push up new test cases until they make it out of test), I wonder if something like Robert Kaye's lazy replication system he us

Re: [GENERAL] Is there a peer-to-peer server solution with PG?

2005-02-07 Thread Robert Treat
be able to help get you to a little closer to what your looking for. If you have time please check it out and see if it can be of any help, I'm sure many of us would be interested in hearing some feedback on it. http://www.daffodildb.com/dbreplicator.html Robert Treat -- Build A Brighter La

[GENERAL] What talk would get you to go to OSCon?

2005-02-08 Thread Robert Treat
an uptick in postgresql attendees. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Schema comparison tool

2005-02-18 Thread Robert Treat
ck to this. Robert Treat On Tuesday 15 February 2005 16:31, Bradley D. Snobar wrote: > The database comparer tool is one of EMS better products. > > http://www.sqlmanager.net/ > http://www.sqlmanager.net/products/postgresql/dbcomparer > > Jeff Amiel <[EMAIL PROTECTED]> wrote

Re: [GENERAL] Why pgAdmin III guru suggests VACUUM in 8.1

2005-11-30 Thread Robert Treat
py it over before start up) so you should have a chance, but it is complicated to do in an uncontrolled environment, which is why it doesn't work that way as of yet. BTW, if you have a good idea of the size of your data set, you might be able to hardcode things. Ie. a desktop app is prob

Re: [GENERAL] Error on PostgreSQL mailing list web pages?

2005-12-07 Thread Robert Treat
ROTECTED] > > Also on a couple of the others I have looked at... Is this right? > I forwarded this on to [EMAIL PROTECTED] and Marc is on it, though it will take some time for the pages to regenerate. Thanks for the report though. -- Robert Treat Build A Brighter Lamp :: Linu

Re: [GENERAL] Performance large tables.

2005-12-10 Thread Robert Treat
Example command "UPDATE data where name=x and date=y;". > > Try using VACUUM or VACUUM FULL after those weekly updates... Once you've updated a majority of the rows in a large tables, if your still doing further work on that table that involves complex conditionals, you'l

[GENERAL] newbie : setting access for users in a web enviroment

2005-12-23 Thread robert mena
Hi, I am new to postgres but coming from a MySQL enviroment. I am confused with the necessary steps to create users and restrict them to access/delete/insert/update data and create/delete/alter tables in a specific database. I've created a database test and a user testadm createdb test create

Re: [GENERAL] newbie : setting access for users in a web enviroment

2005-12-24 Thread robert mena
AIL PROTECTED]> wrote: > Am Freitag, 23. Dezember 2005 22:06 schrieb robert mena: > > GRANT CREATE,REFERENCES ON DATABASE test TO testadm; > > > > \z > > Access privileges for database "test" > > Schema | Name | Type | Access privileges > > +---

[GENERAL] Postgresql web interface tools site

2005-12-28 Thread david robert
Hi Guys,    Finally here is the one place most web interface tools available for postgresql database   http://www.debianhelp.co.uk/postgresqlweb.htm   hopefully you will enjoy this Play Santa's Celebrity Xmas Party, an exclusive game from Yahoo!

Re: [GENERAL] Forum Software

2005-12-30 Thread Robert Treat
ould be a wonderful product. (From this thread it just sounds like they need a little more structure in the project) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Unique transaction ID

2006-01-04 Thread Robert Osowiecki
Apart from now() function, is there some kind of sequence that advances with each transaction started? If not: is it possible to implement that using sequences? Robson. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please se

Re: [GENERAL] Unique transaction ID

2006-01-04 Thread Robert Osowiecki
Jaime Casanova napisał(a): it exists a transaction id called XID, you can't get it via sql though, you need to make a c function and invoke GetTopTransactionId() (or GetCurrentTransactionId() in versions prior to 8.0) I've read a little about problems with overlapping XID and how they were

Re: [GENERAL] Reordering columns in a table

2006-01-07 Thread Robert Treat
provides anything like that. Robert Treat On Friday 06 January 2006 22:34, Ian Harding wrote: > As I recall, the MS SQL Server draggy droppy diagrammer tool made it > seem trivial to rearrange columns did the same thing. It just > generated SQL statements to: > > Begin trans

Re: [GENERAL] 'Official' definition of ACID compliance?

2006-01-07 Thread Robert Treat
ly ACID-incompliant anymore than how they handle timestamp fields. That said see nearby posts about row level constraints and transactions involving mixed table types that can't actually be rolled back if you want to find ways that mysql breaks acid compliance. -- Robert Treat Build A Br

[GENERAL] function overloading

2006-01-09 Thread Robert Greimel
other way to avoid this madness of writing 625 functions ? Thanks Robert ---(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 do not match

Re: [GENERAL] function overloading

2006-01-10 Thread Robert Greimel
On Mon, 2006-01-09 at 20:28, Tom Lane wrote: > Robert Greimel <[EMAIL PROTECTED]> writes: > > I have a question regarding function overloading: > > > assume that you have a function that takes several numeric arguments - > > lets for example say 4 arguments: f(a,b,

[GENERAL] sort character data in arbitrary order?

2006-01-14 Thread Robert Paulsen
Hi, I need to query a database for a record with the "best" value in a one-character field. The field is named "state" and I need a record with a state of 'a', 'b', or 'c'. There may be more than one matching record but I want the "best" one where "best" is defined as state 'a', or if there are

Re: [GENERAL] sort character data in arbitrary order?

2006-01-14 Thread Robert Paulsen
On Saturday 14 January 2006 14:10, Michael Fuhr wrote: > On Sat, Jan 14, 2006 at 01:38:52PM -0600, Robert Paulsen wrote: > > SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]' > > ORDER BY state ASC LIMIT 1. > > > > This works as expected. M

Fwd: Re: [GENERAL] sort character data in arbitrary order?

2006-01-14 Thread Robert Paulsen
On Saturday 14 January 2006 14:06, Andrew - Supernews wrote: > On 2006-01-14, Robert Paulsen <[EMAIL PROTECTED]> wrote: > > Here is my query so far: > > > > SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]' > > ORDER BY state ASC

[GENERAL] Missing database entry in pg_database

2006-01-25 Thread Robert Korteweg
u can't reach second base, and keep your foot on first." Groeten, Robert ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Missing database entry in pg_database

2006-01-26 Thread Robert Korteweg
Robert Korteweg writes: I have a problem with a database i'm maintaining. I first noticed the problem because i could not make a backup of the database i got the following error: pg_dump: missing pg_database entry for database "xxx" I verified this by selecting the pg_d

Re: [GENERAL] Missing database entry in pg_database

2006-01-27 Thread Robert Korteweg
Robert Korteweg wrote: Robert Korteweg writes: I have a problem with a database i'm maintaining. I first noticed the problem because i could not make a backup of the database i got the following error: pg_dump: missing pg_database entry for database "xxx" I verified th

[GENERAL] eqpg doesn't like bit fields

2006-02-02 Thread Noble, Robert
I get the following error from ecpg when it encounters a structure containing a bit field: ../../include/ecn_types.h:317: ERROR: syntax error at or near ":" The source it is complaining about is: 176 typedef enum{ 177 tifIOC = 0, 178 tifDay = 1, 179 tifGTX = 2,

Re: [GENERAL] Compile of Pgmail function fails

2006-02-07 Thread Robert Treat
pos := pgmail(p1,p2,p3,p4); > > > Can anyone help me? I'm using postgres 7.4.7 version. Try to run pgmail by itself with those values and see what error that gives you. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---

Re: [GENERAL] Why does an ON SELECT rule have to be named "_RETURN"?

2006-02-16 Thread Robert Treat
of cases. Last time we discussed this for phppgadmin, the general opinion was it wasn't worth trying to work around postgresql core's deficiency. Once the core postgresql server supports updatable views in proper, I'd imagine this would get done. --

Re: [GENERAL] Why does an ON SELECT rule have to be named "_RETURN"?

2006-02-16 Thread Robert Treat
On Thu, 2006-02-16 at 10:41, Tom Lane wrote: > Martijn van Oosterhout writes: > > On Thu, Feb 16, 2006 at 07:28:20AM -0500, Robert Treat wrote: > >> One problem is the only way for a client tool to work generically in prov= > > ding > >> data entry forms would be

Re: NULLs in unique indexes; Was: [GENERAL] Oracle purchases

2006-02-16 Thread Robert Treat
n. ISTM this is asking for a lot of knowledge of mysql internals for the average front end developer. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] return setof and Temp tables

2006-02-17 Thread Robert Treat
structure matched that of the temp table, or use out parameters to mimic it. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

2006-02-22 Thread Robert Treat
on't run any proxy so the error cannot be my end and this > problem has been there for at least two days. > It's a known issue with the guides section. I had been waiting on some activity elsewhere wrt a techdocs replacement, but have about given up on that so am working on a plan b

Re: [GENERAL] User groups

2006-02-25 Thread Robert Treat
ake a site on meetup like the php folks did, or maybe make a site at the pg user group site. http://pugs.postgresql.org/ -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3:

Re: [GENERAL] Postgre capability

2006-02-26 Thread Robert Treat
on top of a postgre data base. > > The database is called PostgreSQL or Postgres, not Postgre. > > Search for ERP and Postgres on http://sourceforge.net and you'll get > some hits back. I don't know of anyone running a commercial ERP system > on PostgreSQL, but that doesn&#x

Re: [GENERAL] a web framework for postgresql?

2006-03-01 Thread Robert Treat
might be able to get something together. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL scalability concerns

2006-03-16 Thread Robert Treat
ou'll probably want something that can do connection pooling. You can get more help on the -performance list too, just make sure you provide specifics. You might also want to look into getting commercial support, though choice questions to the mailing list might be enough to steer you on t

Re: [GENERAL] will slony work for this ?

2006-03-16 Thread Robert Treat
portance of this being that there will be no way for it to just "get all the changes"; you'll have to rebuild it. My understanding is the same is true for replicator, but perhaps you can elaborate on that? -- Robert Treat Build A Brighter Lamp :: Linux Ap

Re: [DOCS] [GENERAL] COPY command documentation

2006-03-23 Thread Robert Treat
icable. That really is a factor, most of the comments would need to be reworded to be added into the docs proper. In the past these ideas were rejected as either off-topic or that it would turn this list into a high traffic list... if peoples opinions have changed, it could be arranged. -- Rob

Re: [DOCS] [GENERAL] COPY command documentation

2006-03-23 Thread Robert Treat
On Thursday 23 March 2006 17:46, David Fetter wrote: > On Thu, Mar 23, 2006 at 04:46:02PM -0500, Robert Treat wrote: > > > ...and it's unlikely that they will, now or later, without > > > somebody whose whole job is to monitor those comments and make > > > pat

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

2006-03-26 Thread Robert Treat
er or possibly joomla? I think the Mambo developers may be anti-postgresql, but Joomla should have decent postgresql support, with the main person behind that being Mitch Pirtle of JamboWorks. You might want to track him down. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middlewar

Re: [GENERAL] best practice in upgrading db structure

2006-03-28 Thread Robert Treat
TABLE because it's a lot cleaner/easier. For larger tables, > you might want to CREATE TABLE AS SELECT ..., or maybe copy out and copy > back in. This seems backwards to me. On larger tables I tend to favor alter table for adding/dropping columns since the table doesn'

Re: [GENERAL] How to use result column names in having cause

2006-03-31 Thread Robert Treat
y this. > Yes, this behavior is driven by the sql standards. There is actually a very nice paper on this subject if you are interested http://web.onetel.com/~hughdarwen/TheThirdManifesto/Importance-of-Column-Names.pdf -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [Slightly OT] data model books/resources?

2006-03-31 Thread Robert Treat
gement" (ISBN: 0201485559) > Feel free to reply off list to keep the clutter down - I'd be happy to > summarize responses for the list. > We're all about clutter :-) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL makes me lie

2006-04-01 Thread Robert Treat
on support is in the plans for future > versions of PostgreSQL? > Improved collation support is being worked on but it's a complex problem so there's no realt ETA. (Developers interested in helping out our encouraged to send a note to -hackers). In the mean time check out the citext proj

Re: [GENERAL] giving users access to specific databases

2006-04-01 Thread Robert Treat
my files on the > > server, access to create new postgres databases and a link to phpPgAdmin. > > Do you get the option to create a new database user? You could create > a new user and give that user access to your database. > Yeah, we're just window dressing atop the

Re: [GENERAL] Creating serial ID on Windows.

2006-04-03 Thread Robert Treat
nce between your platforms. In the above scenario you will likely have differences in dependency information when declaring a default nextval call on a sequence compared to declaring a true sequence type. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL --

Re: [GENERAL] how to create script of database in postgres..sql(winxp)

2006-04-03 Thread Robert Treat
d to use the pg_dump program, which is a seperate program from psql. IIRC it is in your start menu, but if not you will need to access it from a command line window. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end

Re: [GENERAL] MediaWiki and Postgresql?

2006-04-07 Thread Robert Treat
x27;s called pgpedia. > > If I am confusing wiki's, I'm wondering if they'd be willing to > accept patches to improve PostgreSQL support... You are not. I dubbed the new code wikipgedia, it lives on the foundry, the home page is at http://wikipedia.projects.postgres

Re: [GENERAL] Google Summer of Code (Fix aggregate operators & Implement features such as Data Cubes and Skyline)

2006-04-17 Thread Robert Treat
ntor to help push the project along. Robert Treat > > -Original Message- > > From: Tom Lane [mailto:[EMAIL PROTECTED] > > Sent: Saturday, April 15, 2006 7:14 PM > > To: Benjamin Arai > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] Googl

Re: [GENERAL] Database Selection

2006-04-26 Thread Robert Treat
one system on linux, apache, mod_foo and the other on bsd, lighty, and mod_bar ? Best to through your support behind one complete system (sounds like postgresql from previous postings) that can do the job and become an expert in making that system secure. -- Robert Treat Build A Brighter Lam

Re: [GENERAL] Alternative for vacuuming queue-like tables

2006-04-28 Thread Robert Treat
al table. > > I guess what I'm asking for is a kind of "REBUILD TABLE" which is not > MVCC by definition but it would be useful in the mentioned queue table > case. > vaccum full ? -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Autovacuum Logging

2006-04-28 Thread Robert Treat
The best solution I have seen so far is the idea of a GUC to control autovacuums chatter level. I hope we get that becuase the above will be a regression imho. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: RES: [GENERAL] Add column and specify the column position in

2006-05-19 Thread Robert Treat
t mysql uses to implement it (for the table types that will actually do it, some just ignore your request silently!) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/readin

Re: [GENERAL] Contributing code

2006-05-19 Thread Robert Treat
also open up the amount of people who can also take said code and run it in thier "real-world" instances and find issues or make improvements to it. I recomend posting the code in it's current form and letting others take a look. It can always be updated later if you find that

Re: [GENERAL] reindexdb program error under PG 8.1.3

2006-05-25 Thread Robert Treat
rather scrambled, and > that reindexing often sorts the values and rewrites that data so that > the indexes take less space and work faster. Is that not the case here? > It really isn't neccessary. That said, there is *something* going on with your db, so it might be prudent t

Re: [GENERAL] Case for postgreSQL

2006-06-04 Thread Robert Treat
On Sunday 04 June 2006 12:55, P.M wrote: > Hi, > > I would like to know if it exists a good case tool for creating DB into > PostgreSQL ? thanks a lot, > There are several listed at http://www.postgresql.org/docs/techdocs.54 -- Robert Treat Build A Brighter Lamp :: Linux Apa

Re: [GENERAL] Data about rate of downloads

2006-06-06 Thread Robert Treat
made available > freely. > I doubt they could for open source projects, unless those projects had very tight control over thier distribution (which is kind of self defeating). Smaller projects on places like pgfoundry might be able to track this (slony comes to mind), but for us it seem

Re: [GENERAL] [pgsql-advocacy] Me And My Database

2006-06-06 Thread Robert Treat
ratch every time I do an > update. If you going through this kind of step now, why not just generate the whole site from the pg database as html pages and then push those out to the client? That way you eliminate any dbms overhead and reduce load on your webservers (and eliminate the need for a 2nd db schema) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

2006-06-09 Thread Robert Treat
o let me know when somebody uses it. :) > So "as an empiricist", you have derived that programming in PHP, hitting a mysql backend, atop a Windows OS, is far better than that wonky perl/postgresql/linux stuff you normally work with, right? -- Robert Treat Build A Brighter Lamp ::

Re: [GENERAL] phppgadmin 4.0.1

2006-06-17 Thread Robert Treat
and // understand how to change PostgreSQL's pg_hba.conf to enable // passworded local connections. $conf['extra_login_security'] = false; -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)

Re: [GENERAL] pg_dump design problem (bug??)

2006-06-27 Thread Robert Treat
gt; The real question is whether the pg developers would > object to such a feature, whatever the design is, > or whether it's just that nobody's > gotten around to writing it. > Probably more of no one getting around to it, but you need to come up with a solution that does

Re: [GENERAL] phppgadmin

2006-06-29 Thread Robert Treat
session support setup in your php. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(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 do not match

Re: [GENERAL] php can't connect to postgresql server

2006-07-03 Thread Robert Treat
at your postgresql.conf "listen_addresses" is properly set, also make sure you dont have a firewall setting that is blocking connections, the default firewall settings on FC boxes are notorious for blocking pg. -- Robert Treat Build A Brighter LAMP :: Beginning PHP and PostgreSQL 8 (ISBN 1590595475) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-07-03 Thread Robert Treat
ght flags, the output is pretty good. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Error code 1063

2006-07-11 Thread Robert Fitzpatrick
quot; -D "C:\Program Files\PostgreSQL\8.1\data\" pg_ctl: could not start service "psql-8.1": error code 1063 I tried googling that error code, but come up with nothing. Can someone tell us what this code means? -- Robert ---(end of broadcast)--

[GENERAL] Error code 1063

2006-07-11 Thread Robert Fitzpatrick
t 2006-06-12 08:51:18 LOG: shutting down 2006-06-12 08:51:19 LOG: database system is shut down 2006-06-12 08:51:19 LOG: logger shutting down I guess it has been down sine then, but the users have not used the database. -- Robert ---(end of broadcast)--

Re: [GENERAL] PostgreSQL on Embeded Systems

2006-07-18 Thread Robert Treat
gt; temporarily need up to an extra 90 MB. Use the df command to check for disk > space. > > This includes space required for compiling the application. Looks like > about 40 MB for the installation and an empty cluster. Well, certainly you aren't going to want to be compiling from

Re: [GENERAL] databases hidden in phppgadmin

2006-07-18 Thread Robert Treat
7;t be > found. You know Tom, if you're interested in hacking on phpPgAdmin, I'd be happy to send you a copy of "Beginning PHP & PostgreSQL 8 " :-) Darren, this is fixed in ppa's CVS HEAD. If you want a specific patch, drop me a note off list, though I am thi

Re: [GENERAL] Consulta

2006-08-06 Thread Robert Treat
I would think .cu == spanish? en la programa "psql" uso \dt también, hay una lista española: [EMAIL PROTECTED] Robert Treat On Sunday 06 August 2006 05:33, Marco Bizzarri wrote: > Sorry, I will try to answer in english and in italian, if you're able > to understand

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

2006-08-30 Thread Robert Treat
tting a team of developers on top of the contest so they come out shining. Too bad people in this community don't see the value of paying people to do advocacy related development. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(

Re: [GENERAL] Dblink and connections to MySQL?

2006-08-30 Thread Robert Treat
ish this as well, plphp for instance. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

Re: [GENERAL] plz unsubscribe me

2006-08-30 Thread Robert Treat
I'd like to see done is to get majordomo to bounce list > > messages containing "unsubscribe" in the subject, with an explanatory > > message about the right way to unsubscribe. There's no reason the rest > > of us should be bothered. > > I would agre

Re: [GENERAL] Postgresql mentioned on Newsforge MySQL article

2006-08-30 Thread Robert Treat
On Wednesday 30 August 2006 16:48, Joshua D. Drake wrote: > Martijn van Oosterhout wrote: > > On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote: > >> Seems they are fast where it counts... namely getting a team of > >> developers on top of the contest so they

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on NetBSD

2006-09-01 Thread Robert Treat
only reservation I see on that is a bias toward more eloquent writers > having disproprotionate influence. But I don't see any way to avoid that. > I think some members of this community confuse volunteerism with meritocracy. -- Robert Treat Build A Brighter LAMP ::

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-15 Thread Robert Treat
slides from his recent talk showing why he came up with the statements he made (http://talks.php.net/show/oscon06/1). Please post the info when you get comparable performance running from PostgreSQL... -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Any commercial shopping cart packages using

2003-12-16 Thread Robert Treat
> "Its" is a possessive pronoun. "It's" is a contraction for "it is". > > > 'tis not as simple as that my friend, 'tis really more a matter of dialect. http://www.word-detective.com/back-d.html#its Robert Treat -- Build A

Re: [GENERAL] Php help

2003-12-16 Thread Robert Treat
ERE partno ilike '5R%'; Robert Treat On Thu, 2003-12-11 at 01:39, Eric Holmstrom wrote: > Hi there, > > Ive been reading but not getting far, so thought i would ask here. IN > SQL im trying to do this. > > What its meant to do is look in Column partno. Then check if

Re: [GENERAL] Groff and Weinberg SQL Complete Reference - Sample

2003-12-22 Thread Robert Treat
Paul, once you get through the book perhaps you could submit a book review to the techdocs website, along with a pg_dump of the sample database. Robert Treat On Mon, 2003-12-22 at 05:50, Richard Huxton wrote: > On Monday 22 December 2003 07:47, Paul Ganainm wrote: > > Not really a P

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-24 Thread Robert Treat
ror_id, max(status_id) FROM current ce GROUP BY findsite(entity_id) ) AS errors ON (error_id = search_id) WHERE search_id = s.site_id AND s.region_id = r.region_id AND search_id = e.entity_id AND a.host_id = h.host_id AND h.site_id = s.site_id ) ) AS ss ORDER BY UPPER(ss.name) AS

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Robert Treat
ry Douglas's book titled "PostgreSQL" from the same publisher must be somewhat similar. http://www.amazon.com/exec/obidos/ASIN/0735712573/qid=1072831905/sr=2-1/ref=sr_2_1/002-2846574-6863256 Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [GENERAL] Where can I find the "Contrib" page on the PostgreSQL site?

2003-12-30 Thread Robert Treat
It comes with the distribution (assuming by distribution you mean the main tarball, some "distributions" package it seperatly i think). You can view the contents on the web via webcvs: http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/ Robert Treat On Tuesday 30 Dec

Re: [GENERAL] what we need to use postgresql in the enterprise

2004-01-11 Thread Robert Treat
enses and think about spending that money to hire someone to develop those features in PostgreSQL, I'm thinking you'd save money in the long run. Robert Treat On Friday 09 January 2004 14:48, [EMAIL PROTECTED] wrote: > I write this to tell you why we won't use postgresql ev

Re: [GENERAL] how to catch the error in procedure ?

2004-01-16 Thread Robert Treat
the moment). An error terminates a transaction immediately in > PG's current model. > Didn't someone say this could be implemented in some of the other pl's... plpython maybe? Or maybe they were using dblink to make a separate connection/query... ? Robert Treat -- Build A

Re: [GENERAL] Dazed and Confused

2004-02-16 Thread Robert Creager
When grilled further on (Mon, 16 Feb 2004 07:39:25 -0500), Terry Lee Tucker <[EMAIL PROTECTED]> confessed: > as in, \i cust/cust_preupd_func.plsql, I get an error. The error is: > psql:logs/logs_preupd_func.plsql:132: ERROR: ProcedureCreate: cannot change > return type of existing function. >

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Robert Treat
techdocs.postgresql.org/hosting.php) but barring that I think your going to have to turn to the mysql community for information about their database. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)---

Re: [GENERAL] GPG MD5 Checksum for postgres 7.4

2004-02-18 Thread Robert Treat
i On Mon, 2004-02-16 at 14:26, Simone Crider wrote: > Could you please tell me where I would find the GPG MD5 Checksum values > for the postgres 7.4? > http://www.gtsm.com/postgres_sigs.html Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} P

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Robert Treat
tion, "troll" ??? > http://info.astrian.net/jargon/terms/t/troll.html :-) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Where are these tables??

2004-03-26 Thread Robert Treat
m full on your cluster to see if their filesizes change at all... but if you've got that cowboy feeling going i'd say shutdown the database, backup the directory, delete the files, and fire it back up... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

<    4   5   6   7   8   9   10   11   12   >