[GENERAL] How to Describe a field in the table???

Hi, Im porting my programs from mySQL to PG. mySQL supports a query "DESCRIBE tablename fieldname" , that provides a detailed description of a specific table field. Is there such an equivalent in PG? "\d tablename" gives description for all the fields in the table, however I need to find out

[GENERAL] Two way encription in PG???

Hi, Im porting my software from mySQL to PG. I need to encypt a field in a table using two way encription. In mySQL for those purposes I was using build-in functions ENCODE/DECODE, is there such an equivalent in PG? How do I encrypt/decrypt something in PG? Regards, Boulat

[GENERAL] NULL parameters abort functions

I discover that if a function is passed a NULL parameter then it simply doesn't operate and a NULL value is returned. Is there *any* way round that? It makes life incredibly complicated. -- Bruce ---(end of broadcast)--- TIP 1: subscribe and

Re: [GENERAL] triggers vs NEW pseudorecord

On Sun, Mar 04, 2001 at 07:07:24AM -0500, Jan Wieck wrote: will trillich wrote: so altho the docs elsewhere say NOT to rely on access to the pseudo table NEW within a trigger function, this part does work like it should. but when i add SELECT or UPDATE it complains of "NEW used in

Re: [GENERAL] Two way encription in PG???

Boulat Khakimov writes: How do I encrypt/decrypt something in PG? Download 7.1 and use the contrib/pgcrypto module. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] NULL parameters abort functions

Bruce Richardson writes: I discover that if a function is passed a NULL parameter then it simply doesn't operate and a NULL value is returned. Is there *any* way round that? It makes life incredibly complicated. Upgrade to 7.1. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [GENERAL] CREATE INDEX function limitation

[EMAIL PROTECTED] (Bruce Richardson) writes: In a CREATE INDEX statement, functions don't do type conversion and can't be nested, meaning that the cast convertion function won't work. So, CREATE INDEX testidx on testtable (upper(CAST colname AS TEXT)); fails. Is this a feature I should just

Re: [GENERAL] INSERT ... RETURNING as Oracle

Sipos Andras writes: create table basket ( id serial NOT NULL PRIMARY KEY, timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ); How can I make a one step insert into the table and get values of 'ID' ? I am trying to find a similar solution as in the oracle's INSERT ...

[GENERAL] Re: avoiding endless loop in an UPDATE trigger

On Mon, Feb 26, 2001 at 11:53:51AM -0800, Norman J. Clarke wrote: Hello, I am attempting to write a trigger function or rule in pl/pgsql that runs on UPDATE to a table named "nodes". From inside this trigger, I would like to UPDATE the same "nodes" table. How can I do this without entering

[GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???

Hi, I am trying to configure PostgreSQL 7.1 over RedHat 7.0 (according to Lamar Owen the RPM's for 7.1 were built on RedHat 6.2and not 7.0 - does that implies any possible problems?). I have PostgreSQL already starting automatically but with no support to TCP/IP connections. I can see this

RE: [GENERAL] INSERT ... RETURNING as Oracle

Title: RE: [GENERAL] INSERT ... RETURNING as Oracle And using MAX is also horrifically slow once you start having any significant volumes of data. Why not write a function to add the info, which selects from a sequence, inserts the new row using the sequence number, and then returns the

[GENERAL] pgaccess on Win9x

Hi Y'all: Unzipped pgaccess to C:\. Have TclPro 1.4 at c:\Program Files\TclPro1.4 Executing C:\pgaccess\main.tcl I get: couldn't load library "libpgtcl.dll": this library or a dependent library could not be found in library path while executing "load libpgtcl[info sharedlibextension]"

With which user Apache accesses PostgreSQL (was Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???)

- Original Message - From: Uro Gruber [EMAIL PROTECTED] To: Paulo Parola [EMAIL PROTECTED] Sent: Sunday, March 04, 2001 7:14 PM Subject: Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ??? Hi, Sunday, March 04, 2001, 10:38:04 PM, you wrote: PP

Re: [GENERAL] postgres locks... [more information]

Ok, I think I know what happened, kind of.. One of my users' databases was currupt. I actually had to delete the entire base/dbname folder. Then I went in and drop/created the DB again and it seems to work fine. Is there any was to know how this happened? I have a .tar of the currupt DB if

Re: [GENERAL] postgres locks...

Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: Basically, psql would sit there trying to connect, meanwhile all the attempted connections wouldn't die. More details please? What do you mean exactly by the above statements? I had to "kill -9" all the postgres/postmaster

Re: [GENERAL] Two way encription in PG???

Peter Eisentraut wrote: Boulat Khakimov writes: How do I encrypt/decrypt something in PG? Download 7.1 and use the contrib/pgcrypto module. I looked at the pgcrypto README file and it seems that it only makes one-way hashes. None of the functions had a key argument of any kind. The

[GENERAL] Re: With which user Apache accesses PostgreSQL

On Sun, Mar 04, 2001 at 08:07:20PM -0300, Paulo Parola wrote: [ . . . ] My question should be: with which user Apache accesses PostgreSQL? From the message issued by PostgreSQL it is user 'apache'. On most systems it seems to be either wwwrun or nobody by default. Does that mean that