Re: [GENERAL] Postgis error

Regards, Frank Heikens -- 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] aliases for sequences and other DB objects?

No, it's not possible, pgSQL does't have a CREATE ALIAS -syntax You could put this function into another function to create sort of an alias, but that wouldn't make to much sense. Frank Op 9 jun 2009, om 22:03 heeft Agoston Postgres het volgende geschreven: Hi! Is it possible in Postgres

Re: [GENERAL] How to know the indexes on a Table

Hi all, Is there any way, to know the name of indexes on a table, defined in a database. I mean can I query something like Select Index_name from pg_class where relname = "Table_name" . Thanks in advance. --- Thanks & Reagrds Anirban Pal | Software Engineer Newgen Software Tech

Re: [GENERAL] pg_relation_size, relation does not exist

The search_path isn't correct. You're looking for the size of tables in schema 'econ' but you don't mention this schema inside the function pg_relation_size(). Try to use the schemanames as well, saves you a lot of problems with assumptions. This one should work: SELECT tablename,

Re: [GENERAL] pg_relation_size, relation does not exist

Agreed. Personally I wouldn't use pg_tables at all because of the missing oid. Would be nice to have in this view, but it can't be changed because it's a system-view. pg_class would do the job. Regards, Frank Op 16 jun 2009, om 16:12 heeft Tom Lane het volgende gesc

Re: [GENERAL] pg_relation_size, relation does not exist

olumn to the view in a future version? We certainly shouldn't go modify it, but adding to it should be pretty safe, no? -- Magnus Hagander Self: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ Frank Heikens wrote: Agreed. Personally I wouldn't use pg_tables at all becaus

Re: [GENERAL] create a table inside a function

A very simple and incomplete example: CREATE OR REPLACE FUNCTION new_table(int) returns bool AS $$ BEGIN IF $1 = 1 THEN EXECUTE 'CREATE TABLE x()'; ELSIF $1 = 2 THEN EXECUTE 'CREATE TABLE y()'; ELSE EXECUTE 'CREATE TABLE z()'

Re: [GENERAL] pg_dump PostgreSQL 8.4

1. is there any configuration setting i need to do. any help would be appreciated. regards raffy segador destiny cable inc ncr, philipines Frank Heikens frankheik...@mac.com -- 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] Error when assigning default value for function parameter

r "DEFAULT" LINE 1: ...TE OR REPLACE FUNCTION ___myfunc(a int, b integer DEFAULT 10... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Frank Heikens frankheik...@mac.com -- Se

Re: [GENERAL] bytea_output default value change in 9.0 breaks Apache::Session::Postgres

al mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Regards, Frank Heikens -- 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] Justifying a PG over MySQL approach to a project

Managers want support, they can't live without. Every piece of software has its flaws and needs patches. PostgreSQL is supported for 5 years, the latest version (8.4) will be supported at least until 2014. In total there are 6 supported version as we speak, 7.4 - 8.4. MySQL has active suppo

Re: [GENERAL] Sorting performance vs. MySQL

g? Thanks in advance. -- Yang Zhang http://www.mit.edu/~y_z/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Frank Heikens frankheik...@mac.com -- 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] Sorting performance vs. MySQL

Op 22 feb 2010, om 19:30 heeft Richard Broersma het volgende geschreven: On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens wrote: There is no index on the column transactionid in your PostgreSQL- table, as there is in your MySQL-table. This explains the difference. CREATE INDEX

Re: [GENERAL] Sorting performance vs. MySQL

sort runs much faster (on the order of several minutes). Make sure your index does fit into memory, what's the size of the index? -- Yang Zhang http://www.mit.edu/~y_z/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] Sorting performance vs. MySQL

it.edu/~y_z/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Frank Heikens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Not able to change the owner of function

Skip the SET-keyword: ALTER FUNCTION test_create() OWNER TO masanip; Regards, Frank Op 24 feb 2010, om 07:14 heeft Jignesh Shah het volgende geschreven: Hi, could you tell me what could be the issue in below command. I could see that there is an option for changing OWNER of function but

Re: [GENERAL] windows 7 compatiblity?

Hi I recently bought Windows 7 32 bit professional. Unfortunately Postgresql 8.4.3 did not install or work. Tell us about your problems, error messages and logs, then we can help you to get it working. I started searching Google and found that a lot of other people have the same problem

Re: [GENERAL] Problem either with PostgreSQL or with PHP

pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Frank Heikens frankheik...@mac.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general