Re: [HACKERS] Status of index location patch

> Just wondering what is the status of this patch. Is seems from comments > that people like the idea. I have also looked in the archives for other > people looking for this kind of feature and have found alot of interest. > > If you think it is a good idea for 7.2, let me know what needs to be

[HACKERS] Status of index location patch

All, Just wondering what is the status of this patch. Is seems from comments that people like the idea. I have also looked in the archives for other people looking for this kind of feature and have found alot of interest. If you think it is a good idea for 7.2, let me know what needs to be cha

Re: [HACKERS] querying system catalogs to extract foreign keys

On 13 Sep 2001 22:56:16 -0700, you wrote: >I tried to use the getImportedKeys and getExportedKeys of >java.sql.DatabaseMetadata... But it didnt give any expected >results... This is probably a limitation or bug in the JDBC driver. Please post details of your problem on [EMAIL PROTECTED] E.g. w

Re: [HACKERS] syslog by default?

Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, that makes sense. My only question is how many platforms _don't_ > have syslog. If it is only NT and QNX, I think we can live with using > it by default if it exists. There seems to be a certain amount of confusion here. The proposal at hand was

Re: [HACKERS] System Tables

Peter Harvey writes: > Are the table structures of the System Tables changed often? Only between major releases (if necessary). > Have they changed from v7.1.1 and v7.1.2? No. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of bro

[HACKERS] chunk size problem

I started getting these error messages webunl=> \dt NOTICE: AllocSetFree: detected write past chunk end in TransactionCommandContext 3a4608 pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processi

Re: [HACKERS] [GENERAL] Where do they find the time??? Great Bridge closed now!!!??

peace_flower <"alavoor[AT]"@yahoo.com> writes: > I hope the MySQL team will drop the development and Jump into PostgreSQL > development. Pgsql going to be the only sql server to > run the WORLD ECONOMY smoothly.. There is no time support and develop > two duplicate products!! PostgreSQL is very a

[HACKERS] System Tables

Are the table structures of the System Tables changed often? Have they changed from v7.1.1 and v7.1.2? Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- ---(end of broadcast)

[HACKERS] Where do they find the time??? Great Bridge closed now!!!??

Great Bridge ceased operation and not going to support postgreSQL (because of lack of investor) In these days of economic downturn, recession and world-wide economic depression...(and even the looming war) I am wondering how the MySQL team is finding time to support and develop duplicate SQL ser

Re: [HACKERS] Index location patch for review

> > Attached is a patch that adds support for specifying a location for > > indexes via the "create database" command. > > > > I believe this patch is complete, but it is my first . > > This patch allows index locations to be specified as > different from data locations. Is this a feature dir

Re: [HACKERS] [BUGS] Build problem with CVS version

> John Summerfield writes: > > > I'd point out this from the INSTALL document: > > --prefix=PREFIX > > > > Install all files under the directory PREFIX instead of > > /usr/local/pgsql. The actual files will be installed into various > > subdirectories; no files

[HACKERS] querying system catalogs to extract foreign keys

I wanted to extract foriegn keys from the postgresql database related to each of the tables.. I tried to use the getImportedKeys and getExportedKeys of java.sql.DatabaseMetadata... But it didnt give any expected results... So can anyone tell me how to query the system catalogs to extract this info

[HACKERS] Trigger - Editing Procedures

  I have written some triggers which will call some procedures.   I am looking for some way wherein I can edit these procedures   Is there any way to do so?   regards, joseph  

[HACKERS]

> Hi > > I saw in TODO > CLIENTS > * Add XML interface: psql, pg_dump, COPY, separate server > and there's some code for JDBC in contrib/retep directory. > > Are there any plans to add xml support to postgresql, to return > rown in formatted in xml for start? not only from psql, but > from ever

Re: [HACKERS] count of occurences PLUS optimisation

Sorry about the size of this message!, it covers several optimisation areas. Yes we are talking about a limited situation of ORDER BY (that does not match the GROUP BY order) plus LIMIT, but one that is easy to identify. It also has the advantage that the number to be LIMITed will 9 times out of

Re: [HACKERS] syslog by default?

On Sep 12, [EMAIL PROTECTED] contorted a few electrons to say... Bruce> OK, that makes sense. My only question is how many platforms _don't_ Bruce> have syslog. If it is only NT and QNX, I think we can live with using Bruce> it by default if it exists. perhaps you could take some code from

[HACKERS]

> Hi > > I saw in TODO > CLIENTS > * Add XML interface: psql, pg_dump, COPY, separate server > and there's some code for JDBC in contrib/retep directory. > > Are there any plans to add xml support to postgresql, to return > rown in formatted in xml for start? not only from psql, but > from eve

[HACKERS] XML

> Hi > > I saw in TODO > CLIENTS > * Add XML interface: psql, pg_dump, COPY, separate server > and there's some code for JDBC in contrib/retep directory. > > Are there any plans to add xml support to postgresql, to return > rown in formatted in xml for start? not only from psql, but > from ever

[HACKERS] XML support?

Hi I saw in TODO CLIENTS * Add XML interface: psql, pg_dump, COPY, separate server and there's some code for JDBC in contrib/retep directory. Are there any plans to add xml support to postgresql, to return rown in formatted in xml for start? not only from psql, but from everywhere (e.g. php) T