[ADMIN] table name as parameter in pl/psql

hi all, i'm trying to do something like this: CREATE FUNCTION read_table(text) RETURNS int AS ' DECLARE table_name ALIAS FOR $1; res INTERGER; BEGIN SELECT INTO res COUNT(id) FROM table_name; RETURN res; END; ' LANGUAGE 'plpgsql'; using psql the

[ADMIN] Moving a database

Hi all, we recently upgraded from 6.53 to 7.1.2, and at the same time tried to move the database to a new filesystem. However, while the upgrade was 100% successful using pg_dumpall, we see that postgres is still reading some files from the old file system (though only updating the new files).

Re: [ADMIN] Moving a database

Ewan Leith [EMAIL PROTECTED] writes: An example is pg_shadow which is read on both file systems whenever someone seems to authenticate, but only updated on the new file system. I don't believe it for a minute. Please describe the actual problem you're having, rather than jumping to

[ADMIN] Help! System catalogs vanished!

Hi there, I'm having a just wonderful Friday at work. Not. At around 2am this morning, probably in the middle of the nightly scheduled VACUUM ANALYZE, the UPS on my server failed. This morning, I have no databases. The details: PostgreSQL 7.0.3 on IRIX 6.5.11m. When I started the machine

[ADMIN] What is libpq.so.2.1 ?

Hallo, I`´m newbie in postgreSQL. Please help me, if you can. Q: After start postgreSQL on my system (SuSE 7.0) with postgreSQL 7.0 an creat a new directory /var/lib/pgsql/data I want creat a new db with createdb Personal. The system tells me, that it culd not found libpq.so.2.1 That is so ! At

[ADMIN] How to rename a database

Does anyone know how to rename a database on postgres 7.1? Thank you in advance. Ligia ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] pgdumpall_file is bigger than 2 Gigabyte

David M. Richter schrieb: Hello! Ive got a problem! My database has the size of almost 5 Gigabytes. So the dump will take at least 2 Gigs of harddisk. But my Kernel supports only 2 Gig Files! Any experiences with big dumpfiles? Thanks a lot DAvid Hello I guess split and gzip

Re: [ADMIN] Primary Key Problems

On Fri, 7 Dec 2001, Phill Kenoyer wrote: I took your advice and checked the string size using char_length() and octet_length(). They are the same. octet_length | stock| octet_length | inventory_type | client_id 5 | 10725 |4 | used |60

Re: [ADMIN] table name as parameter in pl/psql

On Mon, 10 Dec 2001, [utf-8] [EMAIL PROTECTED] wrote: hi all, i'm trying to do something like this: CREATE FUNCTION read_table(text) RETURNS int AS ' DECLARE table_name ALIAS FOR $1; res INTERGER; BEGIN SELECT INTO res COUNT(id) FROM table_name;

[ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Hello-- I have been having trouble getting subselect queries to complete on a Sun E-450 running Solaris 7 and PostgreSQL 7.1.3.Just about any subselect query I try to run will fail to complete execution---Postgres's serverlog indicates that the process associated with the query gets killed

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Heather Johnson [EMAIL PROTECTED] writes: I have been having trouble getting subselect queries to complete on a Sun E= -450 running Solaris 7 and PostgreSQL 7.1.3. Just about any subselect query= I try to run will fail to complete execution---Postgres's serverlog indica= tes that the process