Hello All,
I built the latest postgresql 7.4.2 in HPUX PA.
The command psql -E databasename, is not give the
output like in 7.3.4.
In Postgresql 7.3.4, it gives the following output:
$ echo select * from db5; | psql -E test
* QUERY **
BEGIN; SELECT usesuper FROM
Dragan Matic [EMAIL PROTECTED] writes:
Is there some way to make Postgres sort elements
in this way (setting sort order or collation, I suppose)?
C locale would sort that way; you appear to be using some other locale.
I concur with the nearby suggestions that you should consider a more
Bob Powell [EMAIL PROTECTED] writes:
NOTICE : analyzing pg_type server closed connection unexpectedly.
This probably means the backend terminated abnormally before or
while processing the request.
Not good ... can you get a stack trace from the backend core dump?
Vacuum has been
Sam Masiello wrote:
After doing lots of reading it looks like dblink might be a great
solution for this. After trying to insert dblink.sql into the database,
I just get a series of errors:
ERROR: stat failed on file '$libdir/dblink': No such file or directory
This is not a dblink error per se, but
On Thu, 20 May 2004, Dragan Matic wrote:
If I have a table t with column c which is defined as char(5) and fill
it with following values:
insert into t (c) values ('1')
insert into t (c) values ('2')
insert into t (c) values ('3')
insert into t (c) values ('4')
insert into
Hi!
I would like to know if it's possible to give a priority order of how
to sort the returning rows?
Like for example to order every row with a field language = DK first,
then the rows with field language = *DE' and last the other languages,
ordered alphabetically?
Sincerely
Victor
With mysql it's possible to add a parameter SQL_CALC_FOUND_ROWS to
the selectstatement and then after having made a query to the database
with a limit clause you can fire off a second query, SELECT
found_rows() as numberofrows to get the number of rows the query would
have returned without the
Hello.
I'm running postgres 7.4.1 and notice an accumulation of temp schemas
named pg_temp_1, pg_temp_2... etc.
These schemas are empty and I have manually removed them from time to
time.
What procedure is leaving these behind and is there a way for me to
have them cleaned up automatically
Hello,
well, almost everything is in the subject !
I have to fill 2 tables (more complicated than in the example !):
CREATE TABLE A (
id serial primary key,
foo text);
CREATE TABLE B (
id serial references A,
bar text);
I fill A with :
INSERT into A VALUES (DEFAULT, toto);
On Mon, 17 May 2004, Milos Prudek wrote:
Actually, if you declared idmember as SERIAL PRIMARY KEY, you could
just do:
I can't do that. idmember is a SERIAL PRIMARY KEY for members. Each
member can have many messages (msg table) with the same idmember column
value. See my original
On Thursday May 20 2004 10:11, Durai raj wrote:
When I stop the postmaster in another session or in
terminal, I got the following error:
$ pg_ctl -D /var/opt/iexpress/postgresql stop
waiting for postmaster to shut
down
failed
Hi,
Whenever my database's data gets updated in a variety of ways, I need
to run an external perl script (to re-generate static web pages). What do
you recommend I look at to accomplish this? (Triggers?)
Thanks for your help!
David
---(end of
12 matches
Mail list logo