PostgreSQL Database Forum

Can I use the serial data type in lieu of an 'auto_number' field? I asked something like this some months ago and it seems that auto_number fields were addressed through a combination of triggers and procedures to ensure that there were do duplicate KEYS generated. Is it realistic to use the serial data type as a KEY? ...

Hi All. There is one thing which somewhat annoys me, which is that psql always prompts me for a password. That makes it difficult for use in Makefile where I want to say 'make build_db', which would run psql for each stored procedure which needs to be updated. Is there a way to specify that password somehow in a command line like isql (...

For the last couple of hours I've been trying to update my 8.0.0betaX sources with "cvs update" but I keep getting the following: cvs update: Updating . cvs update: Updating ChangeLogs cvs update: Updating MIGRATION cvs update: Updating config cvs update: waiting for anoncvs's lock in /projects/cvsroot/pgsql-server/config cvs update: ...

Hi All, I'm wonder if there is any possibility to modify a users password by updating the pg_shadow table. I'd like to ensure that when the user modifies his/her http password (htpasswd) than his database password also changes. It is important to have the same password for both services. I plan to do it from php. Is there any way to do...

Have any configure experts looked at building plpython.so on mac os x lately? The standard configure key "--with-python" fails miserably (libpython is not a shared lib error message). I found help on the macosxguru site, Basically one has to change the python_libspec to (in Makefile.global)

Is it possible to return the field names of a composite type using a function? Any examples or pointers? -- Robert ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

PostgreSQL 8.0.0beta2 (CVS) Solaris 9 I've noticed the following message in the server's logs: LOG: failed to commit transaction_isolation The log message appears if I issue a SET TRANSACTION ISOLATION LEVEL and later do a ROLLBACK. For example:

Hi, We about a week ago installed a clean version of postgres 7.4.5 for testing purposes. For the last couple of days for any transaction it has been complaining about: Thu Sep 23 09:36:24 2004: ERROR: could not access status of transaction 941262 Thu Sep 23 10:10:01 2004: DETAIL: could not open file "/nw/data/pgdata/pg_clog/0000": No...

Hola como estan, Es posible optimizar la siguiente consulta: select '3ARR' as level, coalesce(dpe_costod,0), dpe_productfk,dpe_procode, dpe_procode2, stamp,dpe_qty, dpe_qtyrec,dpe_provfk, coalesce(dpe_costol,0) from detpa

Hi, I've seen in previous posts that recommended practice for database backup is to run the dump utility twice. Once for schema only and a second time for data only (I think). Up to know, I've only ever dumped both, and have never had a problem restoring into older/newer versions of postgres, nor with restoring into other commercial...

In testing slony with pg 8.0 (from cvs), I see a number of these "CONTEXT" log statements showing up for what appear to be successfully executed saveplans. I see the CONTEXT statements are controlled by log_error_verbosity in postgresql.conf. I want these CONTEXT log statements for *errors*, but not for non-error statements. Is that...

In order to try to reduce lock contention on my FK's, I need to convert them to DEFERRABLE. The straightforward way is to drop and recreate the modified FK. However, on a table with 65M rows, this is taking quite some time. I'm afraid how long it will take to update both FK's on my 170M+ row table... Anyhow, is there some trickier way to...

This version is mostly bug fixes and speed enhancements... BiggerSQL is a multimedia aware Cocoa based Postgresql browser for Mac OSX. The homepage for BiggerSQL is http://homepage.mac.com/levanj/Cocoa BiggerSQL comes with the complete source code. Jerry

Dear friends, First pls accept my apologies, because I am a new Postgres user, so my questions could be silly. We need to setup a database using UTF-8 encoding, however, by some way, we have to express our need for right Greek character collation order. I tried the default installation using pginstaller, then I created a db (using...

Hi everyone, I have a table with a bytea-column: CREATE TABLE picture( id int primary key, preview bytea NOT NULL); How can I insert a value in the bytea-column 'preview'? The function 'lo_import()' does only work

I have an interval field which is used to calculate total hours. At present it outputs as days hours minutes Is there any way to output as total hours I have tried to_char(field,'HH:MM') but I get wierd results like -51 or -5

I know that PSQL has the cool feature of doing: Adding missing FROM-clause But I want to disable it, because its silent adding can allow a bad SQL statement to execute a cartesian select (when in fact it should error out). I searched and found references to changing the postgresql.conf with: add_missing_from = false enable_implicited_join...

Hello, I am playing with the "INHERITS" functionality of create table to determine its suitability to my needs and I've hit a roadblock (hopefully minor)... If I have two tables like this: CREATE TABLE tablea ( id SERIAL

Hi all, I'm currently coding some functions in plpgsql for generating reports out of records in a table. Problem is: NULL values in records make the complete function fail. Here is a simple test case (original is more complex with a multi- table query in the for qres in select... part): create table test( id serial,

Hi, Is it possible to define "linked servers" like in MS-SQL? Or - is any work going on to implement such feature? So that using 2 postgresql DB's where one is in dmz and one in production - the last one has defined the one in dmz as a "linked server" and sql's sent to the internal DB can do joins between tables in internal DB and DB in...

I guess this is not possible? The installer cannot find the postgres user, which is in the Active Directory. It is a Win 2003 Ent server used here for testing things. Can someone point me to the docs for requirements of the PostreSQL install on Windows? -- Robert ---------------------------(end of broadcast)---------------------------

Hello, we are using a table with a primary key of type varchar. If we try to find entries with select * from <table> where <table.key> = '<text>'; entries with a key length of more than 32 characters are not found. Entries with a shorter key are found. Using "Like" instead of "=" works for varchar keys with length > 32 as well. Does...

Hello All, I have just upgrade my postgresql to 7.4.5-2, but I have problem with default value in postgresql 7.4.5-2, everytime I set default value for varchar or timestamp fields, the result value always change to sometihing like this : I set the default value to '1900-01-01 00:00:00' , but the result is '1900-01-01 00:00:00'::timestamp...

Hello list, Is there a way to restore a specific function from backup file created with pg_dump. Thanks in advance, -- Sinceramente,

I have a categories table that contains a FK to another category in the same table, creating a hierarchy. At the very top is this row: category_id | name | description | parent_id -------------+------+-------------------------+----------- 1 | ROOT | The top level category. | 0 There is no record with category_id 0...