OK, below is the dump of the table definition. Several other tables reference this and
have ON DELETE CASCADE. In this table there is a rule for ON DELETE. The WHERE clause
(NOT old.is_deleted) should always be the case, as the field is FALSE for all existing
entries (checked).
The cascading de
I was trying to implement a pseudo-delete, where the (millions of) records in several
child tables were actually deleted, but a flag was set in the summary table instead of
deleting it, as an archiving mechanism. (If the flag was already set, the WHERE clause
in the RULE should be false, and the
I can't find a good way to skip over a large number of records in PLPGSQL (I
want to fast-forward and I don't need the I/O of reading and throwing away
hundreds of records.) In SQL, I could just use MOVE. That doesn't appear to be
supported in PLPGSQL?! Help?
---(end of
les generated by the join
operation. How can I do that?
Thanks!
--
andrew
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Sorry for the confusion. This is what i meant. Thanks, Michael.
select *
from (select * from A, B where A.a = B.b) as s
where foo(s) < 2;
On 1/25/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> andrew wrote:
> > I want to use a UDF to filter tuples t that are generated afte
But the function foo() would produce different values for the two
queries, so the result will be different.
A simple example is foo() computes the sum of all the integer fields
of the input record.
On 1/26/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> andrew wrote:
> > Sorry fo
How will the query planner do for a nesting query? Treat the
subqueries as multiple queries and then link them together?
where can I find the information (codes or documents)?
Thanks.
On 1/26/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> andrew wrote:
> > But the function foo(
I can see the final plan by using the EXPLAIN command. But I want to
know the procedure of the planner in handling nesting queries. Can you
direct me to the corresponding part of the code and/or the documents?
Thanks.
On 1/26/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> andrew wrote
ect * from (select * from Person,Auction where
Person.id=Auction.seller) as s where complete(s)
ERROR: Cannot pass result of sub-select or join s to a function
On 1/27/06, andrew <[EMAIL PROTECTED]> wrote:
> I can see the final plan by using the EXPLAIN command. But I want to
> know t
!
On 1/27/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> andrew <[EMAIL PROTECTED]> writes:
> > I got errors in this query. I have a function complete(record) which
> > takes a generic record type data. But it seems cannot be applied to a
> > sub-select result:
>
&g
<[EMAIL PROTECTED]> wrote:
> andrew <[EMAIL PROTECTED]> writes:
> > I got errors in this query. I have a function complete(record) which
> > takes a generic record type data. But it seems cannot be applied to a
> > sub-select result:
>
> As I seem to recall hav
little venture. Any advice
on that would be welcome too. )
Cheers,
Andrew Smith
---
/* rebuild user table tUsers */
ALTER TABLE tUsers RENAME TO tOldUsers;
DROP SEQUENCE nUser;
CREATE SEQUENCE nUser;
CREATE TABLE tUsers
(
kUser INTEGER NOT NULL DEFAULT NEXTVAL('nUser'),
fId TEX
[EMAIL PROTECTED] wrote:
> i have a table with this structure
>
> name (varchar)|category id (int4)|parent category id (int4)|leaf node
> (bool)
>
> im trying to make a perl script that should tree the info
>
> parent cat
> subcat
> subcat2
> subcat2
>
);
CREATE SEQUENCE nextid start 1;
CREATE RULE ins_topic AS ON INSERT TO topics WHERE id ISNULL DO UPDATE
topics SET id=nextval('nextid') WHERE id ISNULL;
This example updates the last insert. I need it to update the currnet
insert. How do I do this?
Kind regards
Andrew Higgs
cause it's theoretically possible for me to change this conceptual
relationship in the future. What I think I'm looking for is some sort of
a join that will cause postgres to consider cd_pragmatic as True whenever
cd_interest is true.
Any thoughts?
-----
imit
1;
number | fruit | dt
++
15 | Apples | 1999-07-20 00:00:00-05
(1 row)
Cheers,
Andy Perrin
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Soc
Or how about just:
SELECT count(*) FROM tablename WHERE a > b;
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
[EM
on. That is, sometimes I need minimum(arg1, arg2) but
sometimes it's minimum(arg1, arg2, arg3, arg4, arg5), etc.
Thanks-
Andy Perrin
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Caro
',' || arg2 || ',' || arg3 || ',' || arg4 || ',' ||
> arg5)
>
> i.e.:
>
> create function minimum(text) returns integer
>
> and then do the parsing internally ('specially if you're using perl).
> Pretty bad, but it's an opti
psql
\i filename.txt
-Andy Perrin
"Jeff S." wrote:
>
> I want to build my tables by placing all the sql
> statements in a file. What is the correct way to use
> this file with psql?
>
> Example: My text file has this in it:
>
> CREATE TABLE table1 (
>table1_id serial,
>field1 char(5
thout wiping out
existing data?
Thanks.
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
[EMAIL PROTECTED] - [EMAIL PROT
e returning 10. Can anyone offer advice?
Thanks.
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
[EMAIL PROTECTED] - [EMAIL PROTECTED
all entries are null.
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
[EMAIL PROTECTED] - [EMAIL PROTECTED]
On Sun, 11 Mar 2001, Ross J. Reeds
paidto_date;
Again, untested - try it and see.
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chapel Hill)
[EMAIL PROTECTED] - http://www.unc.edu/~aperrin
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
--
Andrew J. Perrin - Programmer/Analyst, Desktop Support
Children's Primary Ca
INSERT in this session)
Hope this helps.
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chapel Hill)
[EMAIL PROTECTED] - http://www.unc.edu/~aperrin
On Thu, 22 Mar 2001, postgresql wrote:
> I have been
ax
you can get what you're looking for by simply JOINing Records and
Data. Then, when you want to "change" a record - say, for example, Andrew
Perrin moves from Berkeley to Chapel Hill, thereby changing phones from
510-xxx- to 919-xxx- - you actually *add* a new record, with a
hi
;t think I have the original SQL sitting around to drop and
recreate them.
Thanks for any advice.
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chap
h?
Thanks again.
------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Carolina, Chapel Hill)
[EMAIL PROTECTED] - http://www.unc.edu/~aperrin
On Sat, 24 Mar 2001
ELECT number_i_care_about FROM table WHERE serial_number =
currval('serial_number_seq');
ap
--
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology
(Soon: Asst Professor of Sociology, U of North Caroli
-
> "Reality is that which, when you stop believing in it, doesn't go
> away".
> -- Philip K. Dick
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
---
ff all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
--
Andrew J. Perrin - Programmer/Analyst, Desktop Support
Children's Primary Care Research Group, UNC -
Try:
- The ILIKE operator, for example,
SELECT * FROM account WHERE username ILIKE "test";
- upper() or lower(), for example,
SELECT * FROM accont WHERE lower(username) = "test";
-----
Andrew J. Perrin - Assistant Pr
where name <> "bar";
returns 0
Cheers,
Andy
-----
Andrew J. Perrin - Assistant Professor of Sociology
University of North Carolina, Chapel Hill
269 Hamilton Hall CB#3210, Chapel Hill, NC 27599-3210 USA
[EMAIL PROTE
erse('qwer');
reverse
-
rerq
(1 row)
Ooops...
----
Andrew G. Hammond [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://xyzzy.dhs.org/~drew/ <http://xyzzy.dhs.org/%7Edrew/>
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86
Well, the quickest solution I can think of off hand is to not use
SERIAL. Instead, do it manually, like this:
DROP SEQUENCE my_seq;
CREATE SEQUENCE my_seq;
DROP TABLE my_table;
CREATE TABLE my_table (
my_table_id INTEGER DEFAULT nextval('my_seq') PRIMARY KEY,
...
);
Kevin Branne
Hi , All!
Could someone clarify me :
When I want to store BLOB's internally in database (for example jpeg )
should I use bytea or OID? Is OID something like BFILE in Oracle 8i?
If both are appropriate for internal BLOB why I can't use
update image set picture=lo_import('Myfile') where imag
;) where
image_code='blablabla'
with bytea column type but only with OID column
type?
And one more thing:
Where is function byteain documented?
TIA,
Andrew.
. FROM participants
WHERE typenr=2 LIMIT 172
ORDER BY zip;
returns ERROR: parser: parse error at or near "ORDER"
I've tried a variety of parentheses to no avail.
Can someone shed some light?
Thanks!
------
Andre
Thanks! That did it.
The inner parens are necessary - without them the ORDER BY seems to be
parsed as part of the second subquery and is therefore a syntax error.
Best,
Andy
--
Andrew J Perrin - http://www.unc.edu/~aperrin
On 12 Sep 2002, Roland Roberts wrote:
> >>>>> "Andrew" == Andrew Perrin <[EMAIL PROTECTED]> writes:
> ...
> Can you do this via a subselect:
>
> SELECT * FROM
> ( SELECT ... FROM participants
> WHERE typenr=1 AND
> U
On Thu, 12 Sep 2002, Stephan Szabo wrote:
> On Thu, 12 Sep 2002, Andrew Perrin wrote:
>
> > Greetings-
> >
> > I have a table of participants to be contacted for a study. Some are in
> > the "exposure" group, others in the "control" group
FROM bar
WHERE baz
AND bop
AND NOT boo
;
Thanks,
Andy
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) un
Unfortunately it is Windows based. The emacs mode for SQL is pretty
primitive too. Oh well - maybe I'll write one someday.
Thanks,
Andy
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology,
RE first_name ~* 'Jordan';
ap
------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Thu, 26 Sep 2002, Jordan Reiter wrote:
>
quot;. There's no
column called "name".
Try again with the line above as SELECT ffix_ability.ability_name
ap
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Sat, 12
changed
in the object. Finally, there was an object method put() that took care of
updating the database. put() checked the changed property and simply
silently finished unless changed was true.
ap
------
Andrew J Perrin - http://w
for Jackie Smith, who would
appropriately be represented by an entry in customers (, 'Jackie
Smith') and one in cust_sexes (, NULL).
(Otherwise the introduction is excellent.)
Any comments?
Andy
--
Andrew J Perr
referrals table:
periph_id referring_id
title referred_table
authorreferred_id
date
page
Comments?
Thanks.
------
Andrew J Perrin - http://www.unc.edu/~aper
day', date_opened)
WHERE ;
But it doesn't give me a zero for the days when no tickets were opened -
which I really need because I want to graph the result.
I could do this in the application code but that doesn't seem right.
Help would be great.
And
an a zero, but your application
should be able to handle that detail.
You can also do this having two tables: one for the months, and another
for the descriptions:
SELECT * FROM months m CROSS JOIN descriptions d FULL OUTER JOIN values
v ON m.month = v.month AND
DAM - Technical Support
> Analyst
I performed that task yesterday using PostgreSQL
7.3.3:
Alter table mkt drop constraint mkt_pkey;
I don't know if it's supported in earlier versions.
Best regards,
Andrew Gould
---(end of broadcast)---
t
think that 7500 rows should never take over a minute. PG 7.3.3 takes 9
minutes (the one time we waited for it to finish).
How many data pages could 7500 rows need? With 2 or 3 page reads, it can't
take up much memory or I/O to do that.
- Andrew
On Wed, 6 Aug 2003, Tom Lane wrote:
>
I have this QUERY (below) that PostgreSQL 7.3.X servers run MUCH slower
than
the 7.1.3 server does. It makes sense that both servers have to do a
sequential scan over the ZIPCODE column. There are over 7,500 rows in the
LOCATIONS table.
Does anyone know what changed in the planner or optimizer? Can
to break lots of existing functions. Maybe the right
thing would be to deprecate relying on implicit conversion to boolean
for one release cycle and then make it an error.
cheers
andrew
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I'm looking to apply a unique constraint to a table such that field A
must be unique based on the date range from Field B to Field C.
This is for a rate based service model whereby, for example, $5 is worth
1 hour of Internet access. But next week, because of increased
competition, $5 is wort
ents);
It cacks on the new and old parameters - misunderstanding on my part?
potential bug? I have to check most of the fields in this table, so would
rather pass the whole record rather than individual fields.
Thanks,
Andrew
---(end of broadcast)---
Sure. Alter your configuration to echo queries, and then watch your
log file. Alternatively, you can enable the command string
statistics function, and then you get the queries in near to real
time in pg_stat_activity.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote
On Fri, Feb 20, 2004 at 12:24:46AM -0300, 2000info wrote:
> pg_dump, ok.
> pg_restore, don?t restore. Why?
If you didn't use a non-ASCII format from pg_dump, you don't need
pg_restore. Just use psql.
A
--
Andrew Sullivan
---(
On Tue, Mar 16, 2004 at 03:13:38PM +0530, Kumar wrote:
> Dear Friends,
>
> Is possible to import data from MS Excel sheet into postgres
> database 7.3.4 running on Linux 7.2
Yes. I find the easiest way is to export a delimited file from Excel
and use the \copy command in psql.
A
this
sort of thing, as you can easily run into its limitations. I suppose
it depends on how big your resulting spreadsheets are going to be.
In my experience, though, the first thing that happens when you
deliver someone a summary spreadsheet is, they ask you for the raw
data so they can doubl
On Tue, Mar 16, 2004 at 02:13:57PM +0200, cristi wrote:
> How should I convert a postgres database to oracle?
Send it out to ASCII and then import it to Oracle. But if you want
support for going _to_ Oracle, you probably ought to get support from
Oracle people, right?
A
--
Andrew Sulli
On Tue, Apr 20, 2004 at 09:14:48PM +0200, H.J. Sanders wrote:
>
> - BEGIN WORK
>
> - INSERT ROW
>
> - IF FAILED THEN UPDATE ROW
>
> - COMMIT WORK
You can do it the other way. Begin, update; if 0 rows are updated
then insert.
A
--
Andrew Sull
n).
pg_dump -d or -D. Note that restoring from this is going to be a
whole lot slower than restoring from a COPY based dump.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please s
ages, then you can end up with
references in the database to files that don't exist, because the
filesystem operations can't be made subject to the transactions of
the database.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of broadcast)---
a (a numeric(18,4));
CREATE TABLE
andrewtest=# create table b (b varchar(25));
CREATE TABLE
andrewtest=# insert into a values(12000.43);
INSERT 17168 1
andrewtest=# insert into b select (a.a)::varchar;
INSERT 17169 1
That's on 7.4.2. You might want to try casting to text first.
A
--
And
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There are two ways to do it. The server-side approach is to increase
logging levels in the config file and then "pg_ctl reload". See
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html#RUNTIME-CONFIG-LOGGING
for the stuff involved.
The ot
On Thu, Jun 24, 2004 at 12:32:59PM -0500, Jaime Casanova wrote:
>
> Why not disallow the ability of boolean fields to be null?
Why not do it yourself? That's what the NOT NULL constraint is for.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrat
assign_id
... assign_date
... ...
Thanks for any guidance.
Andy
------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL
Excellent - thanks, Josh!
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
[EMAIL PROTECTED] * andrew_perrin (at) unc.edu
On Wed, 25 Aug 2004, Josh Berkus wrote
names to get everything in the order you like, of course),
and then rename the old table, rename the new table to the old table
name, and drop the old table if you like.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the market
On Wed, Sep 15, 2004 at 04:22:01PM +0200, Stef wrote:
> Andrew Sullivan mentioned :
> => I'm not sure why you want to do the former, but in any case, it's
> Because lazy people write inserts without specifying column names.
Ugh. Sorry to say so, but this sounds to me real
why I didn't use this solution originally. But I figured out a way to
> modify pieces of the "create table" statement to drop all the indexes
> and constraints first.
>
> Is there an easier way around this?
I doubt it.
A
--
Andrew Sullivan
On Sun, Sep 19, 2004 at 12:25:00PM -0400, Tom Lane wrote:
> ps aux | grep postmaster | grep -v grep
> (or use "ps -ef" if using a SysV-ish ps).
Except that on Solaris, ps -ef _always_ shows "postmaster", even for
the individual back ends.
A
--
Andrew Sullivan
se, on Solaris you also have the ucb
ps, so it makes no difference.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun
---(end of broadcast)--
TER TABLE a SET srl NOT NULL;
ALTER TABLE a SET login_name NOT NULL;
ALTER TABLE a SET password NOT NULL;
I'll just assume that you're using hased passwords, and not storing them
in cleartext...
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Admi
me looping
in the Perl script, but I'd like to avoid pulling the
whole list into memory in case the list gets long. My
preference is to just handle one record at a time in
Perl if possible.
Help?
Andrew Ward
[EMAIL PROTECTED]
__
Do You Ya
ated. I've taken it as far as I can and don't really know where to
| move from here.
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-BEGIN PGP SIGNATURE-
Version: GnuPG
ooking for locks here, though. That makes no
sense, given that you've only 78 rows being returned. BTW, this
topic should probably be better pursued on -performance.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
y
don't know if you looked at my stored function, but there are
> no locks in it (no explicit ones anyway).
Foreign keys are one well-known area of locking surprises.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visio
le
oughta work.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
#x27;m afraid. I don't know of a way
to move tables from one schema to another otherwise. You could do
all the dependencies with a pg_dump -t, I suspect. Not tested that,
though.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
'' || $2, $2);'
LANGUAGE sql;
CREATE AGGREGATE comma_concat (
~BASETYPE=text,
~SFUNC=comma_concat,
~STYPE=text
);
Which is handy for 1:n reports like
SELECT grade, comma_concat($name) AS members
FROM test_results
GROUP BY grade;
- --
Andrew Hammond416-673-4138[EMAIL
Hi,
how do I change the encoding type in postgreSQL (8) from UTF-8 to ISO-8859-1?
many thanks
Andrew
<>
+The home of urban music
+ http://www.beyarecords.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
Does anyone know how to implement type inheritance in postgresql? in oracle you
just use the word UNDER in ur code i.e:
CREATE TYPE test2_UDT UNDER test1_UDT AS (abc INT);
any ideas?
--
__
Check out the latest SMS services @ http://www.linuxmail.org
hi can anyone inform me where to get the postgreSQL complex.sql & complex.c
tutorials from, cos i have no idea.
in the 7.4.2-A4 doc it says:
The examples in this section can be found in complex.sql and complex.c in the
src/tutorial
directory of the source distribution. See the README file in th
gt; thing, though I understand they would run recursively too. Here's the
> table structure in question:
You have to do this with a trigger. The problem is that the rule is
expanded inline like a macro, so you can't prevent the behaviour
you're seeing.
A
--
Andrew Sullivan
ly in the parent.
Tom's answers always make me realise that I should think harder
before I talk. He's right, of course: one common value means store
it once.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
you told th
t; <[EMAIL PROTECTED]>
To: "Andrew Thorley" <[EMAIL PROTECTED]>
Subject: Re: [SQL] Type Inheritance
Date: Fri, 26 Nov 2004 13:14:07 -0500
>
> "Andrew Thorley" <[EMAIL PROTECTED]> writes:
> > Does anyone know how to implement type inheritance in postg
is is what im trying to achieve, although at present, to no avail :(
- Original Message -----
From: "Andrew Thorley" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Subject: Re: [SQL] Type Inheritance
Date: Sat, 27 Nov 2004 22:04:55 +0800
>
> hi
Hi,
ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);
& table as: CREATE TABLE t (col1 qwerty_UDT);
my prob is that when i try to insert into the type i.e: INSERT INTO t (col1)
Values (qwerty_UDT(123));
i get the error:
ERROR: function test_x(integer) does not exist
HIN
qwerty_udt(integer) does not exist
HINT: No function matches the given name and argument types. You may need to
add explicit type casts.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Andrew Thorley" <[EMAIL PROTECTED]>
Subject: Re: [SQL]
#x27;t succeed since the b.n = 'b' condition is guaranteed to fail
> when b.* is nulled out ...
You can make it work by moving parts of the condition into the explicit
join clause:
select a.i
from t as a left join t as b on a.n='a' and b.n='b' and a.i=b.i
whe
size (currently 1155072 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 50) and/or its max_connections
parameter (currently 10)
What is the best way to resolve this? max_connections = 10? Does that
figure auto increase as more users request data?
rega
On Fri, Dec 03, 2004 at 09:00:53AM +, Andrew M wrote:
> DETAIL: Failed system call was shmget(key=1, size=1155072, 03600).
> HINT: This error usually means that PostgreSQL's request for a shared
> memory segment exceeded available memory or swap space. To reduce the
IN in place of a join is
unwise (even though recent versions can sometimes plan it as though it were
a join); using UNION in place of an outer join is _very_ unwise. (In fact
UNION / INTERSECT / EXCEPT should normally be reserved for those cases
where there is simply no alternative.)
--
Andrew, S
Now I
> need help porting the "down" the hierarchy function.
Have you looked at contrib/tablefunc's connectby() function?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)-
nal
| 'processed' timestamp-column?
|
|
|
| Thanks for helping me do the right.
|
| ---(end of broadcast)---
| TIP 4: Don't 'kill -9' the postmaster
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Admin
ELECT case 'a'::text. . .)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
f decisions that need to
be made about what to do with incompatible types. What if you change
from int8 to int4? What about varchar(4) to char(4)? Just to name
two simple-minded examples. See the -general and -hackers archives
for plenty of previous discussion of this stuff.
A
--
Andrew Su
1 - 100 of 396 matches
Mail list logo
