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
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 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
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
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
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
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 !
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
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
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
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
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
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 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
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 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
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
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
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
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
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,
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
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
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
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.
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=
-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
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?
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
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
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
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
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 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
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
>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
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]
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
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
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
>
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
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 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
"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 ...
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"
> 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
46 matches
Mail list logo
