On Mon, 25 Aug 2003, Steve Santacroce wrote:
> Sorry, forgot to write that. It was in the line. The wierd thing is that I
> can type:
> /usr/local/bin/pg_ctl -D /pgdata -l /var/log/pgsql start
>
> and it will start, but if I use:
>
> su -l pgsql -c exec "/usr/local/bin/pg_ctl -D /pgdata -l /var/lo
Look at User Mode Linux:
http://user-mode-linux.sourceforge.net/
It'll let you run multiple linux instances on the same box.
On Wed, 27 Aug 2003, Thierry Missimilly wrote:
> Hi,
>
> This is a good status.
> But i think you have forgotten DBMirror which is in the contrib directory.
> I have tri
Hornyak Laszlo wrote:
>
> Ok, I know this was an RTFM category question, I just didn`t find the
> information, but I promiss I will learn more about the proper use of the
> unix command 'grep', so next time I will find it easily :)
>
> I was looking for a `crontab -e`-like editing. It lets edit
This was over looked.
3.5.1. Date/Time Input
Date and time input is accepted in almost any reasonable format, including
ISO 8601, SQL-compatible, traditional PostgreSQL, and others. For some
formats, ordering of month and day in date input can be ambiguous and there
is support for specifying the e
We have some date problems when importing data into the PSQL system. The
following example shows it happening:
Source file = spec.csv
2,1,08/06/99,29/07/99,1,1,A,'R' CONDITION,C,MA,,O,,WS000
When imported into Postgres, the data is shown as:
mss_live=# select id,cdate,mdate,code,type,cat
Dear All:
I start postgresql with
"/app/pgsql/bin/pg_ctl start -l /app/pgsql/logfile -D
/app/pgsql/data",
when I use "cat /dev/null > /app/pgsql/logile" to clear
logfile, I can't clear logfile. How can I
clear the logfile, thank you!
vincent
On Tue, Aug 26, 2003 at 06:05:45PM -0400, Stephen Frost wrote:
> It appears to be up there now and you can puruse it using ViewCVS. The
> LICENSE file in erserver/docs certainly doesn't look like BSD (which is
> claimed on the main page) to me though.
Oops, looks like something didn't get changed
On Tue, Aug 26, 2003 at 17:48:38 -0300,
Rhaoni Chiu Pereira <[EMAIL PROTECTED]> wrote:
> when I need for just one query a especific index to be used the only way is to
> raise the costs ?
There is no way to say to use a specific index. You can turn off some plans
(and raise the cost of sequenti
Ok, I know this was an RTFM category question, I just didn`t find the
information, but I promiss I will learn more about the proper use of the
unix command 'grep', so next time I will find it easily :)
I was looking for a `crontab -e`-like editing. It lets edit the file,
checks the format, and i
On Tue, 26 Aug 2003, Andrew Sullivan wrote:
> I'm afraid that's the problem, though. The code cannot recover freed
> btree pages which can't be recycled for others to use. There is no
> choice but to reindex certain indexes.
While we're at it, anybody got a clue on how to reindex system tables?
Indeed, a free release of eRServer was released last night and is
available at
http://gborg.postgresql.org/project/erserver/download/download.php
There was an announcement sent to pgsql-announce also.
We will now be evaluating this to see if it is suitable for our
needs.
I spoke to PostgreSQL Inc l
scott.marlowe wrote:
> On Mon, 25 Aug 2003, Jeff Boes wrote:
>
> > >One action we have consiously not done is "REINDEX" on the
> > >table. We want to avoid that as far as possible.
> >
> > Why? It's usually a very painless step, unless the table has millions and
> > millions of rows. We reindex t
* Andrew Sullivan ([EMAIL PROTECTED]) wrote:
> On Tue, Aug 26, 2003 at 06:19:12PM +0100, Chris Miles wrote:
> > eRServer
> > http://www.erserver.com/
> > Commercial, looks professional. Not free.
> > However, No trial or evaluation ?
>
> There's (about to be?) a free version available now. If
Curt Sampson <[EMAIL PROTECTED]> writes:
> While we're at it, anybody got a clue on how to reindex system tables?
The procedure given in the REINDEX reference page doesn't work for you?
regards, tom lane
---(end of broadcast)---
On Wed, 27 Aug 2003, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > While we're at it, anybody got a clue on how to reindex system tables?
> The procedure given in the REINDEX reference page doesn't work for you?
You mean with the standalone backend? All the other developers get
p
Curt Sampson <[EMAIL PROTECTED]> writes:
> I'm not actually sure why there would be a problem (aside from
> performance) in removing and rebuilding an index on a system table,
All the hard-coded low-level stuff that expects the index to be there
blows up.
This might possibly be made to work for i
Archie MacDonald (rsh) wrote:
I am following the instructions in the techdocs for solaris 8 ( see
link below) and I am trying to
instal readline 4.2a first. It has not went well so far ...:-(
Easiest way to get tools installed on Solaris ... go to
www.sunfreeware.com. They've got readline, gcc, e
Hi,
I am trying to create a new database at the location E:\PGdbs on a
system running cygwin postgresql.
If I try to set this location using pgAdmin II it errors out complaining
about the first character in the string.
If I try to set this location using the -D paramater of create the
following h
On Wed, 27 Aug 2003, Andrew Sullivan wrote:
> On Tue, Aug 26, 2003 at 06:05:45PM -0400, Stephen Frost wrote:
> > It appears to be up there now and you can puruse it using ViewCVS. The
> > LICENSE file in erserver/docs certainly doesn't look like BSD (which is
> > claimed on the main page) to me
Hi,
This time I think this is a bug, but where? In my code or in plpgsql? Or
in my understanding of dynamic queries?
If the following is executed in context, where the dynamic query returns
data with every iteration everythin goes fine. If the the dynamic query
returns nothing - bush becomes null
Hallo everybody,
I have a problem that I can not to solve in a
simple way. I wrote a message to [EMAIL PROTECTED] but "I
can get no satisfaction". Maybe You help me please :-)
This is my problem
SOME INFORMATION:
I have a postgresql database version 7.2.2 on Linux
platform. I co
Mauri Sahlberg <[EMAIL PROTECTED]> writes:
> If the following is executed in context, where the dynamic query returns
> data with every iteration everythin goes fine. If the the dynamic query
> returns nothing - bush becomes null and everything fails. I do not
> undestand why bush becomes null when
The shell must be case sensitive.
Try :
[/]$ initlocation e:\pgDBs
[/]$ createdb -D 'e:\pgDBs' testdb
You see the differnce with yours ? (e:pgDBs)
Chris Brown wrote:
Hi,
I am trying to create a new database at the location E:\PGdbs on a
system running cygwin postgresql.
If I try to set this lo
Hallo dears PG-Users,
I have sucessfully installed the postgreSQL database an I want to administrate
the tables with phppgadmin. Almost ist perfekt except that I can't set a user
passwort. Wenn I add a new user by using the phppgadmin, the new user will be
created, but I allways can login without
On Thu, 28 Aug 2003, Ludwig Heusser wrote:
> Hallo dears PG-Users,
>
> I have sucessfully installed the postgreSQL database an I want to administrate
> the tables with phppgadmin. Almost ist perfekt except that I can't set a user
> passwort. Wenn I add a new user by using the phppgadmin, the new u
Does version 7.3 provide a way to get VACUUM activity reports in the server
log (postmaster's stderr) without having them show up in the client's
stderr?
In 7.2, running vacuum "quiet", i.e.,
/usr/local/pgsql/bin/vacuumdb -U postgres -q -a -z
logged vacuum activity to the server log. e.g.,
"DEBU
I'm wondering if anyone knows how to extract a single co-ordinate from the data
type "box".
I know that I can access a single co-ordinate from a "point" using the array
notation: p[0] or p[1] where p is of type "point".
I can extract a single "point" from a "box" with b[0] or b[1] where b is of
ty
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> But when I try something like b[0][0] the passer ignores the second array
> subscript parameter and returns only a "point".
Try this:
regression=# select f1, (f1[1])[0] from box_tbl;
f1 | f1
-+-
(2,2),(0,0)
Thanks for the quick response.
- Original Message -
> "Donald Fraser" <[EMAIL PROTECTED]> writes:
> > But when I try something like b[0][0] the passer ignores the second array
> > subscript parameter and returns only a "point".
> You need the extra parentheses because the two subscript o
I think you are forgetting that a box is an array of one dimension with
two points.
So, the first point is B[0] and the second is B[1].
Donald Fraser wrote:
>
> Thanks for the quick response.
>
> - Original Message -
> > "Donald Fraser" <[EMAIL PROTECTED]> writes:
> > > But when I try s
Concatenating a null value makes the string null. try:
SELECT 'foo'||NULL||'bar';
Just add a condition to check rivi.suoritus for null before making an
assignment.
Mauri Sahlberg wrote:
returns nothing - bush becomes null and everything fails. I do not
undestand why bush becomes null when the
Thank you very much. Also thanks for Josh.
I have to say that I'm really impressed with the speed of this list and
dedication of the people who develop postgres.
Twice I have asked a question on this list and twice I've got absolutely
correct answer in less than one day - even when both of my que
On Thu, 28 Aug 2003, Josh Goldberg wrote:
> Concatenating a null value makes the string null. try:
> SELECT 'foo'||NULL||'bar';
>
> Just add a condition to check rivi.suoritus for null before making an
> assignment.
or better use coalesce
>
>
>
> Mauri Sahlberg wrote:
>
> >returns nothing - bus
if your table is named foo and the field you want to chage is bar, then:
BEGIN;
ALTER TABLE foo RENAME bar TO bar_old;
ALTER TABLE foo ADD bar VARCHAR();
UPDATE foo SET bar=bar_old;
*if everything went ok then*
ALTER TABLE foo DROP bar_old;
COMMIT;
same goes for CHAR data type.
about limitat
34 matches
Mail list logo
