Hi All:
I got a question right now, please let me a hand.
I am wondering is Postgresql will do something like session on the back
end that will lock up a table or database while a table or database is
accessed by one user. Then all other user cannot access that table or
database.
As I know, ther
[EMAIL PROTECTED] wrote:
> Hi,
>
> how can i import data from a file with text delimited ( CSV or similar ) ?
No, sorry. I would like to add that feature for 7.3. You can use COPY
and the fields have to be delimited by a single character.
--
Bruce Momjian| http://c
Tom Lane wrote:
Thomas Swan <[EMAIL PROTECTED]> writes:
No, it won't. If the user has TimeZone set to -05, as he should, then
his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'.
And it will be displayed to him that way. But if someone else who
has
Thomas Swan <[EMAIL PROTECTED]> writes:
>> No, it won't. If the user has TimeZone set to -05, as he should, then
>> his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'.
>> And it will be displayed to him that way. But if someone else who
>> has TimeZone set differently lo
I just realized, after trying to compile a C++ script, that I forgot to compile the
C++ interface library during the installation of postgres. At least I'm assuming this
to be the case as /usr/include/pgsql -lpq++ doesn't exist. My question is: do I need
to recompile postgres to create the /usr
Oh, I remember. There was some bad control characters in 7.0 and
earlier in genbki.sh. I think the following patch should fix things for
you. Of course, we have a nice 7.2.1 waiting for you. ;-)
---
Camilo Villarreal wr
On Fri, 21 Jun 2002, Tom Lane wrote:
> If you are using 7.2, shut down the postmaster, start a standalone
> backend and issue the proper ALTER USER commands to restore postgres'
> superuserdom. (There is info about running a standalone backend on
> the 'postgres' man page and the 'REINDEX' man p
Tom Lane wrote:
Felipe Nascimento <[EMAIL PROTECTED]> writes:
let's imagine that my server resides in Time Zone(TZ) "-00", and one user
resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the
server, on the same day.
Let's say that the user inp
Hi all,
I have a stange problem when executing pg_dumpall as a cron job.
The crontab entry looks like:
05 22 * * 1-5 postgres /usr/bin/pg_dumpall -D >
/disks/postgres/db.pg_dumpall
On stderr I get the message
connected to template1...
/usr/bin/pg_dumpall: 0: Bad file descriptor
The createt
Title: RE: [ADMIN] time stamp
Is this valid for Web applications where the db server's client is the web server? (web server resides on the same machine of the db server!)
Or this is valid only for client x server applications?
Felipe
-Original Message-
From: Tom Lane [mailto:[E
Hi,
how can i import data from a file with text delimited ( CSV or similar ) ?
Thanks in advance.
sandro.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello again,
I have some additional information that points to an
encoding problem. I pulled the COPY sql from the dump
file for the table that didn't get inserted properly
and tried to run just that section (with psql -f). I
got this error:
psql -f bibent_data.sql HRS
psql:bibent_dat
Date exist in database.
What err:
SELECT T01.Operador, T01.Data, T01.Hora,
T01.TipoCli, T01.Cliente, T01.Contato, T01.Cidade, T01.UF, T01.DDD, T01.Fone,
T01.Observacoes, T01.Valor, T01.IsCliInic, T01.Produto, T01.Motivo,
T01.Resultado, T01.Promocao, T01.ProdPromo1, T01.ProdPromo2, T01.P
I installed postgres & did the following
/usr/local/pgsql/bin$ pg_ctl start -l logfile
/usr/local/pgsql/bin$ createdb testdb
I got the following message
/usr/lib/postgresql/bin/psql: relocation error:
/usr/lib/postgresql/bin/psql: undefined symbol: pg_encoding_to_char
createdb: database creat
Hello,
first I'm sorry for my english, but I hope you can understand my following
problems and questions.
As I spent much time in getting information about the posibilities with
authentification in postreSQL there are some questions left. I didn't found
any answers to this questions so I hope you
Hello,
I've looked for this in the books and archives and
haven't been able to find an answer.
I did a pg_dump on an older postgres database (I
believe it's 7.0.something), and restored to 7.2.1
with multibyte capability. The old db is not
multibyte. What's happened is that there are a
signifi
Hi,
We had recently an outage on one of our servers running Solaris 6+Postgresql
7.0 and we'll have to restore the databases from tape. This time I
installed Solaris 7 and gcc 3.1 but when I tried to compile postgresql 7.0,
after I run configure, I get no Makefile!!!.
I guess the gcc version
Hello all,
I've a hard working pgsql db running on 7/7x365 server. Each night (when
activity is less intensive) I run vacuum and vacuum analyze on tables where
principal activity is performed.
Tables are cleaned (files sizes are decreasing), but indices files keeps on
growing in si
I just realized, after trying to compile a C++ script, that I forgot to compile the
C++ interface library during the installation of postgres. At least I'm assuming this
to be the case as /usr/include/pgsql -lpq++ doesn't exist. My question is: do I need
to recompile postgres to create the /usr
<>
Felipe Nascimento <[EMAIL PROTECTED]> writes:
> let's imagine that my server resides in Time Zone(TZ) "-00", and one user
> resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the
> server, on the same day.
> Let's say that the user inputs a date for a business meeting: "2002-06-
Title: Re: [ADMIN] time stamp
Anybody???
I used to manage a database without Time Zone. Now I use PG,
and this concept of using Time Zone in date data is new to me. I find it
intersting, but I have the following doubt:
let's imagine that my server resides in Time Zone(TZ) "-00"
Davide Bozzelli <[EMAIL PROTECTED]> writes:
> I have lost the superuser permissions of postgres user.
> The postgres user does not have the "create user"
> and "create database" permission .
> Are there a way to recover this permissions without
> the recreation of the cluster database ?
If you a
Hi.
alter table alter column add
default ;
Cheers,Florian
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
RobsonSent: Friday, June 21, 2002 2:13 PMTo:
[EMAIL PROTECTED]Subject: [ADMIN] Default value after
table createImportance: H
With set default value,
after table create ?
with pgAdmin II , psql, or
etc...
Regards,
Robson
Hi
I have lost the superuser permissions of postgres user.
The postgres user does not have the "create user"
and "create database" permission .
Are there a way to recover this permissions without
the recreation of the cluster database ?
Thx for help .
---(end of br
26 matches
Mail list logo
