| |
thread by: Tom Allison |
last post Nov 23 '05 by: Tom Allison
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?
...
|
thread by: Dmitri Priimak |
last post Nov 23 '05 by: John DeSoi
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 (...
|
thread by: Michael Fuhr |
last post Nov 23 '05 by: Marc G. Fournier
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: ...
|
thread by: Együd Csaba |
last post Nov 23 '05 by: Michael Fuhr
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...
|
thread by: Jerry LeVan |
last post Nov 23 '05 by: Jerry LeVan
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)
|
thread by: Robert Fitzpatrick |
last post Nov 23 '05 by: Robert Fitzpatrick
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)
|
thread by: Michael Fuhr |
last post Nov 23 '05 by: Tom Lane
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:
|
| |
thread by: Amin Abdulghani |
last post Nov 23 '05 by: Amin Abdulghani
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...
|
thread by: Josué Maldonado |
last post Nov 23 '05 by: Josué Maldonado
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
|
thread by: Anony Mous |
last post Nov 23 '05 by: Tom Lane
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...
|
thread by: Ed L. |
last post Nov 23 '05 by: Ed L.
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...
|
thread by: Vivek Khera |
last post Nov 23 '05 by: Vivek Khera
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...
|
thread by: Jerry LeVan |
last post Nov 23 '05 by: Jerry LeVan
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
|
thread by: Manolatos Tilemahos |
last post Nov 23 '05 by: joseph speigle
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...
|
thread by: Oliver Nolden |
last post Nov 23 '05 by: Oliver Nolden
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
|
| |
thread by: mike |
last post Nov 23 '05 by: Tom Lane
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
|
thread by: terry |
last post Nov 23 '05 by: Tom Lane
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...
|
thread by: Net Virtual Mailing Lists |
last post Nov 23 '05 by: Net Virtual Mailing Lists
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
|
thread by: Daniel Martini |
last post Nov 23 '05 by: Najib Abi Fadel
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,
|
thread by: Willy Skjæveland |
last post Nov 23 '05 by: Willy Skjæveland
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...
|
thread by: Robert Fitzpatrick |
last post Nov 23 '05 by: Robert Fitzpatrick
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)---------------------------
|
thread by: Christian Enklaar |
last post Nov 23 '05 by: Christian Enklaar
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...
|
thread by: Frans |
last post Nov 23 '05 by: Tom Lane
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...
|
| |
thread by: Josué Maldonado |
last post Nov 23 '05 by: Thomas F.O'Connell
Hello list,
Is there a way to restore a specific function from backup file created
with pg_dump.
Thanks in advance,
--
Sinceramente,
|
thread by: Matthew Hixson |
last post Nov 23 '05 by: Matthew Hixson
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...
|