[GENERAL] sequences and dependences
Hi, I would like to write a request where I would get the table name and column name of a sequence. In fact I want the opposite of pg_get_serial_sequence ! I have been looking at the sytem table and could not link the sequence from pg_class to a table (and even less to a table). And I have not been sucessful looking at the net either ! Cheers, [EMAIL PROTECTED] The Computing Froggy __ Do You Yahoo!? En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités http://mail.yahoo.fr Yahoo! Mail
Re: [GENERAL] XML Support related questions
Am Donnerstag, 22. Mai 2008 schrieb Brijesh Shrivastav: 1) Can xml column be constrained to be DOCUMENT or CONTENT type? Using a check constraint that does IS [NOT] DOCUMENT on the value. 2) Is there plan in near future to support XML schema validation i.e to ensure inserted xml document conforms to a preregistered set of XML schemas. Plans yes, but I don't think anyone is working on it at the moment. 3) Support for XQuery - I know it is asking for too much but when do you see it happening in the future. See #2. 4) Support for xml indexes - Is it something that is being worked upon for next release? See #3. ;-) Of course this question is a bit underspecified, because indexes depend on some operators, and XML does not have any operators at the moment, so what do you want to index? -- 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] XML2 module and xpath_table
Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer: How would I achieve the same without using the deprecated xml2 module? xpath_table is probably the major piece that is not directly covered by the new system. So until we have a replacement, we probably won't remove the old module. -- 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] XML2 module and xpath_table
Peter Eisentraut wrote on 24.05.2008 13:35: Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer: How would I achieve the same without using the deprecated xml2 module? xpath_table is probably the major piece that is not directly covered by the new system. So until we have a replacement, we probably won't remove the old module. Ah, good to know. Thanks for the answer -- 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] sequences and dependences
I would like to write a request where I would get the table name and column name of a sequence. In fact I want the opposite of pg_get_serial_sequence ! You are looking for refobjid in pg_depend, but this time the sequence could be a dependent to more than table. A query like the one bellow is should give you the name of the table, assuming you account for the correct namespace; it will not automatically show the name of the column: select objid::regclass, refobjid::regclass from pg_depend where objid::regclass::text = 'person_id_seq' ; Thanks Ioannis Tambouras -- 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] sequences and dependences
On Fri, 23 May 2008, Laurent ROCHE wrote: I would like to write a request where I would get the table name and column name of a sequence. I have been looking at the sytem table and could not link the sequence from pg_class to a table (and even less to a table). There's an example of how to chain between two pg_class entries using pg_depend that I think is close to what you're looking for at http://wiki.postgresql.org/wiki/Fixing_Sequences -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- 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] SUMMARY: Solaved. apache perl cgi script cant load libpq.5.dylib on mac os tiger
Hmmm, It was the protection on the /usr/local/pgsql directory. Solved, by myself an hour after making this post. Odd that, its been bugging the heck out of me for over a week now, and then one hour after posting At 16:05 +0100 23/5/08, Fergus McMenemie wrote: I have a perl cgi script that wont run on a new mac. The script runs fine from the command line, so the perl and postgresql seem good. However when run as an apache cgi script the postgresql stuff fails as shown below. I altered the script to dump %ENV and the paths seem in order. The script is not using mod perl. It is using the apple os x 10.4.11 supplied version of apache, postgresql-8.3.0 and perl, v5.8.8 with DBD::Pg, DBI and JSON installed. I am at a total loss as to why the library cant be found and would be very grateful for any help. Content-type: text/html Software error: install_driver(Pg) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle' for module DBD::Pg: dlopen(/usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle, 1): Library not loaded: /usr/local/pgsql/lib/libpq.5.dylib Referenced from: /usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle Reason: image not found at /usr/local/lib/perl5/5.8.8/darwin-2level/DynaLoader.pm line 230. at (eval 45) line 3 Compilation failed in require at (eval 45) line 3. Perhaps a required shared library or dll isn't installed where expected at /Library/WebServer/cgi-bin/pgcgi.pl line 383 $ENV{AUTH_TYPE} = Basic $ENV{DOCUMENT_ROOT} = /Library/WebServer/Documents $ENV{DYLD_LIBRARY_PATH} = /usr/local/pgsql/lib:/usr/lib:/usr/local/lib $ENV{GATEWAY_INTERFACE} = CGI/1.1 $ENV{HTTPS} = on $ENV{HTTP_ACCEPT} = text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,/;q=0.5 $ENV{HTTP_ACCEPT_CHARSET} = ISO-8859-1,utf-8;q=0.7,;q=0.7 $ENV{HTTP_ACCEPT_ENCODING} = gzip,deflate $ENV{HTTP_ACCEPT_LANGUAGE} = en,en-us;q=0.5 $ENV{HTTP_CONNECTION} = keep-alive $ENV{HTTP_HOST} = X.co.uk $ENV{HTTP_KEEP_ALIVE} = 300 $ENV{HTTP_USER_AGENT} = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14 $ENV{LD_LIBRARY_PATH} = /usr/local/pgsql/lib:/usr/lib:/usr/local/lib $ENV{PATH} = /usr/local/pgsql/bin:/usr/local/bin:/bin:/sbin:/usr/bin:/usr/sbin $ENV{QUERY_STRING} = $ENV{REMOTE_ADDR} = XX $ENV{REMOTE_PORT} = 53698 $ENV{REMOTE_USER} = fergus $ENV{REQUEST_METHOD} = GET $ENV{REQUEST_URI} = /cgi-bin/pgcgi.pl $ENV{SCRIPT_FILENAME} = /Library/WebServer/cgi-bin/pgcgi.pl $ENV{SCRIPT_NAME} = /cgi-bin/pgcgi.pl $ENV{SERVER_ADDR} = $ENV{SERVER_ADMIN} = [EMAIL PROTECTED] $ENV{SERVER_NAME} = X.co.uk $ENV{SERVER_PORT} = 443 $ENV{SERVER_PROTOCOL} = HTTP/1.1 $ENV{SERVER_SIGNATURE} = Apache/1.3.41 Server at .co.uk Port 443 $ENV{SERVER_SOFTWARE} = Apache/1.3.41 (Darwin) mod_ssl/2.8.31 OpenSSL/0.9.7l -- === Fergus McMenemie Email:[EMAIL PROTECTED] Techmore Ltd Phone:(UK) 07721 376021 Unix/Mac/Intranets Analyst Programmer === -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- === Fergus McMenemie Email:[EMAIL PROTECTED] Techmore Ltd Phone:(UK) 07721 376021 Unix/Mac/Intranets Analyst Programmer === -- 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] best er modeling tool for postgreSQL
Scott Ribe wrote: I don't remember if MagicDraw supports multiple schema or not, but back when I was looking at CASE-type tools it was one the nicer ones that I found that would run on platforms other than Windows. For Windows, I've been using Case Studio for several years and I've been very happy with it. However, the company has since been bought by Quest and the product name was changed to Toad Data Modeler. I have no idea if it's the same as or /better/worse than CS. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] editing functions/triggers etc..
Hi, I was wondering if anyone has written a tool that will drop (cascade) then allow the edit and then restore the functions/triggers including the adding the function/triggers to the inserts/deletes/etc.. to the tables. It turns out that have to change 50 fifty triggers. At the moment I create a list of the tables -remove the link, edit the code, restore the link. This is not working very well. TIA John -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Optimzing Postgresql
Hi, I am deciding between MySQL and Postgres. I'm leaning towards Postgres mainly due the widely publicized speed when using transactions. However, I am not able to find any good books / resources for tuning/ optimizing the database. Is there a book like High Performance MySQL for Postgres that teaches what the different parameters are and how to tune them? Or do most techniques covered in the High Performance Mysql apply to Postgres too? Thanks, Ram
Re: [GENERAL] Optimzing Postgresql
Ram Ravichandran wrote: Hi, I am deciding between MySQL and Postgres. I'm leaning towards Postgres mainly due the widely publicized speed when using transactions. Everything except for a couple of actions in Postgresql are wrapped in transactions and can be rollback, you can not turn it off like in MySQL. However, I am not able to find any good books / resources for tuning/ optimizing the database. Is there a book like High Performance MySQL for Postgres that teaches what the different parameters are and how to tune them? Or do most techniques covered in the High Performance Mysql apply to Postgres too? I can not comment on a book i have never read so i have no idea what is between the cover of said book. I don't know if it is specific to MySQL or is general enough to apply to all databases. I would think the book is specific to MySQL. Tunning Postgresql performance is really quit painless just very time consuming. Greg Smith has written allot stuff that covers the parameters in postgresql http://www.westnet.com/~gsmith/ Here's another resource. http://www.postgresqldocs.org/wiki/Performance_Optimization -- 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] Optimzing Postgresql
On May 24, 2008, at 11:57 AM, Ram Ravichandran wrote: Hi, I am deciding between MySQL and Postgres. I'm leaning towards Postgres mainly due the widely publicized speed when using transactions. However, I am not able to find any good books / resources for tuning/ optimizing the database. Is there a book like High Performance MySQL for Postgres that teaches what the different parameters are and how to tune them? The postgresql manual is good. http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm is a five minute tuning overview. http://www.powerpostgresql.com/PerfList/ is a good overview of basic tuning, written for 8.0 but still pretty applicable. Hang out on the pgsql-performance mailing list and see what other people do - How do I tune a database for X comes up pretty regularly, and gets good answers, so trolling through the mailing list archive can give some very good advice. Or do most techniques covered in the High Performance Mysql apply to Postgres too? Probably not. Mysql has a very different philosophy to postgresql. And some approaches that are suggested to work around performance issue on mysql may actually harm performance on other databases. Cheers, Steve -- 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] Optimzing Postgresql
On 5/24/08, Ram Ravichandran [EMAIL PROTECTED] wrote: I am deciding between MySQL and Postgres. I'm leaning towards Postgres mainly due the widely publicized speed when using transactions. However, I am not able to find any good books / resources for tuning/ optimizing the database. Is there a book like High Performance MySQL for Postgres that teaches what the different parameters are and how to tune them? Or do most techniques covered in the High Performance Mysql apply to Postgres too? There's no book, that I know, dedicated to tuning PostgreSQL performance, but the PostgreSQL book by Korry Douglas has a big section on tuning and statistics gathering: http://www.amazon.com/PostgreSQL-Developers-Library-Korry-Douglas/dp/0672327562 There are plenty of overlaps between tuning PostgreSQL and tuning any other database, such as using the right RAID setup to optimize I/O. PostgreSQL has a bunch of parameters for controlling buffer sizes, write-ahead logging, sort memory and so on. Here's a decent overview: http://www.powerpostgresql.com/PerfList When looking for material, make sure it's updated to the 8.x series, which drastically changed the way PostgreSQL manages its cache buffers. Alexander. -- 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] best er modeling tool for postgreSQL
I know some of these have already been mentioned, but here's the summary I had stashed away. Although, I'm not sure which ones have any issues with default schemas. If you do find any such problems (especially with the kind GPL developers), I'm sure they'd appreciate any feedback. /** GNU-GPL **/ OpenSystemArchitect http://www.codebydesign.com/ Power*Architect http://code.google.com/p/power-architect/ Druid http://druid.sourceforge.net/ ERW http://erw.dsi.unimi.it/ Dia http://live.gnome.org/Dia XML to DDL (python scripts) http://xml2ddl.berlios.de/ Graphiz - I believe I've read of people using it to reverse engineer from DDL http://graphviz.org/ /** Multiple versions/licenses (each has a free and a not-free version) **/ DBVisualizer http://www.minq.se/products/dbvis/ Toad http://www.toadsoft.com/ /** Not-free **/ Microsoft Visio - (If you already have it, it does work quite well) DataStudio - 30 day trial http://www.aquafold.com DBWrench - 30 day trial http://www.dbwrench.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general