Philip Crotwell <[EMAIL PROTECTED]> writes:
> I am running postgres7.1 on redhat 6.2 and my database has gone belly up.
> I know i am not supposed to "kill -9 " the postmaster, but it has become
> completely unresponsive. pgsql just hangs as does stopping with the
> rc.d script.
Actually, kill -
Hi,
I used PostgreSQL 6.53 and I used tables with timestamps fields. When I
read the value of a Timestamp field in a C program, i received a string of
this format :
2001-04-08 12:54:09-0
Can someone give me some explanation about the meaning of the two last
characters ?
Thanks
Natacha Joseph
[E
Hi
I'm working on a project (http://mandible.sourceforge.net/)that uses
postgres for a membership directory. The database being used as a
starting example is currently an Access database, and the first naming
standard I'm using is the Leszynski/Reddick one at
http://msdn.microsoft.com/library/bac
Tom Lane wrote:
>
> Renaud Thonnart <[EMAIL PROTECTED]> writes:
> > Which is the SQL norm of PostgreSQL?
> > I suppose it is SQL3 ?
>
> AFAIK, SQL3 is not a recognized standard. We are converging (slowly)
> on full support for SQL92, and we have some SQL99 features (and will
> have more over t
Anyone have any clues as to my question yesterday re: why my trigger
only fires on the first insert per connection? After posting yesterday,
I tried a few different things, but the only thing that works (and
obviously not the most efficient thing to do) is to disconnect and
reconnect after every
I am generating scripts from MSSQL Server and converting them to create objects in
PostgreSQL. It is suprisingly easy. However, I think I may have hit a rock.
It appears that PostgreSQL does not support listing constraints to be added as in the
following syntax:
alter table foo add
hello,
i trying to restore a database with lagre objects with
pg_restore -o -d
i dumped it with:
pg_dump -Ft -o >
The result:
Archiver(tar): unable to find header for 52.dat
What wrong
thanks
Torsten Krämer
---(end of broadcast)---
TIP
Hello,
I know nothing about triggers so I need a little hand-holding here. I'm
taking an Oracle script and converting it to pgsql. One of the things
that the Oracle database supports is a trigger on dates. So there are two
fields in the table, CREATION_DATE and UPDATE_DATE.
In the CREAT TABLE st
Keith Siu <[EMAIL PROTECTED]> writes:
> I ve made a mistake to create a view " all staff" and can't drop it
> everytime I descript or drop the view , it appear Error as below :
> template1> \d all staff;
> ERROR: nodeRead : Bad type 0
> template1>drop view all staff;
> ERROR :parser: parser erro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 11 May 2001 10:26, Philip Crotwell wrote:
> PS I don't know why this happened, but the only theory I have is that I am
> running with -i to allow jdbc connections and I had port scanned the
> machine with nmap shortly before noticing that I
"Simon Crute" <[EMAIL PROTECTED]> writes:
> The error message reported is
> [Tue May 8 20:25:27 2001] newuser.plx: DBD::Pg::st execute failed: ERROR:
> parser: parse error at or near "ail" at /.../cgi/newuser.plx line 161.
Suggested approach to problems like this: turn on query logging at th
Andrew Perrin <[EMAIL PROTECTED]> writes:
> Has anyone got advice on building postgres 7.1 with PL/Perl support
> WITHOUT having one's perl installation built with a shared libperl.a?
Try repeating the Perl build with shared-lib selected and then just
installing the resulting libperl.so beside l
Here are some links to SQL tutorials:
http://www.intermedia.net/support/sql/sqltut.shtm
a PostgreSQL-specific tutorial can be found at:
http://www.eskimo.com/~ericj/comp/sql1.htm
Tim
- Original Message -
From: "Mark R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May
> create trigger date_update before update on mytable
> for each statement execut procedure [procedure that inserts a date
> for me in the update_date column]
>
> So what would I be doing for the portion in brackets?
at that point you need a function.
check out the CREATE FUNCTION syntax i
Marcos Cruz <[EMAIL PROTECTED]> writes:
> I'm changing a database from Access'97 to PostgreSQL 7.1.1 and
> found a query limit when a I have large text field into the SQL
> insert.
> The returned msg is like " query too long, length > 8191 octets"
Hm, I notice
#define TEXT_FIELD_SIZE
[EMAIL PROTECTED] writes:
> Some times on PG 7.1 under heavy load pg complains that there are too
> many open files. I am running it under RedHat Linux 7.1 on the 2.4
> kernel. Is this just a matter of needing to increase the maxfiles in
> proc/sys/fs?
Check what is using the fds - I'm not a
Hi,
Trying to install onto a linux box with an rpm.
libpq.so.2 and libpq.so.2.0 both are in /usr/lib which is in my LD_LIBRARY_PATH
so I can't understand the problem:
[coers@antibes postgresql-7.1-RH6x-i386]$ sudo rpm -U *.rpm
error: failed dependencies:
libpq.so.2 is needed by postgres
Hi
Not sure if this is helpful, but...
Am I doing this correctly, anything else to try before "pulling the plug"?
thanks,
PHilip
# gdb postmaster 29214
GNU gdb 19991004
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
we
Hi,
Is it possible to create an index using a function(field) sintaxis ?
For instance:
CREATE INDEX "i1_cdu" on "cdu" using btree ( substr(cdu_code,1,1)
"varchar_ops" );
If not, should I alter the table to include a field with the value
'substr(codigo,1,1)'.
Thanks
Gabi :-)
--
Hi
Once more, this time with feeling :)
Sorry, not a regular user of gdb, but I figured out my error, does this
help?
Anything else before kill -9?
thanks,
PHilip
# gdb postmaster 29214
GNU gdb 19991004
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU Gen
> (gdb) bt
> #0 0x4013da02 in __libc_accept () from /lib/libc.so.6
> #1 0x80c34b9 in StreamConnection ()
> #2 0x80e07b1 in ConnCreate ()
> #3 0x80e0239 in ServerLoop ()
> #4 0x80dfdb3 in PostmasterMain ()
> #5 0x80c3fa5 in main ()
> #6 0x400a39cb in __libc_start_main (main=0x80c3ec0 , argc=
On 8 May 2001, at 7:13, Raymond Chui wrote:
> What is the $PGDATA/data/pg_log file use for?
> Is it a logical log file file? I see that file grow very big.
> Can I do `cat /dev/null > $PGDATA/data/pg_log`
> reduce it to zero size once a while? Or is there other
DON'T!
That file is the transa
Maybe someone can confirm what looks like a long-name-truncation bug in
7.0.0? I haven't tested it on newer releases, nor have I dug into the
code. The problem appears to be that a different truncation algorithm is
used for creating the truncated sequence name than the algorithm used
when doing
> Is it possible to create an index using a function(field) sintaxis ?
As far as I know you can -- I have lots of indexes on lower(varchar).. There
may be limitations though so I'll let someone else have the final word :-)
-Mitch
---(end of broadcast)--
> I am generating scripts from MSSQL Server and converting them to create
objects in PostgreSQL. It is suprisingly easy. However, I think I may have
hit a rock.
>
> It appears that PostgreSQL does not support listing constraints to be
added as in the following syntax:
I don't know why it won't
Hi,
I am looking for a cheap hosting plan that supports PostgreSQL (hopefully
7.1) with PHP4 on a unix platform (BSD prefered, Linux would be OK though).
It would be nice if phpPgAdmin was already configured with the account. But
if not, that's ok, I can set it up myself. This is only for the dev
VACUUM ANALYZE;
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM
What does this mean?
TIA!
-Ryan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister co
>> Also, I see that alter table add constraint does not work for defaults.
>>
>> Is this something that is going to be added?
>
> That I do hope will be added since the only way to replicate the
> functionality is to drop, readd and repopulate a table.
>
> Greg
I am not sure specifically what
On Mon, 7 May 2001, Ian Harding wrote:
> I am generating scripts from MSSQL Server and converting them to
> create objects in PostgreSQL. It is suprisingly easy. However, I
> think I may have hit a rock.
>
> It appears that PostgreSQL does not support listing constraints to be
> added as in th
Ed Loehr <[EMAIL PROTECTED]> writes:
> Maybe someone can confirm what looks like a long-name-truncation bug in
> 7.0.0?
I see no bug here; it told you what name it planned to use for the
sequence:
> psql:/home/ed/pgbug:8: NOTICE: CREATE TABLE will create implicit
> sequence 'process_state_subsc
Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> Is it possible to create an index using a function(field) sintaxis ?
Yes, but *only* on a function of one or more raw fields.
> CREATE INDEX "i1_cdu" on "cdu" using btree ( substr(cdu_code,1,1)
> "varchar_ops" );
This doesn't work because you hav
you need to be a postgresql user, which is somewhat like being a unix user
but different,
you said earlier that you've got a debian system so,
if you have a user account that is already registered as a postgres
superuser login to that account and say:
createuser jorge
Otherwise, if you've just
Tom Lane wrote:
>
> Ed Loehr <[EMAIL PROTECTED]> writes:
> > Maybe someone can confirm what looks like a long-name-truncation bug in
> > 7.0.0?
>
> I see no bug here; it told you what name it planned to use for the
> sequence:
>
> > psql:/home/ed/pgbug:8: NOTICE: CREATE TABLE will create impli
"Richard Huxton" <[EMAIL PROTECTED]> writes:
>> ?? Knowing that your previous guess was wrong doesn't tell you what the
>> right answer is, especially not for the somewhat-different question that
>> the next query is likely to provide.
> Surely if you used a seqscan on "where x=1" and only got 2
We have a table with a lot of user sessions (basically end -time and
length of connection). We would like to query this table to count the max
number of simultaneous sessions, but we are stumped on how to do that.
The only thing I have been able to think of is to iterate over the entire
table
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
>> I believe you could actually use a non-shared libperl.a on Intel Linux;
>> just dike out the test for shared-ness in plperl's Makefile.PL.
>> The reason it's there is we couldn't think of a direct test for
>> position-independent code, which is the r
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
> As far as I know, there is no simple way to test whether libperl.a is
> compiled as position independent code or not. But it would be fairly
> easy to test whether you can build a shared library using libperl.a,
> by writing a little test case which
37 matches
Mail list logo