Should help --> ALTER TABLE tablename ALTER columname TYPE text;
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/20/07, Kelly Burkhart <[EMAIL PROTECTED]> wrote:
On 1/19/07, Martijn van Oosterhout wrote:
>
> ALTER TABLE, to be correct, actually has to check the entire tab
Please find answers to your questions below:
1.) Would running Postgre and SQL Server on the same machine cause any
conflict with each other (other then competing for
CPU/Memory)
I don't think so that will be a problem except that it is not always a good
idea to keep two database servers on
I don't think he's looking for progress information, I think he is
looking to be able to insert in chunks, which I don't know much about,
but I think the some of the binary types (bytea or blob) support this.
Anyone?
Bruce Momjian wrote:
Sorry, I know of no way to get a status bar that shows
On Fri, Jan 19, 2007 at 18:20:47 -0500,
Jeremy Haile <[EMAIL PROTECTED]> wrote:
> That's interesting. So if you have a composite index on two columns, is
> there much of a reason (usually) to create single indexes on each of the
> two columns? I guess the single indexes might be slightly faster
On 1/19/07, Martijn van Oosterhout wrote:
ALTER TABLE, to be correct, actually has to check the entire table to
make sure it's ok. By doing it directly you're basically telling the DB
it's OK.
For making a varchar column longer it's safe though, and the easiest way.
Is it possible to use a s
The following location contains PostgreSQL C functions for generating
lanmanager and ntlm password hashes. Feel free to use as you see fit.
http://www.yellowbank.com/code/PostgreSQL/y_ntlm/
Best.
--
Ron Peterson
https://www.yellowbank.com/
---(end of broadcast)-
On Fri, Jan 19, 2007 at 15:22:12 -0500,
Jan Muszynski <[EMAIL PROTECTED]> wrote:
> If I have an index that's composed of 2 columns:
> Index index1 on tableA (foo,bar)
>
> and I then:
> Select cola, colb from tableA where foo=
>
> Will index1 still be used, or am I looking at a seqscan u
On Fri, Jan 19, 2007 at 18:24:32 +0200,
Andrus <[EMAIL PROTECTED]> wrote:
> > It might make more sense to use your own table of users and hashed
> > passwords
> > rather than postgres'. This would depend somewhat on the overlap of users
> > who
> > are using your application and those who conne
Sorry, I know of no way to get a status bar that shows how far the an
INSERT or COPY has progressed. People have asked for it, but no one has
any idea how to implement it.
---
Benedict Faria wrote:
> Hello,
> my customer, n
On Fri, 19 Jan 2007 13:51:18 -0500, Merlin Moncure wrote:
> one second it took to move the mail to my spam folder. Yes, we all know
> how annoying and stupid spam is but there is a human element here that
> puts things in slightly different light, don't you think?
Absolutely! I'd like to know ho
> Rather simple question, of which I'm not sure of the answer.
>
> If I have a multiple column index, say:
> Index index1 on tableA (foo,bar)
>
> and I then:
> Select * from "tableA" where foo =
>
> Will index1 be used, or am I looking at a seqscan in all circumstances?
>
> TIA
> -jan m
R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yes, it depends.
Given the example from OP, if you have queries that only reference
field bar, then the query optimizer will do a seqscan on the table.
You would need a separate index on "bar"
And, given index1, you do not need another index on "foo
If I have an index that's composed of 2 columns:
Index index1 on tableA (foo,bar)
and I then:
Select cola, colb from tableA where foo=
Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?
TIA
-jan m
---(end of broadcast)-
Hello,
my customer, ntl:Telewest is using an open source 'file upload progress
bar' called NeatUpload to help users to upload video files to a MS SQL
database. They want to replace the MS SQL database with
Solaris/PostgreSQL and ZFS.
There is an extension to NeatUpload that enables this to wo
G'day folks,
I'm faily new to the world of Postgre so excuse me if these questions seem ignorant.
My current employer develops a software package which runs on OpenVMS on HP Alpha/Itanium servers and contains a custom
database comprised of various format text and binary files. I.e. not in a r
[EMAIL PROTECTED] wrote:
> Thanks. Am I correct in assuming that this scanning of the entire
> table is done when I use the 'ALTER TABLE' command and not something I
> must do after it's done?
Yes, ALTAR TABLE ... scans through the entire table when it does the
update, it's not something you ne
> It might make more sense to use your own table of users and hashed
> passwords
> rather than postgres'. This would depend somewhat on the overlap of users
> who
> are using your application and those who connect directly to the database.
> If there isn't much overlap, having a separate table is
Toni Casueps wrote:
>
>
> I have a set of tables with one-to-many relationships between them:
>
> T1 <-->> T2 <-->> T3 <-->> T4
>
> I need to copy some rows of these tables to another set of tables which
> have
> the same fields. There are two rows on T1 that I want to copy, and then
> thos
I am using LinuxHA to manage the failover and Slony as part of to
failover to move to the healthy node. But my question was more along
the lines, if a user has access to both databases (master and slave)
but does not know which one is which, how can you tell?
Take a scenario: you configure 2 serv
That's interesting. So if you have a composite index on two columns, is
there much of a reason (usually) to create single indexes on each of the
two columns? I guess the single indexes might be slightly faster
depending on the number of different values/combinations, so probably
"it depends" eh?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/19/07 15:53, Jan Muszynski wrote:
> Rather simple question, of which I'm not sure of the answer.
>
> If I have a multiple column index, say:
> Index index1 on tableA (foo,bar)
>
> and I then:
> Select * from "tableA" where foo =
>
> W
Darcy Buskermolen wrote:
[snip]
Another thought, is it at all possible to do a partial vacuum? ie spend the
next 30 minutes vacuuming foo table, and update the fsm with what hew have
learned over the 30 mins, even if we have not done a full table scan ?
There was a proposal for this, but
Rather simple question, of which I'm not sure of the answer.
If I have a multiple column index, say:
Index index1 on tableA (foo,bar)
and I then:
Select * from "tableA" where foo =
Will index1 be used, or am I looking at a seqscan in all circumstances?
TIA
-jan m
-
Added to TODO:
> o Allow multiple vacuums so large tables do not starve small
> tables
>
> http://archives.postgresql.org/pgsql-general/2007-01/msg00031.php
>
> o Improve control of auto-vacuum
>
> http://archives.postgresql.org/pgsql-hackers/2006-12/msg00876.p
Hi,
On Fri, 2007-01-19 at 12:52 -0800, Dianne Yumul wrote:
> I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
> it, postgresql won't start. I get the following error: "An old
> version of the database format was found" My previous postgresql
> version was 8.0.8 and I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/19/07 11:51, Guy Fraser wrote:
> On Thu, 2007-01-18 at 17:48 -0800, Richard Troy wrote:
>> On Thu, 18 Jan 2007, Joshua D. Drake wrote:
[snip]
> I feel that all @en25.com and @enterprisedb.com should be
> considered for banning from the PostgreSQ
Hello list,
I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
it, postgresql won't start. I get the following error: "An old
version of the database format was found" My previous postgresql
version was 8.0.8 and I read nothing on the release notes about a
dump/resto
> d'oh! that was just a transcription error though...if you create f()
> returning bigint and immutable it produces the same results.
So I see. But...
pedcard=# create function f2() returns boolean as $$ begin return 't'; end;
$$ language plpgsql immutable;
CREATE FUNCTION
pedcard=# create funct
On 19 Jan 2007 12:12:34 -0800, Karen Hill <[EMAIL PROTECTED]> wrote:
Alan Hodgson wrote:
> On Thursday 18 January 2007 15:54, Steve Atkins <[EMAIL PROTECTED]> wrote:
> > Anyone else get spam from EnterpriseDB today, talking about
> > "Postgresql Support Services"?
> >
>
> yep. You really would t
On 1/19/07, Scott Ribe <[EMAIL PROTECTED]> wrote:
> Also, somebody correct me if I'm off my rocker here, but immutable
> procedures are re-evaluated for each execution...they are just folded
> into a constant during plan phase.
You would need to actually create an immutable function in order to
Alan Hodgson wrote:
> On Thursday 18 January 2007 15:54, Steve Atkins <[EMAIL PROTECTED]> wrote:
> > Anyone else get spam from EnterpriseDB today, talking about
> > "Postgresql Support Services"?
> >
>
> yep. You really would think that even the marketing weenies might know
> better by now.
I do
I thought as much.
Thanx for the reply,
Garth
Merlin Moncure wrote:
On 1/19/07, Garth Keesler <[EMAIL PROTECTED]> wrote:
I have a primary key made up of two varchar(128) columns, typically less
than 16 chars each. Concatenating the two columns would still be unique.
Would it make sense to conc
> Also, somebody correct me if I'm off my rocker here, but immutable
> procedures are re-evaluated for each execution...they are just folded
> into a constant during plan phase.
You would need to actually create an immutable function in order to test how
immutable functions work ;-) And apparently
On 1/19/07, Garth Keesler <[EMAIL PROTECTED]> wrote:
I have a primary key made up of two varchar(128) columns, typically less
than 16 chars each. Concatenating the two columns would still be unique.
Would it make sense to concat the two columns, using a unique separator
like '~' and index on that
I have a primary key made up of two varchar(128) columns, typically less
than 16 chars each. Concatenating the two columns would still be unique.
Would it make sense to concat the two columns, using a unique separator
like '~' and index on that single column or would that be more trouble
than t
> SPAM is a term used for unsolicited email of any kind... sent to a large
number...
Thus the use of the word "bulk".
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)---
TIP 3: Have you check
Is it feasible to add a "reindex concurrently" that doesn't lock the
table for the rebuild, then locks the table when doing a second pass to
pickup rows that were changed after the first pass? Or something like
that
On Fri, 19 Jan 2007 12:45:03 -0500, "Tom Lane" <[EMAIL PROTECTED]> said:
> "E
On 1/18/07, Scott Ribe <[EMAIL PROTECTED]> wrote:
Is there a way to force a flush of all cached plans? Particularly, to force
re-evaluation of immutable stored procedures? Don't worry, it's a testing &
development thing, not something I want to do during production ;-)
Also, somebody correct me
Howard Cole <[EMAIL PROTECTED]> writes:
> If I try the following query:
> delete from operator where operator_id=283;
> I get the following error message:
> ERROR: could not open relation with OID 438427
> SQL state: XX000
> Context: SQL statement "UPDATE ONLY "public"."timesheet_booking" SET
On 1/19/07, Guy Fraser <[EMAIL PROTECTED]> wrote:
I feel that all @en25.com and @enterprisedb.com should be
considered for banning from the PostgreSQL mailing lists without
a better apology than has been given to date:
Thats a bit harsh IMO. Many of the enterprisedb people are active
contribut
On Thu, 2007-01-18 at 12:21 -0700, Scott Ribe wrote:
> > Start a fresh connection.
>
> OK. Better than having to restart the whole server, which is what I was
> doing...
>
Just to clarify, you don't have to restart the whole server. All you
have to do is disconnect the client, and reconnect.
Re
On Fri, 19 Jan 2007, Guy Fraser wrote:
> > Josh, under the law, that's not spam. Individually written emails are
> > never spam even if they may be "unsolicited sales material." So, rest
> > assured.
> >
> > Richard
> >
> You are oh so wrong in so many ways.
>
> SPAM is a term used for unsolicite
On Thu, 2007-01-18 at 17:48 -0800, Richard Troy wrote:
> On Thu, 18 Jan 2007, Joshua D. Drake wrote:
> > >
> > > Spam is spam. I don't care what they're selling. Anyone dumb enough to
> > > send spam in 2006 should be fired on the spot.
> >
> > That is a bit extreme. One persons SPAM is another p
"Stockho, Jonathan W " <[EMAIL PROTECTED]> writes:
> createuser: could not connect to database postgres: could not connect to
> server: No such file or directory
> Is the server running locally and accepting connections on
> Unix domain socket "/tmp/.s.PGSQL.0"?
".0"? That suggests th
"Ed L." <[EMAIL PROTECTED]> writes:
> Online index creation definitely helps us toward 24x7. But
> wouldn't we still have to drop the old index, thus blocking
> production queries?
Yes, but only for a very short period.
regards, tom lane
---(end
I ran into a similar problem and the solution I came up with (which
admittedly feels like a kludge) was to temporarily disable the triggers
on the table being modified while an update was made and then
re-enabling them immediately after the update. I am sure there is
potential for problems with t
On Friday January 19 2007 2:11 am, Csaba Nagy wrote:
>
> > I afraid I don't see how any of the answers I saw discussed
> > fit a 24x7 operation. Reindex, drop index, vacuum full, ...
> > they all block production queries of one sort or another for
> > significant periods of time (minutes) on large
Martijn van Oosterhout writes:
> On Thu, Jan 18, 2007 at 10:08:24PM +0100, Peter Kovacs wrote:
>> Are the plans cached per connection? Why not globally?
> Because global plan caching is much harder and nobody has done it yet?
The idea's been discussed before, and there are at least three problem
Hi All,
I am getting an error I do not understand from the following setup
CREATE TABLE timesheet_booking
(
timesheet_booking_id bigserial NOT NULL,
operator_id integer,
booking_item_id integer,
"day" date NOT NULL,
minutes integer NOT NULL,
CONSTRAINT timesheet_booking_pkey PRIMARY KEY (t
A thousand words. I like the brevity of this post:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
Can't really argue with it.
- Ian
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
On Fri, Jan 19, 2007 at 09:31:49 +0100,
Bertram Scharpf <[EMAIL PROTECTED]> wrote:
> Hi,
>
> looking at the source code I find out that this works:
>
> sandbox=# create role joe login password 'verysecret';
> CREATE ROLE
> sandbox=# create function validate_user_8_1(text,text) returns boo
On Friday 19 January 2007 01:47, Simon Riggs wrote:
> On Tue, 2007-01-16 at 07:16 -0800, Darcy Buskermolen wrote:
> > On Tuesday 16 January 2007 06:29, Alvaro Herrera wrote:
> > > elein wrote:
> > > > Have you made any consideration of providing feedback on autovacuum
> > > > to users? Right now we
>> That would explain everything. Except why it's a VARCHAR instead of
>> DATE. But that's a whole 'nother discussion.
>
> As I understood OP, it's a staging table :)
Right. And it's exactly because the original source has bogus data that I
need a staging table to load it up and study it and fi
On Fri, Jan 19, 2007 at 09:31:49AM +0100, Bertram Scharpf wrote:
> Hi,
>
> looking at the source code I find out that this works:
> May I rely on this in future versions or are there more
> sophisticated ways to do it?
Umm, how much more sophisticated do you want? It's more sophicticated
than
On Thu, Jan 18, 2007 at 08:02:58PM -0700, Michael Fuhr wrote:
> On Thu, Jan 18, 2007 at 06:14:23PM -0800, Joshua D. Drake wrote:
> > http://www.commandprompt.com/ :) We are more cost effective and have
> > been doing it for much, much longer ;)
>
> As somebody with a measure of influence over Pos
Thats exactly what I'm facing here.
CREATE OR REPLACE FUNCTION test(int4)
RETURNS int4 AS
$BODY$
require "abc.pl"
$BODY$
LANGUAGE 'plperlu' VOLATILE;
SELECT test(23) doesn't run the script inside abc.pl that happens to
be a some insert statements.
Now, when i actually copy and paste t
On Thu, Jan 18, 2007 at 10:08:24PM +0100, Peter Kovacs wrote:
> Are the plans cached per connection? Why not globally?
Because global plan caching is much harder and nobody has done it yet?
If you use something like pgpool, you ofcourse get the advantages of
cached plans across multiple sessions,
On Thu, Jan 18, 2007 at 06:27:04AM -0800, [EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] wrote:
> > Using ALTER TABLE ALTER TYPE VARCHAR() to
> > change the size requires scanning the entire table. For large tables,
> > this will be much slower than the pg_attribute query. Both will get
> > the j
As written in documentation "Slony-I does not provide any automatic
detection for failed systems. "
First of all, you may want to upgrade to the latest stable slony1 version.
But if you have a combination of Slony + Linux HA you can make use of Slony
failover to do an automatic failover when the
Hello,
You should ask directly to the slony1 mailing list.
[EMAIL PROTECTED] a écrit :
> (...) The Slony version I'm using is 1.1.2.
The current version of Slony1 is slony1-1.2.6.
> Take a scenario that
> you want to check the state of the system without prior knowledge of
> the node setup, how w
On Tue, 2007-01-16 at 07:16 -0800, Darcy Buskermolen wrote:
> On Tuesday 16 January 2007 06:29, Alvaro Herrera wrote:
> > elein wrote:
> > > Have you made any consideration of providing feedback on autovacuum to
> > > users? Right now we don't even know what tables were vacuumed when and
> > > what
[snip]
> I afraid I don't see how any of the answers I saw discussed fit a
> 24x7 operation. Reindex, drop index, vacuum full, ... they all
> block production queries of one sort or another for significant
> periods of time (minutes) on large (multi/tens of GB) tables,
> and thus are infeasibl
On Thu, Jan 18, 2007 at 05:40:27AM -0800, Ole Laurisch wrote:
> Hello,
>
> I would like to install PGSQL on Windows XP and would like to change
> the default directory for the data as I would prefer to have my
> databases on a specific partition and not on my programm partitition.
> What do I have
Stockho, Jonathan W wrote:
I'm new to postgres, so bare with me.
I installed version 8.2 from rpms on Suse 10.
I then changed to the postgres user and ran initdb.
After that I create a database called movies using the command "createdb
movies"
Then I used the pg_ctl command to start the postm
Hi,
looking at the source code I find out that this works:
sandbox=# create role joe login password 'verysecret';
CREATE ROLE
sandbox=# create function validate_user_8_1(text,text) returns boolean
immutable language 'sql' as $$ select 'md5'||md5($2||$1) = rolpassword from
pg_authid where
Vinesh, Raghavan wrote:
Hello,
PostgreSQL version: 8.2.1
OS: Windows 2003 Server / Windows XP Professional
When I try installation of PostgreSQL by providing an admin account for
postgresql service user the installation fails. According to the release
notes of PostgreSQL 8.2 this is supported.
66 matches
Mail list logo
