Hi,
Am Donnerstag, 15. Mär 2007, 15:38:56 +0100 schrieb A. Kretschmer:
> am Wed, dem 14.03.2007, um 1:24:01 -0700 mailte Arkan folgendes:
> > have anybody installed PgSQL on Windows Vista? [...]
>
> Someone write this about vista:
>
> 1. Disable UAC
> 2. EnableAdministrator account
> 3. Login
On 3/16/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
just wondeng why doesn't it let me put
my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask;
host=192.168.0.120; port=5432;", "", "");
in eval
you dont need to put ->connect in eval.
just set connect option 'raiseerror' to 0 (and printerror as
On 3/16/07, louis gonzales <[EMAIL PROTECTED]> wrote:
I want to write a statement-level trigger - one that happens once per
statement - such that, immediately after an insert into a table(which
gets a unique integer value as an ID from a defined sequence, being the
primary key on the table), a ne
Jeff Davis <[EMAIL PROTECTED]> writes:
> The planner chooses what looks to me like a very strange plan for this
> query:
Exactly which PG version is this?
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to inc
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> Joshua D. Drake escribió:
>> Tom Lane wrote:
>> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> >> Erik Jones wrote:
>> >>> I really hope you meant upgrades to 8.2.x. And, no, it's not worth
>> >>> waiting. Upgrade at the soonest available opportuni
Hello.
When we start using of any replication system (e.g. Slony) we need to create
a "read-only" role for access the database. This role must be able to read
anything, but should NOT be able to INSERT, UPDATE or DELETE for all
database objects.
Overall, we need 3 roles:
1. Administrator: can d
On Mar 15, 2007, at 10:22 AM, Alvaro Herrera wrote:
He could wait for 8.4 as well, as it will be probably faster and have
more features than 8.3. Following your reasoning, one could wait
essentially forever.
H... precisely the reason my cell phone hasn't been replaced in a
long tim
I have two indexes defined on "syslog_p":
"syslog_p_severity_ts_idx" btree (severity, ts)
"syslog_p_ts_where_severity_1_idx" btree (ts) WHERE severity = 1
The planner chooses what looks to me like a very strange plan for this
query:
=> explain analyze select * from syslog where severity=1;
QUER
On Mar 16, 2007, at 3:48 PM, Jeff Davis wrote:
To clarify a little:
No clarifcation needed. Joshua Drake's suggestion made perfect sense
and I was able to implement in 2 seconds.
works like a charm!
ETA 2 weeks -> 30mins
Thanks to all.
// Jonathan Vanasco
| - - - - - - - - - - - - -
On Fri, 2007-03-16 at 12:17 -0700, Joshua D. Drake wrote:
> >
> > QUERY PLAN
> > ---
On Fri, 2007-03-16 at 14:20 -0400, Jonah H. Harris wrote:
> As Ezequias asked about migrating an application, I'm not quite sure
> why we're discussing this. Using HSODBC to move data permanently is
> quite good assuming you have no data type issues.
I missed the OP and therefore the link to ap
On Mar 16, 2007, at 2:06 PM, Bruce McAlister wrote:
Hi All,
Okay, I'm getting a little further now. I'm about to create entries
in the
pg_autovacuum system tables. However, I'm a little confused as to
how I go
about finding out the OID value of the tables. The pg_autovacuum table
requires
>
> QUERY PLAN
> -
>
> Seq Scan on table_a (cost=
if you have time, could you offer advice on this:
i'm doing a database cleanup right now -- 1.4M records -- and each
query is taking 1 second
i can't really wait 2 weeks for this to finish , so I'm hoping that
someone will be able to help out
the issue is that the planner keeps doing a se
Hi All,
Okay, I'm getting a little further now. I'm about to create entries in the
pg_autovacuum system tables. However, I'm a little confused as to how I go
about finding out the OID value of the tables. The pg_autovacuum table
requires the OID of the table you want to create settings for (vac
On 3/16/07, David Fetter <[EMAIL PROTECTED]> wrote:
DBI-Link has a way to push predicates to the remote side, ...
As Ezequias asked about migrating an application, I'm not quite sure
why we're discussing this. Using HSODBC to move data permanently is
quite good assuming you have no data type
On Fri, Mar 16, 2007 at 10:18:56AM -0700, Reece Hart wrote:
> On Thu, 2007-03-15 at 16:20 -0400, Robert Treat wrote:
> > Do you find [HSODBC] works well? I've used it from some older
> > Oracle instances connecting back into PostgreSQL and the results I
> > had have been flakey at best.
>
> - The
On Thu, 2007-03-15 at 16:20 -0400, Robert Treat wrote:
> Do you find [HSODBC] works well? I've used it from some older Oracle
> instances connecting back into PostgreSQL and the results I had have
> been flakey at best.
For us too. We tried in early 2006 with Oracle 8 via hsodbc to
postgresql 7.4
On Windows Server 2003, if you create a tablespace to a location that
doesn't exist, then try to remove that tablespace, you get an error that
pg_tblspc/# does not exist. It appears that postgres created the
tablespace internally, but not the folder. When you try to drop the
tablespace, t
> "Douglas" == Douglas McNaught <[EMAIL PROTECTED]> writes:
Douglas> my $dbh;
Douglas> eval { $dbh = connect(...) };
Since eval returns its value (or undef if $@ has the error), you can shorten
this to:
my $dbh = eval { DBI->connect(...) };
and now either look at $@ (if you want to disting
Tony Caduto <[EMAIL PROTECTED]> writes:
> I don't think the whole --output-version thing would be a good idea
> either, but it would be a simple matter to add some logic for the
> GRANT ON SEQUENCE, which seems to be the only thing that is really
> causing problems at least between 8.1 and 8.2.
Joshua D. Drake wrote:
other deficiencies let's not add to complexity by having an
--output-version.
If you want that, create a wrapper program that calls to different
statically compiled versions of pg_dump.
Joshua D. Drake
I am afraid that I have to agree with Tom here. Pg_dump has plent
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> just wondeng why doesn't it let me put
> my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120; port=5432;",
> "", "");
> in eval
>
> says
> Global symbol "$dbh" requires explicit package name at line used>
The my() variable goes ou
On Fri, Mar 16, 2007 at 10:54:49AM -0400, Jasbinder Singh Bali wrote:
> just wondeng why doesn't it let me put
> my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120;
> port=5432;", "", "");
> in eval
>
> says
> Global symbol "$dbh" requires explicit package name at line is used>
Wel
You'll want something like this:
my $dbh = eval { DBI->connect();};
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jasbinder Singh
Bali
Sent: Friday, March 16, 2007 9:55 AM
To: Martijn van Oosterhout; Tom Lane; pgsql-general@postgresql.org
Subje
On Mar 16, 2007, at 10:54 , Jasbinder Singh Bali wrote:
just wondeng why doesn't it let me put
my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120;
port=5432;", "", "");
in eval
says
Global symbol "$dbh" requires explicit package name at line ever dbh is used>
There is a ma
On 3/16/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Robin Ericsson" <[EMAIL PROTECTED]> writes:
> Yes, I've looked at those, I was thinking that point looked like a
> good type, but it's only 2d, so maybe I need a hint on how to use this
> in a 3d environment.
Yeah, the built-in geometric types are
just wondeng why doesn't it let me put
my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120;
port=5432;", "", "");
in eval
says
Global symbol "$dbh" requires explicit package name at line
Jas
On 3/16/07, Martijn van Oosterhout wrote:
On Thu, Mar 15, 2007 at 10:06:06PM -0400, Jas
It's about $20,000 cheaper than ISO (ISA? IEC? One of those TLAs.)
certification. Industrial engineering.
CSIA is industrial control certification:
http://www.controlsys.org/
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent
"Robin Ericsson" <[EMAIL PROTECTED]> writes:
> Yes, I've looked at those, I was thinking that point looked like a
> good type, but it's only 2d, so maybe I need a hint on how to use this
> in a 3d environment.
Yeah, the built-in geometric types are all 2D. If you need 3D, perhaps
PostGIS can help
louis gonzales wrote:
Is it better to have 1 monolithic table and have to search it, or
small individual tables but many of them?
Ron Johnson wrote:
Yes, 1 large table. This is what RDMS were designed for.
---(end of broadcast)---
TIP 1: if p
On Mar 15, 2007, at 9:08 PM, Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
Basically I need a way for my script to know if it needs to
abort because there were issues with the dump before it follows
through with the drop db...
Well, just checking the exit status from pg_dump ought to
louis gonzales wrote:
> Actually, there will be creation of 2 new tables for each insert on
> 'primary' table, so for 10K records, we would have 20K tables. Those
> tables each will never grow more than a few records each.
>
> Is it better to have 1 monolithic table and have to search it, or smal
Brandon Aiken wrote:
> Actually the only reason we have an email disclaimer is for CSIA
> compliance. We know they have a highly dubious legal standing, but,
> hey, it's what the auditors require.
google CSIA turns up a bunch of stuff. what is it exactly?
>
> --
> Brandon Aiken
> CS/IT Systems
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("Joshua D. Drake") transmitted:
>>> There is zero question that 8.2 is faster than 7.4 *but* if 7.4 isn't
>>> slow for them... Note, that I meant no reason for him to upgrade 7.4
>>> *right now*. He could wait for 8.3. (I thi
Actually the only reason we have an email disclaimer is for CSIA
compliance. We know they have a highly dubious legal standing, but,
hey, it's what the auditors require.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Konrad Neuwirth [mailto:[EMAIL PROTECTED]
Sent: Frida
Actually, there will be creation of 2 new tables for each insert on
'primary' table, so for 10K records, we would have 20K tables. Those
tables each will never grow more than a few records each.
Is it better to have 1 monolithic table and have to search it, or small
individual tables but many
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Erik
Jones) transmitted:
> On Mar 14, 2007, at 6:17 PM, CAJ CAJ wrote:
>
>
> Hello,
>
> What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to
> be released in July, what will be the stat
Dave Page wrote:
>
>> --- Original Message ---
>> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
>> To: Dave Page <[EMAIL PROTECTED]>
>> Sent: 15/03/07, 23:51:18
>> Subject: Re: [GENERAL] pg_dumpall and version confusion
>>
>> If you want that, create a wrapper program that calls to different
On Thursday 15 March 2007 9:52 pm, Parthan SR wrote:
> Hello,
>
> My table 'orderitems' looks like this
>
> create table orderitem (
> id serial not null primary key,
> item integer not null,
> quantity numeric(6,2) not null,
> unit varchar(10),
> conference integer not null,
> seller integer not n
Jorge Godoy wrote:
> "Dave Page" <[EMAIL PROTECTED]> writes:
>
>>> --- Original Message ---
>>> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
>>> To: Dave Page <[EMAIL PROTECTED]>
>>> Sent: 15/03/07, 23:51:18
>>> Subject: Re: [GENERAL] pg_dumpall and version confusion
>>>
>>> If you want tha
Tino Wildenhain <[EMAIL PROTECTED]> writes:
> Show me a user which really clicks on 1000 or more checkboxes on a
> webpage or similar ;)
> I'd think around 20 values is plenty.
On the other hand, show me a page with 1000 or more checkboxes to be clicked
at once and I'd show a developer / designer
"Dave Page" <[EMAIL PROTECTED]> writes:
>> --- Original Message ---
>> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
>> To: Dave Page <[EMAIL PROTECTED]>
>> Sent: 15/03/07, 23:51:18
>> Subject: Re: [GENERAL] pg_dumpall and version confusion
>>
>> If you want that, create a wrapper program t
On Thu, Mar 15, 2007 at 10:06:06PM -0400, Jasbinder Singh Bali wrote:
> How about using a try catch block?
> isn't that more efficient that eval?
Umm, eval is perl's equivalent of try/catch. There is no other way.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/kleptog/
> From e
Hello,
I'm working a lot with psql and plpgsql, I have a project based on psql and
for the developpement I often need to "dump" a function, it is not really
possible with psql because you don't have correctly the parameter.
So I've made a patch for pg_dump which permit to dump all the functions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/15/07 22:14, louis gonzales wrote:
> Hello List,
> I want to write a statement-level trigger - one that happens once per
> statement - such that, immediately after an insert into a table(which
> gets a unique integer value as an ID from a defined
On 3/15/07, Webb Sprague <[EMAIL PROTECTED]> wrote:
http://www.postgresql.org/docs/8.2/static/datatype-geometric.html
Have you looked at these yet? If not, you asked your question
prematurely and should have read the docs. If so, in what respect do
they not work for you?
Yes, I've looked at
Bruno Wolff III schrieb:
On Mon, Mar 12, 2007 at 11:15:01 -0700,
Stefan Berglund <[EMAIL PROTECTED]> wrote:
I have an app where the user makes multiple selections from a list. I
can either construct a huge WHERE clause such as SELECT blah blah FROM
foo WHERE (ID = 53016 OR ID = 27 OR ID = 292
Parthan SR wrote:
I get the following error in the browser, whent he fields for unit and
returnedas are left blank and hence becomes None.
I also tried to have some string value such as 'nos' and 'not reqd' for
'unit' and 'requiredas' but still it get a similar error
saying column 'nos' does not
> --- Original Message ---
> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 15/03/07, 23:51:18
> Subject: Re: [GENERAL] pg_dumpall and version confusion
>
> If you want that, create a wrapper program that calls to different
> statically compiled v
50 matches
Mail list logo
