> In postgresql there is no difference in storage method between text,
> varchar(n) and char(n).
However, there's an additional length check for (var)char(n)
involved meaning an ever so tiny performance penalty if that's
of concern.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291
On 19/11/04 6:46 pm, "Pierre-Frédéric Caillaud"
<[EMAIL PROTECTED]> wrote:
>
>> can do this fine with small files But if I get above a 1000 rows it
>> takes so long it time out.
>
> PHP is slow, but not *that* slow, you have a problem somewhere !
Aha yes, I was reading the file doing this
Hi all,
I have three questions about 1 table
CREATE TABLE public.logs
(
rule_name varchar(32) NOT NULL,
bytes int8 NOT NULL,
pkts int8 NOT NULL,
hostname varchar(100),
that_time int4 NOT NULL
) WITH OIDS;
Question 1.
If I run the following query:
select cast(min(that_time) as abstim
Hello,
I have a table with a timestamp column and I want to set this to a value
of now() - a random number of days between 0 and 45 for each row... I've
tried to do this a bunch of different ways and can't figure it out...
Here is my latest version:
update sometable set entered_dt = now() - inte
Try:
select * from event where game_clock IS NULL
- Greg
>Occasionally I want to store a null value for my java.sql.Time--> Time
>column in Postgresql.
>update event set game_clock=null where event_id=1;
>
> I can retreive the record with the null value (type Time) if I select
>on the primary
Err, I just read my latest digest and saw the solution:
update datafrenzy.jobdata set entered_dt= now() - CAST(round(random()*45)
|| ' days' AS interval);
- Greg
>Hello,
>
>I have a table with a timestamp column and I want to set this to a value
>of now() - a random number of days between 0 and
Joost Kraaijeveld wrote:
If I run the following query:
select cast(min(that_time) as abstime), cast(max(that_time) as abstime), (sum(bytes)/(1024*1024)) as "Totaal in Megabytes" from logs
where
that_time between cast( abstime('2004-10-1 00:00') as int4) and cast( abstime('2004-11-1 00:00') as int
"Joost Kraaijeveld" <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
>
> I have three questions about 1 table
>
> CREATE TABLE public.logs
> (
> rule_name varchar(32) NOT NULL,
> bytes int8 NOT NULL,
> pkts int8 NOT NULL,
> hostname varchar(100),
> that_time int4 NOT NULL
> ) WITH OIDS;
>
>
Hi Jim and Richard,
Thank for pointing out something that I should have known.
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl
---(end of broadcast)-
On Nov 23, 2004, at 5:33 AM, Net Virtual Mailing Lists wrote:
I have a table with a timestamp column and I want to set this to a
value
of now() - a random number of days between 0 and 45 for each row...
I've
tried to do this a bunch of different ways and can't figure it out...
Here is my latest v
I guess the subject says it all, can I install the
B5 release to a B4 db without starting from scratch?
Jerry
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [
On Tue, Nov 23, 2004 at 09:49:05AM -0500, Jerry LeVan wrote:
> I guess the subject says it all, can I install the
> B5 release to a B4 db without starting from scratch?
I think upgrading to beta5 requires an initdb. You can find out
by comparing catalog versions between your current database and
On Tue, Nov 23, 2004 at 09:03:26AM -0500, John DeSoi wrote:
> select now() - ((round(random()*45))::text || ' days')::interval;
Or one of the following (add round() if desired):
select now() - 45 * random() * interval'1 day';
select now() - random() * interval'45 day';
--
Michael Fuhr
http://w
Jerry LeVan <[EMAIL PROTECTED]> writes:
> I guess the subject says it all, can I install the
> B5 release to a B4 db without starting from scratch?
Afraid not.
When in doubt, the authoritative answer for such questions can be found
by consulting the catversion revision history:
http://developer.p
Thanks for the insight Thomas and Gregory. I think I can make a work
around.
Phil
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi all!
Trying to restore one of my db on PG-7.4.3 (on Debian-Sarge):
$ psql finanza < finanza.out
I get:
-
[...]
ERROR: invalid input syntax for type double precision: "-"
CONTEXT: COPY dep_tit, line 1, column ultima_quot: "-"
ERROR: invalid input syntax for type double precision: "-"
I know there is a command to add the column. I want to back
up the table before I alter it. What is the best way. It has a couple indexes
and a trigger.
If I am in the wrong forum please direct me to the right
one.
Thanks.
Lewie
Ennio-Sr <[EMAIL PROTECTED]> writes:
> This is an extract of the dump file:
> CREATE TABLE "dep_tit" (
> "cod_rif" character(3),
> "titolo" character varying(20),
> "quantity" integer,
> "costo_med_fisc" double precision,
> "data_rif" date,
> "ultima_quot" double precision,
Due to recent action by Google concerning the comp.databases.postgresql.*
hierarchy, we are going to make some changes that should satisfy just
about everyone ... over the next 24hrs or so, traffic *to*
comp.databases.postgresql.* from the mailing lists will cease and be
re-routed to pgsql.* in
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
>
> Due to recent action by Google concerning the comp.databases.postgresql.*
> hierarchy, we are going to make some changes that should satisfy just
> about everyone ... over the next 24hrs or so, traffic *to*
> comp.databases.postgresql.* from
Did you warn the proponent of comp.databases.postgresql.* that you were
going to do this? Did you read any of the arguments for and against a
completely separate hierarchy that were posted to the RFD thread in
news.groups?
Interesting point. What did come of all the arguments? These news server
c
Hi,
struggling around with this for some time:
How can I use a table name as a parameter in a PL/pgSQL function ??
I tried this but it didn't work...
CREATE OR REPLACE FUNCTION my_row_count(text) RETURNS int4 AS '
DECLARE
num_rows int4;
BEGIN
num_rows := (select count(*) from $1);
RETURN n
On Tue, 23 Nov 2004 15:37:56 -0400 (AST), [EMAIL PROTECTED]
("Marc G. Fournier") wrote:
>
>Due to recent action by Google concerning the comp.databases.postgresql.*
>hierarchy, we are going to make some changes that should satisfy just
>about everyone ... over the next 24hrs or so, traffic *to*
At 03:44 PM 11/23/2004, Joshua D. Drake wrote:
Did you warn the proponent of comp.databases.postgresql.* that you were
going to do this? Did you read any of the arguments for and against a
completely separate hierarchy that were posted to the RFD thread in
news.groups?
Interesting point. What did
You'll need to use the EXECUTE command to build the SQL dynamically.
See:
http://www.postgresql.org/docs/7.4/interactive/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
On Nov 23, 2004, at 2:56 PM, Alexander Pucher wrote:
Hi,
struggling around with this for some time:
How can I use a ta
On Nov 23, 2004, at 3:59 PM, Gary L. Burnore wrote:
On Tue, 23 Nov 2004 15:37:56 -0400 (AST), [EMAIL PROTECTED]
("Marc G. Fournier") wrote:
Due to recent action by Google concerning the
comp.databases.postgresql.*
hierarchy, we are going to make some changes that should satisfy just
about everyon
On Tue, 23 Nov 2004 16:23:19 -0500, [EMAIL PROTECTED] (Patrick B
Kelly) wrote:
>
>On Nov 23, 2004, at 3:59 PM, Gary L. Burnore wrote:
>
>> On Tue, 23 Nov 2004 15:37:56 -0400 (AST), [EMAIL PROTECTED]
>> ("Marc G. Fournier") wrote:
>>
>>>
>>> Due to recent action by Google concerning the
>>> comp.
On 23 Nov 2004 21:41:16 GMT, Woodchuck Bill <[EMAIL PROTECTED]>
wrote:
>[EMAIL PROTECTED] (Patrick B Kelly) wrote in news:E55E257B-3D95-11D9-
>[EMAIL PROTECTED]:
>
>> On Nov 23, 2004, at 3:59 PM, Gary L. Burnore wrote:
>>
>>> On Tue, 23 Nov 2004 15:37:56 -0400 (AST), [EMAIL PROTECTED]
>>> ("Marc
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
>
[I had written]
> >
> > Did you warn the proponent of comp.databases.postgresql.* that you were
> > going to do this? Did you read any of the arguments for and against a
> > completely separate hierarchy that were posted to the RFD thread in
> > new
Sorry if this has been covered before, but the mailing list search is
down right now.
What's the best way to check for the existance of a function? I saw
pg_function_is_visible(), but the problem is that I'd need to use
::regprocedure with it, and ::regprocedure generates an error if the
function
On 23 Nov 2004 21:57:22 GMT, Woodchuck Bill <[EMAIL PROTECTED]>
wrote:
>Gary L. Burnore <[EMAIL PROTECTED]> wrote in
>news:[EMAIL PROTECTED]:
>
>> And not helping postgres since less NSP's will carry the groups and
>> the postgres message.
>>
>> It's ok. Mysql's better anyway.
>>
>
>Gary, why d
[snip]
I'm not clear on what exactly "as a whole" means, but I would suggest
that arbitrary and peremptory behaviour, perceived or real, is not
likely to endear the pgsql community to Usenet newsmasters.
All I meant was, has core talked about it? Personally I think the fact
that Marc has been as p
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Title: VACUUM and ANALYZE With Empty Tables
We use a development environment that works with Postgres via ODBC and uses cursors to insert and update rows in Postgres tables. I'm using Postgres version 7.4.5.
I have a test program that reads 34,000 rows from an external file and inserts them
Patrick B Kelly <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> Marc appears to be the only one NOT making this situation worse.
Appearances can be deceiving--particularly when you're unfamiliar with
the territory.
> Let's
> review. Si
On Tue, Nov 23, 2004 at 04:49:24PM -0500, Jim Seymour wrote:
> >Perhaps this should
> > be taken up as a whole?
> [snip]
>
> I'm not clear on what exactly "as a whole" means, but I would suggest
> that arbitrary and peremptory behaviour, perceive
"Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> It's ok. Mysql's better anyway.
Was that absolutely necessary?
Jim
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I'm also working on trying to do a select out of pg_proc, but I'm not
> having a lot of luck there either...
> # select oid,* from pg_proc where proname='user_write_lock_oid' and
> proargtypes = ARRAY((SELECT oid FROM pg_type WHERE
> typname='oid'))::
Jim Seymour wrote:
"Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
[snip]
It's ok. Mysql's better anyway.
Was that absolutely necessary?
Yes. It shows his lack of credibility ;)
Jim
---(end of broadcast)---
TIP 6: Have you searched our list archives?
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> All I meant was, has core talked about it?
There has been no private discussion among core about it; it's not part
of our charter IMHO.
Personally I think Marc should have waited awhile longer to see whether
the news.groups process would produce a p
At 05:28 PM 11/23/2004, Joshua D. Drake wrote:
Jim Seymour wrote:
"Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
[snip]
It's ok. Mysql's better anyway.
Was that absolutely necessary?
Of course not.
Yes. It shows his lack of credibility ;)
My credibility isn't the issue. That yet another news server
At 05:43 PM 11/23/2004, Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> All I meant was, has core talked about it?
There has been no private discussion among core about it; it's not part
of our charter IMHO.
Personally I think Marc should have waited awhile longer to see whether
the
Tom Lane <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> Personally I think Marc should have waited awhile longer to see whether
> the news.groups process would produce a positive vote, but that's just
> my own $0.02.
That's the way *I* would've preferred to see it handled. Then again:
*I* was lookin
On Tue, 23 Nov 2004, Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
All I meant was, has core talked about it?
There has been no private discussion among core about it; it's not part
of our charter IMHO.
Personally I think Marc should have waited awhile longer to see whether
the news
* Tom Lane <[EMAIL PROTECTED]> [231104, 14:37]:
> Ennio-Sr <[EMAIL PROTECTED]> writes:
> > This is an extract of the dump file:
>
>
> > COPY dep_tit (cod_rif, titolo, quantity, costo_med_fisc, data_rif,
> > ultima_quot, data_ult_q) FROM stdin;
> > 1 Tit. a 100 3.9112 2004-07-23
* Tom Lane <[EMAIL PROTECTED]> [231104, 14:37]:
> Ennio-Sr <[EMAIL PROTECTED]> writes:
> > This is an extract of the dump file:
>
> [...]
>
> If that is the correct analysis then the easiest fix is probably to edit
> the COPY commands to add WITH NULL AS '-' (this assumes that you don't
> have an
On Tue, 23 Nov 2004, Jim Seymour wrote:
Tom Lane <[EMAIL PROTECTED]> wrote:
[snip]
Personally I think Marc should have waited awhile longer to see whether
the news.groups process would produce a positive vote, but that's just
my own $0.02.
That's the way *I* would've preferred to see it handled.
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> What I've done doesn't eliminate (or shouldn't) the desire for a comp.*
> hierarchy of groups for postgresql, it just means that the what will end
> up still being considered bogus groups will be able to still be accessible
> by those that wish to
Marc G. Fournier wrote:
> Due to recent action by Google concerning the
> comp.databases.postgresql.* hierarchy, we are going to make some
> changes that should satisfy just about everyone ... over the next
> 24hrs or so, traffic *to*
> comp.databases.postgresql.* from the mailing lists will cease
Using Postgres V. 7.4.1, the following query:
SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');
Returns '1'. I would expect it to return '12345'. Is this a bug, or am
I missing something? Thanks.
begin:vcard
fn:Kenneth Tanzer
n:Tanzer;Kenneth
org:Downtown Emergency Service Center;Inform
At 05:57 PM 11/23/2004, Jim Seymour wrote:
Tom Lane <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> Personally I think Marc should have waited awhile longer to see whether
> the news.groups process would produce a positive vote, but that's just
> my own $0.02.
That's the way *I* would've preferred to see i
At 06:16 PM 11/23/2004, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> What I've done doesn't eliminate (or shouldn't) the desire for a comp.*
> hierarchy of groups for postgresql, it just means that the what will end
> up still being considered bogus groups will be able to still
Ennio-Sr <[EMAIL PROTECTED]> writes:
> May I ask how to 'edit the COPY commands'? Perhaps you mean to edit the
> dump file and add "WITH NULL AS '-' " ?
Yeah.
> Mmmh, I tried to add that in the dump file (at the end of the COPY
> command) and got these errors:
> You are now connected as new user
Tim,
I'm afraid, I didn't get the point. Could you give me an example code
snippet of how to use the EXECUTE command in my case. Do I have to use
the EXECUTE within my function?
Thanks a lot,
alex.
Timothy Perrigo wrote:
You'll need to use the EXECUTE command to build the SQL dynamically.
See:
h
On Tue, 23 Nov 2004, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
What I've done doesn't eliminate (or shouldn't) the desire for a comp.*
hierarchy of groups for postgresql, it just means that the what will end
up still being considered bogus groups will be able to still be access
On Wed, 24 Nov 2004, Peter Eisentraut wrote:
Marc G. Fournier wrote:
Due to recent action by Google concerning the
comp.databases.postgresql.* hierarchy, we are going to make some
changes that should satisfy just about everyone ... over the next
24hrs or so, traffic *to*
comp.databases.postgresql.*
Ken Tanzer wrote:
Using Postgres V. 7.4.1, the following query:
SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');
Returns '1'. I would expect it to return '12345'. Is this a bug, or am
I missing something? Thanks.
The regexp {1,5} is satisfied with the minimum of 1 digit. It looks
ahe
I need to import a file into a Unicode database.
I am getting an error:
ERROR: Unicode characters greater than or equal to 0x1 are not
supported
CONTEXT: COPY mailing_list_entry, line 30928, column first_last_name:
"Ver?nica"
The source file came from pg_dump... Is there a way I can easily
Ken Tanzer <[EMAIL PROTECTED]> writes:
> Using Postgres V. 7.4.1, the following query:
> SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');
> Returns '1'. I would expect it to return '12345'. Is this a bug, or am
> I missing something? Thanks.
Hmm ... playing with it, it seems that t
Checking in the Tcl bug tracker reveals that this is an open issue
for them as well:
http://sourceforge.net/tracker/index.php?func=detail&aid=219219&group_id=10894&atid=110894
http://sourceforge.net/tracker/index.php?func=detail&aid=219358&group_id=10894&atid=110894
The first entry has Henry Spen
From: "Ken Tanzer" <[EMAIL PROTECTED]>
> Using Postgres V. 7.4.1, the following query:
>
> SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');
>
> Returns '1'. I would expect it to return '12345'. Is this a bug, or am
> I missing something? Thanks.
the results of mixing greedy and non-
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Jim Seymour
> Sent: Tuesday, November 23, 2004 5:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Upcoming Changes to News Server ...
>
>
>
> "Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
> >
> [snip]
At 07:47 PM 11/23/2004, [EMAIL PROTECTED] wrote:
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Jim Seymour
> Sent: Tuesday, November 23, 2004 5:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Upcoming Changes to News Server ...
>
>
>
> "Gary L.
BTW, you indicated that one of the reasons pressing you to move was that
Google had dropped indexing services for the comp.* groups. Have they
given you an indication that they would index pgsql.*, or are we just
out of luck on that service?
Just FYI, it seems that the comp.* groups are fine o
At 08:12 PM 11/23/2004, Joshua D. Drake wrote:
BTW, you indicated that one of the reasons pressing you to move was that
Google had dropped indexing services for the comp.* groups. Have they
given you an indication that they would index pgsql.*, or are we just
out of luck on that service?
Just FYI,
[EMAIL PROTECTED] ("Gary L. Burnore") wrote in
news:[EMAIL PROTECTED]:
> At 03:44 PM 11/23/2004, Joshua D. Drake wrote:
>
>>>Did you warn the proponent of comp.databases.postgresql.* that you
>>>were going to do this? Did you read any of the arguments for and
>>>against a completely separate hi
Robert McClenon <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> I have not checked that out, but am very pleased to hear it.
Have a look..
http://groups.google.com/groups?hl=en&lr=&group=comp.databases.postgresql
Just goes to show you, there are things that can be done about rogue
gr
[EMAIL PROTECTED] (Patrick B Kelly) wrote in news:E55E257B-3D95-11D9-
[EMAIL PROTECTED]:
> The list has been deluged with
> countless angry process oriented messages filled with vitriol and
> devoid of any content regarding the purpose of this forum, we have been
> bombarded with profanity,
On Tue, 23 Nov 2004, Gary L. Burnore wrote:
> At 07:47 PM 11/23/2004, [EMAIL PROTECTED] wrote:
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] Behalf Of Jim Seymour
> > > Sent: Tuesday, November 23, 2004 5:18 PM
> > > To: [EMAIL PROTECTED]
> > > Subj
Tom Lane wrote:
> regards, tom lane
Tom,
>From the content of some of your posts I gather that you are a contributor
to the PostgreSQL development effort.
I just wanted to say thanks for such a fine applications.
--
--
GreyGeek
---(end of broadcast)---
Patrick May <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> Interesting. Does this affect anyone's views on the group name
> (yes, I'm looking at you, Ms. Morgan) or is the feeling that existing
> users wouldn't switch to a new name, even if it were archived by
> Google?
If they wer
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in
news:[EMAIL PROTECTED]:
>
> Due to recent action by Google concerning the
> comp.databases.postgresql.* hierarchy, we are going to make some
> changes that should satisfy just about everyone ... over the next
> 24hrs or so, traffic *to* comp.databa
Gary L. Burnore <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> And not helping postgres since less NSP's will carry the groups and
> the postgres message.
>
> It's ok. Mysql's better anyway.
>
Gary, why do your posts show up twice in postgresql.general? Different
message IDs for each
Hello,
I saw discussion about bitmap indexes few weeks ago. I wonder if
any of you is working on it (in secret)? I will be chosing subject
of my master thesis and thougth about implementing bitmap indexes.
--
**Paweł Niewiadomski**, new()foo-baz.com, http://new.foo-baz.com/
Podręcznik Administra
ctlinnd rmgroup comp.databases.postgresql.interfaces.php
ctlinnd rmgroup comp.databases.postgresql.ports.general
ctlinnd rmgroup comp.databases.postgresql.interfaces
ctlinnd rmgroup comp.databases.postgresql.ports
ctlinnd rmgroup comp.databases.postgresql.interfaces.general
ctlinnd rmgroup comp.da
[EMAIL PROTECTED] (Jim Seymour) wrote in
news:[EMAIL PROTECTED]:
> The key words there being "think about," IMO. For example, the part
> about "would have even more prestige." Really? My news server at work
> doesn't carry such newsgroups at all. Which is pretty much the point
> somebody else
[EMAIL PROTECTED] (Patrick B Kelly) wrote in news:E55E257B-3D95-11D9-
[EMAIL PROTECTED]:
> On Nov 23, 2004, at 3:59 PM, Gary L. Burnore wrote:
>
>> On Tue, 23 Nov 2004 15:37:56 -0400 (AST), [EMAIL PROTECTED]
>> ("Marc G. Fournier") wrote:
>>
>>>
>>> Due to recent action by Google concerning the
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
to usenet works, how about back to mail?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[EMAIL PROTECTED] (Jim Seymour) writes:
>Here's another factoid for you. When a new big-8 newsgroup is
>approved, an "official" newsgroup creation control message is sent.
>Well, somebody *forged* just such a control message for one-or-more
>comp.databases.postgresql.* newsgroups.
That was *not*
[EMAIL PROTECTED] ("Gary L. Burnore") writes:
>At 05:28 PM 11/23/2004, Joshua D. Drake wrote:
>>Jim Seymour wrote:
>>>"Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
>>>[snip]
>>>
It's ok. Mysql's better anyway.
>>>
>>>Was that absolutely necessary?
>Of course not.
>>Yes. It shows his lack of
At 08:58 PM 11/23/2004, you wrote:
ctlinnd rmgroup comp.databases.postgresql.interfaces.php
ctlinnd rmgroup comp.databases.postgresql.ports.general
ctlinnd rmgroup comp.databases.postgresql.interfaces
ctlinnd rmgroup comp.databases.postgresql.ports
ctlinnd rmgroup comp.databases.postgresql.interfac
"\"Marc G. Fournier From\"@svr1.postgresql.org"@linxnet.com: <[EMAIL
PROTECTED]> wrote:
>
> [EMAIL PROTECTED] (Jim Seymour) writes:
>
> >Here's another factoid for you. When a new big-8 newsgroup is
> >approved, an "official" newsgroup creation control message is sent.
> >Well, somebody *forged
For the record, you shouldn't have needed to do a dump restore between
7.4.1 and 7.4.6 should you?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Nov 19, 2004, at 7:24 PM,
"Thomas F.O'Connell" <[EMAIL PROTECTED]> wrote:
>
> For the record, you shouldn't have needed to do a dump restore between
> 7.4.1 and 7.4.6 should you?
IIRC, it was 7.4.1 -> 7.4.2 that required either that or some
manual fixing-up.
Jim
---(end of broadcast)
Sorry for the brief response earlier; I was a bit rushed. After
looking into it, it's a bit messier than I thought (at least, as far as
I can tell...perhaps one of the gurus on this list can show us a better
way).
Ordinarily, when you write select statements (for example) in a plpgsql
functio
[EMAIL PROTECTED] ("Gary L. Burnore") writes:
>At 07:47 PM 11/23/2004, [EMAIL PROTECTED] wrote:
>> > -Original Message-
>> > From: [EMAIL PROTECTED]
>> > [mailto:[EMAIL PROTECTED] Behalf Of Jim Seymour
>> > Sent: Tuesday, November 23, 2004 5:18 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: R
At 11:56 PM 11/23/2004, Stephan Szabo wrote:
On Tue, 23 Nov 2004, Gary L. Burnore wrote:
> At 07:47 PM 11/23/2004, [EMAIL PROTECTED] wrote:
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] Behalf Of Jim Seymour
> > > Sent: Tuesday, November 23, 2004 5:1
On Tue, 23 Nov 2004, Timothy Perrigo wrote:
> Sorry for the brief response earlier; I was a bit rushed. After
> looking into it, it's a bit messier than I thought (at least, as far as
> I can tell...perhaps one of the gurus on this list can show us a better
> way).
>
> Ordinarily, when you write
I'm not sure, (RFC2822 grammar parsing is touchy stuff) but I think this email
address you posted from is messed up:
"\"\\"Marc G. Fournier From\\"@svr1.postgresql.org\":" <[EMAIL PROTECTED]>
That is, I think the display-name part of the address after unquoting is:
"\Marc G. Fournier From [EMAI
in Fedora core 1:
abc=# select version();explain select * from abc;select count(*) from abc;
version
-
Hello,
When I do a "pgdump --schema=someschema somedatabase > something.dump",
the results of the dump file look like this:
REVOKE ALL ON SCHEMA someschema FROM PUBLIC;
GRANT ALL ON SCHEMA someschema TO PUBLIC;
SET search_path = someschema, pg_catalog;
CREATE SEQUENCE emailtemplate_email_t
"songsubo" <[EMAIL PROTECTED]> writes:
> in Fedora core 1:
> Time: 35.84 ms
> in Fedora core 3:
> Time: 29.876 ms
And your problem was what exactly?
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increas
On Sun, Nov 21, 2004 at 05:50:30PM +, Chris Green wrote:
> I'm after a good report generator for a postgresql database. I am
> using Rekall at the moment which is quite good but I'm not quite able
> to do some of the things I want.
>
> Has anyone got any recommendations for forms/reports gene
93 matches
Mail list logo
