[GENERAL] OT: job offer

Hope nobody minds a job offer. We have developed an application for the insurance market that is based on: wxPython for the GUI twisted pb as network layer certainly python :-) reportlab/OpenOffice/pyUno for printing zope/plone as alternative web interface. the database backend is postgresql.

Re: [GENERAL] Nested Query OK in psql but not in PHP

On Sun, Apr 30, 2006 at 03:52:29PM -0700, [EMAIL PROTECTED] wrote: > ... Is there something that changes in the PHP code that builds > the tabular display if a query is a nested query as opposed to it not > being a nested query? PHP has no idea what a nested query is, let alone understanding SQL.

[GENERAL] Authentication & connection problems

Hi! I've got some problems with PostgreSQL v8.1.3 . My system is Windows XP Professional Edition. Here's the deal. For example, when trying to connect to an existing databas, or even creating a new one with the command createdb [dbname], different error occurs. Another example: when running the

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

* Tony Lausin ([EMAIL PROTECTED]) wrote: > Ahh. I see the point more clearly now. Perhaps the best strategy for > me is to press on with Postgres until the project is at a profitable > enough stage to merit a migration to Oracle - should Postgres become > an issue. I feel more confident about being

Re: [GENERAL] Nested Query OK in psql but not in PHP

On Mon, 1 May 2006, Martijn van Oosterhout wrote: On Sun, Apr 30, 2006 at 03:52:29PM -0700, [EMAIL PROTECTED] wrote: ... Is there something that changes in the PHP code that builds the tabular display if a query is a nested query as opposed to it not being a nested query? PHP has no idea what

Re: [GENERAL] Authentication & connection problems

Here's the deal. For example, when trying to connect to an existing databas, or even creating a new one with the command createdb [dbname], different error occurs. What errors exactly? We can't guess.. Another example: when running the command psql, entering the password and hitting enter

[GENERAL] How would I write this query...

Hi - I have two tables, one of them has names of people and an associated integer ID. The other table is a list of the people (from the first table) by their ID number that have signed up for a class. How would I write a query that would list all the people from the first table that do not

Re: [GENERAL] Select / sub select? query... help...

Thanks for the advice.. I got it working! -Jim "Jim Fitzgerald" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello - > > I'm trying to figure out how to write a particular query and need some > assistance. I imagine this is extremely simple. I have the table defined > belo

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

Just to round out the suggestions, if I remember correctly, the OP mentioned something about chat. For entirely dynamic, disposable data, perhaps a reliable database isn't what is called for at all. If the power shuts off, it may not matter that some chat log is lost. I suggest to use the right to

Re: [GENERAL] How would I write this query...

On May 1, 2006, at 3:32 , Jim Fitzgerald wrote: I have two tables, one of them has names of people and an associated integer ID. The other table is a list of the people (from the first table) by their ID number that have signed up for a class. How would I write a query that would list a

Re: [GENERAL] Authentication & connection problems

On 5/1/06, chris smith <[EMAIL PROTECTED]> wrote: > Here's the deal. For example, when trying to connect to an existing > databas, or even > creating a new one with the command createdb [dbname], > different error occurs. What errors exactly? We can't guess.. > Another example: when running

Re: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is

1. If I am correct about this then what is the point of using the ISpell dictionary in the first place? Yes. The main goal of any dictionaries is a 'normalize' lexeme, ie to get a infinitive. It's very important for languages with variable word's form such as french, russian, norwegian etc. So

Re: [GENERAL] How would I write this query...

On sun, 2006-04-30 at 11:32 -0700, Jim Fitzgerald wrote: > I have two tables, one of them has names of people and an associated > integer ID. The other table is a list of the people (from the first table) > by their ID number that have signed up for a class. How would I write a > query that

Re: [GENERAL] How to define + operator for strings

You can't really. There are 27 meanings for a binary '+' operator and it's not always easy to work out whats is going to if the underlying types are not numeric in some sense. So is the best way to create function CONCAT(s1, s2, ... s10) which returns concatenation in its arguments in both DBMS.

Re: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is the point?

Are you saying that the English ISpell dictionary isn't particularly useful for English text if you're using the English stemmer? One of the concerns that I had about the use of ISpell on English text was that ISpell could provide two or more alternatives for a single search term that would increas

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

Thanks for the suggestions, everyone. This is what I have so far: I require an open source DBMS because I want to avoid being locked into a particular vendor, especially one that will send me a big bill. That leaves me with MySQL, PostgreSQL (my preference), Firebird, and possibly Berkeley DB (if

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

On Sun, 2006-04-30 at 14:32, Tony Lausin wrote: > > [ rotfl... ] MySQL will fall over under any heavy concurrent-write > > scenario. It's conceivable that PG won't do what you need either, > > but if not I'm afraid you're going to be forced into Oracle or one > > of the other serious-money DBs. >

Re: [GENERAL] How would I write this query...

Jim Fitzgerald wrote: > Hi - > > I have two tables, one of them has names of people and an associated > integer ID. The other table is a list of the people (from the first > table) by their ID number that have signed up for a class. How would > I write a query that would list all the people fr

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

On Sun, 2006-04-30 at 14:32, Tony Lausin wrote: [ rotfl... ] MySQL will fall over under any heavy concurrent-write scenario. It's conceivable that PG won't do what you need either, but if not I'm afraid you're going to be forced into Oracle or one of the other serious-money DBs.

[GENERAL] Leading substrings - alternatives with 8.1.3?

Back in the 7.4 era, to make leading substrings be indexed, I had to set locale=C. See thread: I couldn't find any updates to this issue in the archives since then. With 8.1.3, the default locale for my system is en_US.UTF8.

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

On Mon, 2006-05-01 at 12:08, Philip Hallstrom wrote: > > On Sun, 2006-04-30 at 14:32, Tony Lausin wrote: > >>> [ rotfl... ] MySQL will fall over under any heavy concurrent-write > >>> scenario. It's conceivable that PG won't do what you need either, > >>> but if not I'm afraid you're going to be

Re: [GENERAL] Leading substrings - alternatives with 8.1.3?

On Mon, May 01, 2006 at 12:16:46PM -0500, Wes wrote: > Back in the 7.4 era, to make leading substrings be indexed, I had to set > locale=C. See thread: > > > > I couldn't find any updates to this issue in the archives since th

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?

On Mon, 2006-05-01 at 13:37, Philip Hallstrom wrote: > > >> I would also read this about mysql's table locking: > >> > >> http://dev.mysql.com/doc/refman/4.1/en/table-locking.html > >> > >> Specifically, regarding myisam tables: > >> > >> "Table locking enables many threads to read from a table a

Re: [GENERAL] Leading substrings - alternatives with 8.1.3?

On 5/1/06 12:47 PM, "Martijn van Oosterhout" wrote: > Check the documentation, but if you declare a index with (for example) > text_pettern_ops, then LIKE will work even if the rest of your DB is > UTF-8. My understanding of using operator classes is that I'd have to create two indexes for each

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

And from reading that page, one can see that InnoDB tables are still considered to be kind of the "red headed step child" of table handlers by the mysql crew. Sad, because it's the only table handler they have than can truly handle any real concurrency of reads and writes mixed together (it's a t

Re: [GENERAL] Leading substrings - alternatives with 8.1.3?

On Mon, May 01, 2006 at 01:45:35PM -0500, Wes wrote: > On 5/1/06 12:47 PM, "Martijn van Oosterhout" wrote: > > > Check the documentation, but if you declare a index with (for example) > > text_pettern_ops, then LIKE will work even if the rest of your DB is > > UTF-8. > > My understanding of usin

Re: [GENERAL] How would I write this query...

select * from people where id not in ( select id from class_registration ) In my experience, queries like the OUTER LEFT JOIN version posted earlier are usually much more efficient than NOT IN queries like the above. The planner seems to be pretty smart about turning (positive) IN queries in

Re: [GENERAL] selecting column comment

FWIW: From the system catalogs: SELECT PC.relname, PD.description FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC WHERE PD.objoid = PC.oid AND PD.objsubid = 0 "Ari Kahn" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I have a comments on tables in my database. > > e.g.

Re: [GENERAL] How would I write this query...

John D. Burger wrote: >> select * >> from people >> where id not in >> ( >> select id >> from class_registration >> ) > > In my experience, queries like the OUTER LEFT JOIN version posted > earlier are usually much more efficient than NOT IN queries like the > above. The planner seems to be prett

[GENERAL] insert into a view?

Tried it but didn't work. It gave me a hint though to try triggers. Can anyone show me how to do an insert into a view using triggers? Thanks. :-) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgr

Re: [GENERAL] insert into a view?

On Mon, May 01, 2006 at 05:23:22PM -0700, Karen Hill wrote: > Tried it but didn't work. It gave me a hint though to try triggers. > Can anyone show me how to do an insert into a view using triggers? Rules are probably what you're after; the documentation has examples. http://www.postgresql.org/d

Re: [GENERAL] insert into a view?

"Karen Hill" <[EMAIL PROTECTED]> writes: > Tried it but didn't work. It gave me a hint though to try triggers. > Can anyone show me how to do an insert into a view using triggers? I hope it said rules, because you can't put a trigger on a view. regression=# create table t(f1 int, f2 text); CREAT

[GENERAL] How to join to delete

I'm using pg 7.4.5 on Win XP SP1. I want to delete rows from a table B, but need to join it to another table A in order to select the rows in B to be deleted. Eg. Delete from A join B on (A.bk = B.bk) where A.ak = x; but only delete rows from B. How do I acheive this? Chris -- Chris Velevitc

[GENERAL] Return value (instead of reference) for user defined type

Hi, I've successfully built several user types. But, I'm having problems with the one I am working on currently. The server SIGSEGV's at the end of the _in routine. Nearest I can tell, the problem is related to my attempt to return an int "by value" (all of my other types return references but