Title: ALTER TABLE - add several columns
Hi,
I just want to add several columns to an existing table. Do I have to call a statements like below for each new column, or is there a possibility to do it at once?
- existing table: test
- columns to add: col1 (FK),
Original Message
Subject: Re: [GENERAL] IP clash in the PC
From:"Deepa K" <[EMAIL PROTECTED]>
Date:Thu, August 26, 2004 10:56 am
To: "Jan Wieck" <[EMAIL PROTECTED]>
-
Nick wrote:
"/help/support/index/time.jsp"
and i want to extract the 1st, 2nd and 3rd parts
1st = help, 2nd = support, 3rd = index
Are you using 7.4? If so:
select split_part('/help/support/index/time.jsp','/',2),
split_part('/help/support/index/time.jsp','/',3),
split_part('/help/sup
> Hi,
> Yes, in other PC, PG is running. But, PG load is not getting load. And
> also I think it is possible to reach the other PC from this PC as Eth0
> is not up (because of clash).
>
> 1. Load running PC - Eth0 is not up
> 2. Other PC- Eth0 is up
>
>> The only thing *I* can think of i
Hi,
Our new Postgres
database includes a table with about 1 mil records. So far, I've
been impressed with the performance of queries against 1 mil rows.
Unfortunately I just found out that the size of the table will increase to
3 mil records.
Can I expect
Postgres to return results on
Hi!
I'm thinking about creating a table listing my shares (say 'Shares') and
then update its price column from a .txt file (say 'Prices') downloaded
from an internet site periodically.
Recalling past readings my first idea would be to use
something like:
=> update table Shares set price = (select p
don't know much about mailman, but I've just restarted the daemons ... let
me know if that 'unsticks' things ...
On Wed, 25 Aug 2004, DeJuan Jackson wrote:
It appears that the Slony list isn't accepting traffic/posts at all. I
posted a message yesterday (2004-08-24) and haven't even received it
I recently upgraded an application from postgresql 7.4.2 to 7.4.5, and now I am having
timezone nightmares.
I checked on the old server, and found that in the postgresql.conf, the timezone was
set for unknown. The timezone portion of the records was being set to GMT+06 ( for
reference, I am in
Everyone,
I am about to begin a project which will use Java (JDBC) and postgresql.
In most Java projects, I do not embed SQL code, but create functions
which have the SQL logic. I call the functions from within my Java
code. For selects, the functions return refcursors, which the Java code
c
On 8/25/2004 11:39 AM, Marc G. Fournier wrote:
On Wed, 25 Aug 2004, Thomas Hallgren wrote:
This project might be perceived as a thirdparty add-on and thus, fail
its purpose. The steering committee must stand behind this officially.
Will you? What's your opinion about the suggestion?
Behind what?
On Wed, 2004-08-25 at 17:09, Alvaro Herrera wrote:
> On Wed, Aug 25, 2004 at 04:25:02PM +0100, Oliver Elphick wrote:
> > Maybe recreating pg_user in the database will help. It is a global
> > table, so if you have other databases where pg_user exists, copy the row
> > from pg_class in that databa
On Wed, 25 Aug 2004, Thomas Hallgren wrote:
For the first category, an inclusion could be possible if the software
has a potential to reach more users and can make the offering more
complete in some respect. If that's not the case, it should be included.
Most software that "sucks royally" will b
On Wed, Aug 25, 2004 at 12:09:58PM -0400, Alvaro Herrera wrote:
> No, pg_user is a view on pg_shadow ...
>
> SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb,
> pg_shadow.usesuper, pg_shadow.usecatupd, ''::text AS passwd,
> pg_shadow.valuntil, pg_shadow.useconfig FROM p
It appears that the Slony list isn't accepting traffic/posts at all. I
posted a message yesterday (2004-08-24) and haven't even received it
myself at this point (2004-08-25). Just thought I'd give a heads up, in
case now one knew.
---(end of broadcast)-
Marc G. Fournier wrote:
1. your project must be pgxs compatible.
2. it must be hosted on pgFoundry.
3. it must have automatic regression testing built in (perhaps this
is part of #1).
4. documentation must follow some guidelines so that it is easy to
combine it with other docs.
5. someone must su
On Wed, Aug 25, 2004 at 11:14:36AM -0400, Liu, Mingyi wrote:
> 1. Is there existing open-source FTI for postgres that allows partial words search?
I think a trigram-based solution could help you here. In 8.0beta there
is a contrib/pg_trgm module that implements such a thing. It isn't
present on
On Wed, Aug 25, 2004 at 04:25:02PM +0100, Oliver Elphick wrote:
> On Wed, 2004-08-25 at 15:08, David Suela Fernández wrote:
>
> > The problem is that pg_dump always give me the next error:
> >
> > pg_dump: SQL command failed
> > pg_dump: Error message from server: ERROR: relation "pg_user" does
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 25 Aug 2004, Mark Gibson wrote:
> We've now switched to RHEL3 (management decision - for support!),
> which IMHO is an admin nightmare (but thats just RPM's for you).
> We had to download and compile several important packages manually,
It might not be pretty but:
SELECT * FROM v_fol_unit_pub_utmpt WHERE folder_folder_object = 100120
AND unit IN ( 90072, 90005, 90074, 90075 ) AND unit_pub_type IN ( 2 )
AND utmpt IN ( 1 ) ORDER BY unit = 90072 desc, unit = 90005 desc, unit =
90074 desc;
It probably won't work very well if you ne
On Wed, 25 Aug 2004, Thomas Hallgren wrote:
1. your project must be pgxs compatible.
2. it must be hosted on pgFoundry.
3. it must have automatic regression testing built in (perhaps this is part
of #1).
4. documentation must follow some guidelines so that it is easy to combine it
with other docs
On Wed, 2004-08-25 at 15:08, David Suela Fernández wrote:
> The problem is that pg_dump always give me the next error:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: relation "pg_user" does not exist
> pg_dump: The command was: SELECT (SELECT usename FROM pg_user WH
Sorry if this question has been asked before. I tried to search in postgres mailing
lists at http://archives.postgresql.org/pgsql-general/ just now and it gave me error
"An error occured! Can not connect to search daemon".
Anyway I installed tsearch2 and openFTS and was able to do some searches
On Aug 25, 2004, at 2:18 AM, Hadley Willan wrote:
Hi,
I was wondering if it's possible to order the result set by some
of the set contained in an IN clause.
I had to do something like this recently. Ended up with a pl/pgsql
function, looked a lot like this:
create or replace function arr
On Wed, 2004-08-25 at 08:46, Matthew Marlowe wrote:
> Gentoo has alot of features, is amazingly customizeable, and can significantly
> reduce long term systems maintenance costs -- but it isn't a silver bullet. You have
> to take over some QA tasks that redhat/etc would otherwise be doing.
>
> W
Hi folks,
I'm new to PostgreSQL and am busy tring to work with
it. Of pl/pgsql I know even less and that's the part I
have a question on right now. I have this nice example
to get me started with
pl/pgsql...
I have a table with the schedule of a service my sport
team wants to offer:
Table Sch
Christopher,
It seems to me that some vital components have already been set up,
considering:
a) pgxs provides a "build environment" to make it easier to add in
"third party extensions" without each of them having to have its
own full PG source tree.
b) PGFoundry is getting set up as a h
At 09:20 PM 8/24/2004 +0200, Peter Eisentraut wrote:
David Wheeler wrote:
> That's not the trouble so much as that the locales can be badly
If we always followed the principle "X could be broken, so let's not use
X", then we would never get anything done. Instead, "X is broken, so
fix it".
> broke
27 matches
Mail list logo
