"Aggarwal , Ajay" <[EMAIL PROTECTED]> writes:
> I am having a problem, while trying to CREATE a table with more than one
> column of type 'serial'. Apparently only one sequence gets created and that
> is for the last 'serial' type column in the table.
How embarrassing ... I wonder how long that's
On Thu, Jan 25, 2001 at 08:40:23AM -0500, wrote:
> I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but
> its not working. can someone show me a example or something?
It's % and you have to use the LIKE operator.
SELECT * FROM thistable WHERE name LIKE '%marley';
--
Adam
=?iso-8859-1?Q?"Felix=20K=F6nig"?= <[EMAIL PROTECTED]> writes:
> gcc -I../../../include -I../../../backend -I/usr/local/include -O2 -I/usr/local/inc
> lude -DBUILDING_DLL=1 -Wall -Wmissing-prototypes -Wmissing-declarations -I../..-c
> -o istrat.o istrat.c
> istrat.c: In function `OperatorRe
> > Is there a way to start with yesterday's dump and load each transaction
> > log dump in order until you have a complete restore of the database?
WAL based BAR is not implemented in 7.1
Try to use Rserv from 7.1' contrib - it generates consistent incremental
snapshots.
> Also, does a pg_dump
> George Johnson writes:
>
> > Where to find high level specs on what is/isn't needed to make a new
> > procedural language?
>
> The CREATE LANGUAGE reference page contains some pointers.
>
> > With JNI I don't see why PL/Java would be an unreasonable undertaking and
> > sure-fire way to "Make
"Richard Huxton" <[EMAIL PROTECTED]> writes:
> Doesn't seem to be the notify - backend crashes with
> create rule blah_upd as on update to blah do insert into foo (dummy) values
> ('test');
Actually, that was a completely different bug :-(. Thanks for the
report.
regards
Tom Lane <[EMAIL PROTECTED]> writes:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > From what I've seen so far, all the backends (other than the one that
> > actually crashes) seem to survive the SIGTERM I send to the
> > postmaster. How do I tell which one is which? The command line?
>
> SIG
On Fri, 26 Jan 2001, adb wrote:
> I understand that I need to up the max number of open files in the linux
> kernel but I'd like to know what's a good number to set it to for a high
> traffic postgres server and what's the best way to set it in linux so
> it's permanent?
I set to 16384. with abou
ISO/DIS 19125-2 Geographic information - Simple feature access - Part 2: SQL
option
I'm trying to look for this document on the web, as it gives information on
how ISO Geographic Objects should be represented in SQL. Does anybody have
this or at least a summary of it. Or can give me some example
I've been following this thread but it's not clear to me what an 8k row
limit means exactly.
Does it mean that the size of all the data in that row must not be greater
than 8k? That seems very small to me.
Also, how does one change BLCKSZ?
Some more detail on the subject would be great. thank y
Now there is a truly great, concise example.
>
> Hi all!
>
> Very usefull sample:
>
> CREATE FUNCTION getpid () returns int4 as '/lib/libc.so.6' LANGUAGE 'C';
> SELECT getpid();
>
> ;))
>
>
> P.S. Only for Linux!
>
>
> --
> Trurl McByte, Capt. of StasisCruiser "Prince"
> |InterN
> Is there a way to start with yesterday's dump and load each transaction
> log dump in order until you have a complete restore of the database?
Does recovery of pg_dump and the transaction logs work with a backup and
then doing a rollforward on the transaction logs? What would be the
procedure?
Doug McNaught <[EMAIL PROTECTED]> writes:
> From what I've seen so far, all the backends (other than the one that
> actually crashes) seem to survive the SIGTERM I send to the
> postmaster. How do I tell which one is which? The command line?
SIGTERM to the postmaster commands polite shutdown, i
> > the max size of a row...
>
> 8k in pre v7.1, no limit in v7.1 an dlater ...
32k really... BLCKSZ can be changed.. I've had no trouble running a
production database with BLCKSZ set to 32k though there might be issues I'm
not aware of..
-Mitch
[EMAIL PROTECTED] writes:
> I am trying to make a function that takes four varchar arguments as in
> CREATE FUNCTION address(varchar,varchar,varchar,varchar) ...
>
> when i try to pass the function a NULL value, it turns all the values into
> NULL:
> select address('foo','foo',NULL,'foo').
Thi
Hi again, I'm getting stuff like
ERROR: cannot write block 1056 of tradehistory [testdb] blind: Too many
open files in system
and
postmaster: StreamConnection: accept: Too many open files in system
I understand that I need to up the max number of open files in the linux
kernel but I'd like t
Tom Lane <[EMAIL PROTECTED]> writes:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > I'm running VACUUM, then VACUUM ANALYZE (the docs seem to suggest that
> > you need both). Basically my script is:
>
> VACUUM ANALYZE is a superset of VACUUM; you do not need both.
Good to know.
> > The exam
Hi, I've read the administrator guide section on backups and
I'm wondering is there an easy way to do backups of the
transaction log similar to sybase or oracle?
I imagine I would use pg_dumpall nightly but I'm wondering if there's
something else to run every 10 minutes or so to dump the log. Or
On Fri, 26 Jan 2001, a wrote:
> Hi,
>
> Is there any document about the limitation of postgres
> like the total size of one table
none that we are aware of ...
> the max row number of a table
2^32 ... limitation is the OID size, which is currently a 32bit int ...
move to 64bit int's, and then
"Mr. Chan" wrote:
> dear all,
> how to get last sequence from postgresql? I mean such mysql
> last_insert_id function or ms sql select @@identity.
> thanks!
> Chan
Select currval('sequence_name_id') from tablename;
this will give you the last sequence generated in tablename
Hi all!
Very usefull sample:
CREATE FUNCTION getpid () returns int4 as '/lib/libc.so.6' LANGUAGE 'C';
SELECT getpid();
;))
P.S. Only for Linux!
--
Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200 RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35 87 1F
Hello.I'm using PostgreSQL 7.0.2 with webmail IMP, but have the
follow error :Warning: Unable to connect to PostgresSQL server:
pqReadData() --read failed: errno=32 Broken pipe in ./lib/db.pgsql on line
126Warning: Unable to connect to PostgresSQL server: pqReadData() --read
failed: errno=9
GNUe Forms is a data entry/query tool that allows a designer to describe a
data aware user interface via an XML based form definition language.
This file is then parsed at client startup and a proper user interface is
dynamically generated. Currently the client portion of the system is
availab
Is there any PostgreSQL function, that, given an OID and a table (class)
name, would true true (or the OID) if the OID is a member of that class?
I want to write something like:
create function ISA(oid, name) returns oid as '
select oid from $2* where oid = $1
' language 'sql';
(But, of course
I've got some wierd behavior with a view
that I created.
devwindaily=# select
version();
version
- PostgreSQL
7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.
> You can detect whether a field is actually being *changed* by comparing
> NEW.field and OLD.field. You cannot distinguish the case where the
> UPDATE didn't mention a field from the case where it did but assigned
> the same value that was already there (eg UPDATE foo SET x = x).
> This behavior
El Vie 26 Ene 2001 17:02, Chean Fonk Joe Thong escribió:
> Hi to all,
>
> Currently I'm trying to upgrade my PostgreSQL from 6.5
> to 7.0.2 with rpm files on my Redhat 6.1 with Glibc
> 2.1.3. The installation won't continue because RPM
> Manager told me that I need libc.so.6 (>= GLIBC 2.2).
I ha
The field data type is TEXT. I don't think you need to do anything special
(as long as you are using 7.1).
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Clinton James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi to all,
Currently I'm trying to upgrade my PostgreSQL from 6.5
to 7.0.2 with rpm files on my Redhat 6.1 with Glibc
2.1.3. The installation won't continue because RPM
Manager told me that I need libc.so.6 (>= GLIBC 2.2).
I've two questions:
I forced the installation with no deps, when start
On Fri, Jan 26, 2001 at 01:45:33PM -0600, Clinton James wrote:
> I have some blocks of text than can be from 2K to 80K in size. I understand
> 7.1 will have compression to use with text, but does anyone know of a way I
> can use these large text blocks as a field?
The unlimited row width feature
I have some blocks of text than can be from 2K to 80K in size. I understand
7.1 will have compression to use with text, but does anyone know of a way I
can use these large text blocks as a field? I'll have Win NT as a client
getting the data from a Linux box through ODBC so BLOBs don't appear a g
Has anyone implemented a form of one way replication with the new
write ahead logging in 7.1?
I'm looking for a way to have a warm or hot standby server waiting to
take over in the event of a machine failure.
I know there's discusion about adding replication to future releases,
I'm just wonderin
Using version 7.0.2 (system is production, so I can't take it down for
minor releases) I enter:
$ pg_dump romanlegion > rdb.backup
and I get:
failed sanity check, table usergames was not found
Ok, fair enough, so:
$ psql romanlegion
romanlegion=# \d usergames
Table "usergames"
Attribute
Tom Lane <[EMAIL PROTECTED]> writes:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > For a localhost TCP socket, a write() has to be sent down the network
> > stack and (possibly) split into packets, which are then sent through
> > the routing engine and back up through the stack, flow-controlled
"Gregory Wood" <[EMAIL PROTECTED]> writes:
> To do this I created a trigger that would raise an exception "IF
> new.UpdateRequired ISNULL". In 7.0 this would work because
> new.UpdateRequired seemed to be NULL unless it was specified (I cannot test
> this any longer because I don't have a 7.0 serv
Doug McNaught <[EMAIL PROTECTED]> writes:
>> On Thu, Jan 25, 2001 at 11:07:19PM -0500, Tom Lane wrote:
> On a properly designed kernel, there shouldn't be any measurable
> performance difference between a local TCP connection and a Unix-socket
> connection.
> Much as I hesitate to contradict Tom
At 12:39 PM +0100 1/26/01, Gilles DAROLD wrote:
>Hi,
>
>Just to repeat that we have this stuff enabled using perl and mod_perl for a
>very
>long time. Just try to declare all your vars as global (without my or local)
>and
>see what's append between apache child process :-)
>
>But as I know Apache:
sorry it was the very first thing in functions-sting.htm manual. i guess i
was looking for the actual function name CONCAT.
string || string
On Fri, 26 Jan 2001, Thomas T. Thai wrote:
> Date: Fri, 26 Jan 2001 11:57:55 -0600 (CST)
> From: Thomas T. Thai <[EMAIL PROTECTED]>
> To: PostgreSQL Ge
i'm still porting my app from mysql to pgsql. i'm stuck on this one. in my
mysql app where i have a tree structure defined as:
01
0101
0102
...
ZZ01
ZZ02
ZZ0301
...etc
it's basically base 36
when i would move a node in the tree, i would do something like this in
mysql:
UPDATE tbl SET code =
C
Greetings! What is the 'best way' or 'guiding philosophy' if there is
one for dealing with calculated values in a pg database? For example,
say you have a table with a column of floats, and you want to make a
view showing this column as a percent of the total across the column.
Should you
a) cr
We recently upgraded our development server to 7.1 and I believe I've
noticed an inconsistency with how update triggers behave on version 7.1
versus 7.0. Since I'm not sure which should be the expected behavior I have
no idea if it is a bug or not. Here is the situation:
I have a table in which o
> The best way to solve this, would be to remove the feature of keeping
> deleted/updated records in the databasefiles and therefor no
> need to vacuum.
> Is there any way to configure this when compiling? Or are there other
> possibilities?
^
There will be in, hopefully, 7.2, only
Frank Joerdens <[EMAIL PROTECTED]> writes:
> On Thu, Jan 25, 2001 at 11:07:19PM -0500, Tom Lane wrote:
> > Frank Joerdens <[EMAIL PROTECTED]> writes:
> > > What performance penalty can I expect when going over TCP/IP sockets
> > > instead of Unix sockets?
> >
> > On a properly designed kernel, t
> "Frank" == Frank Joerdens <[EMAIL PROTECTED]> writes:
Frank> On Thu, Jan 25, 2001 at 11:07:19PM -0500, Tom Lane wrote:
>> Frank Joerdens <[EMAIL PROTECTED]> writes: > What performance
>> penalty can I expect when going over TCP/IP sockets > instead
>> of Unix sockets?
>>
Alfonso Peniche wrote:
>Hi all
>
>I have the following inheritance relation:
>
> user
> |
> --
> ||
>student employee
>
>If I insert John into table student, how can I insert him afterwards so
>that he is also a
On Fri, 26 Jan 2001, Alfonso Peniche wrote:
> user
> |
>--
>||
> student employee
Why not store the common data between student and employee in user, and
then store the additional data for student and employee in the relation
itsel
Alfonso Peniche <[EMAIL PROTECTED]> writes:
> I have the following inheritance relation:
> user
> |
>--
>||
> student employee
> If I insert John into table student, how can I insert him afterwards so
> that he is also an employee
Hi all
I have the following inheritance relation:
user
|
--
||
student employee
If I insert John into table student, how can I insert him afterwards so
that he is also an employee (this could happen several days later)?
Thanx
On Thu, Jan 25, 2001 at 11:07:19PM -0500, Tom Lane wrote:
> Frank Joerdens <[EMAIL PROTECTED]> writes:
> > What performance penalty can I expect when going over TCP/IP sockets
> > instead of Unix sockets?
>
> On a properly designed kernel, there shouldn't be any measurable
> performance differenc
Guillaume =?KOI8-R?Q?Le=27mery?= <[EMAIL PROTECTED]> writes:
> CREATE TABLE parametre
> (
> id_parametre int4 not null primary key,
> id_regie int4 NULL ,
> par_id_parametre int4 NULL ,
> type INT4 not null,
> valeur_str varchar null,
> valeur_int int4 null,
> valeur_fl float8 null,
> valeur_txt v
*** Please forgive if this is double post.
*** My first attempt was from the wrong account :(
GNUe Forms is a data entry/query tool that allows a designer to describe a
data aware user interface via an XML based form definition language.
This file is then parsed at client startup and a prope
"Igor V. Rafienko" <[EMAIL PROTECTED]> writes:
> on Jan 25, 2001, 15:14, Stephan Szabo std::cout'ed:
> | select * from table where pk=1::int8 should use the index if pk is an
> | int8 column.
> Would that work for other operators (such as <, >, etc.) as well?
It's a necessary prerequisite, anywa
on Jan 26, 2001, 10:20, Tom Lane std::cout'ed:
| It won't use an index unless the optimizer knows that the number of
| rows to be selected is small, which for a one-sided "<" query would
| depend on where the endpoints of the data range are. Had you done
| a VACUUM ANALYZE recently?
Yes, I be
"Dr R.Adscheid" <[EMAIL PROTECTED]> writes:
> We are using PostgreSQL 6.3/Digital Unix 4.0B in an environment with 7x24
> availiability. There
> is one table, which has about 9000 new records per day and about 10% being
> updated. With an index over several columns the select on this table is quit
Hei!
How do I do the connection pooling with libpq? I'm trying to modify
a radius server to fork or thread and pick a connection from the pool
and in that way be able to store 100..500 small records in a second
into postgresql.
I can create a global array of connections, but how is it done after
55 matches
Mail list logo
