On Fri, Jul 29, 2005 at 00:05:46 +0200,
Havasvölgyi Ottó <[EMAIL PROTECTED]> wrote:
>
> This function deletes a row, and updates the pid field where pid is geater
> than the deleted pid value, so that the gap caused by the deletion is not
> present any more.
This isn't directly related to you
Chris Guo wrote:
I just installed postgresql 0.8.3 on the fedora core linux 3, I also
Version 8.0.3 I hope, 0.8.3 would be *very* old.
installed pgadmin 1.0.2 in my computer. But I am having trouble connecting
postgresql by using pgadmin, it shows me the error message" An error
occurred: Erro
Hello.
Somone helped me to set proper A6
parameter in ODBC connection string, for WIN1250 encoding, as following
CLIENT%5fENCODING%3dWIN1250.
If A6 is blank string, I suppose that ODBC driver
uses default UNICODE ?
Could someone tell me how to set other encodings in
A6 parameter ?
Is ther
I performed vacuum freeze instead vacuum full, by
mistake, using PgAdmin.
Is there any danger for my database ?
Zlatko
Hi,
does anyone know a tool for analysing the postgres logfile?
thanks,
stefan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi all,
Sorry for the cross-post, I need the bigger exposure, and I'm not sure
if it's JDBC issue or not.
This is a follow-up from an earlier post, with a new twist.
We have a Java application which is designed initially to work with
Oracle, and then gradually adapted to also work with postgres,
Csaba Nagy wrote:
> However, some of the queries still take the sequential scan route. The
> most puzzling in all this is that I've tried to "prepare" the same query
> in psql, and then "explain execute" the prepared query, and it gave me
> an index scan plan... so now I'm clueless, and have no id
Bruno,
I know this is inefficient. In fact it was someone other's problem to
eliminate gaps and I solved it this way. I don't do such things for myself.
Best Regards,
Otto
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
C
Hi,
Yes, I misspelled in the mail, I don't any way to copy it from the console,
so I rewrote it here.
I will post if I can reproduce it again. I hope that I have missed
something.
Best Regards,
Otto
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Havasvölgyi O
We are currently migrating a database from Ms Sql server to PostgreSQL.
So far replication was done using GUID (global unique identifier) fields
which is MS extension. I am wondering if something similar exists in
PostgreSQL?
Tnx in advance
Dragan
---(end of broadcas
Title: Re: [GENERAL] Is there something like Mssql GUID in PostgreSql database
On 7/29/05 8:04 AM, "Dragan Matic" <[EMAIL PROTECTED]> wrote:
We are currently migrating a database from Ms Sql server to PostgreSQL.
So far replication was done using GUID (global unique identifier) fields
which i
Thanks for the info guys; got a better understanding now.
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales
http://www.systame.com/
---(end of broadcast)---
TIP 3: Have you checked our e
Dear all,
I'm recently migrating a OpenACS 3.2.5 website to a Fedora Core 3 server
My problem was PostgreSQL compilation.
Everytime I run ./configure, the compilation ended with these lines:
(some lines skipped)...
...
checking for preprocessor stringizing operator... yes
On Thu, Jul 28, 2005 at 12:53:07AM -0400, Tom Lane wrote:
> Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > ... the problem is unsigned bigint in mysql to postgresql.
> > There's not another larger integer size that can be used that would
> > allow the 18446744073709551615 (is that the max v
On Jul 28, 2005, at 2:40 PM, Jan Wieck wrote:
Then again, the stats file is only written. There is nothing that
actually forces the blocks out. On a busy system, one individual
stats file will be created, written to,
If one is running with stats_reset_on_server_start true (the default)
d
My template0 and template1 have SQL ASCII encoding,
while I created a database with UNICODE encoding.
Could it cause some conflicts ? If so, how can I
change templates databases to be UNICODE as well ?
On Fri, Jul 29, 2005 at 09:08:28AM -0400, Jeff Trout wrote:
>
> On Jul 28, 2005, at 2:40 PM, Jan Wieck wrote:
>
> >Then again, the stats file is only written. There is nothing that
> >actually forces the blocks out. On a busy system, one individual
> >stats file will be created, written to,
>
=?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> writes:
> I performed vacuum freeze instead vacuum full, by mistake, using =
> PgAdmin.
> Is there any danger for my database ?
No.
regards, tom lane
---(end of broadcast)-
OK, found the source of the problem: our code is setting nulls via:
PreparedStatement.setNull(int parameterIndex, int sqlType)
using Types.NUMERIC as the type, but the data base type is actually
BIGINT. Using Types.BIGINT in this method makes the problem go away.
Hopefully there are no more bad sur
=?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> writes:
> My template0 and template1 have SQL ASCII encoding, while I created a =
> database with UNICODE encoding.
> Could it cause some conflicts ? If so, how can I change templates =
> databases to be UNICODE as well ?
The real question is whe
Hi,
does anyone know a tool for analysing the postgres logfile? i want't to
search for slow queries...
thanks,
stefan
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
If you use a large enough space for the number you can reduce that
probability of an accidental collision to much less than that of
catastrophic hardware failure at which point it isn't noticably better
than having no chance of collisions.
I find the comparison unconvincing - if my hardware cras
Phil Endecott <[EMAIL PROTECTED]> writes:
> Hello again,
>
> Just to give a bit of background, in case it is useful: this is my family tree
> website, treefic.com. I have a schema for each user, each with about a dozen
> tables. In most cases the tables are small, i.e. tens of entries, but the
"John D. Burger" <[EMAIL PROTECTED]> writes:
> > If you use a large enough space for the number you can reduce that
> > probability of an accidental collision to much less than that of
> > catastrophic hardware failure at which point it isn't noticably better
> > than having no chance of collisio
On Fri, Jul 29, 2005 at 12:18:30 -0400,
"John D. Burger" <[EMAIL PROTECTED]> wrote:
> >If you use a large enough space for the number you can reduce that
> >probability of an accidental collision to much less than that of
> >catastrophic hardware failure at which point it isn't noticably better
>
Ok, I should be posting this to the kindergarden list... but I didn't
subscribe...
I've connected to a database
psql -l testdb
showed tables
\d
show table schema
\d testtable
now I want to select
#select someColumn from testtable
I get nothing... no output, nothing...
I'm used to MySQL whe
Greetings!
I am using to partition several tables. When I perform a query
on another table, and then try to join against an inherited table set, the
optimizer does not use any indexes to perform the join.
This is 8.0.1. Is this fixed in 8.0.2 or 8.0.3?
The query:
explain
select *
from (
se
On 7/29/05, Jonathan Villa <[EMAIL PROTECTED]> wrote:
> now I want to select
> #select someColumn from testtable
>
> I get nothing... no output, nothing...
Try terminating the statement with ';'?
---(end of broadcast)---
TIP 5: don't forget to incr
Greetings!
I managed to get an even simpler example:
select *
from eventlog.record_main
where luid in (
select luid from eventlog_partition._20050706__raw_record
order by luid limit 1
)
;
If I use <=> rather than , postgresql uses index scanning. As soon as
I use (ie, a set to compare
Ok, this is odd...
I tried ending with a semicolon before, and received this error
ERROR: parser: parse error at or near "select"
I have to do it twice before I get it works...here's an example
select project_name from project_group_list;
ERROR: parser: parse error at or near "select"
select
Greg Stark wrote:
Phil Endecott wrote:
Just to give a bit of background, in case it is useful: this is my family tree
website, treefic.com. I have a schema for each user, each with about a dozen
tables. In most cases the tables are small, i.e. tens of entries, but the
users I care about are th
On Fri, 2005-07-29 at 14:19, Jonathan Villa wrote:
> Ok, this is odd...
>
> I tried ending with a semicolon before, and received this error
>
> ERROR: parser: parse error at or near "select"
>
> I have to do it twice before I get it works...here's an example
>
> select project_name from projec
On Fri, Jul 29, 2005 at 02:19:07PM -0500, Jonathan Villa wrote:
> I tried ending with a semicolon before, and received this error
>
> ERROR: parser: parse error at or near "select"
>
> I have to do it twice before I get it works...here's an example
>
> select project_name from project_group_lis
On 7/29/05, Jonathan Villa <[EMAIL PROTECTED]> wrote:
>
> Ok, this is odd...
>
> I tried ending with a semicolon before, and received this error
>
> ERROR: parser: parse error at or near "select"
>
> I have to do it twice before I get it works...here's an example
>
> select project_name from
-Jonathan
> On 7/29/05, Jonathan Villa <[EMAIL PROTECTED]> wrote:
>>
>> Ok, this is odd...
>>
>> I tried ending with a semicolon before, and received this error
>>
>> ERROR: parser: parse error at or near "select"
>>
>> I have to do it twice before I get it works...here's an example
>>
>> selec
On Fri, 2005-07-29 at 14:48, Jonathan Villa wrote:
> -Jonathan
> >>
> >>
> >
> > that's because you type a select without a semicolon then you write
> > one with the semicolon so the parser think both are only one command
> > but refused to execute that bad formed sentence and give you the
> > erro
On Thu, Jul 28, 2005 at 12:53:07AM -0400, Tom Lane wrote:
> Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > ... the problem is unsigned bigint in mysql to postgresql.
> > There's not another larger integer size that can be used that would
> > allow the 18446744073709551615 (is that the max v
On Wed, Jul 27, 2005 at 09:16:04PM -0700, Chris Travers wrote:
> Christopher Kings-Lynne wrote:
>
> >>So far, the checklist I can see includes:
> >>* Maintaining conversion scripts
> >
> >
> >What I think we need is a C program that dumps directly from MySQL
> >into PostgreSQL sql.
> >
> >ie. Ta
On Fri, Jul 29, 2005 at 02:49:54PM -0500, Jim C. Nasby wrote:
> On Thu, Jul 28, 2005 at 12:53:07AM -0400, Tom Lane wrote:
> > Gregory Youngblood <[EMAIL PROTECTED]> writes:
> > > ... the problem is unsigned bigint in mysql to postgresql.
> > > There's not another larger integer size that can be u
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Is there any serious impediment to adding unsigned types to PostgreSQL?
Quick, what's the datatype of 12345? And why?
My guess is that transparent support for such a thing would require some
tricky and fragile compromises in the numeric hierarchy's pr
On Fri, Jul 29, 2005 at 03:57:48PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Is there any serious impediment to adding unsigned types to PostgreSQL?
>
> Quick, what's the datatype of 12345? And why?
>
> My guess is that transparent support for such a thing would req
Phil Endecott <[EMAIL PROTECTED]> writes:
> Those aren't questions that I need to answer often.
But the fact that they're utterly infeasible in your current design is a bad
sign. Just because you don't need them now doesn't mean you won't need
*something* that spans users later. Sometimes you h
Does anyone know where I can get a windows version of 7.4.7?
TIA
Rod MacNeil
NOTE:
This e-mail message is intended only for the named recipient(s) above
and may contain information that is privileged, confidential and/or
exempt fr
Greg Stark wrote:
The sort of question I do need to answer is this: starting from individual
X, find all the ancestors and descendants for n generations. This involves n
iterations of a loop, joining the relatives found so far with the next
generation. If there are p people in the tree this has s
On Fri, Jul 29, 2005 at 03:54:07PM -0500, Jeff Lund wrote:
Hi,
In the future please post to a list instead of asking me privately. I
have picked a list arbitrarily to post the response.
> I am a DBA using Postgres 8.0.3, and it is great. Could someone
> tell me what is wrong or what the prob
On Fri, Jul 29, 2005 at 20:23:54 -,
Rod MacNeil <[EMAIL PROTECTED]> wrote:
> Does anyone know where I can get a windows version of 7.4.7?
7.4.7 doesn't run under windows natively. You can get it to run using
cygwin.
Perhaps if you told us more about what you are trying to do, we could
make s
Title: Message
Hi,
I'm running
postgressql 7.1.3-2.
I've a
When I did a select
on the table, I was able to see that row. However, when I tried to update
that row, I got 'Update 0', I even tried to delete that row, I
couldn't. It seems like the database is confused. I did the Vacuum
Wang, Mary Y wrote:
Hi,
I'm running postgressql 7.1.3-2.
I've a
When I did a select on the table, I was able to see that row. However,
when I tried to update that row, I got 'Update 0', I even tried to
delete that row, I couldn't. It seems like the database is confused. I
did the Vacu
Title: Message
Are you sure that your user account has
been granted DELETE and UPDATE on that table?
If you are sure that the account you were
connected with has permissions, then:
Give the exact command
you did to perform the select.
Give the exact result set
you got back when
Title: Design question
My company is looking to use PostgreSQL in place of our existing system.
We currently house data for multiple clients. All of their data is stored in a single database in different schemas for each client. Mosts clients have multiple login accounts, which we maintain i
I have a application which maintains a number of monthly totals.
recorded, mth1, mth2, mth3 mth12, total
This from the days when I used another DB system to postgresql.
Is there going to be a performance advantage to change to using
postgresql array based datatype for these records? Parti
William Harazim wrote:
My company is looking to use PostgreSQL in place of our existing system.
We currently house data for multiple clients. All of their data is
stored in a single database in different schemas for each client.
Mosts clients have multiple login accounts, which we maintain in
52 matches
Mail list logo
