declare _t1 s; to declare _t1 s[];
parsing passed, but of course it blew up at runtime.
Anyway, thanx for the workaround.
I'll see if it's faster comparing fields using record or as I do it currently.
Regards,
Rikard
- --
Rikard Pavelic
http://www.ngs.hr/
-BEGIN PGP SIGNATURE-
Version
The following bug has been logged on the website:
Bug reference: 7525
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.2
Operating system: Windows 7
Description:
Is there a way in Postgres to create a unique constraint
On 29.8.2012. 21:02, Merlin Moncure wrote:
On Wed, Aug 29, 2012 at 10:44 AM, Chris Travers ch...@metatrontech.com
wrote:
Again, the question is simply this:
Are the table constraints for storage complete in themselves (and assuming
full knowledge of all changes of internal data types) or
On 15.8.2012. 3:54, Craig Ringer wrote:
On 08/14/2012 11:42 PM, Rikard Pavelic wrote:
On 8.8.2012. 13:30, Craig Ringer wrote:
On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote:
The following bug has been logged on the website:
Bug reference: 7485
Logged by: Rikard
On 8.8.2012. 13:30, Craig Ringer wrote:
On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote:
The following bug has been logged on the website:
Bug reference: 7485
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: Unsupported
The following bug has been logged on the website:
Bug reference: 7485
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: Unsupported/Unknown
Operating system: Windows
Description:
This is still an issue as reported in
http
The following bug has been logged on the website:
Bug reference: 6701
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.3
Operating system: Windows 7
Description:
create type t AS (i int);
create type complex as (t t, i int
On 20.6.2012. 20:55, Pavel Stehule wrote:
Hello
it is not a bug - see
http://archives.postgresql.org/pgsql-hackers/2009-07/msg01525.php
Regards
Pavel Stehule
I found that in documentation after reporting bug.
I'm sorry for not searching some more, but didn't know where to look exactly.
On 20.6.2012. 21:10, Tom Lane wrote:
rikard.pave...@zg.htnet.hr writes:
create type t AS (i int); create type complex as (t t, i int); create table
bad(i int, c complex); --This doesn't work as expected select * from bad
where c is not null;
What do you consider to be expected? Have you
The following bug has been logged on the website:
Bug reference: 6618
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.3
Operating system: Windows 7
Description:
We've run into another issue with composite types.
I've search
On 13.3.2012. 20:49, Merlin Moncure wrote:
I personally think it's an oversight. This was just discussed a
couple of days ago here:
http://postgresql.1045698.n5.nabble.com/Altering-a-table-with-a-rowtype-column-td5544844.html
The server is blocking the alter-not-null-with-default because
On 28.2.2012. 15:01, Marti Raudsepp wrote:
On Sat, Feb 25, 2012 at 15:23, rikard.pave...@zg.htnet.hr wrote:
This works:
alter table t1 add x float not null;
Peeking at the code, currently any modifications that cause a rewrite
of the original table are disallowed.
Adding a nullable column
The following bug has been logged on the website:
Bug reference: 6489
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.2
Operating system: Windows 7
Description:
I'm trying to push types in Postgres and have run into some
The following bug has been logged online:
Bug reference: 6058
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1 beta2
Operating system: Windows 7 64
Description:psql password prompt
Details:
psql doesn't hide password
The following bug has been logged online:
Bug reference: 6046
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1 beta 1
Operating system: Windows 7 64bit
Description:select current_date crashes postgres
Details:
select
The following bug has been logged online:
Bug reference: 5982
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.alpha5
Operating system: Windows XP SP3
Description:recursive type crashes postgres
Details:
CREATE TYPE turtle
On 15.4.2011 21:06, Tom Lane wrote:
The former.
regression=# CREATE TYPE turtle AS
(
name varchar
);
CREATE TYPE
regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
ERROR: composite type turtle cannot be made a member of itself
regression=#
regards,
On 15.4.2011 22:49, Kevin Grittner wrote:
Rikard Pavelic rikard.pave...@zg.htnet.hr wrote:
On 15.4.2011 21:06, Tom Lane wrote:
The former.
regression=# CREATE TYPE turtle AS
(
name varchar
);
CREATE TYPE
regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
ERROR: composite
The following bug has been logged online:
Bug reference: 5970
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 9.1.alpha5
Operating system: Windows XP SP3
Description:intersect and collation on types
Details:
create table
The following bug has been logged online:
Bug reference: 4892
Logged by: Rikard Pavelic
Email address: rikard.pave...@zg.htnet.hr
PostgreSQL version: 8.4 beta2
Operating system: Windows XP SP3
Description:postmaster died and didn't restart
Details:
log of death [i
20 matches
Mail list logo