Hello All,
I want to add multiple column to a table using single alter statemet,
someting like this:
alter table admin_session add column accounting_session varchar(1) not null
default '0',accounting_active varchar(1),acc_start_date date,acc_end_date date;
is there any way?
am Thu, dem 05.04.2007, um 6:58:01 +0100 mailte Ashish Karalkar folgendes:
> Hello All,
> I want to add multiple column to a table using single alter statemet,
> someting like this:
>
> alter table admin_session add column accounting_session varchar(1) not null
> default '0',accounting_active
Omar Eljumaily <[EMAIL PROTECTED]> writes:
> I've run into this sort of obscure problem. I'm using libpq with a
> front end database api where I need to track column names and how
> they're returned in libpq queries. What's happening is that I start out
> with a set of table names when I open
Is there a way to grant INSERT and UPDATE permissions on all the
tables in a database? I don't want to type-in every table name...
---(end of broadcast)---
TIP 6: explain analyze is your friend
am Wed, dem 04.04.2007, um 22:23:20 -0700 mailte Postgres User folgendes:
> Is there a way to grant INSERT and UPDATE permissions on all the
> tables in a database? I don't want to type-in every table name...
http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.htm
On Wed, 4 Apr 2007, Postgres User wrote:
Oleg,
This looks like a great module, do you have a pointer to it in English?
unfortunately, no.
If can send this module to me as a compressed file, I'll take the time
to post it on PgFoundry as a new project that everyone can easily
access and down
Oleg,
This looks like a great module, do you have a pointer to it in English?
If can send this module to me as a compressed file, I'll take the time
to post it on PgFoundry as a new project that everyone can easily
access and download.
Paul- if you go with the lower() edits route, be sure to no
I recently heard from Josh Berkus that at least one major CMS
application uses Postgres to store entire HTML pages (including image
files) in order to support full versioning.
As a general rule, I prefer not to store BLOBS in a DB- I'd rather
leave the BLOB in the file system and let the db save
My guess is that when you insert into Cities, the sequence field is
incremented one time (=2), and when the Rule is executed to insert
into Capital, the sequence is incremented a second time (=3). As a
result of these 2 operations, the sequence is incremented 2 times.
I don't know anything about
Marcel,
A sequence represents a unique identifier. You can call the function
'nextval' to get the next unique value in the sequence. See related
functions here:
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html
In this code, I get the next sequence, insert it into a table,
I find it fine. Bit different usage though.
I store about 200 50MB items.
Allan
> Hi All!
>
> Question is : How suitable PG for storing about 2 000 000
binary files
> 0,5-2,0 Mb size each ? It is not planned the big number of
clients or a
> plenty of updatings. Like photoalbum on local host
One other thing about this issue. A work around is that I can parse sql
statements myself to come up with the table names. Yes, it's a bit of
work, but not too bad. My question is whether or not column/table
combinations are guaranteed to return in the order that the table names
appear in a
On 04.04.2007, at 16:55, Jamie Deppeler wrote:
Is this a safe setting for g5 1gig ram Os 10.4.9
sysctl -w kern.sysv.shmmax=167772160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
Why shouldn't it be safe?
cug
---
This is with 8.1.8, but I don't see any mention of any bug fixes that
cover this.
I've run into this sort of obscure problem. I'm using libpq with a
front end database api where I need to track column names and how
they're returned in libpq queries. What's happening is that I start out
with
On Wednesday April 4 2007 5:37 pm, Bruce Momjian wrote:
> > Perhaps this could be added to the TODO list? I won't get
> > to it anytime soon.
>
> Yes. What should the TODO text be?
See if the attached patch is acceptable. If not, perhaps the
TODO text should be:
Enable end user to identify de
Is this a safe setting for g5 1gig ram Os 10.4.9
sysctl -w kern.sysv.shmmax=167772160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
---(end of broadcast)---
TIP 9: In versio
Hello All,
Recently I experienced the strange PG behaviour with the large tables in
PG 8.2.3 which I didn't have in 8.1:
I have the large table: around 1 million records and around 400 columns.
When I try to run VACUUM ANALYZE on it, I'm getting the message:
WARNING: relation "public.xx" con
Ed L. wrote:
> On Wednesday April 4 2007 5:02 pm, Alvaro Herrera wrote:
> > > I guess if the bug were fixed, it'd be a non-issue.
> >
> > Sure, please submit a patch. ?It should not be too difficult.
>
> Perhaps this could be added to the TODO list? I won't get to it
> anytime soon.
Yes. What
On Wednesday April 4 2007 5:02 pm, Alvaro Herrera wrote:
> > I guess if the bug were fixed, it'd be a non-issue.
>
> Sure, please submit a patch. It should not be too difficult.
Perhaps this could be added to the TODO list? I won't get to it
anytime soon.
Ed
---(end o
Ed L. wrote:
> On Wednesday April 4 2007 4:48 pm, Alvaro Herrera wrote:
> > > Yes, but how do identify what they are so that I know if I
> > > want to DROP OWNED them?
> >
> > There's no way AFAICT, short of peeking the catalogs (or
> > information_schema). Try pg_shdepend.
>
> I guess if the bug
On Wednesday April 4 2007 4:48 pm, Alvaro Herrera wrote:
> > Yes, but how do identify what they are so that I know if I
> > want to DROP OWNED them?
>
> There's no way AFAICT, short of peeking the catalogs (or
> information_schema). Try pg_shdepend.
I guess if the bug were fixed, it'd be a non-is
Ed L. wrote:
> On Wednesday April 4 2007 4:39 pm, Ed L. wrote:
> > On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
> > > Note that you can give the objects owned by that role to
> > > someone else with REASSIGN OWNED, and drop the objects with
> > > DROP OWNED (note that they act different
Sergei Shelukhin wrote:
> 1) Do I understand it correctly that cross database queries are not
> possible?
Yes.
> 2) What's the difference between unlimited length varchar and text
> columns?
Mostly only the spelling.
> 3) Will adding "deferrable" to FKs that reference very large tables
> speed
marcel.beutner wrote:
> I've searched in the groups already, but couldn't find any helpful
> information - only to use a sequence, which returns just a number and
> not a unique identifier.
Which properties do your unique identifiers posses that are not
satisfied by a number returned by a sequenc
Ed--
check out REASSIGN OWNED
http://www.postgresql.org/docs/current/static/sql-reassign-owned.html
then use CASCADE option of DROP OWNED to drop dependents
e.g.
DROP OWNED BY FUBAR CASCADE
http://www.postgresql.org/docs/current/static/sql-drop-owned.html
HTH,
Martin --
This email message and
Ed L. wrote:
> On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
> >
> > Note that you can give the objects owned by that role to
> > someone else with REASSIGN OWNED, and drop the objects with
> > DROP OWNED (note that they act differently regarding grants;
> > see the docs)
>
> Yes, but h
On Wednesday April 4 2007 4:41 pm, Ed L. wrote:
> On Wednesday April 4 2007 4:39 pm, Ed L. wrote:
> > On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
> > > Note that you can give the objects owned by that role to
> > > someone else with REASSIGN OWNED, and drop the objects
> > > with DROP
On Wednesday April 4 2007 4:39 pm, Ed L. wrote:
> On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
> > Note that you can give the objects owned by that role to
> > someone else with REASSIGN OWNED, and drop the objects with
> > DROP OWNED (note that they act differently regarding grants;
>
On Wednesday April 4 2007 4:35 pm, Alvaro Herrera wrote:
>
> Note that you can give the objects owned by that role to
> someone else with REASSIGN OWNED, and drop the objects with
> DROP OWNED (note that they act differently regarding grants;
> see the docs)
Yes, but how do identify what they are
Ed L. wrote:
> This is pgsql 8.2.3:
>
> % psql -c "drop role mygroup"
> ERROR: role "mygroup" cannot be dropped because some objects
> depend on it
> DETAIL: 227 objects in this database
>
> How do I identify what these dependent objects are?
Hum, this seems to be a bug. The objects are supp
This is pgsql 8.2.3:
% psql -c "drop role mygroup"
ERROR: role "mygroup" cannot be dropped because some objects
depend on it
DETAIL: 227 objects in this database
How do I identify what these dependent objects are?
I've removed all of the users from this group, turned up server
logging to deb
Any suggestions for finding out where all the time is being spent? I'm
- time spent updating indexes ? do you have a lot of them ?
- try with fsync off (not in production, but it will give you an idea)
---(end of broadcast)---
TI
You don't like filesystems ?
On Wed, 04 Apr 2007 07:44:57 +0200, Nikolay Moskvichev <[EMAIL PROTECTED]>
wrote:
Hi All!
Question is : How suitable PG for storing about 2 000 000 binary files
0,5-2,0 Mb size each ? It is not planned the big number of clients or a
plenty of updati
Hi All!
Question is : How suitable PG for storing about 2 000 000 binary files
0,5-2,0 Mb size each ? It is not planned the big number of clients or a
plenty of updatings. Like photoalbum on local host.
---(end of broadcast)---
TIP 3: Have you c
/*I'm learning how to use the partion in Postgres 8.2.3 so I want to
do some test for my awareness.
I create 2 tables:
The parent table is cities:*/
CREATE TABLE xxx.cities
(
id serial NOT NULL,
name text,
population real,
altitude integer,
CONSTRAINT pk_cities PRIMARY KEY (id)
)
/*an
The problem with this approach is really that the tracker + website
combination is designed to show really detailed statistics for every
user on every torrent, which (as you mentioned) complicates things a
great deal. It's also able to store all the history information for all
the clients, whic
Retrying after subscribing... got a "delayed delivery message" earlier.
Hi,
I have the following requirements, and I want to do them without shutting
down postgres. Any help appreciated.
1. Get a list of connections to the postgres server
2. Disconnect some/all connections from postgres
3.
I think it's something like SELECT 'md5' + md5(password + username);
Regards,
Ben
"Thorsten Kraus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
This would be a possible way. Now the question is which algorithm
implementation of md5 PostgreSQL uses...
Bye,
Thorsten
Ben
1) Do I understand it correctly that cross database queries are not
possible? Two dbs on the same server are used in this case.
2) What's the difference between unlimited length varchar and text
columns? I am mostly interested in performance, namely = 'blah' and
like '%blah%' queries over these co
Hi,
I have the following requirements, and I want to do them without shutting
down postgres. Any help appreciated.
1. Get a list of connections to the postgres server
2. Disconnect some/all connections from postgres
3. I modified the pg_hba.conf to block a particular user from connecting to
Hello NG,
Is there an equivalent in postgres for the newid() function like in
sqlserver? I need to generate a unique identifier in my select
statement:
SELECT "X", newid(), "Y" FROM "MyTable"
X
newid()
Y
On Apr 3, 2007, at 10:33 AM, A. Kretschmer wrote:
am Tue, dem 03.04.2007, um 7:19:15 -0700 mailte [EMAIL PROTECTED]
folgendes:
I need to do like 1000 inserts periodically from a web app. Is it
better to do
1000 inserts or 1 insert with the all 1000 rows? Is using copy
command faster
tha
Tom Lane wrote:
You're focusing on the wrong thing --- there's nothing wrong with the plan.
It's only taking 9 seconds to perform the merge join. The other 183
seconds are going somewhere else; you need to find out where.
One thing that came to mind was triggers, which would be shown in the
EX
Who dreads PL/pgSQL? It's a pretty easy language to learn. Granted, not
as easy as one you already know, but I'm not aware of any RDBMS that
supports C# as a stored procedure language.
I needd to re-write a lot of compliatated SQL select statements to run them
in server which generate reports.
Albe Laurenz wrote:
> You can connect as superuser on a different connection and issue that
> SELECT statement.
OK
> But I wouldn't do that. What if there is a problem and all availaible
> superuser connections are exhausted? You would not be able to connect
> to the database any more, even as s
Martijn van Oosterhout wrote:
> To use the superuser connections you need to login as superuser...
Eh... OK. I feel a bit stupid :) Thanks ;)
Iv
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, Apr 04, 2007 at 11:34:22AM +0200, Tommy Gildseth wrote:
> >For the record, this is what the SQL MERGE command is for... I don't
> >think anyone is working on implementing that though...
> >
> This will possibly provide a solution to this question:
> http://www.postgresql.org/docs/current/
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Froggy / Froggy Corp. wrote:
>> pg_dump: ERREUR: Impossible d'accéder au statut de la transaction
>> 892415538
> What files are there in main/pg_clog?
Doesn't really matter --- I'd say it's pretty obviously a data corruption
problem. That value equat
Alvaro Herrera wrote:
>
> Froggy / Froggy Corp. wrote:
> >
> >
> > Alvaro Herrera wrote:
> > >
> > > Froggy / Froggy Corp. wrote:
> > > > Hello everyone,
> > > >
> > > > It is the second time i got this error message (sorry, its french, i
> > > > prefer to c/p this one than making a bad translat
Froggy / Froggy Corp. wrote:
>
>
> Alvaro Herrera wrote:
> >
> > Froggy / Froggy Corp. wrote:
> > > Hello everyone,
> > >
> > > It is the second time i got this error message (sorry, its french, i
> > > prefer to c/p this one than making a bad translation) :
> > >
> > > ---8<8<--
Alvaro Herrera wrote:
>
> Froggy / Froggy Corp. wrote:
> > Hello everyone,
> >
> > It is the second time i got this error message (sorry, its french, i
> > prefer to c/p this one than making a bad translation) :
> >
> > ---8<8<---8<---
> >
> > pg_dump: ERREUR: Im
On 03.04.2007, at 23:00, Jamie Deppeler wrote:
Is it possible to set shared memory settings on the fly in OS X
like you can in Linux e.g. sysctl -w kernel.shmmax=134217728
If this wasn't changed recently - no you can't.
If you use /etc/sysctl.conf make sure it is loaded in /etc/rc before
t
Froggy / Froggy Corp. wrote:
> Hello everyone,
>
> It is the second time i got this error message (sorry, its french, i
> prefer to c/p this one than making a bad translation) :
>
> ---8<8<---8<---
>
> pg_dump: ERREUR: Impossible d'accéder au statut de la transac
I can't use triggers because I need a specific "my_id".
Here's the scenario: a user is browsing the web page for portfolio_id =
3, and wants to update the values. He uploads a CSV file, and I need its
entries to be tagged with portfolio_id = 3, as another user could be
uploading a CSV file for
I agree that with a temp table, the portfolio_id could be cleanly
inserted as you suggest, from the temp table into the staging table. The
staging table would need a portfolio_id, since it could house data from
several different spreadsheets at the same time. In fact, the staging
table could be
Hello everyone,
It is the second time i got this error message (sorry, its french, i
prefer to c/p this one than making a bad translation) :
---8<8<---8<---
pg_dump: ERREUR: Impossible d'accéder au statut de la transaction
892415538
DETAIL: Impossible d'ouvrir l
Martijn van Oosterhout wrote:
On Mon, Apr 02, 2007 at 08:24:46PM -0700, Steve Gerhardt wrote:
I've been working for the past few weeks on porting a closed source
BitTorrent tracker to use PostgreSQL instead of MySQL for storing
statistical data, but I've run in to a rather large snag. The tra
Is it possible to set shared memory settings on the fly in OS X like you
can in Linux e.g. sysctl -w kernel.shmmax=134217728
I have tried sysctl -w kern.sysv.shmmax=134217728 with no luck, i know you can edit /etc/sysctl.conf file.
But i would sooner set these settings as part of the postgresql
58 matches
Mail list logo
