> Since you brought up the subject, will this
> //[EMAIL PROTECTED] = "02"]
> be slower than
> /mydocument/body/chapter/contents/[EMAIL PROTECTED]
> >> = "02"]
> when handling a big document?
> I mean from the query time point of view ...
I have no idea about the postgres XML implementation int
Hi guys!
I was able to dump my database created on Postgres 7.1.2 to Postgres 8.1.4
.
It was a little hassle though because I have to manually remove "\M" from the dump file. This is manageable.
I am stucked though with one problem
psql:si_t2:36: ERROR: missing data for column "remarks"
"Jonathan Vallar" <[EMAIL PROTECTED]> writes:
> I am stucked though with one problem
> psql:si_t2:36: ERROR: missing data for column "remarks"
> CONTEXT: COPY si_t2, line 145:
This basically means that the data line hasn't got the right number of
column separators. Count the tabs ...
On 8/8/06, Feri@ <[EMAIL PROTECTED]> wrote:
Hello to wholes, I am new therein and I am going by of mysql to
postgres,somebody serious so kind to explain me as I can obtain in an array
the names of the draws of a given base of data in PostGres. am programming
in PHP, sorry for my English, i sp
At 07:06 PM 8/7/2006, Michael Fuhr wrote:
On Mon, Aug 07, 2006 at 05:36:49PM -0500, Steve Peterson wrote:
> I'm doing some tests with version 8.1.4 on Windows XP and am having
> trouble recovering some disk space.
>
> The tests involve loading some largeish CSV files in via COPY. One
> of the CO
On Mon, 2006-08-07 at 21:10 -0500, Ron Johnson wrote:
> > What situation are you worried about here exactly?
>
> Backing up a large database in a limited amount of time.
>
> If the DB is large enough, and the time is short enough, then the
> single-reader pg_dump can not read the data fast enough
On Tue, 2006-08-08 at 09:47 -0700, Jeff Davis wrote:
> I'm imagining something similar to the following:
> mydb=# select pg_start_backup('mybackup');
>
> $ tar zcf - /path/to/pgdata | mux.script /dev/st0 /dev/st1 /dev/st2
> $ tar zcf - /path/to/tablespace1 | mux.script /dev/st3 /dev/st4 /dev/st5
>
I'm having a little trouble restoring a backup (from the production
server to our development server).
I recently updated both production and development servers to
postgres 8.1.4 from 8.0.x. When I updated production, I did a fresh
initdb and imported from a previous dump. This server is r
Hello to the list,here's an SQL question, I hope it's not off topic. From a list of URLs I want to get only the distinct values of the *web sites* these URLs belong to, that is everything before and including the 3rd slash, and I think this should be possible within the DB. I would like to say some
SELECT DISTINCT substring(attribute from '^http://[^/]*/') from pg_atp
where attribute like 'http://%';
w/o DISTINCT there should be duplicates (if any)
don't use "DISTINCT ON" at all, it's evil :-) (why?
http://chernowiki.ru/index.php?node=38#A13)
On 8/8/06, Christoph Pingel <[EMAIL PROTECTED]
>Was the old postgres stopped when you created the copy?
>Was the new postgres stopped when you put the copy in?
>Did you restore correct permissions when you put the copy in?
>Is the new install the same version of postgres as the old one?
>What are the error messages?
I t
I tried to modify the parameters of the .CONF file when the pgsql-8.1service was running. The next time I started, it displayed error: "The
service did not listen to local host". (something like this).If you were to do a"su - postgres -c "pg_ctl -D start" what error information does it show?
Stev
On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
On 8/2/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
I'm working on a postgres instance (8.1.2 running on Solaris 10)
where the
data directory (including WAL) is being mounted on tmpfs. Based on
this, and
with knowledge that fsync is di
Hi,Development is Mac OS 10.4.0 (PPC). Production is Mac OS 10.4.7 (Intel). Is that the kicker... PPC vs Intel?On Aug 8, 2006, at 1:46 PM, Talha Khan wrote:Hey Joe!! Which OS are you running on development server and production server?? regards Talha Khan On 8/8/06, Joe Lester <[EMAIL PROTECTED]
On 8/8/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
> if have super high write volumes, consider writing your insert call in
> C. prepare your statement, and use the parameterized
> versionExecPrepared(...).
Can you point to a good exam
On 8/6/06, jesus martinez <[EMAIL PROTECTED]> wrote:
Merlin, first all, thanks for taking time to
answer me.
- where do i have to find the tutorial you
said ? do you have the URL ?
http://pginstaller.projects.postgresql.org/silent.html
- i actually didnt try the silent-mode.
because the re
I recently tried to do something like the following
BEGIN READONLY;
...
CREATE TEMPORARY TABLE ABC AS SELECT ...
...
COMMIT;
and it failed because CREATE is not allowed within a read-only
transaction. The select is something long and complicated (pieced
together with php) and I'm just trying to
DISTINCT ON is extremely useful when you know what you're doing. It's
postgres' version of oracle's first_value analytical function, and when
you need it, nothing else really suffices.
On Tue, 8 Aug 2006, Nikolay Samokhvalov wrote:
SELECT DISTINCT substring(attribute from '^http://[^/]*/') fr
On Tue, 2006-08-08 at 13:06, Joe Lester wrote:
> Hi,
>
> Development is Mac OS 10.4.0 (PPC). Production is Mac OS 10.4.7
> (Intel). Is that the kicker... PPC vs Intel?
Yep.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
> On Tue, 2006-08-08 at 09:47 -0700, Jeff Davis wrote:
>> I'm imagining something similar to the following:
>> mydb=# select pg_start_backup('mybackup');
>>
>> $ tar zcf - /path/to/pgdata | mux.script /dev/st0 /dev/st1 /dev/st2
>> $ t
Am 08.08.2006 um 19:49 schrieb Nikolay Samokhvalov:
SELECT DISTINCT substring(attribute from '^http://[^/]*/') from pg_atp
where attribute like 'http://%';
w/o DISTINCT there should be duplicates (if any)
don't use "DISTINCT ON" at all, it's evil :-) (why?
http://chernowiki.ru/index.php?node=
Thanks for the input, I think I get this now. In my case, the querySELECT DISTINCT ON (substring(attribute from '^http://[^/]*/')) attribute from pg_atp where attribute like 'http://%' doesn't get me just the root of the URL, but the whole URL - but only for the first row for each individual root.
Joe Lester <[EMAIL PROTECTED]> writes:
> Development is Mac OS 10.4.0 (PPC). Production is Mac OS 10.4.7
> (Intel). Is that the kicker... PPC vs Intel?
You don't get to move physical database files between different machine
architectures... usually we see people griping about 32-bit vs 64-bit,
b
Christoph Pingel <[EMAIL PROTECTED]> writes:
> Am 08.08.2006 um 19:49 schrieb Nikolay Samokhvalov:
>> don't use "DISTINCT ON" at all, it's evil :-) (why?
>> http://chernowiki.ru/index.php?node=38#A13
> Thanks for the good advice! From reading this, it seems to be a
> *really* bad thing. And I di
On Aug 8, 2006, at 1:25 PM, Carl R. Brune wrote:
I recently tried to do something like the following
BEGIN READONLY;
...
CREATE TEMPORARY TABLE ABC AS SELECT ...
...
COMMIT;
and it failed because CREATE is not allowed within a read-only
transaction. The select is something long and complicate
I have the following table:CREATE TABLE code_source( csn_src int4 NOT NULL, csn_type varchar(8) NOT NULL, cs_code varchar(15) NOT NULL, cs_desc_short varchar(30), cs_desc_long text,
cs_remarks varchar(20), cs_work_flag char(1), cs_status char(1), cs_manual_key bool NOT NULL DEFAULT false,
2006/8/8, Chris Hoover <[EMAIL PROTECTED]>:
(...)
The reason for the null being passed to to_date is this is on of almot 90k
lines of data we are trying to load, and the script was built to generate
this code. Since to_date(null,'mmdd') returns a null, why is the
default not working?
Becau
On Tue, Aug 08, 2006 at 04:41:04PM -0400, Chris Hoover wrote:
> I have the following table:
> The reason for the null being passed to to_date is this is on of almot 90k
> lines of data we are trying to load, and the script was built to generate
> this code. Since to_date(null,'mmdd') return
When version mismatches between the client and server are inevitable,
what is less likely to get me into trouble - clients/libs newer than
server or server newer than clients/libs?
We have dozens of client machines and multiple PG servers in a 24x7x365
operation and I'd like to deploy upgrades
Hi, I have a middle tier application in C on one machine which doesn't have postgres installed.I have a machine that hosts my postgres database.My middle tier application wants to connect to the Db server.
Is it mandatory for the m/c that hosts the middle tier application to have postgres installe
On Tue, 2006-08-08 at 16:25, Jasbinder Bali wrote:
> Hi,
> I have a middle tier application in C on one machine which doesn't
> have postgres installed.
> I have a machine that hosts my postgres database.
> My middle tier application wants to connect to the Db server.
>
> Is it mandatory for the
In my database server, I'm using packaged version of postgres.I installed it using: "yum install postgres" and this inturn searches for the rmp.So, its a packaged version of postgresql.Now as far as my client is concerned, that has the middle tier component written in C, i don't have any postgres t
On Aug 8, 2006, at 1:10 PM, Merlin Moncure wrote:
On 8/8/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
> if have super high write volumes, consider writing your insert
call in
> C. prepare your statement, and use the parameterized
> ver
Chris Hoover wrote:
I have the following table:
CREATE TABLE code_source
(
csn_src int4 NOT NULL,
csn_type varchar(8) NOT NULL,
cs_code varchar(15) NOT NULL,
cs_desc_short varchar(30),
cs_desc_long text,
cs_remarks varchar(20),
cs_work_flag char(1),
cs_status char(1),
cs_manual
On Tue, 2006-08-08 at 13:48 -0500, Ron Johnson wrote:
> >> I'm imagining something similar to the following:
> >> mydb=# select pg_start_backup('mybackup');
> >>
> >> $ tar zcf - /path/to/pgdata | mux.script /dev/st0 /dev/st1 /dev/st2
> >> $ tar zcf - /path/to/tablespace1 | mux.script /dev/st3 /dev
On 8/8/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
On Aug 8, 2006, at 1:10 PM, Merlin Moncure wrote:
> On 8/8/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
>> On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
>> > if have super high write volumes, consider writing your insert
>> cal
It was a little hassle though because I have to manually remove "\M" from
the dump file. This is manageable.
I am stucked though with one problem
psql:si_t2:36: ERROR: missing data for column "remarks"
CONTEXT: COPY si_t2, line 145:
Upon checking line 145, there are no weird characters. Upon
Does DROP TABLE free up disk space immediately?
Thanks,
-Gabor
NOTE: The contents of this e-mail including any attachments may contain confidential or privileged information and are to be read solely by the intended recipient(s). If you are not an intended recipient of this e-ma
Hello,
I'd like to write a C Function for Postgresql that can access data in
the database, use that to conduct additional queries to find more
information in the database and eventually return a result. I
currently have the functionality I want implemented as php/C programs
that first connect to
HiI would like to create a database server with postgres web application.My DB size will be 20GB.I will write 1 a day with until 10 to 15 simultanous write.How could I size my server (memory, CPU, ...) ?Regardsgertrude
iFRANCE
exprimez-vous !
Gabor Siklos wrote:
> Does DROP TABLE free up disk space immediately?
It frees space at COMMIT.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
T
Steve Crawford <[EMAIL PROTECTED]> writes:
> When version mismatches between the client and server are inevitable,
> what is less likely to get me into trouble - clients/libs newer than
> server or server newer than clients/libs?
For the most part I'd update the server first; the exception is th
On Tue, Aug 08, 2006 at 12:16:18PM -0700, [EMAIL PROTECTED] wrote:
> I'd like to write a C Function for Postgresql that can access data in
> the database, use that to conduct additional queries to find more
> information in the database and eventually return a result. I
> currently have the functi
On Tue, Aug 08, 2006 at 11:25:23AM -0500, Steve Peterson wrote:
> Note that if needed I can whack the database and start over very
> easily, if that's the most expedient way out of this.
That might be the easiest thing to do, but it might also be worth
investigating what happened. It's possible
I should have added that I want to make further use of the temporary
table after the COMMIT -- the rollback approach you propose makes it
go away.
Carl Brune
On Tue, 8 Aug 2006, John DeSoi wrote:
On Aug 8, 2006, at 1:25 PM, Carl R. Brune wrote:
I recently tried to do something like the foll
On Tue, Aug 08, 2006 at 02:22:56PM -0700, Steve Crawford wrote:
> When version mismatches between the client and server are inevitable,
> what is less likely to get me into trouble - clients/libs newer than
> server or server newer than clients/libs?
Note that you can in theory install multiple
46 matches
Mail list logo
