[GENERAL] How to become a Windows beta-tester?

Hi all, I would be interested in playing around with the beta version for the Windows native port - where can I get it? TIA. Paul... -- plinehan y_a_h_o_o and d_o_t com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. XML avoids the fundamental question

Re: [GENERAL] serverless postgresql

[EMAIL PROTECTED] says... That makes sense to me. I wonder if sqlite suffers for this problem (e.g. app crashing and corrupting the database). Likely. I can tell you that Ann Harrison once told me she made a decent amount of money as a consultant fixing broken Interbase/Firebird

Re: [GENERAL] Is my MySQL Gaining ?

[EMAIL PROTECTED] says... err... i think you misunderstood... I'm was looking for a link to show the mozilla folks saying they would stop using the firebird name. I've never heard such a thing, while I have heard the opposite, and the info you site above only seems to verify that mozilla

[GENERAL] Groff and Weinberg SQL Complete Reference - Sample database?

Not really a PostgreSQL question, but maybe somebody here knows the answer! I recently purchased Groff and Weinberg's The Complete Reference SQL, and a fine meaty tome it is too! However, I find to my absolute *_horror_* that there doesn't appear to be an electronic version of the sample

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

[EMAIL PROTECTED] says... Paul Ganainm schrieb: FB does not support inline views/derived tables, e.g.: SELECT count(*) FROM (SELECT col1, col2 FROM table) If you have IB/FB, there is a sample db that comes with it, Employee. There is a view in that db called phone_list. I did select

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

[EMAIL PROTECTED] says... SELECT count(*) FROM (SELECT col1, col2 FROM table) I did select count(*) from phone_list and it worked. Sure you can do a select from a view, but try the above statement where the view definition is embedded diretly into the SELECT. This is not supported

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

[EMAIL PROTECTED] says... What then is a derived table, or is a derived table just a synonym for inline view? I'm not sure what the official name for this is. I have heard both. So from my point of view a derived table and an inline view are the same. OK - I'm fine with the idea

Re: [GENERAL] BLOBS : how to remove them totally

[EMAIL PROTECTED] says... That's a good discussion, but it left out at least one useful bit of info about managing large objects: there's a contrib utility (contrib/vacuumlo) that can find and remove large objects that are not referenced anywhere in the database. What is the URL for the

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

[EMAIL PROTECTED] says... Ditto for FB. If you want to extend the code, though, you have to give those changes back to the community - the licence is more GPL than BSD. maybe you need to clarify what you think of when you say extensible. postgresql has sql extensions like create

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

[EMAIL PROTECTED] says... A partial index is a index on a subset of a table. The case I can think of is a list of transactions, some of which are yet to be billed. They have a BillID field which is NULL. since this is the recent set it is queried quite often, so you can build an index like:

Re: [GENERAL] add column sillyness

[EMAIL PROTECTED] says... tested, solid, native replication both syncronous and asyncronous (at least they list this as a feature, I assume it works as advertised) As an Interbase/Firebird user, I'm confused by this. There is a replication solution, but AFAIK, it's commercial - not Open

Re: [GENERAL] add column sillyness

[EMAIL PROTECTED] says... Yes, I didn't mean to make a statement about firebird support (which I know nothing about) But that didn't stop you actually making an (untrue) statement about it! but rather I was just trying to comment on and show appreciation for the amazing support that I

Re: [GENERAL] add column sillyness

[EMAIL PROTECTED] says... Last night after posting this I asked myself. Could I get the same kind of support (basically an answer to any question within 24 hours from one of the actual postgres developers) with firebird that I can get here? I doubt it. www.ibphoenix.com - go to lists and

Re: [GENERAL] add column sillyness

[EMAIL PROTECTED] says... AFAICT, the main thing that Firebird lacks is a viable open-source development community :-(. This is untrue - go to www.ibphoenix.com and follow the links to the lists. It's a nice bit of software, and I'd be happy to see it doing better, but it seems like

[GENERAL] Database of electoral results?

Hi all, This is not so much a question specific to PostgreSQL, but rather a general application of theory type of problem! I did post this on comp.databases.theory but received no replies there. If anyone here is interested and this is a suitable forum in the PostgreSQL hierarchy, that