PostgreSQL Database Forum

Hi all, Can it speed things up to index the order by columns? Thanks. Hadley

Hello ! I use PostgreSQL 7.4.5-1mdk on an Mandrake Linux 10.0 server. I've installed libpq3, postgresql, postgresql-server and postgresql-docs for that version. I've restarted my server. My database works correctly, but I can't install the PL-PGSQL. I can't find the librairy plpgsql.so on my server. In what package can I find the PL-PGSQL...

Hiya, I am using the following line to retrieve the attribute name of the 1st column for a table on which a trigger has been fired. idfield=SPI_fname(trigdata->tg_relation->rd_att,0); The trigger that calls this function runs after for insert, update and delete.

Hi, Here is the output a psql session. Please notice that the identation inconsistences in the records containg non ASCII chars is as outputed by psql. The db was created with LANIN9 and the console was ran (in the same machine) using UTF-8 (my system's default). I was surprised to notice that setting the client to unicode (which is

Hi, I was trying to overload concat operator ||(text,text) such a way that it behaves like Oracle. i.e. I want 'abc' || null to return 'abc' instead of null. I know that it is not the expected behaviour in postgres, but since I am migrating the database from oracle to postgres , I need this behaviour. But when I try to drop the...

Has anyone ever taken a look at adding radius authentication to Postgresql? I know it's not terribly secure in itself, but some 2 factor authentication schemes like Cryptocard use it for verifying one time passwords, and at least in our case having 2 factor authentication for remote access would be really nice. ...

Hello, Dropping a trigger is permitted if the user is the owner of the table for which the trigger is defined. In a plpgsql function, used by different users, I need to disable some triggers for a short period of time. With the pgsql user login, I can succesfully drop and create the trigger again (after locking the tables for which I...

Hello... Is it possible in PostGre 7.3 to query the size of a text array attribute of a table? Does anyone know how this is queried in 7.3? thanks... help is greatly needed. eddie

I'm setting up a system to use schemas: DB -----------+------------ | | | | Schemas: Prod Test Funcs TestFuncs | | tables tables This sort of arrangmenet allows me to have a Production set of tables and a

I read the recent posts about Hebrew support already and I am having a similar problem, but with an MS Access front end. The database is Unicode encoded. I can input Hebrew, query in hebrew and view hebrew from the PGAdmin III query tool. However in MS Access, when I type hebrew it changes to all ??? and when I view a record input through...

$ /usr/sbin/cygserver -S Segmentation fault (core dumped) yates@leibniz ~ $ -- % Randy Yates % "...the answer lies within your soul %% Fuquay-Varina, NC % 'cause no one knows which side %%% 919-577-9882 % the coin will fall." %%%% <yates@ieee.org> % 'Big...

Can't get the postgres server started under Win2000/cygwin. Here's what happens: $ initdb -D /Gauss/rr/data -W The files belonging to this database system will be owned by user "yates". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory...

Hello, Today I tried connecting to my database locally via psql. I got the usual welcome & basic help messages, but it never got to the prompt: it just hung. So I checked top and the psql process was increasing in size at quite a rate (up to a gig in under 30 seconds). I'd been using psql with no problems only a couple of hours ago, and I...

How do I list the schema for a table or procedure? Is there a command I can do in psql to list this, or do I have to join a series of tables to see that?

Has anyone successfully done this? I've got cygwin and the very first step crashes - bash-2.05$ pwd pwd /cygdrive/e bash-2.05$ cd postgresql-7.4.5 cd postgresql-7.4.5 bash-2.05$ ./configure

U:\postgresql-8.0.0beta2\src\interfaces\libpq>nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 8.00.40607.16 Copyright (C) Microsoft Corporation. All rights reserved. Building the Win32 static library... cl.exe @u:\tmp\nm33D2.tmp cl : Command line warning D9002 : ignoring unknown option '/YX' cl : Command line...

Hi all! I'm writing a script that presents the user with a numbered lines menu, each line corresponding to a <case n> which executes a psql command. As the psql-commands are very similar to each other (all of them have the structure: 1.- psql mydb -x -c "SELECT * FROM tb_nm WHERE col_nm LIKE '%$k_r%'" ) I thought it was possible to...

At my company we are looking at deploying clients for our client/server app outside our firewall, which will then require our postgres box to be internet-accessible. Does anyone out there have experience with this or recommended best practices? We have been looking at either (a) tunnelling everything over ssh, or (b) just making sure that...

Is there any way to retrieve the error code and error message text when an exception has been caught via "exception when others" in pl/pgsql? I'm looking essentially for the equivalent of Oracle's pl/sql sqlerrm and sqlcode variables. Regards, Shelby Cain

Guys, Now that Ingres has been open-sourced, I'm curious about where it stands with regards to PostgreSQL. Is it a worthy competitor? PostgreSQL has been my database of choice for many years, and I'm very interested in how Ingres and PostgreSQL stack up in terms of features and performance. Any insight you can provide will be very much...

subscribe end ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ---------------------------(end of broadcast)---------------------------

I'm having a problem suppressing output from some of my cron scripts and java code. One file of sql scripts (eod-misc.sql) is called by a shell script (update.sh). Within eod-misc, various sql commands and home rolled functions are called eg SELECT * FROM myFunction(); which generates a lot of output (77000 lines for one of them), which gets...

Hello... Is it possible in PostGre 7.3 to query the size of a text array attribute of a table? Does anyone know how this is queried in 7.3? thanks... help is greatly needed. eddie ----- Original Message ----- From: "Po Eddie Lim" <eddiepo@hq.ntsp.nec.co.jp>

Hello: At the risk of starting a flame-war, I'd like some more details on the use of Gentoo Linux for a production PostgreSQL server. There have been a couple of comments lately that it is not such a great idea; does anyone have specific experience they'd be willing to share? Some background: we've been running PostgreSQL on assorted...

Is there any way to debug a procedural language shared library when you can't createlang? I get this... L-897V601: {1} createlang pltcl template1 DEBUG: InitPostgres DEBUG: StartTransactionCommand DEBUG: PortalRun DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: PortalRun