if i understand your problem right, you could use a View type as return
type ... in this view you declare the fields you want to return ...
thanks,
vishOn 7 Nov 2005 03:15:21 -0800, ctobini <[EMAIL PROTECTED]> wrote:
Hello,I would like to know how to recuperate the results of a request.I read t
Thanks again.
I'll give it a try.
Bob
- Original Message -
From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, November 10, 2005 7:44 PM
Subject: Re: [GENERAL] Where
one full row - NOT two or more rows.
On Thursday 10 November 2
one full row - NOT two or more rows.
On Thursday 10 November 2005 17:23, Bob Pawley wrote:
> By 'one record' do you mean one full row or one column of one row??
>
> Bob
>
> - Original Message -
> From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROTECTED]>
> Cc:
>
On Thu, Nov 10, 2005 at 02:44:28PM -0800, Shane wrote:
> The only thing I would add is you don't seem to be able to
> index a part of the timestamp with time zone value. As an
> example, I had a table with around 10m rows where I wanted
> to query by date. In order to add an index liki
> date_par
SELECT INTO
tries to create table
See: http://www.postgresql.org/docs/8.0/interactive/sql-selectinto.html
Why do you do the select into anyways? It does nothing.
If you try to update table pipe with the select result you have the wrong
command.
UC
On Thursday 10 November 2005 14:24,
Thanks Richard. Backup as compressed worked.
Richard Huxton wrote:
Richard Sydney-Smith wrote:
? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
Chose "plain" and saved to disk.
uninstalled 8.0.4
installed 8.1.0
create database in pgAdminIII v1.4
restore
reports as
I'm no expert, but I did just accomplish a restore from backup; so at
least I can help you with your second question.
pg_dump is the animal you'll want to use to create your backup. I
use it wrapped in a script that automatically timestamps and names
the output appropriately. Args looks
I guess to much information can be an overload. Been surfin' to find a decent
book and don't really know which one to try. I have a um, not exactly vague
understanding of a database.
Meaning I can create the tables and crude/elementary queries that are just
about as basic as you can get. It's
Hello to everybody.
I just have a couple of newbie questions. I'm trying to restore our
databases from a file system backup. The backups are done with rsync,
the postgresql service is stopped before backups are done on the
server. The system is Fedora Core 4 with Postgresql 8.0.3.
Now back
By 'one record' do you mean one full row or one column of one row??
Bob
- Original Message -
From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, November 10, 2005 5:05 PM
Subject: Re: [GENERAL] Where
This will work if you can guar
Summary:
Two queries that are nearly identical AND use the exact same indices
take much different times in execution. Both queries produce the exact
same results. One takes 1072ms to execute, the other 262ms. Although I
have a fix, it seems more of a hack, and I'd also like to know why it'
This will work if you can guarantee that it's only one record
INSERT INTO pipe (fluid_id,contain) SELECT (fluid_id,contain) FROM process
WHERE contain='ip'
otherwise (more than one record) you have to loop over the resultset,
something like (off the top of my head)
create or replace function
On 11/9/05, Nicolay A Vasiliev <[EMAIL PROTECTED]> wrote:
Hello there!I'd like to ask the PostgreSQL community for the conseptual thing. Wedevelop our web sites using MySQL. We like this for its high speed andfulltext search feature. But nowadays our projects are growing fast and
we afraid our MySQ
Voila, 2. Executed as superuser and, yes, no errors.
Thanks again!
Scott
On Nov 10, 2005, at 3:51 PM, Tom Lane wrote:
Scott Frankel <[EMAIL PROTECTED]> writes:
After upgrading from postgres 7.x.x to 8.1.0, my database restore
produces the following error msgs.
SCHEMA public postgre
Thank you - what is the correct command???
Bob
- Original Message -
From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <[EMAIL PROTECTED]>
Sent: Thursday, November 10, 2005 3:34 PM
Subject: Re: [GENERAL] Where
SELECT INTO
tries to create table
See: http://
Scott Frankel <[EMAIL PROTECTED]> writes:
> After upgrading from postgres 7.x.x to 8.1.0, my database restore
> produces the following error msgs.
> SCHEMA public postgres
> pg_restore: [archiver (db)] could not execute query: ERROR: must be
> owner of schema public
> Command was: COMMEN
I'd just like to congratulate the team on the excellent job that they've
done on Postgresql 8.1.
Yet again I'm amazed by the progress made in each and every major release
of this product I've seen since I started using it (around version 7.0).
To single out the changes that jump out at me t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Aly,
On Thu, 10 Nov 2005, Aly Dharshi wrote:
I was just wondering if there will be any RPMs for x86-64, that would
be great.
We have RPMs for som x86-64 platforms on the FTP mirrors. For which
platform are you exactly looking for?
Th
After upgrading from postgres 7.x.x to 8.1.0, my database restore
produces the following error msgs. The database is quite pedestrian:
a dozen or so tables, couple of triggers, some comments, &c. Note
that even though I get the following errors, a '\dt+' returns the
comment strings. Ar
I am attempting to transfer the data in the fluid_id
column of table process into column fluid_id of table pipe.
This should happen only when column contain of table
process holds the value 'ip'.
Here is the command that I am having trouble with.
---
create table process (fluid_id
in
On Thursday 10 November 2005 21:31, Michael Schuerig wrote:
> I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding,
> client encoding is set to unicode, too. LC_COLLATE for the cluster is
> [EMAIL PROTECTED] I noticed that that collation doesn't work for
> two-byte characters, appare
I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding,
client encoding is set to unicode, too. LC_COLLATE for the cluster is
[EMAIL PROTECTED] I noticed that that collation doesn't work for
two-byte characters, apparently they are ordered bytewise.
My current conjecture is that I
Le Jeudi 10 Novembre 2005 19:30, John DeSoi a écrit :
> My suggestion would be to try a content management system like Drupal
> (http://drupal.org). It supports both MySQL and PostgreSQL, so you
> could design a system that works with both databases and choose the
> one that best fits your requirem
On Thu, Nov 10, 2005 at 12:56:26PM -0500, Tamas Hegedus wrote:
> Hi,
>
> I was using locale="C" (ANSI_SQL) in the last years as ONLY this case
> indexes were used in queries containing """... LIKE 'someString%' """.
>
> I would like to access my databases through JDBC (I am new to it; I am
> no
Lincoln Yeoh writes:
> Is it OK to use PREPARE TRANSACTION and COMMIT PREPARED in order to have
> transactions that last longer than just a single web request?
> Previously it was usually a bad idea to keep database connections alive
> just to keep a transaction pending.
A prepared transaction
Hi,
I was using locale="C" (ANSI_SQL) in the last years as ONLY this case
indexes were used in queries containing """... LIKE 'someString%' """.
I would like to access my databases through JDBC (I am new to it; I am
not a programmer). For JDBC it is highly recommended not to use ANSI_SQL
enc
hi everybody,
Is it possible tu run vacuum from a plpgsql function ? I have a process
that copies a lot of data from a csv file with the copy command and at
the end of the function I would like to force a vacuun, is that
possible.
thanks in advance
Hugo
Hi all.
I have created a script containing handy functions for creating&deleting
range/list partitioned tables, see attached file (part_functions.sql).
This script defines the following functions:
partition_add(tblname text, part_suffix text, condition text)
partition_delete(tblname text, part_
Carlos Oliva wrote:
Thank you for your response Matthew. Currently I run pg_autovacuum with the
following scripts.
su -l postgres -c "pg_autovacuum -D -U postgres > /dev/null 2>&1"&
Do you suggest that I could change it to something like the following:
su -l postgres -c "pg_autovacuum -d2 -D -U
Hello Folks,
I was just wondering if there will be any RPMs for x86-64, that would
be great. Thanks for the wonderful job that you are doing Devrim.
Cheers,
Aly.
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 10 Nov 2005, Pavel Stehule
Hi,
Is it OK to use PREPARE TRANSACTION and COMMIT PREPARED in order to have
transactions that last longer than just a single web request?
Previously it was usually a bad idea to keep database connections alive
just to keep a transaction pending.
Now I'm thinking that we could keep transact
Thank you for your response Matthew. Currently I run pg_autovacuum with the
following scripts.
su -l postgres -c "pg_autovacuum -D -U postgres > /dev/null 2>&1"&
Do you suggest that I could change it to something like the following:
su -l postgres -c "pg_autovacuum -d2 -D -U postgres > /tmp/vacuu
Couple of thing here:
1) Just because autovacuum is running, doesn't mean that it has actually
tried to vacuum a table. 5 minutes is the time that it sleeps in between
investigating activity to see if a vacuum is needed. If you want to see
if pg_autovacuum has actually tried to do anything you
Hi Forum,
Should autovacuum reclaim most of the free space of a
database? We are trying to configure our database and running
pg_autovacuum to streamline our database. We have increased the
max_fsm_pages to a value larger than the total pages needed (see the output
from a full vacuum bel
On 11/10/05, Assad Jarrahian <[EMAIL PROTECTED]> wrote:
> Hi,
> I am trying to write a stored procedure that takes as input an array
> (one or more integers) and returns all rows matching that ID (primary
> key of the table):
>
> I have this so far:
>
> CREATE OR REPLACE FUNCTION
> getLMs(int[],f
On Nov 10, 2005, at 1:03 PM, Andrus wrote:
How I can select Slony-I installation option ?
I havent seen such thing during 8.1 installation.
also, as it stands today, slony-I doesn't support 8.1 at all due to
some internal changes. it is obviously a high priority to remedy
this situation.
Hi,
I am trying to write a stored procedure that takes as input an array
(one or more integers) and returns all rows matching that ID (primary
key of the table):
I have this so far:
CREATE OR REPLACE FUNCTION
getLMs(int[],float(8), float(8)) RETURNS SETOF tp_lm_object AS $$
DECLARE
myrec r
> Postgres 8.1 PgAdmin help in slony windows says:
>
> "In case you're installing a PostgreSQL 8.1 server on Win32,
> the windows installer routine can do this for you if you
> select the "Slony-I"
> installation option. "
>
> How I can select Slony-I installation option ?
> I havent seen such
OK. Thanks!
Scott
On Nov 10, 2005, at 10:20 AM, Tom Lane wrote:
Scott Frankel <[EMAIL PROTECTED]> writes:
[ Mac OS X ]
could not save history to file "/.psql_history":
Invalid argument
Searching the archives, I found a thread about this error wherein the
poster "solved" the probl
On Nov 10, 2005, at 2:50 AM, Nicolay A Vasiliev wrote:
I'd like to ask the PostgreSQL community for the conseptual thing.
We develop our web sites using MySQL. We like this for its high
speed and fulltext search feature. But nowadays our projects are
growing fast and we afraid our MySQL wo
Scott Frankel <[EMAIL PROTECTED]> writes:
> [ Mac OS X ]
> could not save history to file "/.psql_history":
> Invalid argument
> Searching the archives, I found a thread about this error wherein the
> poster "solved" the problem by commenting out the reporting code in
> the source file.
Postgres 8.1 PgAdmin help in slony windows says:
"In case you're installing a PostgreSQL 8.1 server on Win32, the windows
installer routine can do this for you if you select the "Slony-I"
installation option. "
How I can select Slony-I installation option ?
I havent seen such thing during 8.1 i
I just upgraded from postgres 7.x.x to 8.1.0 and am getting the following error from cmd-line psql:could not save history to file "/.psql_history": Invalid argumentSearching the archives, I found a thread about this error wherein the poster "solved" the problem by commenting out the reporting c
On Thu, 2005-11-10 at 11:27, Peter Eisentraut wrote:
> Scott Marlowe wrote:
> > Ya know, this brings up an interesting question, would it be feasible
> > to allow for a function of somekind to be applied as an argument to a
> > primary key declaration?
>
> You would have to guarantee somehow that
From both User A and User B, this query returns rows:
select * from pg_trigger where tgname = ''
but User A gets 2 rows (because I have the same trigger name on two
different tables) while User B only sees one of them. Is it permissions
on pg_trigger or on the original table (or some other th
Andrus wrote:
> Can Postgres use index
>
> CREATE UNIQUE INDEX foo_bar ON foo(bar bpchar_pattern_ops);
>
> in usual WHERE expressions just like regular index ?
>
> I.e can
>
> SELECT * FROM foo WHERE bar='123'
>
> use index foo_bar ?
I think in the time it took you to write this email you could ha
Scott Marlowe wrote:
> Ya know, this brings up an interesting question, would it be feasible
> to allow for a function of somekind to be applied as an argument to a
> primary key declaration?
You would have to guarantee somehow that the function is a one-to-one
mapping, in order not to destroy th
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Wed, Nov 09, 2005 at 11:06:22AM -0800, Bob Pawley wrote:
> The postgre is version 8 - the about calls it version 1.2.1 March 28, 2005
What version exactly? What does "SELECT version()" show?
On Thu, 2005-11-10 at 07:45, Peter Eisentraut wrote:
> Am Donnerstag, 10. November 2005 10:19 schrieb Andrus:
> > thank you. I don't understand how to delete primary key index without
> > removing primary key constraint or how to force primary key to use foo_bar
> > index.
>
> You cannot drop the
Voila! Xcode v2.1 worked.
Thanks!
Scott
On Nov 9, 2005, at 2:22 PM, Tom Lane wrote:
Scott Frankel <[EMAIL PROTECTED]> writes:
My build of postgresql-8.1.0 is failing on MacOSX.
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0)
file: -lSystem is not an object file
Thanks for answer, I will use TIMESTAMP WITH TIMEZONE.
--
Best regards,
Julian Legeny
mailto:[EMAIL PROTECTED]
=
On Thu, Nov 10, 2005 at 04:37:36PM +0100, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have question about func
> Note that if you don't use the pk in unnamed joins (i.e. you always
> identify the field you're keying off of) then the primary key is
> redundant and not needed, and you could just create the table without it
> and then create the unique index.
Thank you.
Can Postgres use index
CREATE UNIQUE I
[EMAIL PROTECTED] writes:
> I have question about functionality for TIMESTAMP (with/without time zone).
> The main question is, what is better for usage: timemestamp WITH or
> WITHOUT
> time zone?
You almost certainly want to store timestamp WITH time zone. It's
really poor design that th
On Thu, Nov 10, 2005 at 04:37:36PM +0100, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have question about functionality for TIMESTAMP (with/without time zone).
> The main question is, what is better for usage: timemestamp WITH or
> WITHOUT
> time zone?
>
> I have e.g. server in USA and there
On Thu, 2005-11-10 at 03:19, Andrus wrote:
> >> > How to create primary key without duplicate index on bar column ?
> >> >
> >> > Andrus.
> >> >
> >> >
> >>
> >> you can't.
> >> postgresql implements primary keys creating unique indexes and not
> >> null constraints on the pk columns.
> >
> > But,
psql was run from the linux box, read using both \i and -f.
The strange this is, it seems to work now...yesterday I was even thrown out by
the server due to some internal error.
Postgis-1.0.4 and the (pg-)admin81 module are also installed, if that has
something to do with it.
Could also be due
On Wed, Nov 09, 2005 at 08:19:32PM +0100, Mikael Carneholm wrote:
> Postgres machine OS: RHEL release 2.1 (Panama)
> PGAdminIII client OS: WinXP Pro 2002 SP2
> Clients: psql, PGAdminIII Query tool
The function creation hangs even with psql? Where did you run psql
from -- the Windows box, the Linu
Wow, nevermind. What I must not understand is my own code. Yikes, what
a bonehead.
--- Begin Message ---
From both User A and User B, this query returns rows:
select * from pg_trigger where tgname = ''
but User A gets 2 rows (because I have the same trigger name on two
different tables) whil
Hello,
I have question about functionality for TIMESTAMP (with/without time zone).
The main question is, what is better for usage: timemestamp WITH or WITHOUT
time zone?
I have e.g. server in USA and there is 6:00 a.m. Then I have client somwhere in
Europe (+7 hour) and I read timestamp
Hi,
I would like to have one function in plpgsql which is gen_func. From this
function I would like to call other functions depending on
the input parameters of gen_func - lets say f1 and f2. Parameters to f1 or f2
are text, refcursor and text[].
I tried to use EXECUTE but the problem is how to
Hi,
I’ve been trying to compile my own custom version of Mapserver for Windows this afternoon. Basically none of the
binaries linked from the official page are compiled with Fast-CGI support, so I
want to compile my own version since we want to use it in a pretty high volume
environment
Richard Huxton writes:
> In another email you mention that this script sometimes doesn't stop PG.
> This is the relevant block of code, and you can see that the line
> starting "su -l postgres" has been commented out and replaced.
> That's strange, because my copy of pg_ctl refuses to run as roo
Maik Trömel wrote:
Result: 2005-08-02 05:00:00+02 | 2005-11-10 14:16:41+01
Now, my question:
Why time zone "+02" in "2005-08-02 05:00:00+02"? And why "+01" in
"2005-11-10 14:16:41+01"?
I think +01 depends on my system time. But why +02?
Summer-time or daylight-saving-time shift. Your clocks
am 10.11.2005, um 14:58:14 +0100 mailte Maik Trömel folgendes:
> Now, my question:
> Why time zone "+02" in "2005-08-02 05:00:00+02"? And why "+01" in
> "2005-11-10 14:16:41+01"?
2005-08-02: summertime
2005-11-10: normal time
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heyn
Hi.
I just compiled the RH9 sources on my RH8 system, seems to work just fine.
The packages are available via the link below. Anyone who likes, may fetch the
rpms. Do read the README file before using the packages and keep in mind, they
are not official. I can only verify that they work on my small
Richard Sydney-Smith wrote:
? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
Chose "plain" and saved to disk.
uninstalled 8.0.4
installed 8.1.0
create database in pgAdminIII v1.4
restore
reports as not a valid archive.
Obviously this is not what I expect.
Some older b
Hello,
I created a table with:
"create table wrf (region integer, created_on timestamp(0) with time
zone, valid_for timestamp(0) with time zone, type varchar(5), max float,
min float, avg float, stddev float, var float);"
then i inserted data with:
"insert into wrf values ( $i, '2005-08-02 03
Am Donnerstag, 10. November 2005 10:19 schrieb Andrus:
> thank you. I don't understand how to delete primary key index without
> removing primary key constraint or how to force primary key to use foo_bar
> index.
You cannot drop the primary key index without dropping the primary key, and
you cann
? In pgAdminIII linked to 8.0.4 server did a backup of all databased.
Chose "plain" and saved to disk.
uninstalled 8.0.4
installed 8.1.0
create database in pgAdminIII v1.4
restore
reports as not a valid archive.
Obviously this is not what I expect.
Some older backups from a 7.4.? server on
Thanks! Nice link!
Tino Wildenhain wrote:
as such, dont miss
http://python.projects.postgresql.org/
which is a new approach for pl/python (among
other things it does too) It allows you,
with PG 8.x, to write set returning functions
which are lazy (e.g. built values as they
are fetched) - via s
Nicolay A Vasiliev schrieb:
Richard Huxton wrote:
Nicolay A Vasiliev wrote:
...
The others have their strengths and weaknesses depending on the
language itself. If you're prepared to compile from source there is a
pl-php which might interest you.
It's from the nice people at Command Promp
Piechu Piechu schrieb:
hello
I'm new in this list, so sorry if my question seems stupid
Is it possible to invoke store procedure because of time, I mean for example I
want my procedure to be invoked every ten minutes - what should I do to reach
this goal
Usually one takes the system cron s
am 10.11.2005, um 12:46:33 +0100 mailte Piechu Piechu folgendes:
> hello
>
> I'm new in this list, so sorry if my question seems stupid
>
> Is it possible to invoke store procedure because of time, I mean for
> example I want my procedure to be invoked every ten minutes - what
> should I do to r
hello
I'm new in this list, so sorry if my question seems stupid
Is it possible to invoke store procedure because of time, I mean for example I
want my procedure to be invoked every ten minutes - what should I do to reach
this goal
Greetings
Jakub Piechnik
Martijn van Oosterhout wrote:
On Thu, Nov 10, 2005 at 12:16:12PM +0300, Nicolay A Vasiliev wrote:
There are a number of different PL-languages. How do you select these
languages? I think PL/SQL is more fast or am I wrong?
Suggest me please your way of PL language selection.
Well, it kind o
Richard Huxton wrote:
Nicolay A Vasiliev wrote:
Hello!
I am going to be inspired into PostgreSQL community. So I need your
advices, buddies.
Crikey! I must be more persuasive than I thought :-)
Wow :)
There are a number of different PL-languages. How do you select these
languages? I
Thanks that was it.
Had installed an AVR programming environment that used cygwin.
C:\WinAVR\bin;C:\WinAVR\utils\bin;
Note that I wasable to re-install version 8.0.4 of postgres without
having to remove the references to WinAVR from the environment
variables.
thanks again
Richard
Magnus H
See http://www.postgresql.org/docs/faqs.FAQ_windows.html, question 3.1.
Your problem is most likely with a broken DLL file in the system path,
usually from cygwin.
//Magnus
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Richard Sydney-Smith
>
Nicolay A Vasiliev wrote:
Hello!
I am going to be inspired into PostgreSQL community. So I need your
advices, buddies.
Crikey! I must be more persuasive than I thought :-)
There are a number of different PL-languages. How do you select these
languages? I think PL/SQL is more fast or am I wr
Hello, Richard, and thanks for your answer!
Best of all, sorry for my poor English cause I am not a native English
speaking man :( .
Richard Huxton wrote:
> Nicolay A Vasiliev wrote:
>
>> Hello there!
>>
>> I'd like to ask the PostgreSQL community for the conseptual thing.
We develop our web
Nicolay A. Vasiliev wrote:
Hello, Richard, and thanks for your answer!
Best of all, sorry for my poor English cause I am not a native English
speaking man :(.
Your English is fine Nicolay - perfectly fluent AFIACT.
Oh - don't forget to CC: the list too - there are plenty more people who
can
On Thu, Nov 10, 2005 at 12:16:12PM +0300, Nicolay A Vasiliev wrote:
> There are a number of different PL-languages. How do you select these
> languages? I think PL/SQL is more fast or am I wrong?
>
> Suggest me please your way of PL language selection.
Well, it kind of depends on what you want t
>> > How to create primary key without duplicate index on bar column ?
>> >
>> > Andrus.
>> >
>> >
>>
>> you can't.
>> postgresql implements primary keys creating unique indexes and not
>> null constraints on the pk columns.
>
> But, of course, you CAN delete that other index now that it's redundan
surabhi.ahuja wrote:
i am using PostgreSQL 8.0.0
You should upgrade to 8.0.4 as soon as is convenient - there are 4 sets
of bugfixes available.
and the statrtup script i am using is as follows:
*
#! /bin/sh
# dbxdScript for starting up the PostgreSQL
# server in t
Nicolay A Vasiliev wrote:
Hello there!
I'd like to ask the PostgreSQL community for the conseptual thing. We
develop our web sites using MySQL. We like this for its high speed and
fulltext search feature.
Cool - how much faster than the other systems you tested against was MySQL?
> But nowa
Hello!
I am going to be inspired into PostgreSQL community. So I need your
advices, buddies.
There are a number of different PL-languages. How do you select these
languages? I think PL/SQL is more fast or am I wrong?
Suggest me please your way of PL language selection.
Thanks in advance,
N
Hello!
How do you get the list of id's? If you get it while some calculating
you may get the list of them (1, 3, 6,...) and then produce the query
select * from tablename where id in (your_list)
Hope this helps,
Nicolay
Maik Trömel wrote:
Hello!
I want to run a shell script with variables
I have installed successfully on one machine. Removed 8.0 and then
installed 8.1 ok
However the second machine fails.
Asks for the language and then halts.
If I kill process in task manager then installation resumes but then
fails completely with a "Chinese" user name. Computer is laptop with
Title: Re: [GENERAL] Postmaster failing to start on reboot
Another thing that has been
noted is ...sometimes if i run the command
dbxd stop.
it fails to bring down postmaster. What
should be done in such a situation?
right now we do a kill -9
postmaster
Thanks
regards
Surabhi ahuja
am 10.11.2005, um 10:10:22 +0100 mailte Maik Trömel folgendes:
> Hello!
>
> I want to run a shell script with variables under Postgresql.
>
> An example:
> I want to make the following query;
>
> select * from tablename where id=1;
> select * from tablename where id=2;
> select * from tab
Title: Re: [GENERAL] Postmaster failing to start on reboot
The error
"If you're sure there
are no old server processes> still running, remove the shared memory
block with the command "ipcr> m", or just delete the file>
"/export/home1/sdc_image_pool/dbx/postmaster.pid".
was looged in t
Title: Re: [GENERAL] Postmaster failing to start on reboot
i am using PostgreSQL
8.0.0
and the statrtup script i am using is as
follows:
*
#! /bin/sh# dbxd Script for starting up the
PostgreSQL#
server in the daemon mode##
# postgreSQL version is:PGVERSION=8.0
#
Hello!
I want to run a shell script with variables under Postgresql.
An example:
I want to make the following query;
select * from tablename where id=1;
select * from tablename where id=2;
select * from tablename where id=3;
select * from tablename where id=4;
.
Is it possible
Hello there!
I'd like to ask the PostgreSQL community for the conseptual thing. We
develop our web sites using MySQL. We like this for its high speed and
fulltext search feature. But nowadays our projects are growing fast and
we afraid our MySQL won't be able to perform large amount of complex
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 10 Nov 2005, Pavel Stehule wrote:
will be packages for debian?
I think there are already:
http://people.debian.org/~mpitt/
Regards,
- --
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~Po
95 matches
Mail list logo
