Ok, that works.
Another thing that was strange is that when I changed
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
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 with
On 29.8.2012. 21:02, Merlin Moncure wrote:
> On Wed, Aug 29, 2012 at 10:44 AM, Chris Travers
> 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 are they
>> e
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:
>>>>
&g
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...@
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
On 21.6.2012. 6:03, Pavel Stehule wrote:
> 2012/6/21 Rikard Pavelic :
>> 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 comple
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"? Ha
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 ex
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 27.4.2012. 0:39, Tom Lane wrote:
>
> There is no supported method for changing the order of attributes in a
> composite type, so I wonder exactly how you did step 4. If it involved
> direct manipulation of the system catalogs, I would say this falls in
> the category of "if you break it, you ge
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'
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, 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 without a default
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
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 passwo
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
On 15.4.2011 22:49, Kevin Grittner wrote:
> Rikard Pavelic wrote:
>> On 15.4.2011 21:06, Tom Lane wrote:
>>> The former.
>>>
>>> regression=# CREATE TYPE turtle AS
>>> (
>>> name varchar
>>> );
>>> CREATE TYPE
>
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=#
>
>
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
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 dea
22 matches
Mail list logo
