Thats most of what I needed. I shouls be able to suss out the rest.
Thanks
Rick
Martijn van Oosterhout wrote:
Well, using the -E option to psql, \df expands to:
SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||
pg_catalog.format_type(p.prorettype, NULL) as "Result data type",
n.nspna
I've read this message, and tryed to apply this changes to my own database.
sapiens=# vacuum verbose;
...
INFO: free space map: 1 relations, 39 pages stored; 48 total pages needed
DETAIL: Allocated FSM size: 1000 relations + 3 pages = 237 kB shared memory.
1 relation and 48 pages seems
Cott Lang <[EMAIL PROTECTED]> writes:
> On Mon, 2003-12-08 at 02:53, Thierry Missimilly wrote:
>
>> For exemple, with the root privilege :
>> mount -t ext3 -o data=writeback /dev/sdb1 /data1
>
> Thanks, but my problem is I need to change the root partition to
> data=writeback, which you can't do b
Hi, all.
Re: version 7.2.2
I modified the postgresql.conf file as below and got "really neat"
debugging turned on. :)
pg_ctl reload -D
Unfortunately after I was done, I wanted to turn it off again. I
commented out the lines and ran the "reload" again. This did not have
any effect. So, I
Chris Travers <[EMAIL PROTECTED]> writes:
> On Mon, 2003-12-08 at 01:39, Tom Lane wrote:
>> Is it really not possible to express what you need with plain old SQL
>> permissions? It seems like you are going out of your way to avoid the
>> obvious solution.
> Thanks-- as you can see, that is what t
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Chris Travers <[EMAIL PROTECTED]> wrote:
>> I suspect I know what the answer here is, but I thought I would ask
>> anyway. How transparent are SQL language functions from the planner's
>> perspective? For example if I create a table:
> In 7.4 simpl
John Gibson <[EMAIL PROTECTED]> writes:
> Unfortunately after I was done, I wanted to turn it off again. I
> commented out the lines and ran the "reload" again. This did not have
> any effect.
No, it wouldn't; a comment is a comment. You'd need to change the
entries to explicitly select the o
[EMAIL PROTECTED] wrote:
> In the command
>
> CREATE OPERATOR name (
> PROCEDURE = func_name
> [, LEFTARG = lefttype ] [, RIGHTARG = righttype ]
> [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
> [, RESTRICT = res_proc ] [, JOIN = join_proc ]
> [, HASHES ] [, MERGES ]
> [, S
On Mon, 8 Dec 2003, Josué Maldonado wrote:
> Hello list,
>
> Is there a way to manual/explicit lock a record from within a plpgsql
> function?
SELECT ... FOR UPDATE
--
Nigel Andrews
---(end of broadcast)---
TIP 5: Have you checked our extens
<[EMAIL PROTECTED]> writes:
> Is omitting the COMMUTATOR option a problem at all in case of
> self-commutative operators?
At the moment it only really matters for operators that are used in
top-level WHERE clauses --- which lets out anything that doesn't return
boolean. But I'd say that as a matt
On Mon, 8 Dec 2003, Stephan Szabo wrote:
> On Tue, 9 Dec 2003, Brendan Jurd wrote:
>
> > Hi all,
> >
> > I read on the manual page for Inheritance that:
> >
> > "A limitation of the inheritance feature is that indexes (including
> > unique constraints) and foreign key constraints only apply to sin
On Tue, 9 Dec 2003, Brendan Jurd wrote:
> Hi all,
>
> I read on the manual page for Inheritance that:
>
> "A limitation of the inheritance feature is that indexes (including
> unique constraints) and foreign key constraints only apply to single
> tables, not to their inheritance children. Thus, in
Peter Eisentraut wrote:
Brendan Jurd wrote:
I have a few projects that could benefit from inherited table
structure, and it's a very cool idea, but this inability of indexes
to include derived tables is a real functionality-killer. It's not
"Object Relational" if the objects can
Hi all
I can see Postgresql calls itself a "object-relational database
management system", but what's the object part of it?
I have found inheritance, but are there more OO features in postgresql?
br
socketd (a postgresql newbie)
---(end of broadcast)
Brian Maguire wrote:
What's the best way to create a connection with dblink with persisted
connections for web applications?
It all depends on how you intend to use the dblink connections.
If your web page connects to Postgres, issues a single query using
dblink (via a view or whatever), and th
Hi Keith, everyone,
I'm sure you've caugth my last message as I was too hasty to post my
replies
right away. Anyways, it turned out that the only cause of my problem is
that
I 've applied "upx" on the binaries. It works though for my standard
Slackware
setup, but it does not for the busybox enviro
"Victor B. Berdin" <[EMAIL PROTECTED]> writes:
> I'm sure you've caugth my last message as I was too hasty to post my
> replies right away. Anyways, it turned out that the only cause of my
> problem is that I 've applied "upx" on the binaries.
Even more specifically, it sounds like the problem was
Hi!
Thanks all for your help.
Now I can dump data from old dababase, but new problem came when I restore the
data to postgresql 7.4.
Error went out during the COPY command, if I do it in such command lines:
1. pg_dump news -f pgsql-database-news.sql #in ol
Hello ！
I can dump data from old dababase(Postgresql 6.5.3), but new problem came out
when I restore the data to postgresql 7.4.
It went out during the COPY command, if I do it in such command lines:
1. pg_dump news -f pgsql-database-news.sql #in old system w
19 matches
Mail list logo
