b$' is only prompt and depend on PS1 environment value
setting. You can found more information in 'man bash' in the
/etc/profile file or other places...
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end o
is
>pg_dump -Ft -b test1 > db.tar
>
> I get following message
> pg_dump: WARNING: function "lo_oid" not dumped
> pg_dump: reason: data type name of argument 0 (oid 16584) not found
See and try the "pg_dumplo" from contrib tree. Maybe it help you.
Kare
t's in TODO, but I think nobody
works on this very wanted feature :-(
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
abo=# select to_date(to_char(20020101, 'FM'),'mmdd');
> > to_date
> >
> > 2002-01-01
> >(1 row)
The extra space is very common for all to_...() outputs/inputs and is
needful thing of this. Don't ask me why.. i
i=# select timestamp(date '1998-02-24',time '23:07');
> ERROR: parser: parse error at or near "date"
test=# select date '1998-02-24' + time '23:07';
?column?
-
1998-02-24 23:07:00
(1 row)
test=# select timestamp '1
;t create tables.
But we can still think about better privilege system with more
settings. For example Oracle's GRANT/REVOKE is still better :-)
There was some planns, Peter, Jan? IMHO now is good time for open
this theme again.
Karel
--
Karel Zak <[EMAIL PROTECTED]&g
ut the data? Is there a simple command for that?
>
pg_dump
-s, --schema-onlydump out only the schema, no data
Something is bad on docs or pg_dump --help? :-)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, Po
( i already know the ILIKE clause but
>it's
> insufficient !! ...)
What is insufficient? You can use a lot of solutions for case insensitive
oprations, like LIKE/ILIKE, upper(foo)=upper(bar), etc.
See mailing list arhives, it's already discussed theme.
>
On Thu, Apr 19, 2001 at 10:04:42AM -0300, Fabio Alberto Sobral wrote:
> Dear Sirs,
>
>I have a timestamp atribute in my table and I want to get only the date of
> this atribute. How can I do this? Does the extract or date_part functions
> resolve my problem?
Cast timestampt to date:
hether or not
> someone is working on Python as a server-side function language (PL/Python)?
Yes, I will try implement it for 7.2
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://d
ge.com -- this
is very popular theme :-)
BTW, anywhere at http://sourceforge.net is OpenSource database test too.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
-
On Wed, 14 Feb 2001, Tom Lane wrote:
> "Schmidt, Peter" <[EMAIL PROTECTED]> writes:
> > However, what I'm interested in is the comparison between 7.0x and 7.1x.
> > Shouldn't the 7.1b4 database be faster? Have you (or anyone else) done this
> > comparison?
>
> 7.1 is considerably faster if you
On Mon, 5 Feb 2001, [iso-8859-1] Johan Segernäs wrote:
> And running postgresql on a P133 with 64 meggs of RAM using debian woody.
> How many users will that box be able to serve?
>
> I'm running apache/php on another machine and the database will have
> questions and answers for some exams
On Tue, 19 Sep 2000, Vladimir V. Zolotych wrote:
> Hi all,
> Can you help me a bit ?
> The question is: how can I compare TEXT and CHAR(32) types ?
> More detailed description:
> my=> create table foo (tt text, cc char(32));
>
> CREATE
> my=> insert into foo values ('aa', 'ab');
>
>
On Wed, 6 Sep 2000, vijayendra mohan agrawal wrote:
> Dear all,
>
> How to define FOREIGN KEY in a table ???
Found you some problem in great PostgreSQL documentation?
Karel
CREATE [ TEMPORARY | TEMP ] TABLE table (
column type
[ NULL | NOT NUL
On Tue, 18 Jul 2000, Sandro Serafini wrote:
> Hi!
>
> > And don't forget some_postgresSQL_user != OS_user.
>
> Yes I know, but I would be satisfied :)
>
> > For you problem has commercial DB something like tablespace and quota for
> > users, but all these are *internal* in a DB and DB not us
On Tue, 18 Jul 2000, Sandro Serafini wrote:
> Hi!
>
> I need to limit the postgresql user's quotas on my system...
>
> I noticed that postgres creates a new directory for every database, so I tried
> changing the owner of the directory and the files within the directory to the
> unix user "own
On Wed, 5 Jul 2000, Yadira M. Rodriguez wrote:
> Hi,
>
> I'm getting this error: "No such function 'to_char' with the specified
> attributes" when trying to select a timestamp type field. For example:
> "select to_char(col_name, 'MM-DD-') from table_name". Is there
> somebody that can he
On Thu, 29 Jun 2000, stanislas pinte wrote:
> hello,
>
> I posted several questions in the mailing list "general", and received no
> response. I think that it is not documented where to manage the
> connection time-out as far as TCP/IP connections are concerned.
>
> My problem is the following
On Fri, 2 Jun 2000, Bruce Momjian wrote:
> > > Most think that raw devices are a pain and offer little performance
> > > improvement and lots of portability and coding problems.
> >
> > I don't know how much it is a performance improvement (someone say 10-20%),
> > but Bruce is probably right,
On Fri, 2 Jun 2000, Bruce Momjian wrote:
> > > [ Charset ISO-8859-1 unsupported, converting... ]
> > > > I understand OID is signed integer which go up to 2^31.
> > > > Almost any case it would be sufficient. (It's sufficient for me, at least)
> > > >
> > > > What I really want to know is the sa
>
> I was thinking about a solution that doesn't cause an overflow. Please
Use 'numeric' datetype. It never overflow and allow you to use deciamal
numbers, but is slowly and is needs more memory.
Karel
On Fri, 26 May 2000, Norbert Meissner wrote:
> Hi all,
>
> i found a strange behaviour in Postgresql 7.0 on FreeBSD 4.0
>
> $ createdb foo
> $psql foo
> foo=# create table number (a_number int);
> foo=# insert into number values(15);
> foo=# insert into number values(16);
> sel
On Wed, 5 Apr 2000, Hernan J. Gonzalez wrote:
> I'm puzzled with the date formats in
> the 7.0b2 version. Perhaps I'm missing something
> trivial, (SQL standards?) but I have been using postgres
> from years, and never had this kind of problem.
>
> I use the -e switch, so that
> > dates passed
On Thu, 16 Mar 2000, KOOPMAN,JON (A-SantaClara,ex1) wrote:
> Thanks for the quick response,
>
> o Possibly add a permission structure to database level ACL
>that can turn off read privilege to a database to certain
>/all users. Is there any reason to limit database
>connectivity d
On Sat, 19 Feb 2000, Peter Eisentraut wrote:
> On 2000-02-18, [EMAIL PROTECTED] mentioned:
>
> > pg_dump doesn't support large objects, I haven't found any advise how
> > to do it in doc neither in FAQ. How an I to backup a db with large
> > objects without losing my data?
>
> You need to writ
On Tue, 28 Dec 1999, Ruben Fagundo wrote:
>
> I was wondering if anyone has seen this problem. I created a Postgres
> Database, and when I run
>
> vacuum -z -v db_name --table mixedTablename
>
> I am told:
>
> NOTICE: vacuum: Table not found
vacuum --table \"TableName\" ...etc
and very interesting is
that it not exist in the standard distribution.
I can continue with development of this program if will interest.
Karel
--
Karel Zak <[EMAIL PROTECTED]> http://home.zf.jcu.cz/~zakkr/
Docs:
28 matches
Mail list logo