,
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
@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
:
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
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
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
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
Op 22 feb 2010, om 19:30 heeft Richard Broersma het volgende geschreven:
On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens
frankheik...@mac.com wrote:
There is no index on the column transactionid in your PostgreSQL-
table, as
there is in your MySQL-table. This explains the difference
://www.postgresql.org/mailpref/pgsql-general
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
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:
http://www.postgresql.org
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
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
--
Sent via pgsql-general
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
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
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
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 geschreven:
Frank
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 because of the missing
oid.
Would be nice
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
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
18 matches
Mail list logo