PostgreSQL Database Forum

You know I didn't even think about that, duh. I was thinking of using it inside a function where the password could be obtained on the database server itself somehow, avoiding the need to pass any passwords from the web application and simplifying a rather complicated permission structure we have where we have anonymous users that need insert...

Hello: I have an awkward situation where I must downgrade from 7.4 to 7.1. I have two databases already in 7.4. I'm largely ignorant concerning postgresql: am I going to have any severe problems downgrading? Thanks Matt

Hi folks! A query I am running does not seem to use indexes that are available (running version 7.4.2). I have the following table: => \d replicated Table "public.replicated" Column | Type | Modifiers -----------------+--------------------------+-----------------------------------------------------

Is there a way to get the list of connected users to a postgres server? -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---------------------------(end of broadcast)---------------------------

Hi !! Is it possible to put inside a plpgsql function psql commands like \pset ? Thanks !! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Does anyone know of a good way of implementing postgres real-time mirroring? Whether it's a program that's already out there or whether it is something that can be done by the DBA? I know there is one in contrib called dbmirror but does it actually work well (it seems to also require pgperl) Thanks much Sally ...

I have been using Postgresql 7.2.4 on a Redhat 8.0 system. Prior to putting the system into production I want to upgrade Postgresql and PHP to the latest stable versions. To that end I have downloaded the latest versions and compiled them. I have saved my current databases using pg_dumpall. Currently I have the last versions that Redhat...

Hello Can¨I get list of dependencies between objects? What I know I can use views from pg_catalog.pg_constraint, but Is there any simple way? Thank You Pavel

select productname, upper(productname) from products gives this: Gustaf's Knäckebröd GUSTAF'S KNäCKEBRöD Tunnbröd TUNNBRöD Gumbär Gummibärchen GUMBäR GUMMIBäRCHEN Tourtière ...

look please http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=253295 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

All, I am trying to create a basic auditing mechanism using triggers and would like to create a table that contains the following information: audit_operation = TG_OP audit_username = CURRENT_USER audit_time = CURRENT_TIMESTAMP audit_table = TG_RELNAME

"Chris Gamache" <cgg007@yahoo.com> wrote: > When I reload and attempt to access the database I find this > in the logs: > > ERROR: cache lookup failed for function 75769893 You should be OK as long as you have the dump file. If you haven't modifed any of the tsearch2 pg_ts_* tables, try and load tsearch2.sql first before loading the...

Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, which operator class can I use in order to search points by distance like in: SELECT p FROM tbl WHERE (p <-> point(0,0)) < 10; - From what I've seen, there is none - which surprises me ...

Hello, upgrading my OS from RedHat 8.0 to FC2, postgresql was also automatically updated from 7.2. to 7.4. Unfortunately, I did not "dumpall"... How can I get my data??? I copied the data-folder to another location and so got running the new postgresql-server. I tried to install the old 7.2.4.tar.gz in a new folder, but it don't go further...

I have a question about locks. I have a stats table that get updated when some other table changes. Sometimes that other table is updated a 2nd time before the first stats update is finished which causes an error. I've tried using 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE' but get 'could not serialize access due to concurrent update' ...

Hello, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for them. However, it seems that PostgreSQL does not support it. Could someone helps me please? The example table: T1 (col1 varchar(7) not null,

Hello, I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta 2 as the backend running on Windows XP (installed with pgInstaller). Ocassionally, I get this SQLException message in my web page: "SMgrRelation hashtable corrupted"

(Sorry if it arrives twice.) > > Hi All, > I'd like to write an SRF but I'm block a strange error message > > WARNING: plpgsql: ERROR during compile of check_close2 near line 11 > ERROR: return type mismatch in function returning tuple at > or near ";" >

How can i get a list of all types that dont have the "_"before them. I only want a list of the types that a user might need to create tables. thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443

Is it possible to to the following I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong type error. Is there any way to stop this behaviour so that the valid information is allowed,but the blank values get ignored. ...

Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table?

Hi, I want to administer files with postgres. When I "import" a file to postgres I also submit certain atributes the file has. Such as filetype or specific properties I know about the file (not the standard stuff like the OS knows about the file as date,and size) I want that postgres then copies the file to a save place and write and read...

Hi, Below is my VB6 code that writes data from an Access 2000 table to a PG table. The " & "" " on the right of each line should prevent nulls from being passed to PG. For some reason I still get nulls in any field without data. Even the secondary part number which is set to "".

Hellou, when I use pg_dump database > dump.dat on database with tsearch2 and then psql database < dump.dat - this command fails, because in dump.dat is declaration of tsearch2 procedures and types after main schema, which is using tsearch2. is this patch for this??