What is the preferred way of issuing errors of the form:
"Delimiter expected after character #3"
(where "3" obviously varies).
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Apr 19, 2006, at 14:44 , Martin Kuria wrote:
I have a postgresql database Table Categories which has the
structure like this
Cat_ID | Parent_ID | Name
1 | 0 | Automobiles
2 | 0 | Beauty & Health
3 | 1 | Bikes
4 | 1 | Cars
5 | 3 | Suzuki
6 | 3 | Yamaha
On Apr 19, 2006, at 20:31 , chris smith wrote:
On 4/19/06, Kynn Jones <[EMAIL PROTECTED]> wrote:
I keep bumping against this situation: I have a main database A,
and I want
to implement a database B, that is distinct from A, but
subordinate to it,
meaning that it refers to data in A, but
On 4/27/06, Aly Dharshi <[EMAIL PROTECTED]> wrote:
> Yes, if you search the archives there was something on this. Maybe it was
> around
> 32-bit, but nonetheless, take a search through.
There is a patch in the queue written by Magnus Hagander right now
which allows pg to build from the microsoft
Hi,
I just wrote a pgsql.vim file for vim users. It helps you to colorize
the file which contains PostgreSQL SQL keywords:
http://www.gunduz.org/postgresql/pgsql.vim
In order to use this file, first edit filetype.vim file and add
" PgSQL
au BufNewFile,BufRead *.pgsql
This is pretty ugly but you can query pgsql for table attributes...
replace tablename and you'll get the schema for a table including
primary and foreign keys. You could shrink it down and look just
for the foreign key.
SELECT f.attnum AS number, f.attname AS name, f.attnum, f.attnotnull
Benjamin Smith wrote:
I have a customer table (very important) and have numerous fields in other
tables FK to the serial id of the customer table.
What you need is a list of the foreign key definitions, out of which you
build SQL selects that check each child table based on foreign key. T
Tom,
Thanks for the advice. I realize that I have little understanding of
index usage in PostgreSQL - I'm doing my best to improve this. Below is
another comparison of the 'distinct' and 'group by' queries from the
same table with seqscan set to on and off. I does look like the group
by works b
Forgot to add; another option is to use a PL function with an
exception handler. This may be a bit more elegant approach but not
necessarily easier.
FYI
Jerry Sievers <[EMAIL PROTECTED]> writes:
> Benjamin Smith <[EMAIL PROTECTED]> writes:
>
> > I want to be able to determine in advance whethe
Benjamin Smith <[EMAIL PROTECTED]> writes:
> I want to be able to determine in advance whether or not a record is
> "deleteable" before displaying the button to delete the record. If it's not
> deleteable, it should say so before the user hits the button.
>
> But, the only way that I've been a
I have a customer table (very important) and have numerous fields in other
tables FK to the serial id of the customer table.
There's an option to delete a customer record, but it has to fail if any
records are linked to it (eg: invoices) in order to prevent the books from
getting scrambled.
Mike Leahy <[EMAIL PROTECTED]> writes:
> ... When I try to get the distinct number of
> years from these tables, it does a sequential scan to get two unique
> values from the "year" column in the *_edu table, but it uses an index
> scan to get a single unique value from the "year" column from the *
Hello list,
I've been having a bit of difficulty getting Postgres to use indexes on
some large tables that I have. Included below are the results from
'explain analyze' for two queries that should get the unique years of
data that are available from two different tables (tbl_ind_schools_edu
and t
Eric Davies <[EMAIL PROTECTED]> writes:
> As far as I can see, you can't write a set returning function that
> takes a set as input, as in
>select getMetaData( select * from mytable);
> Is a function of the type I'm trying to write even possible in PostgreSQL?
I don't think it's possible
Hi.
Some people on the list may find the following interesting:
http://marc2.theaimsgroup.com/?l=apache-modules&m=114599516512637&w=2
Since it uses Apaches apr_dbd, Postgres is one of the supported
platforms.
Sincerely,
Joachim
---(end of broadcast)-
Hi,
I'd like to write a PostgreSQL server function (ideally in C) that takes
a set of objects and returns 1 or more rows from each object, such that
the rows returned can be cast to a desired rowtype. The structure of the
returned rows depends on additional arguments. For example, I'd like to
be
On Thu, Apr 27, 2006 at 10:17:51 -0400,
Vivek Khera <[EMAIL PROTECTED]> wrote:
>
> On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:
>
> >I am developing a temporal database and I have the necessity to
> >control the integrity constraints befor the commit of the transiction.
> >I cannot use
Hey,
I am trying to figure out some unexpected behavior in Postgresql.
When I create a rule that fires on a table after an update, and if
that rule has a SELECT statement in it, it seems to be attempting to
fire (on an empty set) regardless of how the conditional evaluates
after an update.
The r
On Apr 27, 2006, at 11:06 AM, Kenneth Downs wrote:I've got a test database that is going live. During development I have not vacuum'd much, so to get started I did "Vacuum verbose analyze". you probably really do have a lot of spare space in the files. i'd recommend vacuum full if you can, to com
juan jose dominguez <[EMAIL PROTECTED]> schrieb:
> Buenas, queria saber como sacar la edad de alguien. Me da el siguiente error
> con el siguiente codigo :
> **** ---- FFuunnccttiioonn::
> ffuunncciioonn__ssaaccaa__eeddaadd(()) ****
> **** DDRROOP
Buenas, queria saber como sacar la edad de alguien. Me da el siguiente error con el siguiente codigo :
-- Function: funcion_saca_edad()
DROP TRIGGER trigger_saca_edad ON fechas;
DROP FUNCTION funcion_saca_edad ();
CREATE OR REPLACE FUNCTION funcion_saca_edad() RETURNS OPAQUE AS'
DECLARE
ed
why not a join like below (not tested)
select id
from p4_versions a
join p4_files b on (a.versionof = b.id and a.version = b.headver)
where p4path like '%/date.txt'
-- Original Message ---
From: Mark Harrison <[EMAIL PROTECTED]>
To: Postgresql-General
Sent: Thu, 27 Apr 2006 09
Mark Harrison <[EMAIL PROTECTED]> writes:
> I've got a query that depends upon two pieces of data from another table for
> use in a where clause.
> scratch1=# select id from p4_versions where
> versionof=(select id from p4_files where p4path like '%/date.txt')
> and
>
Mark Harrison wrote:
### QUERY 3: combine the two statements above by using two subselects
scratch1=# select id from p4_versions where
versionof=(select id from p4_files where p4path like
'%/date.txt')
and
version=(select headver from p4_files where p4path li
I've got a query that depends upon two pieces of data from another table for
use in a where clause.
If I perform this procedurally, I can issue two sql commands (see below),
one to get the two pieces of data to search upon (QUERY 1), and one to
perform the query with these two pieces of data plu
Holger Zwingmann wrote:
If I check, after the reconnect, for some given 'text key' my SELECT
won't find it and my procedure will thus insert a new (key,value) pair.
When I disconnect and reconnect sometimes later again, I will suddenly
find both of the keys with the next query and will thus raise
On 4/27/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> I believe that has been fixed in recent version of postgres. At some point
> in the past there was only a date + int operator and not an int + date
> operator.
> Overloading makes it easy to forget that those are two different operators.
I'l
On 4/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Either write it as date + integer, or add an integer + date operator
I thought I did it in that order, but I'll check it again.
> (not very hard, just transpose the inputs), or use PG >= 8.0 which has
> integer + date built in.
I'm using a shared
Well, one problem now is that everytime pg_autovacuum opens a database,
a message is placed in the logs:
LOG: autovacuum: processing database "test"
LOG: autovacuum: processing database "test"
LOG: autovacuum: processing database "test"
LOG: autovacuum:
Right, I think there has been discussion about this and general
agreement that the current autovacuum logging options are less than
ideal to put it mildly. Unfortunately, I don't think there has been any
action by anyone to do something about it. I hope to work on this at
some point, but codi
Yes, if you search the archives there was something on this. Maybe it was around
32-bit, but nonetheless, take a search through.
Aly.
Stanislaw Tristan wrote:
It is a possible?
---(end of broadcast)---
TIP 5: don't forget to increase your fre
>From the system catalogs:
SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0
"Ari Kahn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have a comments on tables in my database.
>
> e.g. COMMEN
Hi folks I'm hoping somebody can demystify something for me.
I've got a test database that is going live.
During development I have not vacuum'd much, so to get started I did
"Vacuum verbose analyze".
At the end of the process it told me that vacuum needed max_fsm_pages to
be set at about 2
This is not a postgreSQL issue -- you are having problems with your PHP
configuration...
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Help! I was trying to make an installation of PHP 5.1.2 + Apache
> 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
> got PHP to
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> In addition, it's not the norm. I subscribe to lots of mailing lists
> and postgresql.org lists are the only ones that I've seem do that.
You may think it's not the norm, but you're mistaken. This is how the
PG lists are run, as well as most other t
On Thu, 27 Apr 2006, Vivek Khera wrote:
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote:
We knows installation of tsearch2 working with 4 millions docs.
What are the design goals for the size of the source tables? My engineers
are telling me of things their friends have tried and have h
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote:
We knows installation of tsearch2 working with 4 millions docs.
What are the design goals for the size of the source tables? My
engineers are telling me of things their friends have tried and have
hit limits of tsearch2. One was importi
On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:I am developing a temporal database and I have the necessity to control the integrity constraints befor the commit of the transiction.I cannot use the deferrable checking because the integrity constraints is a select and i cannot use the trigger or
Richard Huxton wrote:
> alexandre - aldeia digital wrote:
>> Hi,
>>
>> If I do:
>>
>> pg_dump -Fc -t TABLE database > table-custom.sql
>>
>> The pg_dump returns the DDL of the table, the data and the DDL for
>> indexes and PK. If I use -s, only the structure is returned but it's
>> include all elem
P G wrote:
> I have recently switched to Kubuntu and I just installed Postgres on
> it. The installation was successful.
>
> When I try psql, I get this error message, though:
>
> % psql postgres
> Error: You must install at least one postgresql-client- package.
>
> But I have installed postgr
It is a possible?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Help! I was trying to make an installation of PHP 5.1.2 + Apache
2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
got PHP to work with Apache quite smoothly, so did I marry PHP with
PostgreSQL - scripts connecting to the database work fine from
windows command line, except that
In article <[EMAIL PROTECTED]>,
Jim C. Nasby <[EMAIL PROTECTED]> wrote:
% Keep reading... from the same paragraph:
%
% Clustering is a one-time operation: when the table is subsequently
% updated, the changes are not clustered.
But this isn't really relevant to the question. More to the point
is
> [EMAIL PROTECTED] (Scott Marlowe) writes:
> > About the security thing. Security is a process, and you won't get
> > it from using two different database engines.
>
> I'd argue that security is an "emergent property" which is either
> supported by or undermined by particular facts/features/confi
I'm trying to set up PG, and am curious about the failure scenarios of
Postgres with respect to crashed disks. In a given Postgres
installation across many disks, which sections of Postgres can fail
"gracefully" (i.e. the customer data is safe and the installation can
be recreated without backups)
try:
select tax_code from warehouse.sec_trans group by tax_code
there was a discussion about this on the pgsql-performance a while back:
http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php
-ae
On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote:
select DISTINCT tax_code from war
Yes, I read this opinion that MySQL is only sql interface to filesystem
:-)
I plan to use win1250 encoding because this is native czech windows
encoding (I do not understand why M$ invents the wheel and invents new
code pages (cp1250) although the code page latin2 was here all the
time). BTW czech
I have a comments on tables in my database.
e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
I know you can get comments using \d+
Is there a way to select comments?
Reason: I do a lot of perl interfaces. I find escape commands do not
work using DBI.
Thanks,
Ari
--
All opinions here sound good so I decided to use only one db engine
(PostgreSQL 8.1) and two databases; now I must tune my database
generator parameters (I use PowerDesigner by Sybase) in order to
work-arround the pg's identifier case sensitivity (newsgroups app (php
scripts) doesn't use quotes (de
On Thu, Apr 27, 2006 at 16:55:22 +1000,
Chris Velevitch <[EMAIL PROTECTED]> wrote:
> Seems like the problem has something to do with date arithmetic. I
> can't seem to add an integer expression to a date constant. It works
> if I add a integer constant to a date constant, but that's not what I
>
On Thu, Apr 27, 2006 at 18:44:25 +1000,
Chris Velevitch <[EMAIL PROTECTED]> wrote:
>
> "One day I accidentally sent a private, personal reply out over one of
> my own damn lists."
>
> It's like he accidentally drove down a one way street in the wrong
> direction, so he now drives everywhere in
On Thu, Apr 27, 2006 at 17:22:09 +1000,
Chris Velevitch <[EMAIL PROTECTED]> wrote:
> On 4/27/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote:
> > What do you mean? Do you mean a Reply-To: header added? If so, check out
> > the help docs, but there is a 'set replyto' you can add that will have it
On Thu, Apr 27, 2006 at 17:34:11 +1000,
Chris Velevitch <[EMAIL PROTECTED]> wrote:
> On 4/27/06, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> > Done on purpose. Use "reply to all".
>
> Isn't that a bad habit to get into? There's been a lot of press about
> people who habitually reply all.
Reply
Chris Velevitch wrote:
On 4/27/06, Guy Rouillier <[EMAIL PROTECTED]> wrote:
Done on purpose. Use "reply to all".
Isn't that a bad habit to get into? There's been a lot of press about
people who habitually reply all.
Besides, isn't the point of a mailing list is that it's a global
public disc
> Connection conn = ...
> CallableStatement cs = conn.prepareCall("{? = call
> nextval('seq_nm')}"); cs.registerOutParameter(1, Types.BIGINT);
> cs.execute(); long nextval = cs.getLong(1); cs.close();
Yeah, it seems to work, if i change the definition for calling the sequence in
conjunction wit
Bert wrote:
This rule is creating first of all the insert and then i can run an
Update on this insert, so far its functioning. Your definition is quite
good but what are doing when you change the table definition? Rewrite
all Rules?
I actually use a data dictionary processor that automaticall
You can have a looks at http://www.postgresql.org/docs/8.1/static/sql-createtype.htmlRegards/Shoaib
On 4/27/06, Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
Hi all,
I need some help to create types to use
in a table. For exemple, I want to create:
CREATE TYPE salary_type (
value
Hi all,
I need some help to create types to use
in a table. For exemple, I want to create:
CREATE TYPE salary_type (
value
NUMERIC(10,2),
date DATE
)
CREATE TABLE employee (
num_employee
INT,
name VARCHAR(60),
salary salary_type
)
I know I ne
> -Disk 2: If the transaction log dies, all changes since the last> checkpoint are lost, right? Again, if I set up an empty pg_xlog
> directory somewhere else, the DB should run just fine, right?No, because there's no way to know what state the data pages are in.Data may have made it to disk, may
On 4/27/06, Martijn van Oosterhout wrote:
> Go to the archives:
>
> http://archives.postgresql.org/pgsql-general/
>
> Select "To subscribe or unsubscribe"
>
> Goto "Sign-in" and Sign in
>
> Goto "Unsubscribe or Change Settings" and tick (I beleive) replyto.
>
> Have a nice day,
Thanks for that in
On Thu, Apr 27, 2006 at 01:34:06AM -0700, SunWuKung wrote:
> If a transaction inserts rows to two tables will a procedure invoked by
> an "after insert on each row" trigger on one table see all the records
> inserted in the other table?
That's the idea.
> In other words - will the transaction run
On Thu, Apr 27, 2006 at 06:59:19PM +1000, Chris Velevitch wrote:
> On 4/27/06, Martijn van Oosterhout wrote:
> > Fortunatly we have a mailing list manager that allows you to choose
> > which way you want it.
>
> Please explain what you mean by this?
Go to the archives:
http://archives.postgresq
On 4/27/06, Martijn van Oosterhout wrote:
> Fortunatly we have a mailing list manager that allows you to choose
> which way you want it.
Please explain what you mean by this?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
-
On 4/27/06, Tomas Lanczos <[EMAIL PROTECTED]> wrote:
> I am curious, whether is it possible to connect to a PostgreSQL database
> installed on WinXP for an application installed on the same box but running
> in the Cygwin environment (the app. is the GRASS GIS).
There are no reasons why this shoul
I am curious, whether is it possible to connect to a PostgreSQL database
installed on WinXP for an application installed on the same box but running
in the Cygwin environment (the app. is the GRASS GIS).
many thanx
Tomas
---(end of broadcast)---
T
On 4/27/06, Kris Jurka <[EMAIL PROTECTED]> wrote:
> > In addition, it's not the norm. I subscribe to lots of mailing lists
> > and postgresql.org lists are the only ones that I've seem do that.
> >
> > So what's the reasoning behind this choice?
>
> http://www.unicom.com/pw/reply-to-harmful.html
T
On Thu, 27 Apr 2006, Schnabl, Sebastian wrote:
Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with
sequences. Sequoia claims to support for good reasons and db-independece
only "sql-standard(s)". Therefore th
If a transaction inserts rows to two tables will a procedure invoked by
an "after insert on each row" trigger on one table see all the records
inserted in the other table?
In other words - will the transaction run completely before the trigger
is fired?
Thanks for the help.
Balázs
-
Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with sequences.
Sequoia claims to support for good reasons and db-independece only
"sql-standard(s)". Therefore they DON'T support the postgres-specific "select
next
On Thu, Apr 27, 2006 at 05:34:11PM +1000, Chris Velevitch wrote:
> In addition, it's not the norm. I subscribe to lots of mailing lists
> and postgresql.org lists are the only ones that I've seem do that.
>
> So what's the reasoning behind this choice?
All sorts of reasons. One of the main ones b
On Thu, 27 Apr 2006, Chris Velevitch wrote:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
http://www.unicom.com/pw/reply-to-harmful.html
Kris Jurka
-
On 4/27/06, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Done on purpose. Use "reply to all".
Isn't that a bad habit to get into? There's been a lot of press about
people who habitually reply all.
Besides, isn't the point of a mailing list is that it's a global
public discussion on a topic in whic
On 4/27/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote:
> What do you mean? Do you mean a Reply-To: header added? If so, check out
> the help docs, but there is a 'set replyto' you can add that will have it
> added for your email address, without affecting everyone that doesn't want
> it ...
hel
Chris Velevitch wrote:
> It seems that all the postgresql mailing lists don't allow you to
> automatically reply to the list only the sender. I don't get this
> with all my other mailings list. Who I contact to have this
> rectified?
Done on purpose. Use "reply to all".
--
Guy Rouillier
-
On Thu, 27 Apr 2006, Chris Velevitch wrote:
It seems that all the postgresql mailing lists don't allow you to
automatically reply to the list only the sender. I don't get this with
all my other mailings list. Who I contact to have this rectified?
What do you mean? Do you mean a Reply-To: hea
75 matches
Mail list logo
