Dear All,
I've got a composite key in a table. The keys are ID and owner ID. The type of
the ID should be a serial, additionally I hope the ID to be increasable per
owner ID. ( The ID will be increased with the different owner ID) Does anyone
know how to implement it? Thanks in advance.
Best
On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
In practice, if I pg_dump our 100 GB database, our application, which
is half Web front end and half OLTP, at a certain point, slows to a
crawl and the Web interface becomes unresponsive. I start getting
I cannot get the problem to appear using generated data and cannot provide
the real database.
Given these facts, and the fact I can use the expanded query to get the
necessary results, I am going to move on.
If you want me to provide any additional information with respect to this
behavior using
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 select to_timestamp('02/26/2011
14:50', 'MM/DD/ HH24MI') I am getting the following error and
the sql runs fine in older version
Is it my installation issue or library missing?
ERROR:
On 2/25/2011 7:26 AM, Vick Khera wrote:
On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
In practice, if I pg_dump our 100 GB database, our application, which
is half Web front end and half OLTP, at a certain point, slows to a
crawl and the Web interface
Create one sequence per owner and write a function/trigger that will check
the owner id for the record and call the appropriate nextval(sequence) to
get the next value for that owner and replace the id with the generated
value.
If new owner IDs are going to be generated, however, this will not be
On 02/25/2011 09:30 AM, akp geek wrote:
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 select to_timestamp('02/26/2011 14:50',
'MM/DD/ HH24MI') I am getting the following
error and the sql runs fine in older version
Is it my installation
Unfortunately the our database is still 8.3. that's a limitation for using
array_length
Regards
On Thu, Feb 24, 2011 at 4:08 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
Hey,
2011/2/24 akp geek akpg...@gmail.com
Hi all -
I am trying to find the number of elements in the
On Friday, February 25, 2011 6:41:54 am Reid Thompson wrote:
On 02/25/2011 09:30 AM, akp geek wrote:
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 select
to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') I am getting the
Adrian Klaver wrote:
test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
to_timestamp
Thank you all for the suggestion and it's very clear to me now
Regards
On Fri, Feb 25, 2011 at 10:02 AM, Bruce Momjian br...@momjian.us wrote:
Adrian Klaver wrote:
test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
to_timestamp
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to add the references (one by
one),
Hi,
I looking for the best solution to backup files using WAL and warm standby.
I have 2 servers A and B. A is a main server (production) on B is runing
postgres with warm standby. I must now backup databases and WAL to tape
using a TSM, but on server standby if I using macro %r I have only
Hello everyone
I have the following error in my postgres-log:
** ***
TopMemoryContext: 95584 total in 8 blocks; 4824 free (11 chunks); 90760 used
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used
Vibhor Kumar wrote:
On Feb 22, 2011, at 10:23 PM, Jeff Amiel wrote:
It's come time to bite the bullet and convert a half-terraybyte database from
ASCII to UTF8. Have gone through a bit of effort to track down the unclean
ascii text and repair it but would like to avoid the outage of a
Gary Fu g...@sigmaspace.com writes:
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to
Reto Wittwer reto.witt...@exsila.com writes:
Hello everyone
I have the following error in my postgres-log:
2011-02-18 16:33:46.262 CET [2068:1] @ FEHLER: Speicher aufgebraucht
2011-02-18 16:33:46.262 CET [2068:2] @ DETAIL: Fehler bei Anfrage mit Größe
893716290.
Right offhand this looks
On Wed, Feb 23, 2011 at 9:06 AM, Geoffrey Myers
g...@serioustechnology.com wrote:
I'm assuming you're saying you can replicate from an ASCII database to UTF8?
What happens to the data that is not UTF8 'friendly?'
The assumption up-thread was that the data was already made UTF8
friendly in the
Using the 9.0.3 binaries from the PostgreSQL download site, Solaris 10 on
Sparc architecture.
I had a co-worker set up a development server using the 32 bit PostgreSQL
binaries for Solaris 10 Sparc. After some initial testing we realized we can't
take full advantage of the 16 GB of
On Fri, Feb 25, 2011 at 12:25 PM, runner run...@winning.com wrote:
I don't have a problem with blowing the database cluster away and starting
over but I'd like to have a better understanding of what USE_FLOAT8_BYVAL
does and how it affects our install. I spent a considerable amount of time
I'd like to use pgadmin3 for DDL tasks with an imported database. Using
version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application
starts. I learned to define the server as 'localhost' rather than the
hostname, so I can see entries in the left side, tree window. However,
pgadmin3
On 25/02/2011 19:49, Rich Shepard wrote:
I'd like to use pgadmin3 for DDL tasks with an imported database. Using
version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application
starts. I learned to define the server as 'localhost' rather than the
hostname, so I can see entries in the left
Sweet Savings
it is really best place for online shopping
i had try , it is truth and service is very good
fast ship and best quality
hope you can try too
here is the site : : rong2007.com
sure you will like it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Fri, 25 Feb 2011, Raymond O'Donnell wrote:
Upgrade to 1.12?
Ray,
That appears to have done the trick. I somehow thought I was working on
the latest version; it's been that sort of a week.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
I'm trying to do a select to find on a char field that has a single
quote but getting errors. This is what I'm doing:
Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD'
The text I'm trying to find is BERLETT'S ROAD
If I do the same thing but have double quotes in the string
On 25/02/2011 20:37, Rich Shepard wrote:
On Fri, 25 Feb 2011, Raymond O'Donnell wrote:
Upgrade to 1.12?
Ray,
That appears to have done the trick. I somehow thought I was working on
the latest version; it's been that sort of a week.
No problem - glad you're sorted.
Ray.
--
Raymond
VTD-XML 2.10 is now released. It can be downloaded at
https://sourceforge.net/projects/vtd-xml/files/vtd-xml/ximpleware_2.10/.
This release includes a number of new features and enhancement.
* The core API of VTD-XML has been expanded. Users can now perform
cut/paste/insert on an empty
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to
Christine Penner wrote:
I'm trying to do a select to find on a char field that has a single
quote but getting errors. This is what I'm doing:
Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD'
There are a couple of ways to do this in PG but the easiest and closest
to the
Aleksey Tsalolikhin atsaloli.t...@gmail.com writes:
Now just past weekend we upgraded our production server by pg_dump
and pg_restore, and again the database is 109 GB in size!
Which character encoding of the source and target database?
--
Sergey Burladyan
--
Sent via pgsql-general mailing
I'd also add: run pg_tune on your server. Made a *dramatic* difference for us.
On Friday, February 25, 2011 05:26:56 am Vick Khera wrote:
On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
In practice, if I pg_dump our 100 GB database, our application,
On 24/02/2011 10:59 AM, Kalai R wrote:
We are going to design database for a large company with multi branches.
I am using PostgreSQL
For example,
I create a single database for all branches. After 10 years, database
size is too large.
What is too large?
If you keep PostgreSQL up to date,
On 24/02/2011 10:59 AM, Kalai R wrote:
We are going to design database for a large company with multi branches.
I am using PostgreSQL
For example,
I create a single database for all branches. After 10 years, database
size is too large.
Oh yeah, for what it's worth: my employer has
On Feb 25, 2011, at 6:24 PM, Craig Ringer wrote:
In reality you must plan periodic updates, in which case it's quite likely
that the growth of hardware and software performance will keep up with the
data growth.
I've been in a lovely little niche that has fit that description since 1993 ;-)
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it
On 02/25/2011 05:11 PM, Gary Fu wrote:
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the
36 matches
Mail list logo
