[GENERAL] fitler database list

2008-06-09 Thread Christophe Simonis
Is it a way to filter the database list on the tables containt in the database ? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] fitler database list

2008-06-09 Thread Tino Wildenhain
Christophe Simonis wrote: Is it a way to filter the database list on the tables containt in the database ? Yes it is. Cheers Tino :-) smime.p7s Description: S/MIME Cryptographic Signature

[GENERAL] nested view with outer joins - best practices

2008-06-09 Thread Bohdan Linda
Hello, I have noted one very strange thing which I would like to discuss with you. I have noted that outer joins on nested views takes heavily longer than the inner ones. Example: REATE VIEW ports_view AS SELECT ports.pid, nodes.nname FROM ports JOIN nodes ON nodes.nid =

Re: [GENERAL] nested view with outer joins - best practices

2008-06-09 Thread Tom Lane
Bohdan Linda [EMAIL PROTECTED] writes: 2) Will my plan get better with new version of pgsql ( currently its 8.0.x ) 8.0 is incapable of reordering outer joins, which is likely the cause of your problem. regards, tom lane -- Sent via pgsql-general mailing list

[GENERAL] connect by

2008-06-09 Thread Roberts, Jon
I need a high performing version of Oracle's connect by functionality in PostgreSQL. I saw some dispute about attempts to add this in the archives and a reference to an ANSI alternative with statement. Is either of these functions available yet? I'm using 8.3. Jon -- Sent via pgsql-general

Re: [GENERAL] connect by

2008-06-09 Thread Andreas Kretschmer
Roberts, Jon [EMAIL PROTECTED] schrieb: I need a high performing version of Oracle's connect by functionality in PostgreSQL. I saw some dispute about attempts to add this in the archives and a reference to an ANSI alternative with statement. Is either of these functions available yet? I'm

Re: [GENERAL] Application EventLog: could not write to log file: Bad file descriptor

2008-06-09 Thread Alvaro Herrera
Ati Rosselet escribió: sorry, forgot to cc: to the group..To: Alvaro Herrera [EMAIL PROTECTED] not as far as I can tell... I have log_destination='stderr'. unless csv logging is enabled in another location? No, that should mean it's disabled. Since I disabled the following line:

Re: [GENERAL] fitler database list

2008-06-09 Thread Craig Ringer
Tino Wildenhain wrote: Christophe Simonis wrote: Is it a way to filter the database list on the tables containt in the database ? Yes it is. In other words: Maybe you should try to explain more about what you are trying to do and why. Mention the commands you are using. Are you just using

[GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Andrew Lazarus
I was surprised to find out that in my pg_dumpall, inherited tables (which have no extra columns) come out empty. All of the data are in the base table. I was doing a dump to upgrade from 8.2 to 8.3, and this means that I have to split the base table up by hand. (Constraint exclusion on child

Re: [GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Tom Lane
Andrew Lazarus [EMAIL PROTECTED] writes: I was surprised to find out that in my pg_dumpall, inherited tables (which have no extra columns) come out empty. All of the data are in the base table. Well, then, that's where the data was in the source database. I can assure you pg_dump has gotten

Re: [GENERAL] E_PARSE error ?

2008-06-09 Thread Scott Marlowe
On Tue, Jun 3, 2008 at 10:14 AM, PJ [EMAIL PROTECTED] wrote: I'm using php5, postgresql 8.3, apache2.2.8, FreeBSD 7.0 I don't understand the message: *Parse error*: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING the guilty line is:

Re: [GENERAL] Bottom Posting

2008-06-09 Thread Bruce Momjian
Andrej Ricnik-Bay wrote: On 29/05/2008, Bob Pawley [EMAIL PROTECTED] wrote: ... get their point across up front without making me wade through previous posts which I have already read. Good for you :} I can understand the concept of bottom posting No one advocates bottom-posting

Re: [GENERAL] issue with xml functionality and !DOCTYPE

2008-06-09 Thread Bruce Momjian
Belbin, Peter wrote: I'm hoping this is the right place to ask. If not, please, kindly direct me to the right place. I'm having an issue with xml functionality. The issue is that the xml value has the following (large chunks have been removed, but this should be enough to demonstrate